Question: ASAP Please - Solve in Excel Linear programming Suzie Q started an Etsy site selling two types of bridal hair accessories. She calls these classic

ASAP Please - Solve in Excel

Linear programming

Suzie Q started an Etsy site selling two types of bridal hair accessories. She calls these "classic" and "modern."The classic one brings in $30 profit while the modern brings in $19. It takes 2 hours to make the modern and 2.75 hours to make the classic; she has 1 week do make these (10 hrs./day * 7 days = 70 hours). The materials are netting and glue. She has 25 yards of netting and 150 grams of glue; the classic takes 1 yard of netting and 3 g of glue while the modern takes .5 yards of netting and 5 g of glue.

  • Solver:show set-up; include Solver generated answer report as a tab in your spreadsheet.
  • Answer the following question clearly on the spreadsheet:
    • What is the optimal mix of hair accessories Suzie should make to make the most profit?
    • What will be her profit?
    • What constraints are binding? Is there any slack or surplus?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!