4567829 The Data Table and Aggregate Demand Forecast below provide information related to one of the major product lines of refrigerators for Dayton Manufacturing Co. On Tab A develop a Level production plan. Include monthly and total costs On Tab B develop a Chase production plan. Include monthly and total costs. 10 11 12 13 Month # of Days Forecast 14 September 20 15,200 15 October 23 14,500 16 November 21 11,000 17 December 16 9,250 18 19 Data Box 20 Productivity and Cost Data 21 Material and Overhead $/Unit 150 22 Inventory Holding Cost $/Unit on End Inv. 2 23 Regular Time Production $/Hour 14 24 Overtime Prodsution $/Hour 21 25 Max OT as % of Regular Time Production 20 26 Subcontracting $/Unit 235 27 Cost to Fire $/Person 600 28 Cost to Hire $/Person 950 29 30 Labor Hours/Unit 31 Productiion Hours/Day 32 33 Beginning Inventory Level (Units) 1200 34 Desired Minimun Monthly End Inv. (Units) 500 35 36 37 < Tab A - Level Tab B - Chase + Ready Accessibility: Investigate 55°F Sunny Chase Strategy September October November December Day in Month Aggregate Forecast Regular Time Production (Units) Overtime Production (Units) Number of Workers Hired Number of Workers Fired Subcontracting (Units) Beginning Inventory Ending Inventory Costs Regular Time Production Overtime Production Hiring Workers 2 10 Firing Workers Material and Overhead Inventory Monthly Total Costs Q Search Overall Cost Of the Plan 76% O ENG 12:02 AM 4/9/2024 PRE September October November December 5 6 7 8 9 10 The Data Table and Aggregate Demand Forecast below provide information related to one of the major product lines of refrigerators for Dayton Manufacturing Co. On Tab A develop a Level production plan. Include monthly and total costs On Tab B develop a Chase production plan. Include monthly and total costs. 11 12 13 Month # of Days Forecast Level Strategy 14 September 20 15,200 15 October 23 14,500 16 November 21 11,000 Day in Month 17 December 16 9,250 18 19 Data Box Aggregate Forecast Regular Time Production (Units) 20 Productivity and Cost Data Overtime Production (Units) 21 Material and Overhead $/Unit 150 Number of Workers Hired 22 Inventory Holding Cost $/Unit on End Inv. 2 Number of Workers Fired 23 Regular Time Production $/Hour 14 Subcontracting (Units) 24 Overtime Prodsution $/Hour 21 Beginning Inventory 25 Max OT as % of Regular Time Production 20 Ending Inventory 26 Subcontracting $/Unit 235 27 Cost to Fire $/Person 600 28 Cost to Hire $/Person 950 29 30 Labor Hours/Unit 2 Costs Regular Time Production Overtime Production Hiring Workers 31 Productiion Hours/Day 10 Firing Workers 32 Subcontracting 33 Beginning Inventory Level (Units) 1200 Material and Overhead 34 Desired Minimun Monthly End Inv. (Units) 500 35 Inventory (Based on EI) Monthly Total Costs 36 37 38 39 < Tab A - Level Tab B - Chase + Ready Accessibility: Investigate 55°F Sunny Q Search Overall Cost Of the Plan ENG E 12:01 AM 4/9/2024 72% PRE

Marketing
20th Edition
ISBN:9780357033791
Author:Pride, William M
Publisher:Pride, William M
Chapter19: Pricing Concepts
Section: Chapter Questions
Problem 6DRQ
icon
Related questions
Question

I need help with this ASAP please. partial solution will be great too. Please notice that there isn't a current workforce provided. Start by identifying what you feel is an appropirate level of workers, given your demand needs over the planning horizon.

 

4567829
The Data Table and Aggregate Demand Forecast below provide information related
to one of the major product lines of refrigerators for Dayton Manufacturing Co.
On Tab A develop a Level production plan. Include monthly and total costs
On Tab B develop a Chase production plan. Include monthly and total costs.
10
11
12
13
Month
# of Days
Forecast
14
September
20
15,200
15
October
23
14,500
16
November
21
11,000
17
December
16
9,250
18
19
Data Box
20
Productivity and Cost Data
21
Material and Overhead $/Unit
150
22
Inventory Holding Cost $/Unit on End Inv.
2
23
Regular Time Production $/Hour
14
24
Overtime Prodsution $/Hour
21
25
Max OT as % of Regular Time Production
20
26
Subcontracting $/Unit
235
27
Cost to Fire $/Person
600
28
Cost to Hire $/Person
950
29
30
Labor Hours/Unit
31
Productiion Hours/Day
32
33
Beginning Inventory Level (Units)
1200
34
Desired Minimun Monthly End Inv. (Units)
500
35
36
37
<
Tab A - Level Tab B - Chase
+
Ready
Accessibility: Investigate
55°F
Sunny
Chase Strategy
September
October
November
December
Day in Month
Aggregate Forecast
Regular Time Production (Units)
Overtime Production (Units)
Number of Workers Hired
Number of Workers Fired
Subcontracting (Units)
Beginning Inventory
Ending Inventory
Costs
Regular Time Production
Overtime Production
Hiring Workers
2
10
Firing Workers
Material and Overhead
Inventory
Monthly Total Costs
Q Search
Overall Cost Of the Plan
76%
O
ENG
12:02 AM
4/9/2024
PRE
Transcribed Image Text:4567829 The Data Table and Aggregate Demand Forecast below provide information related to one of the major product lines of refrigerators for Dayton Manufacturing Co. On Tab A develop a Level production plan. Include monthly and total costs On Tab B develop a Chase production plan. Include monthly and total costs. 10 11 12 13 Month # of Days Forecast 14 September 20 15,200 15 October 23 14,500 16 November 21 11,000 17 December 16 9,250 18 19 Data Box 20 Productivity and Cost Data 21 Material and Overhead $/Unit 150 22 Inventory Holding Cost $/Unit on End Inv. 2 23 Regular Time Production $/Hour 14 24 Overtime Prodsution $/Hour 21 25 Max OT as % of Regular Time Production 20 26 Subcontracting $/Unit 235 27 Cost to Fire $/Person 600 28 Cost to Hire $/Person 950 29 30 Labor Hours/Unit 31 Productiion Hours/Day 32 33 Beginning Inventory Level (Units) 1200 34 Desired Minimun Monthly End Inv. (Units) 500 35 36 37 < Tab A - Level Tab B - Chase + Ready Accessibility: Investigate 55°F Sunny Chase Strategy September October November December Day in Month Aggregate Forecast Regular Time Production (Units) Overtime Production (Units) Number of Workers Hired Number of Workers Fired Subcontracting (Units) Beginning Inventory Ending Inventory Costs Regular Time Production Overtime Production Hiring Workers 2 10 Firing Workers Material and Overhead Inventory Monthly Total Costs Q Search Overall Cost Of the Plan 76% O ENG 12:02 AM 4/9/2024 PRE
September
October
November
December
5
6
7
8
9
10
The Data Table and Aggregate Demand Forecast below provide information related
to one of the major product lines of refrigerators for Dayton Manufacturing Co.
On Tab A develop a Level production plan. Include monthly and total costs
On Tab B develop a Chase production plan. Include monthly and total costs.
11
12
13
Month
# of Days
Forecast
Level Strategy
14
September
20
15,200
15
October
23
14,500
16
November
21
11,000
Day in Month
17
December
16
9,250
18
19
Data Box
Aggregate Forecast
Regular Time Production (Units)
20
Productivity and Cost Data
Overtime Production (Units)
21
Material and Overhead $/Unit
150
Number of Workers Hired
22
Inventory Holding Cost $/Unit on End Inv.
2
Number of Workers Fired
23
Regular Time Production $/Hour
14
Subcontracting (Units)
24
Overtime Prodsution $/Hour
21
Beginning Inventory
25
Max OT as % of Regular Time Production
20
Ending Inventory
26
Subcontracting $/Unit
235
27
Cost to Fire $/Person
600
28
Cost to Hire $/Person
950
29
30
Labor Hours/Unit
2
Costs
Regular Time Production
Overtime Production
Hiring Workers
31
Productiion Hours/Day
10
Firing Workers
32
Subcontracting
33
Beginning Inventory Level (Units)
1200
Material and Overhead
34
Desired Minimun Monthly End Inv. (Units)
500
35
Inventory (Based on EI)
Monthly Total Costs
36
37
38
39
<
Tab A - Level
Tab B - Chase
+
Ready
Accessibility: Investigate
55°F
Sunny
Q Search
Overall Cost Of the Plan
ENG
E
12:01 AM
4/9/2024
72%
PRE
Transcribed Image Text:September October November December 5 6 7 8 9 10 The Data Table and Aggregate Demand Forecast below provide information related to one of the major product lines of refrigerators for Dayton Manufacturing Co. On Tab A develop a Level production plan. Include monthly and total costs On Tab B develop a Chase production plan. Include monthly and total costs. 11 12 13 Month # of Days Forecast Level Strategy 14 September 20 15,200 15 October 23 14,500 16 November 21 11,000 Day in Month 17 December 16 9,250 18 19 Data Box Aggregate Forecast Regular Time Production (Units) 20 Productivity and Cost Data Overtime Production (Units) 21 Material and Overhead $/Unit 150 Number of Workers Hired 22 Inventory Holding Cost $/Unit on End Inv. 2 Number of Workers Fired 23 Regular Time Production $/Hour 14 Subcontracting (Units) 24 Overtime Prodsution $/Hour 21 Beginning Inventory 25 Max OT as % of Regular Time Production 20 Ending Inventory 26 Subcontracting $/Unit 235 27 Cost to Fire $/Person 600 28 Cost to Hire $/Person 950 29 30 Labor Hours/Unit 2 Costs Regular Time Production Overtime Production Hiring Workers 31 Productiion Hours/Day 10 Firing Workers 32 Subcontracting 33 Beginning Inventory Level (Units) 1200 Material and Overhead 34 Desired Minimun Monthly End Inv. (Units) 500 35 Inventory (Based on EI) Monthly Total Costs 36 37 38 39 < Tab A - Level Tab B - Chase + Ready Accessibility: Investigate 55°F Sunny Q Search Overall Cost Of the Plan ENG E 12:01 AM 4/9/2024 72% PRE
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing