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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started