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

Our papers are 100% unique and written following academic standards and provided requirements. Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Rely on us and be on schedule! With our help, you'll never have to worry about deadlines again. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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

Thanks!

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. Sales Forecasting January February March April May June Previous year (cases) 5734 5845 5890 6132 6587 6735 Prev Yr Promotion (cases)         300 300 Previous year base (cases) 5734 5845 5890 6132 6287 6435 Growth 3.0% 172 175 177 184 189 193 Base projection (cases) 5906 6020 6067 6316 6476 6628 Promotion Projection (cases)           450 Sales forecast (cases) 5906 6020 6067 6316 6476 7078 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. Sales Volume July August September October November December Previous year (cases) 6702 6427 6315 6104 6008 5830 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: Sales & Ops Planning December January February March April May June Sales Forecast (cases)   5906 6020 6067 6316 6476 7078 Production plan (cases)   6050 5900 6250 6316 6925 6425 Inventory (cases) 100 244 124 307 307 756 103 Working days   22 20 22 21 23 21 Capacity (cases)   7333 6667 7333 7000 7667 7000 Utilization (%)   83 89 85 90 90 92 NRG-A 70%   4235 4130 4375 4421 4848 4498 NRG-B 30%   1815 1770 1875 1895 2078 1928 The number of working days for each month is shown below: July August September October November December Work Days 21 18 20 23 20 17 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. Week 1 Week 2 Week 3 Week 4 Week 5   7/2 – 7/6 7/9 – 7/13 7/16 – 7/20 7/23 – 7/27 7/30 – 7/31      8/1 – 8/3 Workdays in Month 21 21 21 21 21                        18 Workdays in Week 2                           3 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: Oats    Lead time = 2 weeks Week 1 Week 2 Week 3 Week 4 Week 5 MPS NRG – A 752 940 940 940 984 (cases) NRG – B 322 403 403 403 422 MPS NRG – A 108 135 135 135 142 (500 lb batch) NRG – B 46 58 58 58 61 Gross requirements (lb) 44,090 55,087 55,087 55,087 57,667 Scheduled receipts 44,000 44,000       Planned receipts     88,000 44,000 44,000 On hand 11650 11,560 473 33,386 22,299 8,632 Planned orders 88,000 44,000 44,000     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.   Quantity Ingredient     Oats (lb) 300 240 Wheat Germ (lb) 50 60 Cinnamon (lb) 5 5
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. Sales Forecasting January February March April May June Previous year (cases) 5734 5845 5890 6132 6587 6735 Prev Yr Promotion (cases)         300 300 Previous year base (cases) 5734 5845 5890 6132 6287 6435 Growth 3.0% 172 175 177 184 189 193 Base projection (cases) 5906 6020 6067 6316 6476 6628 Promotion Projection (cases)           450 Sales forecast (cases) 5906 6020 6067 6316 6476 7078 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. Sales Volume July August September October November December Previous year (cases) 6702 6427 6315 6104 6008 5830 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: Sales & Ops Planning December January February March April May June Sales Forecast (cases)   5906 6020 6067 6316 6476 7078 Production plan (cases)   6050 5900 6250 6316 6925 6425 Inventory (cases) 100 244 124 307 307 756 103 Working days   22 20 22 21 23 21 Capacity (cases)   7333 6667 7333 7000 7667 7000 Utilization (%)   83 89 85 90 90 92 NRG-A 70%   4235 4130 4375 4421 4848 4498 NRG-B 30%   1815 1770 1875 1895 2078 1928 The number of working days for each month is shown below: July August September October November December Work Days 21 18 20 23 20 17 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. Week 1 Week 2 Week 3 Week 4 Week 5   7/2 – 7/6 7/9 – 7/13 7/16 – 7/20 7/23 – 7/27 7/30 – 7/31      8/1 – 8/3 Workdays in Month 21 21 21 21 21                        18 Workdays in Week 2                           3 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: Oats    Lead time = 2 weeks Week 1 Week 2 Week 3 Week 4 Week 5 MPS NRG – A 752 940 940 940 984 (cases) NRG – B 322 403 403 403 422 MPS NRG – A 108 135 135 135 142 (500 lb batch) NRG – B 46 58 58 58 61 Gross requirements (lb) 44,090 55,087 55,087 55,087 57,667 Scheduled receipts 44,000 44,000       Planned receipts     88,000 44,000 44,000 On hand 11650 11,560 473 33,386 22,299 8,632 Planned orders 88,000 44,000 44,000     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.   Quantity Ingredient     Oats (lb) 300 240 Wheat Germ (lb) 50 60 Cinnamon (lb) 5 5

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
Writerbay.net

Hi, student! You are probably looking for a free essay here, right? The most obvious decision is to order an essay from one of our writers. It won’t be free, but we have an affordable pricing policy. In such a manner, you can get a well-written essay on any topic. Let us cover any of your writing needs!


Order a Similar Paper Order a Different Paper