Question: 20 points Use your inventory spreadsheet from assignment 1 Add a column (if you don't have one yet) that gives a product number/inventory ID to

 20 points Use your inventory spreadsheet from assignment 1 Add a

20 points Use your inventory spreadsheet from assignment 1 Add a column (if you don't have one yet) that gives a product number/inventory ID to each item Make sure you have the following column headings 1. 2. a. Inventory ID b. Product Name Unit price C. d. Quantity in Stock e. Inventory Value (Unit price Quantity) Reorder Level f. g. Quantity to Order 3. Use a formula to calculate Inventory Value 4. Use a formula to calculate total inventory Use an IF statement to calculate the quantity to order Use another IF statement anywhere in the spreadsheet and explain how it could be useful in inventory management 5. 6. A Drive

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!