Question: I JUST NEED THE FORMULATION FOR THIS PROBLEM NOT THE EXCEL ANSWER P06_58.xlsx: During the next five periods, the demands listed in the file P06_58.xlsx
I JUST NEED THE FORMULATION FOR THIS PROBLEM NOT THE EXCEL ANSWER

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. A B D E F 1 Demand data 2 3 Month 4 Demand 5 1 2000 2 1700 3 3000 4 2000 3400
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
