Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company first uses a spreadsheet to determine the capacity requirements for the main equipment (the fusion furnaces) and the production schedule for main products. Product#3050 had the following forecasted sales and outstanding orders (all in thousand pounds): January 2 25 February 1 Week 3 4 3 33 4 33 Forecast 25 25 33 33 Order 20 10 The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at the end of each week. Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around 40,000 units in each run. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks. Solution: January February WK2 WK3 WK4 WK1 WK2 WK3 WK4 Forecast 25 25 25 33 33 33 33 Committed 20 10 Beg Inv. Production 40 РОНІ (Min = 30) Available-
Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company first uses a spreadsheet to determine the capacity requirements for the main equipment (the fusion furnaces) and the production schedule for main products. Product#3050 had the following forecasted sales and outstanding orders (all in thousand pounds): January 2 25 February 1 Week 3 4 3 33 4 33 Forecast 25 25 33 33 Order 20 10 The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at the end of each week. Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around 40,000 units in each run. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks. Solution: January February WK2 WK3 WK4 WK1 WK2 WK3 WK4 Forecast 25 25 25 33 33 33 33 Committed 20 10 Beg Inv. Production 40 РОНІ (Min = 30) Available-
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...
Related questions
Question
A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company first uses a spreadsheet to determine the capacity requirements for the main equipment (the fusion furnaces) and the production
The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at the end of each week.
Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around 40,000 units in each run. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks.
Transcribed Image Text:Safari 11:57 PM Sat Mar 26
* 100%
•..
K Assignment 4 - Tasks
Home
Insert
Draw
Layout
Review
View
Cambria
12
B
I U
aA v
=>
Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning
software, the company first uses a spreadsheet to determine the capacity requirements for the main
equipment (the fusion furnaces) and the production schedule for main products. Product#3050 had the
following forecasted sales and outstanding orders (all in thousand pounds):
January
2
25
February
1
Week
3
4
25
3.
4
Forecast
25
33
33
33
33
Order
20
10
The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at
the end of each week.
Considering the holding and setup costs with EPQ, the company has found that the optimum
production quantity is around 40,000 units in each run. Use this production quantity to determine the
production schedule (MPS) and Available to Promise inventory for the next 7 weeks.
Solution:
January
February
WK2
WK3
WK4
WK1
WK2
WK3
WK4
Forecast
25
25
25
33
33
33
33
Committed
20
10
Beg Inv.
40
Production
РОНІ
(Min = 30)
Available-
Transcribed Image Text:following forecasted sales and outstanding orders (all in thousand pounds):
January
3.
February
Week
2
25
4
1
3.
4
Forecast
25
25
33
33
33
33
Order
20
10
The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at
the end of each week.
Considering the holding and setup costs with EPQ, the company has found that the optimum
production quantity is around 40,000 units in each run. Use this production quantity to determine the
production schedule (MPS) and Available to Promise inventory for the next 7 weeks.
Solution:
January
February
WK2
WK3
WK4
WK1
WK2
WK3
WK4
Forecast
25
25
25
33
33
33
33
Committed
20
10
Beg Inv.
40
Production
РОНІ
(Min = 30)
Available-
to-promise
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!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.