Question: Consider the following partially completed master schedule record: a. Complete the projected on-hand inventory calculations and the available-to-promise calculations. b. Suppose that a customer calls

Consider the following partially completed master schedule record:
On-hand inventory at end of April: 40 ****** June" Month Week Forecasteda. Complete the projected on-hand inventory calculations and the available-to-promise calculations.
b. Suppose that a customer calls and cancels an order for 50 units in week 25. Which of the following statements are true?
•The ATP for week 25 will increase by 50 units.
• The projected ending inventory for week 25 will increase by 50 units.
• The ATP for weeks 19 and 22 will be unaffected.

On-hand inventory at end of April: 40 ****** June" Month Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise *May** ******: 19 20 21 22 225 23 24 25 26 200 200 200 225 225 200 200 205 203 201 195 193 190 182 178 600 675 600 240

Step by Step Solution

3.31 Rating (181 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

436-B-M-L-S-C-M (2805).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!