School Store Inventory Spreadsheet
School Store Inventory Spreadsheet
You have been asked to analyse the following receipt and determine an appropriate unit price to charge for each item using a mark-up of 150%.
Click here to view the first two receipts!
To do this you will use an Libre office 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.