Please help solve in excel using Solver and show steps. A manufacturer produces perfume, which requires chemicals and labor. The firm has two production lines to make perfume. The two lines can both be used to produce perfume of the same quality, which is sold in the market at a price of $100 per ounce. Line 1 requires 1 unit of chemicals and 0.1 labor hour to produce each ounce of perfume. Line 2 requires 2 units of chemicals and no labor hour to produce each ounce of perfume. It costs the company $20 for each labor hour and $2 for each unit of chemical. Up to 2,000 labor hours and 50,000 units of chemicals can be purchased. Due to maintenance issues, no more than 60% of the perfume produced should be from Line 1. The company wants to determine how many ounces of perfume to produce on each of the two production lines to maximize its profit, which is the revenue from selling perfume minus the total cost of buying labor hours and chemicals.
Please help solve in excel using Solver and show steps.
A manufacturer produces perfume, which requires chemicals and labor. The firm has two production lines to make perfume. The two lines can both be used to produce perfume of the same quality, which is sold in the market at a price of $100 per ounce. Line 1 requires 1 unit of chemicals and 0.1 labor hour to produce each ounce of perfume. Line 2 requires 2 units of chemicals and no labor hour to produce each ounce of perfume. It costs the company $20 for each labor hour and $2 for each unit of chemical. Up to 2,000 labor hours and 50,000 units of chemicals can be purchased.
Due to maintenance issues, no more than 60% of the perfume produced should be from Line 1.
The company wants to determine how many ounces of perfume to produce on each of the two production lines to maximize its profit, which is the revenue from selling perfume minus the total cost of buying labor hours and chemicals.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
