Linear Programming- Excel, computer science homework help

User Generated

urnirafragnatry

Business Finance

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?

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags