***PLEASE FOLLOW THE INSTRUCTIONS AND SUBMIT WHAT ITS ASKING FOR. THIS ASSIGNMENT REQUIRES YOU TO SHOW YOUR WORK SO PLEASE SHOW YOUR WORK. THERE IS ALSO AN EXCEL SHEET GIVEN FOR YOU TO FILL OUT THANK YOU***
QSO 330 Module Two Assignment Guidelines and Rubric
Overview
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.
What to Submit
Using the MPS Planning Grid Worksheet, complete all cells in the Campaign Weekly Periods table. Save your completed Excel spreadsheet by adding your first and last name in the file name (QSO 330 MPS Planning Grid – Your Name). Submit the completed spreadsheet for grading.
