need help with question 1

= = 11 1:1 $ - % 948-23 Conditional Formatas Cell Formatting Table Styles Styles si Format Sort & Find & Filter Select lipboard E Font Alignment Number Cele ding B D G H M N Instructions: Some Tips: Your 'Model' section should probably track how many backpacks the A store is telling backpacks for the back-to-school season, and is planning how many backpacks to order for the store sells (use a MIN() function for this) and how many surplus month of August. The store is uncertain about customer demand, and must sell any surplus backpacks (e. backpacks they have. You can then use these to determine the store's backpacks it cannot sell) back to a wholesaler at a steep discount, potentially cutting into its profits revenue from the backpacks. Your Profit' output will be the revenue minus the cost of ordering the backpacks In this sheet, build a spreadsheet model predicting the store's profit based on the following input values: Backpack cost: $11.50 (that is, the cost the store must pay for the backpacks) Backpack sale price: $15.50 - Surplus backpack price: $8.50(that is, how much the store receives for each backpack that they can't sell) -Demand: 200 Purchase quantity: 260 (that is, how many backpacks the store purchases) When you are done, anwer the questions on the next tab Inputs Model Outputs