Full Throttle orders a key part from an external supplier and needs to determine the optimum ordering plan for the next 5 weeks. The parts are ordered in bins that contain 200 parts per bin. They can order up to 4 bins per week. The planning team estimated the demand of parts of the next 5 weeks and the supplier gave them the following cost per bin for the next 5 weeks. Week 1 2 3 4 5 Parts Demanded 750 425 300 575 700 Cost per bin $2,000 $1,670 $1,840 $2,190 $1,680 They currently do not have any parts on hand and will incur a carrying cost of $7.50 per part based on average inventory. Develop an Excel model and solve using Solver to find their optimum ordering strategy.