The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,600 1,700 June 2,200 1,700 March July April 1,800 August 1,300 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 $25 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,300 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 1,000 units per month. Evaluate this plan by computing the costs for January through August. 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). Ending Inventory Subcontract Units Period Demand Production Month December January 200 1,500 1,300 February 1,600 1,300 3 March 1,700 1,300 April 1,800 1,300 May 2,300 1,300 6 June 2,200 1,300 7 July 1,700 1,300 August 1,300 1,300

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,500 May 2,300 February 1,600 1,700 June 2,200 1,700 March July April 1,800 August 1,300 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 $25 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,300 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontracting capacity is limited to 1,000 units per month. Evaluate this plan by computing the costs for January through August. 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). Ending Inventory Subcontract Units Period Demand Production Month December January 200 1,500 1,300 February 1,600 1,300 3 March 1,700 1,300 April 1,800 1,300 May 2,300 1,300 6 June 2,200 1,300 7 July 1,700 1,300 August 1,300 1,300

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Identify the four basic process strategies, and describe them by giving an example.

A: A process strategy is one of the strategies of the business organization where the approach used, is…

Q: For a domestic company going internationally, the company might need to redesign the process, what…

A: When a firm has to undergo a trade process development, we can say that the executives can have the…

Q: What is the difference between re-designing and managing process improvements?

A: System restructuring is a method of analysing and improving or entirely changing an organization's…

Q: By looking at the Pareto chart, which issue is the highest priority and where will be appropriate to…

A: Usually in a pareto chart, the sample values are plotted in a descending order in which the largest…

Q: How do process charts help visualize and document workflow and process steps?

A: Process charts are valuable tools used to visualize and document workflow and process steps within…

Q: Include a summary of the requirements for training and certification, as well as some examples taken…

A: In order to ensure that employees have the skills and information needed to carry out their work…

Q: Differentiate between the following common flowchart symbols (square, diamond, inverted triangle…

A: A flowchart is a diagram that represents that depicts a process or a workflow. A flowchart may also…

Q: What is a flowchart of the process?

A: Process flowcharts are easy to formulate. We can either draw it by hand or leverage…

Q: What exactly does it mean to "reap the advantages of a process" and why is it so important?

A: The threads connecting project outcomes to organizational strategy are benefits. Benefits are…

Question

100%

Can you assist me with Question 10. Please display the step process. Thank you

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:
January
1,500
May
2,300
February
1,600
June
2,200
1,700
March
1,700
July
August
April
1,800
1,300
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 $25 per unit per month. Ignore any idle-time costs. The plan is called plan B.
Plan B: Produce at a constant rate of 1,300 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price
of $80 per unit. Subcontracting capacity is limited to 1,000 units per month. Evaluate this plan by computing the costs for January through August.
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).
Ending
Inventory
200
Subcontract
Units
Period
Month
Demand
Production
December
1
January
1,500
1,300
2
February
1,600
1,300
3
March
1,700
1,300
4
April
1,800
1,300
May
2,300
1,300
June
2,200
1,300
7
July
1,700
1,300
8
August
1,300
1,300

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Can the progress of a single procedure be halted while it is being carried out? Any feedback you provide should be backed up by sound reasons.
What are the incremental and cascade techniques' differences and commonalities? What are the differences and similarities between them?
Can a process get stalled? Provide reasoned feedback.
Finding harmony through foodCreative Shock’20 Preliminary Case Study PLEASE FIND THIS CASE STUDY IN GOOGLE, AND ANSWER ON THE FOLLOWING QUESTIONS (PROVIDED BY IMAGE IN FILES)
Decision makers need to consider three primary considerations when designing jobs; list and explain the component or job design
Sometimes job design has to be modified to adapt to emergent technologies or product redesign. How can OD interventions assist in this scenario?
Process selection is influenced by the four key strategic factors ?
How are the four main aspects you take into consideration when making process selections?
Case study: Planning at High Performance Pumps Introduction High Performance Pumps is a small, successful manufacturing organization that specializes in manufacturing a range of pumps. This success is due to the performance, quality and reliability of the product and the excellent back-up service. The pumps range in size from 075 mm to larger pumps. The smaller pumps are manufactured in batches of 100 and the large specials in batches of five. However, regardless of size, all pumps use the same manufacturing processes. Manufacturing processes and planning There is a major common component for all pumps and this is a camshaft. The size of the camshaft varies according to the size of the pump. The process skills involved in the camshaft manufacture are highly developed and considered cost-effective compared with competitors. In fact, one of the areas of expansion is the design and manufacture of camshafts for other companies for their products, with camshaft production increasing by 400…
Describe in your own words the process model you will use to design an online hotel administration (Website) and the rationale behind your selection.
Discuss the process used to overcome objections. This upcoming Tuesday will be the 3rd meeting the sales team from La Carva Luxury Bathtubs will be having with a prospect regarding bathtubs she would like to purchase. The sales team conducted a presentation five months ago to a group of prospects, which this prospect attended. While the prospect expresses great interest in the product, at the previous meetings she seems to have additional concerns regarding the bathtubs and was not able to come to a decision to make a purchase. This issue is becoming overwhelming, and the sales team intends to address this matter once and for all. Based on the listening technique in the LAER MODEL, how will this effectively address the prospect's objections? Explain. Please be mindful to use relevant personal selling and marketing concepts to support the claim.
Why should the procedure be flexible? What are they?