Question) Based on the explanation above, complete the master schedule file (see the image below What do the projected ending inventory and available-to-promise numbers look like? Has Realco over- promised? In your view, should Realco update either the forecast or the production numbers?

Two years ago, Johnny Chang's company, Realco, introduced a new breadmaker, which, due to its competitive pricing and features, was a big success across the United States. While delighted to have the business, Johnny felt uneasy about the lack of formal planning surrounding the product. He found himself constantly wondering, Do we have enough bread-makers to meet the orders we've already accepted? Even if we do, will we have enough to meet expected future demands? Should I be doing something right now to plan for all this? To get a handle on the situation, Johnny decided to talk to various folks in the organization. He started with his inventory manager and found out that inventory at the end of last week was 7,000 units. Johnny thought this was awfully high. Johnny also knew that production had been completing 40,000 breadmakers every other week for the last year. In fact, another batch was due this week. The production numbers were based on the assumption that demand was roughly 20,000 breadmakers a week. In over a year, no one had questioned whether the forecast or production levels should be readjusted. Johnny then paid a visit to his marketing manager to see what current orders looked like. No problem," said Jack Jones, I have the numbers right here." Week Promised Shipment 1 23500 2 23000 3 21500 4 15050 5 13600 6 11500 7 5400 8 1800 Johnny looked at the numbers for a moment and then asked, "When a customer calls, how do you know if you can meet the order?" "Easy," said Jack. "We've found from experience that nearly all orders can be filled within two weeks, so we promise them three weeks. That gives us a cushion, just in case. Now look at weeks 1 and 2. The numbers look a little high, but between inventory and the additional 40,000 units coming in this week, there shouldn't be a problem." Week: 1 2 3 4 5 6 7 8 Total planhed orders Booked olders Projected ending inventory Master production schedule Available to promise