Answered You can hire a professional tutor to get the answer.
N O P DO YOU A W N Cost Unit Price 22.99 Base Shipping 5 Extra Shipping /Unit Tax (for all orders) 0.13 Inventory 9 Opening Inventory: 432 10 Number...
can someone help me, i need the formulas for all the blanks, i have the answers i just dont know which formulas to put in excel
Only cells within the table should be used; no extra cells should be used or added to help with the calculations. Fill in all of the blue cells.
Calculate the cost of shipping and fill from cell J4 to J103.
Calculate the subtotal excluding tax and fill from cell K4 to K103.
Calculate the subtotal including tax and fill from cell L4 to L103.
Calculate the number of units sold in cell O10.
Calculate the closing inventory in cell O10.
Calculate the number of days of sales in cell O13.
Calculate the average units sold per day in cell O14.
Calculate the estimated days of inventory left in cell O15.
Calculate the total sales for units excluding tax in cell O17.
Calculate the total shipping charges excluding tax in cell O18.
Calculate the average shipping cost per order in cell O19.
Calculate the total lax collected in cell O21.
Calculate the total amount collected in cell O22.
Below are screenshots of what the completed spreadsheet should look like.
- Attachment 1
- Attachment 2
- Attachment 3
- Attachment 4
- Attachment 5
- Attachment 6
- Attachment 7
- Attachment 8
