Question: Example of LP - based production strategy Consider a manufacturing plant that employs 3 0 0 workers. The company starts the year with 5 0
Example of LPbased production strategy
Consider a manufacturing plant that employs workers. The company starts the year with units of inventory on hand. The forecast for demand for the next six months is and The plant would like to have an ending inventory of units at the end of the six months. The cost of hiring one worker is $ and the cost of firing a worker is $ Inventory is calculated based on the amount held at the end of each month and costs $ per unit per month. All demand must be satisfied. The number of aggregate units produced by one worker in one day Assume that the number of working days in each month is
Formulate a linear program to determine the company's least total cost aggregate plan that can meet all of the demand without backlog.
Solve using excel and please show how it would look.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
