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 1Attachment 2Attachment 3Attachment 4Attachment 5Attachment 6Attachment 7Attachment 8NOPDO YOU A W NCostUnit Price22.99Base Shipping5Extra Shipping /UnitTax (for all orders)0.13Inventory9Opening Inventory:43210Number of Units Sold:11Closing Inventory:12Days13Number of days of sales:14Average Units Sold per day:15Estimated days of Inventory left:16Sales17Total Sales for units (excl. tax)18Total Shipping charges: (excl. tax)19Average Shipping cost per order:20Total21Total Tax collected:22Total Amount collected:
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.