The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers are shown in the table below: Month & Requirement January - 710 February - 1090 March - 880 April - 690 May - 1400 June - 1130 July - 1550 August - 1020 September - 530 October - 390 November - 980 December - 1210 Current inventory is 140 units. Current capacity is 1,030 units per month. The average salary of production workers is $1,150 per month. Material costs $140/unit. Each production worker accounts for 35 units per month. Overtime is paid at time and a half. Any increase or decrease in the production rate costs $40/unit for tooling, setup, and line changes. This does not apply, however, to overtime. Inventory-holding costs are $30 per unit per month. Lost sales are valued at $70 per unit. Compare the costs of level and chase demand production plans using the Agg Plan – Level and Agg Plan – Chase Excel templates. Round all your answers for cost values to the nearest cent and all other answers to the nearest whole number. Do not round intermediate calculations. If your answer is zero, enter "0".
The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers are shown in the table below:
Month & Requirement
January - 710 February - 1090 March - 880 April - 690 May - 1400 June - 1130
July - 1550 August - 1020 September - 530 October - 390 November - 980 December - 1210
Current inventory is 140 units. Current capacity is 1,030 units per month. The average salary of production workers is $1,150 per month. Material costs $140/unit. Each production worker accounts for 35 units per month. Overtime is paid at time and a half. Any increase or decrease in the production rate costs $40/unit for tooling, setup, and line changes. This does not apply, however, to overtime. Inventory-holding costs are $30 per unit per month. Lost sales are valued at $70 per unit. Compare the costs of level and chase demand production plans using the Agg Plan – Level and Agg Plan – Chase Excel templates. Round all your answers for cost values to the nearest cent and all other answers to the nearest whole number. Do not round intermediate calculations. If your answer is zero, enter "0".
For the level strategy, compare the normal production rate of 1,030 units per month with the average monthly demand rounded to a whole number. Round all your answers for cost values to the nearest cent and all other answers to the nearest whole number. Do not round intermediate calculations. If your answer is zero, enter "0".
Level production plan with the average monthly demand rounded to a whole number:
![← → C
»
THE
Chapter 14 Homework x
Tesla
?
MindTap - Cengage Lea XX agg_plan_level (2).xlsx x X agg_plan_chase (1).xls x C chegg.com/homework x b Search results for The x +
9780357131725&id=1830336778&snapshotld-3537303&
✰ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=5992002520048669802619212528&elSBN
Patagonia
Starbucks
Meta Platforms
CENGAGE MINDTAP
Discussions
Chapter 14 Homework: Resource Management
Total cost: $
Month
January
February
March
April
May
June
July
August
September
October
November
December
Average
$
Demand
Cost
710
1,090
880
690
1,400
1,130
1,550
1,020
530
390
980
1,210
Total Production Total Inventory
Cost
Marketing Research...
$
Cumulative
Demand
O
710
1800
2680
3370
4770
5900
7450
8470
9000
9390
10370
11580
Purdue Pharma an....
$
Production
Total Lost Sales
Cost
Product
Availability
$
Maximum
Total Overtime
Cost
O
Ending
Inventory
Total Undertime
Cost
$
Lost
Sales
Total Rate Change
Cost
<✰✰ ⠀
1
Q Search this course
X
All Bookmarks
Nov 18
2:56
?
2
A-Z
Ce
·
A+](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F37f36609-f6cb-4471-a981-f3cd0262a21d%2F551bd82f-1ae0-41be-9e16-5141d59e2836%2Fk3z4sxq_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 7 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)