please see the attached file for questions and instruction I am looking for spreadsheets for this questions. Thanks!

instructions:

• Read the requirements carefully before you form your solution

• Proofread the writing for any errors before the submission

• Develop spreadsheets for calculation using Excel, submit the spreadsheet as your final answer, making certain that all the formulas used are included. Format the spreadsheets so that each table is on a unique tab, and set up each tab so that it fits a letter size landscape page

• Where possible use calculations rather than manual redundant data entry, both across and within spreadsheets to minimize data copying errors

• You can add any explanation or discussion, if necessary, in adjacent cells

• Additional data required, or methods to develop the tables not shown here can be gained by looking at Concepts in ERP Chapter 4

The Fitter Snacker forecast for the first half of the year is shown below.

Following the format of the table above create a spreadsheet to forecast Fitter Snacker’s sales for the next six months. Assume that the sales growth is 3.5%, and calculate the base projection using the previous year’s data shown below.

Also assume that the special marketing promotion last year resulted in increased sales of 200 cases, and that this year sales will likely increase by 350 in July.

The sales forecast resulted in a sales and operation plan that looked like the following:

The number of working days for each month is shown below:

Now create the Sales and Operations Plan for the next six months, July through December for this year. Do this twice, once by creating a spreadsheet that sets a single value for capacity utilization, and a second time by creating a spreadsheet that allows the utilization to float. Your input variables are the production plan numbers, and the starting inventory in June, which can be increased up to a total of 200 cases.

As you assess your plan for viability, look carefully at utilization, your ability to meet the sales forecast, and your inventory levels. Write a short paragraph that explains how you made your choices; assume that you are defending the plan to the CEO, CFO, and the Plant Manager.

Your next step is to further disaggregate the plan to a weekly level, and then to a daily level for Week 5, using the calendar below. Do this once only for the second of the Sales and Operations Plans that you created.

The final step is to calculate the MRP Record for Wheat Germ for the 5 Week period.

Use the following table format, but do NOT copy the data, use the data you have developed:

A partial Bill of Material (BOM) for Fitter Snacker Bars for a 500lb batch is shown below. Wheat germ has a lead time of one week, and comes in a 300lb lot size, the on-hand inventory is 650lb. Scheduled receipt for week 1 is 11,400lb.