Decision models- excep spreadsheet with solversteel

Assignment Help Business Management

Reference no: EM13369874

Decision Models- excep spreadsheet with SOLVER

Steel Fabricators manufactures truck panels by blending ore from four different mines. Each ton of blended ore requires at least

10 pounds of element A per ton
90 pounds of element B per ton
18 pounds of element C per ton.

Each mine charges a different price, and each mine's ore provides a different blend of basic elements.
Mine

Element 1 2 3 4 Minimum
Requirement
lbs A / ton 18 6 16 4 10
lbs B / ton 80 120 75 110 90
lbs C / ton 25 12 10 15 18
$ Cost / ton 900 480 675 465

The objective is to minimize the cost of a ton of blended ore that satisfies the minimum requirements on elements A, B, and C. Answer the following independent questions.

(a) How much does a ton of the blend cost?

(b) How much element A is in the minimum cost blend? How much element B?

Justify your answers to (c), (d), and (e) by reference to the sensitivity report for your Solver solution to the above problem.

(d) How much would I have to decrease the amount of C required before the cost per blended ton drops to $576?

(e) We are not using any ore from mine 3. How much would it have to lower its price before we considered buying ore 3?

Reference no: EM13369874

Questions Cloud

Commercial logging and tree farmswhat do you think would : commercial logging and tree farmswhat do you think would happen if commercial loggers have their own tree farms? find

Question about forecasting - regression analysisjohn howard : question about forecasting - regression analysisjohn howard a mobile alabama real estate developer has devised a

Question related to external environmentplease help with : question related to external environmentplease help with the followinggiven the importance of understanding the

Decision models - excel spreadsheet using solverneed help : decision models - excel spreadsheet using solverneed help with this question asapsuzzalo library is planning to buy new

Decision models- excep spreadsheet with solversteel : decision models- excep spreadsheet with solversteel fabricators manufactures truck panels by blending ore from four

Describing the nature and extent of knowledge management in : describing the nature and extent of knowledge management in walmartplease assist me in describing the nature and extent

Management and changing definition of familyhow has the : management and changing definition of familyhow has the changing definition of family affected the functions of

Importance of good management to an organizationhow does : importance of good management to an organizationhow does good management affect the successful performance of an

Why might a profit-maximizing employer turn down your offer : why might a profit-maximizing employer turn down your offer to work at 8 per hour?suppose i am making 18 an hour

User Account

All Pages