Question: PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL SOLVER PLEASE. I NEED IT QUICKLY. THANK YOU. 1. Tooleo has contracted with AutoMate to supply their automotive

PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL SOLVER PLEASE. I NEED IT QUICKLY. THANK YOU.

PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL

1. Tooleo has contracted with AutoMate to supply their automotive discount stores with wrenches and chisels. Auto Mate's weekly demand consists of at least 1500 wrenches and 1200 chisels. Tooleo cannot produce all the requested units with its present one-shift capacity and must use overtime and possibly subcontract with other tool shops. The result is an increase in the production cost per unit, as shown in the following table. Market demand restricts the ratio of chisels to wrenches to at least 2:1. Tool Production type Weekly production range (units) Unit cost (3) Wrenches Regular Overtime Subcontracting Regular Overtime Subcontracting 0-550 551-800 801-00 0-620 621-900 901-00 Chisel 2.00 2.80 3.00 2.10 3.20 4.20 a) Formulate and solve the LP for the minimum cost production schedule for each tool. b) What is the effect on total weekly production cost of increasing the regular and overtime capacities for each tool by one unit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!