please solve using this excel template. please post formulas. thanks!

A motorcycle manufacturer is determining its production schedule for the next 6 months. The cost of manufacturing a motorcycle during each month is provided on the worksheet Q4. At the end of each month, a holding cost of $200 per motorcycle left in inventory is incurred. No more than 50 motorcycles can be stored in inventory at any point in time. In addition, the ending inventory level for each month should be non-negative Monthly demands for motorcycles are also given on the worksheet Q4. Assume that at the beginning of the first month. 25 completed motorcycles are in inventory. Also, this company can produce up to 200 motorcycles per month. Finally, each unit on hand at the end of month 6 (after demand is met) could be sold for $1000. Determine a cost- minimizing production schedule that meets all demands on time by Solver on worksheet Q4. B26 E H C 200 200 D 200 200 200 200 F 200 200 6 -800 200 Month 2 Month 3 Month 4 Month 5 Month 6 A B 3 Unit holding cost per month $200 4 Monthly production capacity 200 5 Inventory storage capacity 50 6 Initial inventory (start of month 1) 25 7 Salvage value of each leftover unit (end of month 6) 8 9 Month 1 10 Inventory at start of month 11 Production level during month 12 Demand during month 180 13 Inventory at end of month 14 15 16 Total production cost 17 Total inventory holding cost 18 Total net cost for six-month planning horizon 19 20 21 205 195 196 199 208