A company assembles two types of small drones: Mini and Nano. The time to assemble a Mini is 8 hours and to assemble a Nano is 6 hours. The company has the following goals, in prioritized order:
1. Do not underutilize production capacity, which is 480 hours.
2. Achieve product demand of 40 for Minis and 50 for Nanos. Meeting the Mini demand is more important than meeting the Nano demand by a ratio of 5 to 2.
3. Limit production overtime to 20 hours.
a) Formulate a Goal Programming model for this problem to determine the production amounts of the Mini and Nano drones to best meet the company’s goals. Define clearly your decision variables, constraints and objective(s)
b) Solve this problem using Excel Solver.