The schedular at ZamTech uses MPS time-phased records for planning and item production. The planner is currently working on a schedule for a strut assembly, one of ZamTechs top-selling spare parts.The planner uses a production lot size of 170 and a safety stock of 15 for the strut assembly. The planner has the following forecasts (Ft) and orders (Dt) for the next 8 weeks, as shown in Table 1. Table 1 Week 1 2 3 4 5 6 7 8 Ft 130 130 130 140 140 140 145 145 Dt 45 38 18           Required: a) Help the master production scheduler to fill in the MPS time-phased record shown in Table 2 for the strut assembly. There are 120 units on hand. Table 2   1 2 3 4 5 6 7 8 Ft                 Dt                 EIt-1                 Pt                 EIt                 ATPt                 b) Can the planner accept the following orders? Update the MPS time-phased record for accepted orders, in Table 3. Table 3 Order Quantity Desired week 1 120 4 2 144 6 3 100 2 4 75 3

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter12: Queueing Models
Section: Chapter Questions
Problem 59P
icon
Related questions
Question

The schedular at ZamTech uses MPS time-phased records for planning and item production. The planner is currently working on a schedule for a strut assembly, one of ZamTechs top-selling spare parts.The planner uses a production lot size of 170 and a safety stock of 15 for the strut assembly. The planner has the following forecasts (Ft) and orders (Dt) for the next 8 weeks, as shown in Table 1.

Table 1

Week 1 2 3 4 5 6 7 8
Ft 130 130 130 140 140 140 145 145
Dt 45 38 18          

Required:

a) Help the master production scheduler to fill in the MPS time-phased record shown in Table 2 for the strut assembly. There are 120 units on hand.

Table 2

  1 2 3 4 5 6 7 8
Ft                
Dt                
EIt-1                
Pt                
EIt                
ATPt                

b) Can the planner accept the following orders? Update the MPS time-phased record for accepted orders, in Table 3.

Table 3

Order Quantity Desired week
1 120 4
2 144 6
3 100 2
4 75 3

 

Expert Solution
steps

Step by step

Solved in 8 steps with 16 images

Blurred answer
Knowledge Booster
Introduction to Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
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
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning