In: Advanced Math
Robotix manufacture three robots: Mavis, Charles and Koala; each with different capabilities. All three require special circuits, of which up to 1,000 can be obtained each week. Mavis takes three of them, Charles four of them and Koala six of them. Work is limited to 400 hours per week. The construction of each Mavis consumes two working hours, Charles one hour and Koala three hours. Profits are $500, $250 and $400 respectively for each Mavis, Charles and Koala that is sold. The Robotix has signed a contract with a major customer to make and supply at least 100 Mavis, 100 Charles and 30 Koala each week.
(a) Set up the liner programming problem (variables, objective function, constraints, etc.) Use Excel Solver to answer the following Question:
(b) How many of each robot should Robotix make per week to maximize total profit? What is the maximum profit?
(c) If the profit per Mavis is increased to $510, does the optimal solution change and why? What should be the new optimal profit?
(d) With overtime, the company may increase the working hours to 460 hours. Should the company do that? How much more they can get in profit?
(e) Should the company increase the quantity of each robot? Explain.