Question
A CONCRETE CEMENT Manufacturing company produces HOLLOW BLOCKS and uses three processes in the production. The process requires different amounts of labor, Cement and Gravel.
A CONCRETE CEMENT Manufacturing company produces HOLLOW BLOCKS and uses three processes in the production. The process requires different amounts of labor, Cement and Gravel. Aside from the HOLLOW BLOCKS, BRICKS is a side product but which has limited demand in the market. The Data below shows the result of 1 Hour operation of each process:
| INPUT | OUTPUT | |||
| LABOR (Hours) | CEMENT (lb) | GRAVEL (lb) | HOLLOW BLOCKS (lb) | BRICKS (lb) |
PROCESS 1 | 16 | 400 | 290 | 1100 | 70 |
PROCESS 2 | 22 | 280 | 240 | 1470 | 30 |
PROCESS 3 | 14 | 600 | 450 | 1200 | 150 |
For a weeks production, the company has up to 10 tons of cement at $86/ton, 700 hours of labor at $31.50/hr and an unlimited supply of GRAVEL at 24/ton. Every hollow block is priced at $1300/ton and a maximum of 1 ton of the brick can be sold at $74(note that any amount of the brick greater than 1 ton has no value). Due to these restrictions, not any of the processes can be employed for more than 80 hours in any week. However, the division manager can request her workers to work up to an extra 40 hrs per week in overtime at a cost of $45/hr to the firm. The plant vice president in charge of production wants to generate an operating schedule that maximizes the net income. Moreover, he wants to know if the division can meet its weekly production requirements with the material on hand without using overtime and, if so, the minimal cost of this operation. And, because the decision to allow overtime must be made at the plant level, the vice-president also wants some estimate on how much money, if any, the division can save by using overtime.
NOTE: pls solve it using Microsoft Excel and then post screen shot of the solution and also do its modeling if a model can be made from this question.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started