Description
you have to do this problem on excel please provides notes or points about every step and how you did it?
Product Mix Problem •
We have four products products
– Flats ($20 profit)
– Heels ($30 profit
– Wedges ($25 profit)
– Sandals ($5 profit)
More about the problem…
• Flats require – 2 square feet of leather
• Heels require – 2.8 square feet of leather, 1.2 lbs. of cork
• Wedges require-- 1 2 square feet of leather, 2 lbs. of cork
• Sandals Require
of heels – 0.8 square feet of Leather, 1 5. lbs of rubber
> you must make at least 10 of each
> • You must make 2 flats for each set of heels
Find Out
• How many do we make?
• What happens when our constraints change? • What happens if the objective function
coefficient changes?
Explanation & Answer
Please refer to the Excel file for the tutorial. Remember to input the CORRECT values of the available materials for leather, cork, and rubber in the YELLOW cells then recompute solver.
1. We plot the individual requirements for the shoes
Flats
Leather
Cork
Rubber
Heels
2,00
Wedges
2,80
1,20
Sandals
1,20
2,00
0,80
1,50
Available
Materials
200,00
200,00
200,00
2. Then we input the total available quantity for these materials.
These figures were not provided, so I assumed number. All you
need to do is change the figures in the yellow cells and recompute the
solver.
3. Then we identify the quant...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Communist Manifesto
by Karl Marx
The Prince
by Niccolò Machiavelli
A Brief History of Humankind Sapiens
by Yuval Noah Harari
Harry Potter and the Sorcerers Stone
by J. K. Rowling
The Eyes Were Watching God
by Zora Neale Hurston
The 48 Laws of Power
by Robert Greene
Normal People
by Sally Rooney
Shattered - Inside Hillary Clintons Doomed Campaign
by Amie Parnes and Jonathan Allen