A company manufactures four different types of nails. Each nail is made of a different type of metal and requires assem
Posted: Sun Jul 10, 2022 11:26 am
A company manufactures four different types of nails. Eachnail is made of a different type of metal and requiresassembly, polishing, and packing time in the manufacturing process.For each nail, the time required for these operations is shownbelow (in minutes) as is the profit per unit sold.
cabinet nail type
Brass nail
Nickel nail
Chrome nail
Pewter nail
Assembly Time (mins.)
4
2
3
5
Polishing Time (mins.)
2
3
3
4
Packing Time (mins.)
2.5
1.5
2.5
5
Profit ($)
$ 2.50
$ 2.00
$ 3.50
$ 4.50
The company has 90,000 minutes of assembly time, 50,000 minutesof polishing time, and 53,000 minutes of packing time available. Integer constraints are not needed in this problem.
Complete an optimization model with a sensitivity report inexcel.
What is the total profit in the optimal solution? (Howwould I do this using excel solver?)
cabinet nail type
Brass nail
Nickel nail
Chrome nail
Pewter nail
Assembly Time (mins.)
4
2
3
5
Polishing Time (mins.)
2
3
3
4
Packing Time (mins.)
2.5
1.5
2.5
5
Profit ($)
$ 2.50
$ 2.00
$ 3.50
$ 4.50
The company has 90,000 minutes of assembly time, 50,000 minutesof polishing time, and 53,000 minutes of packing time available. Integer constraints are not needed in this problem.
Complete an optimization model with a sensitivity report inexcel.
What is the total profit in the optimal solution? (Howwould I do this using excel solver?)