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 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
Get step-by-step solutions from verified subject matter experts
