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.

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.

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)

a. The actual graph

b. The explanation of what it tells you.

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

a. List all costs and their values you  used in the calculations.

I. For example, Production costs, $150 per1000 board feet

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

I. for example, Maximum shipping capacity, 1500000board feet per month