The president of Hill Enterprises Terri Hill projects the fi

The president of Hill Enterprises, Terri Hill, projects the firm\'s aggregate demand requirements over the next 8 months as follows:

January

1,200

May

2,100

February

1,600

June

2,200

March

1,800

July

1,900

April

1,700   

August

1,400

Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan B.

Plan B: Produce at a constant rate of 1,200 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75 per unit. Subcontracting capacity is limited to 1000 units per month. Evaluate this plan by computing the costs for January through August.

A) In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers).

  

Period----

Month

Demand-----

Production-------

Ending Inventory--------

Subcontract Units

0

December   

200

1

January

1200

1200

?

?

2

February

1600

1200

?

?

3

March

1800

1200

?

?

4

April

1700

1200

?

?

5

May

2100

1200

?

?

6

June

2200

1200

?

?

7

July

1900

1200

?

?

8

August

1400

1200

?

?

B) The total subcontracting costequals= ? (Enter your response as a whole number.)

C) The total inventory carrying cost = ? (Enter your response as a whole number.)

The total cost, excluding normal time labor costs, is = ? (Enter your response as a whole number.

January

1,200

May

2,100

February

1,600

June

2,200

March

1,800

July

1,900

April

1,700   

August

1,400

Solution

B) The total subcontracting cost = $307,500

C) The total inventory carrying cost = $4,000

The total cost, excluding normal time labor costs = $311,500

Peri
Period Month Demand Production Ending Inventory Subcontract Units Subcontracting Cost = subcontracting units *$75 Inventory carrying cost = inventory * $20 The total cost, excluding normal time labor costs
0 December    200 0 0
1 January 1200 1200 200 0 0 4000 4000
2 February 1600 1200 0 200 15000 0 15000
3 March 1800 1200 0 600 45000 0 45000
4 April 1700 1200 0 500 37500 0 37500
5 May 2100 1200 0 900 67500 0 67500
6 June 2200 1200 0 1000 75000 0 75000
7 July 1900 1200 0 700 52500 0 52500
8 August 1400 1200 0 200 15000 0 15000
Total 13900 9600 4100 307500 4000 311500

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site