A company assembles two types of small drones: Mini and Nano. The time to assemb

Question

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. Make sure you label your sheets appropriately and use short

comments to describe what you did. Include organized snapshots of your Excel solution in the report.

Explanation / Answer

d+ priority d- priority mini x1 nano x2 sign RHS labour 0 0 8 6 production capacity 1 0 >= 480 product demand 1 5 1 2 40 50 production overtime 0 0

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.