VI. Assignment Questions: Use the PowerPoint template to answer the two questions, do not make nay change to the excel file I have attached. The answers are already provided based on the excel sheet.

SCM 801

Green Mills Aggregate Planning

Sales and Operations Planning (S&OP) Assignment

Overview:

Green Mills is currently considering an aggregate plan for next year. This plan is given in “V. Example of Green Mills “Proposed Plan” and is shown below. It will be referred to as “The Proposed Plan.”

Based on the assignment questions you are to develop two alternative plans…

1. A “Level Plan"

2. A plan that must have a lower total cost than the “Proposed Plan.”

Do not leave the instructor guessing on the meaning of a particular slide. You might think of the notes as containing material you would verbalize when presenting your slides. Please, do not write volumes in the notes section. Be concise but clear on the meaning of each slide. All your extra information about a particular slide must fit on that 8.5 by 11 portrait version of the “Notes” page for a particular slide. Also do not re-write the question on the notes slide. Please just write either Q1, Q2, and Q3, at the top of the notes section.

The final slide should be a summary slide which explains the next action steps in the process that should occur. Please do not say items like “email me if you want more information’…. We are looking for concrete steps.

Consequently, when you submit information and the report, it needs to be compiled in a professional, well-analyzed, and thoughtful manner. Additionally, please make sure all items are professionally formatted.

1. 1. The actual document in PPT type file extension. These will include use of the ‘notes’ portion. No pdf file extensions.

   2. An Excel Workbook showing your financial calculations one showing the level plan the other showing the mixed plan. No pdf file extensions.

VI. Assignment Questions:

1. Graph the demand over time (Demand and Total Production on y-axis, January through December; Time by month on x-axis). Place both the Level Plan and your team’s proposed plan on the same graph. What does this graph tell you…Explain! This question has two parts: (5 points)

   1. The actual graph

   2. The explanation of what it tells you.

2. This question has two parts: (5 points)

   1. List all costs and their values that your team used in your calculations.

      1. For example, Production costs, $150 per 1000 board feet

   2. List all constraints the case has placed on the calculations

      1. For example, Maximum shipping capacity, 1500000 board feet per month