Question: Can someone please answer this using excel (pretty please): Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new
Can someone please answer this using excel (pretty please):

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/30 of a day and 1/80 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. The aim of the objective function for Green Vehicle Inc. should be to the objective value. Decision variables: T= number of trucks to be produced per day C= number of cars to be produced per day a) Objective function: Z=T+C
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
