Here is the data set for question #2:

Q:

Product Costic) $ 279.98 fixed fixed $0.33/sq.ft x 11 sq.ft x 12 months fixed Inbound Freight Receiving Labor Storage Cost Insurance Cost of Capital (13%) Property Taxes Loss and damage Obsolescence $ 11.17 $ 1.26 $43.56 $ 0.50 $36.40 $0.84 $ 5.58 $ 8.37 $3/$100 value @ 10% Total Holding Costs (H) Carrying Cost Percentage (h) $95.25 34% 2. Consider the example of a single type of laptop computer discussed in class. We want to see how sensitive costs are to an order quantity Q that is not the least cost Q provided by the EOQ formula. a) Calculate the order cost, the holding cost, and their sum if the retailer orders 1,900 rather than the EOQ quantity of 980. b) Calculate the order cost, the holding cost, and their sum if the retailer orders only 390 rather than the EOQ quantity of 980. c) Re-write the answers to a) and b) in the appropriate parts of the table below. Then, complete the calculations for percentage changes in total costs, percentage changes in cost. Round answers to two decimal places! Example: % increase in H+O Costs for 1,200 - (H+O Costs for 1,200) - (H+O Costs for 980)/(H+O Costs for 980) =? Outcome Q 980 Q-1,900 Q - 390 Holding Cost. S/year 48,980 49,000 97,980 Order Cost, S/year Holding + Order Costs, S/year % Increase in Ho costs for Q #980