FSC Master Production Schedule Worksheet

Question Description

create a time-phased Master Production Schedule in Excel using the information below.

Excelsior Springs Ltd. schedules production of one end product, Hi-Sulphur, in batches of 80 units whenever the projected ending inventory balance in a quarter falls below 10 units. It takes on quarter to make a batch of 80 units. Excelsior currently has 30 units on hand.

The sales forecast for the next four quarters is:

Quarter 1 = 20

Quarter 2 = 70

Quarter 3 = 70

Quarter 4 = 20

You also need to:

Prepare a time-phased MPS record showing the sales forecast and MPS for Hi-Sulphur.

What are the inventory balances at the end of the quarter?

Based on what the software company selected to determine the business environment, the organization services, and the MPS techniques they cater to with their software, explain how this company will benefit your organizational needs.