* The president of Hill Enterprises. Terri Hill, projects the firm's aggregate demand requirements over the...

Question

Question

* The president of Hill Enterprises. Terri Hill, projects the firm's aggregate demand requirements over the...

* The president of Hill Enterprises. Terri Hill, projects the firm's aggregate demand requirements over the next 6 month as follows:

January 1,600
February 2,500
March 1,800
April 2,000
May 1,900
June 2,200

Her operation manager is considering a new plan. Stockout cost of lost sales is $100.
Develope a constant work force model for this problem that will produce the average demand of this 6 months period in each month. Determine the total cost of this plan.

Her operations manager is considering a new plan. Stock cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs.

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

The aggregate plan is following:

EXCEL FORMULAS:

Cell	Formula	Copy to
E4	=MAX(0,C4-F3-D4)	E4:E9
F4	=MAX(0,F3-C4+D4)	F4:F9
F14	=E10*E11
F15	=F10*F11
F16	=SUM(F14:F15)

Total cost of this plan = $ 34,000

Add a comment

Answer 2

Similar Homework Help Questions

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 1,400 1,700 1,800 1,900 2,300 2,200 1,900 1,900 May June January February March April August Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called...
Problem #1 The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over...

Problem #1 The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: Jan Feb Mar Apr 1,400 1,600 1,800 1,800 June Ju Aug 2,200 2,200 1,800 1,800 Her operations manager is considering a new plan, which begins in January with 200 units on hand. 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...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

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,500 June 2,300 March 1,600 July 1,700 April 1,900 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements ...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,500 June 2,100 March 1,600 July 1,700 April 1,800 August 1,700 Her operations manager is considering a new plan, which begins in January with 200units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

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,300 February 1,600 June 2,200 March 1,800 July 1,800 April 1,700 August 1,800 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. 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 C. Plan C: Keep a stable workforce by maintaining a constant production rate equal...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,700 June 2,100 March 1,700 July 1,700 April 1,800 August 1,700 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,100 February 1,700 June 2,300 March 1,800 July 1,900 April 1,800 August 1,500 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 $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs....
The president of Hill Enterprises, Terri Hil, projects the firm's aggregate demand requirements over the next...

The president of Hill Enterprises, Terri Hil, projects the firm's aggregate demand requirements over the next 8 months as follows: May January February ,600 June March April 1.700 August 2,300 2,300 1,900 1,400 1,700July Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month. Ignore any dle-time costs. Evaluate the following plans D...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demanc requirements over the next 8 months as fol lows: 2,200 2,100 1,700 1,700 January February March April 1,500 1,5...

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demanc requirements over the next 8 months as fol lows: 2,200 2,100 1,700 1,700 January February March April 1,500 1,500 1,600 1,900 May June uly August Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is S25 per unit per month. Ignore any idle-time costs. The plan...

* The president of Hill Enterprises. Terri Hill, projects the firm's aggregate demand requirements over the...

Homework Answers

Add Answer to:
* The president of Hill Enterprises. Terri Hill, projects the firm's aggregate demand requirements over the...

Post as a guest

Earn Coins