Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun

Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months.

Month May Jun Jul Aug Sep Oct
Forecast 4,000 4,800 5,600 7,200 6,400 5,000

Use the following information to develop aggregate plans.

Regular production cost $10 per case
Regular production capacity 5,000 cases
Overtime production cost $16 per case
Subcontracting cost $20 per case
Holding cost $1 per case per month
Beginning inventory 0

1.

Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan.

a.

Use level production. Supplement using overtime as needed. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Period May Jun Jul Aug Sep Oct Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular
Overtime
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Regular $ $
Overtime
Inventory
Back orders
Total $ $

b.

Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Period May Jun Jul Aug Sep Oct Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular
Overtime
Subcontract
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Regular $ $
Overtime
Subcontract
Inventory
Back orders
Total $ $

c.

Use overtime up to 750 cases per period and inventory to handle variations in demand. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Period 1 2 3 4 5 6 Total
Forecast 4,000 4,800 5.600 7,200 6,400 5,000 33,000
Output
Regular
Overtime
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Regular $ $
Overtime
Hire/Lay off
Inventory
Back orders
Total $ $

2.

Which plan has the lowest total cost?

Second
First
Third
Neither

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

3. What is a Duchenne smile?

Answered: 1 week ago