Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. A product produced by ABC company consists of two successive operations, I and II. The table below contains data on the months of

3. A product produced by ABC company consists of two successive operations, I and II. The table below contains data on the mo 

3. A product produced by ABC company consists of two successive operations, I and II. The table below contains data on the months of January, February and March of the product. Demand (units) Capacity of operation 1 (hr) Capacity of operation 1 (hr) January 500 900 1000 February 450 650 850 March 600 550 700 Producing a unit of the product takes 0.6 hour on operation I plus 0.8 hour on operation II. Overproduction of either the semifinished product (operation I) or the finished product (operation II) in any month is allowed for use in a later month. The corresponding holding costs are $.20 and $.40 per unit per month. The production cost varies by operation and by month. For operation 1, the unit production cost is $10, $12, and $11 for January, February and March. For operation 2, the corresponding unit production cost is $15, $18, and $16. Determine the optimal production schedule for the two operations over the 3-month horizon using Excel Solver and carry out sensitivity analysis.

Step by Step Solution

3.53 Rating (153 Votes )

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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson

6th edition

978-0077328894, 71313974, 9780077395810, 77328892, 9780071313971, 77395816, 978-0077400163

More Books

Students also viewed these General Management questions

Question

How are derivatives reported on the balance sheet? Why?

Answered: 1 week ago