(0) Consider the following scenario. You are a manager of a warehouse facility that sells construction materials to contractors. You oversee supervising a salesforce and making sure that they calculate total price and discounts correctly. You want to create a MS Excel spreadsheet to speed up your salesforce and minimize human-type errors. To achieve these goals, you need to design a spreadsheet that will perform the following functions: 1. Provide a drop-down menu that will list all products in your inventory 2. Automatically find an original price of the item 3. Automatically find an appropriate discount based on a quantity inputted by the user 4. Calculate adjusted prices and the total cost Based on a scenario above, you need to perform the following: 1. Fill in the discount table (H16:121) based on your pricing strategy. As a manager, you have decided to use the following discount strategy: if a customer buys less than 10 units, discount is 0, between 10 and 49 (inclusive) units - discount is 1 percent, between 50 and 99 units - 3 percent, between 100 and 199 - 5 percent, between 200 and 499 7 percent, and 500 units or more 10 percent. 2. Create the cell with a drop-down menu of products (A5) 3. Create the cell that finds an original price of the product (B5) 4. Indicate (highlight) the cell where user is supposed to input the quantity (C5) 5. Create a cell that finds an appropriate discount based on quantity (D5) 6. Create a cell that calculates the total savings based on a discount (E5) 7. Create a cell that calculates the total price per product charged to a customer (F5) 8. Format your tables appropriately (e.g. accounting formatting for monetary information, percentages, etc.) - 9. After ALL aforementioned steps have been completed, please do the following: a. Type your name in the cell B25 b. Type the following formula in the cell B26 (=NOW()) and click SAVE and submit your spreadsheet

Consider the following scenario (Please use Homework 7 template) You are a manager of a warehouse facility that sells construction materials to contractors. You oversee supervising a salesforce and making sure that they calculate total price and discounts correctly. You want to create a MS Excel spreadsheet to speed up your salesforce and minimize human-type errors. To achieve these goals, you need to design a spreadsheet that will perform the following functions: 1. Provide a drop-down menu that will list all products in your inventory 2. Automatically find an original price of the item 3. Automatically find an appropriate discount based on a quantity inputted by the user 4. Calculate adjusted prices and the total cost Based on a scenario above, you need to perform the following: 1. Fill in the discount table (H16:I21) based on your pricing strategy. As a manager, you have decided to use the following discount strategy: if a customer buys less than 10 units, discount is 0 , between 10 and 49 (inclusive) units - discount is 1 percent, between 50 and 99 units -3 percent, between 100 and 1995 percent, between 200 and 4997 percent, and 500 units or more -10 percent. 2. Create the cell with a drop-down menu of products (A5) 3. Create the cell that finds an original price of the product (B5) 4. Indicate (highlight) the cell where user is supposed to input the quantity (C5) 5. Create a cell that finds an appropriate discount based on quantity (D5) 6. Create a cell that calculates the total savings based on a discount (E5) 7. Create a cell that calculates the total price per product charged to a customer (F5) 8. Format your tables appropriately (e.g. accounting formatting for monetary information, percentages, etc.) 9. After ALL aforementioned steps have been completed, please do the following: a. Type your name in the cell B25 b. Type the following formula in the cell B26 (=NOWO) and click SAVE and submit your spreadsheet