Identify the decision variables, objective function, and constraints in simple verbal statements. Mathematically formulate a linear optimization model. Please show Step 2 in Excel
The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below:
|
Material (measured in square inches) |
Model 1 |
Model 2 |
Model 3 |
Material Available |
|---|---|---|---|---|
|
Cardstock |
12 |
10 |
14 |
1,200 |
|
Satin |
24 |
20 |
15 |
2,000 |
|
Plain fabric |
40 |
40 |
30 |
7,500 |
|
Leather |
11 |
11 |
10 |
1,000 |
|
Profit per model |
$50 |
$44 |
$40 |
-
Identify the decision variables, objective function, and constraints in simple verbal statements.
-
Mathematically formulate a linear optimization model.
-
Please show Step 2 in Excel
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.
Step by step
Solved in 5 steps with 9 images
