Question: Please help me do it in excel solver TE Connectivity requires to produce 12 thousand, 17 thousand and 13 thousand connectors during the next 3
Please help me do it in excel solver
TE Connectivity requires to produce 12 thousand, 17 thousand and 13 thousand connectors during the next 3 months (April, May, June). The plant can produce more than necessary at a cost of $ .07 per month of storage. The cost of material for each piece is $ 5dls per piece produced in April, $ 7dls in May and $ 6dls in June.
The company will start the month of April with 280 operators. Each operator can produce 50 pieces per month. To adjust its workforce to demand, the plant can hire and fire workers each month at a cost of $ 100 per hire and $ 300 per layoff.
Define the Model Variables Define the objective function of the Model. Define the Model constraints Determine the Total Minimum Cost, as well as the quantity to produce per month, the extra inventory at the end of each month, the layoffs and hiring at the beginning of each month
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
