Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OM operations management

Authors: David Alan Collier, James R. Evans

5th edition

1285451376, 978-1285451374

More Books

Students also viewed these General Management questions