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 1Week12345678Ft130130130140140140145145Dt453818 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 12345678Ft 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 3OrderQuantityDesired week1120421446310024753

Find the Given details below: Weeks 1 2 3 4 5 6 7 8 Forecast 130 130 130 140 140 140 145 145…

Answered: The schedular at ZamTech uses MPS…

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

Concept explainers

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 (F_t) and orders (D_t) for the next 8 weeks, as shown in Table 1.

Table 1

Week	1	2	3	4	5	6	7	8
F_t	130	130	130	140	140	140	145	145
D_t	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
F_t
D_t
EI_t-1
P_t
EI_t
ATP_t

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

Step by step

Solved in 8 steps with 16 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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