Home

***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.

The company I chose is TESLA
You can also refer to Mergent Onlineand Business Insights (GALE)for more information on how to use these databases.
Using the same publicly traded company you used in the Environmental Scanning Interactive Assignment, TESLA, research the company online by accessing the Mergent database. Also, access the Business Insights (GALE), which offers information on global companies and industries. The database includes SWOT reports, market share data, financial reports, case studies, business news, and company comparison charts.
You may always research using credible online sources of corporate financial information; just be sure that wherever you obtain financial information, you cite your source.
For this discussion, you will look at the financial statements for the company you selected and, using the previous quarter’s financial data, interpret the data and propose a budget for the next quarter based on your current and prior analysis of company performance.
Complete the budget template using the Operating Budget Template Download Operating Budget Template: Template will be provided
List the current sales, discounts and allowances, net sales, margins, operating costs, and earnings before and after taxes. Include a minimum of two financial ratios (below) in your analysis. 
Prepare the next quarter’s budget based on your interpretation of past data.
Include at least three of the following types of relevant financial ratios in your analysis
Profitability Ratio 
Liquidity Ratio 
Solvency Ratio 
Valuation Ratio 
Leverage Ratio
In your initial post, provide a brief description of your company, a summary of your Operating Budget, and a rationale supporting suggested budgetary changes. Attach your Operating Budget Template to your initial post for your instructor and peers’ review.