School Store Inventory Spreadsheet
School Store Inventory Spreadsheet
You have been asked to analyze the stock The Hive and determine an appropriate unit price to charge for each item.
To do this you will use Google Sheets to create a spreadsheet with the following headers for each column. Use equations for all calculations!
| Item | Wholesale Package Price | Quantity | Unit Price | Additional Costs per unit | Subtotal Cost per unit | Tax | Total cost per unit | Mark-up | Suggested Retail Unit Price |
| Gatorade | 13.99 | 24 | .58 | ||||||
| Square Bars | |||||||||
| Fruit Source | |||||||||
| Chips | |||||||||
| G2 | |||||||||
| Welches | |||||||||
| Mentos | |||||||||
| Czero | |||||||||
| Vegi Snacks | |||||||||
| Water |
Please do some work to format your spreadsheet so it is easy to read and then upload your completed spreadsheet for marking.