MateSheepPerson632
Context: The Electro-Poly Corporation is the world’s leading…
Context:
The Electro-Poly Corporation is the world’s leading manufacturer of slip rings. A slip ring is an electrical coupling device that allows current to pass through a spinning or rotating connectionsuch as a gun turret on a ship, aircraft, or tank. The company recently received a $750,000 order for various quantities of three types of slip rings. Each slip ring requires a certain amount of time to wire and harness. The following table summarizes the requirements for the three models of slip rings.
Model 1 Model 2 Model 3
Number ordered 3000 2000 900
Hours of Wiring Required per Unit 2 1.5 3
Hours of Harnessing Required per Unit 1 2 1
Unfortunately, Electro-Poly does not have enough wiring and harnessing capacity to fill the order by its due date. The company has only 10,000 hours of wiring capacity and 5,000 hours of harnessing capacity available to devote to this order. However, the company can subcontract any portion of this order to one of its competitors. The unit costs of producing each model in-house (including direct labor, direct materials and other related costs) and buying the finished products from a competitor are summarized in the following table.
Model 1 Model 2 Model 3
Cost to Make $50 $83 $130
Cost to Buy $61 $97 $145
Electro-Poly wants to determine the number of slip rings to make and the number to buy in order to fill the customer order at the least possible cost.
The following are the LP formulation, the optimal solution and the sensitivity report of Electro-Poly’s problem.
Image transcription text
M; = Number of model i slip rings to make in-house, i = 1, 2, 3 B; =
Number of model i slip rings to buy from competitor, i = 1, 2, 3
MIN: 50M1 + 83M2 + 130M3 + 61B1 + 97B2 + 145B3…
Show more
Image transcription text
Objective Cell (Min) Cell Name Final Value $H$4 Costs 453300
Decision Variable Cells Final Reduced Objective Allowable
Allowable Cell Name Value Cost Coefficient Increase …
Show more
Your Task:
You cannot use Excel to help you answer these questions. Please provide explanation to get credit.
How much can the unit cost of making model 1 slip rings increase before it becomes more economical to buy some of model 1 slip rings? Explain.
If the cost of buying model 2 slip rings decreased to $88 per unit, how would the optimal solution change (product mix, product quantities and objective function value)? Explain.
Assume workers in the wiring area normally make $12 per hour and get 50% more when they work overtime. Should Electro-Poly schedule these employees to work overtime to complete this job? Explain.
Assume workers in the harnessing area normally make $12 per hour and get 50% more when they work overtime. Should Electro-Poly schedule these employees to work overtime to complete this job? Explain.
Suppose a worker who performs harnessing calls in sick. Now eight fewer hours are available for harnessing hours. How would the optimal solution change (product mix, product quantities and objective function value)? Explain.
Suppose the client revised the order for model 1. The number ordered for model 1 now is 2,900 units. How would the optimal solution change (product mix, product quantities and objective function value)? Explain.
Suppose 100 units of model 3 slip rings ordered by the client require a special operation and Electro-Poly does not have the capability to do this operation. Therefore, Electro-Poly has to buy these 100 units of model 3 slip rings from its competitor for $145. What will be the impact (product mix, product quantities and objective function value)? Explain.
Suppose the costs of making model 1 slip rings and model 2 slip rings are increased by $2 and $5, respectively. How would the optimal solution change (product mix, product quantities and objective function value)? Explain.
