Solve in excel using solver. SHOW SOLVER AND ALL FORMULAS USED

P06_58.xlsx

During the next five periods, the demands listed in the file P06_58.xlsx must be met on time. At the beginning of period 1, the inventory level is 0. During each period when production occurs, a setup cost of $10,000 and a per-unit production cost of $45 are incurred. At the end of each period, a per-unit holding cost of $5 is incurred. Determine the cost-minimizing production schedule. B C D E F A 1 Demand data 2 3 Month 4 Demand 5 4 1 2000 2 1700 3 3000 5 3400 2000