Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley

12th Edition

0136128270, 9780136128274

More Books

Students also viewed these Accounting questions

Question

Who do you know that is a member of a microcultural group?

Answered: 1 week ago