Robotix manufacture three robots: Mavis, Charles and Koala; eachwith different capabilities. All three require special circuits, ofwhich up to 1,000 can be obtained each week. Mavis takes three ofthem, Charles four of them and Koala six of them. Work is limitedto 400 hours per week. The construction of each Mavis consumes twoworking hours, Charles one hour and Koala three hours. Profits are$500, $250 and $400 respectively for each Mavis, Charles and Koalathat is sold. The Robotix has signed a contract with a majorcustomer to make and supply at least 100 Mavis, 100 Charles and 30Koala each week.
(a) Set up the liner programming problem (variables, objectivefunction, constraints, etc.) Use Excel Solver to answer thefollowing Question:
(b) How many of each robot should Robotix make per week tomaximize total profit? What is the maximum profit?
(c) If the profit per Mavis is increased to $510, does theoptimal solution change and why? What should be the new optimalprofit?
(d) With overtime, the company may increase the working hours to460 hours. Should the company do that? How much more they can getin profit?
(e) Should the company increase the quantity of each robot?Explain.
