Question

Operations Management 12th Ed.

B.7

Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold.

a) Define the objective function and constraint equations.

b) Graph the feasible region.

c) What is a maximum-profit daily production plan at the new factory?

d) How much profit will such a plan yield, assuming whatever is produced is sold?

*** Please answer all parts and show your work/steps/formulas in EXCEL only. For Part B, Please provide instructions on how to create the graph using excel and list the steps out so I can create it myself. Thank you very much!!!***

Answer 1

c) Profit maximizing production schedule:

C1 = 30

T1 = 20

d)

Maximum profit per day = $ 12,600