The Little Bo Peep toy company carries 2 products. The company item ordering information for the two products are below: Parameters Demand rate Fixed ordering cost Purchase cost Holding rate Holding cost Product 1 Product 2 800 40 3.00 3.00 10.00 2.00 30% 30% | 3.00 0.60 Use information given in this to build the problem model in a spreadsheet. Then use MS Excel Solver to find out the optimized value for order quantity of product 1 and 2 (Economic Order Quantity, EOQ). The only constraint on this problem is that the quantity of products 1 and 2 should be equal or greater than 1. Hint: Here is what we need to know to be able to calculate the ATC. Input Parameters Demand rate Fixed cost Purchase cost Holding rate Holding cost Orders cost Ordered cost Percentage of Order held Carrying cost Objective (outputParameters Total fixed (Ordering cost) Total holding (inventory cost) *Total purchase Item ATC Demand rate x Fixed cost/Order Quantity (Holding rate x Holding cost x Order quantity)/2 Demand rate x Purchase cost Adding all the above The Little Bo Peep toy company carries 2 products. The company item ordering information for the two products are below: Parameters Demand rate Fixed ordering cost Purchase cost Holding rate Holding cost Product 1 Product 2 800 40 3.00 3.00 10.00 2.00 30% 30% | 3.00 0.60 Use information given in this to build the problem model in a spreadsheet. Then use MS Excel Solver to find out the optimized value for order quantity of product 1 and 2 (Economic Order Quantity, EOQ). The only constraint on this problem is that the quantity of products 1 and 2 should be equal or greater than 1. Hint: Here is what we need to know to be able to calculate the ATC. Input Parameters Demand rate Fixed cost Purchase cost Holding rate Holding cost Orders cost Ordered cost Percentage of Order held Carrying cost Objective (outputParameters Total fixed (Ordering cost) Total holding (inventory cost) *Total purchase Item ATC Demand rate x Fixed cost/Order Quantity (Holding rate x Holding cost x Order quantity)/2 Demand rate x Purchase cost Adding all the above