Reference no: EM133166792
A manufacturer produces two types of fabric products. In the next production run, the company has to decide how many rolls of each fabric type should be produced to maximize profit.
Each roll of type X fabric requires 50 units of cotton, uses 25 hours of labor, and utilizes 20 units of polyester lining. Each roll of type Y fabric requires 40 units of cotton, uses 28 hours of labor, and needs 15 units of polyester lining. The type X fabric yields a profit of $200 per roll, and the type Y fabric yields a profit of $160 per roll.
In the next production run, the company has 3000 units of cotton for use. The employees are scheduled to work at least 1800 hours in producing fabric (overtime is a possibility), and the company has 1500 units of polyester lining available for use.
1.) Using Solver, determine the maximum profit expected
2.) Using Solver, determine how many rolls of type X and type Y fabric will be produced
3.) Using Solver, determine how many units of cotton, hours of labor, and units of polyester lining will be used