As a supply chain professional, you will be asked to manage a company$$s inventory based on a projected forecast. The Master Production Schedule $($MPS$)$ is a tool that allows you to schedule material for your company in concert with the production of goods to be sold. Your job for this assignment is to take an MPS and plan out the amount of material needed for each week of production.

Directions

Complete this activity using the MPS Planning Grid Worksheet linked in the What to Submit section below. The Excel sheet has been filled in for the first three weeks to give you an example. For this assignment, you will need to fill in the rest of the spreadsheet. Show your work by inserting MS Excel formulas to calculate the correct values for all cells containing $$x$.$

The Excel sheet shows the following notes:

Sales for the first three weeks in the Excel sheet add up to $64$ units.

The sales for SME are projected to be $25$ units every week.

The first three weeks in the Excel sheet are using the sold units because they are in the past and have already been realized. Campaign Weekly Periods Four through Eight are projected.

Specifically, you must address the following rubric criteria:

Complete all MPS Planned Order Receipt and Planned Order Release fields.

Accurately calculate the Projected Available Balance values for Campaign Weekly Periods Four through Eight using MS Excel formulas.

Accurately calculate the Net Requirements values for Campaign Weekly Periods Four through Eight using MS Excel formulas.