Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales...

  

Transcribed Image Text:

Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales for July through December. Calculate the base projection using the previous year's values (shown in Figure 1), and factor in the 3 percent estimated growth rate. Assume that the special marketing promotion last year resulted in an increase in sales of 200 cases for July and that a special marketing promotion this year will result in an increase in sales for July of 400 cases. Sales volume July August September October November December Previous year 6702 6327 6215 6007 5954 5813 Source line: Course Technology /Cengage Learning. FIGURE 1 Fitter's sales for last year, July through December Sales forecasting Previous year (cases) January February March April May June 5734 5823 5884 6134 6587 6735 Promotion sales (cases) Previous year base (cases) Growth 300 300 5734 5823 5884 6134 6287 6435 3.0 % 172 175 177 184 189 193 Base projection (cases) Promotion (cases) Sales forecast (cases) 5906 5998 6061 6318 6476 6628 500 5906 5998 6061 6318 6476 7128 Source line: Course Technology /Cengage Learning. FIGURE 2 Fitter's sales forecast for January through June Following the format of the spreadsheet in Figure 2, develop a spreadsheet to forecast Fitter's sales for July through December. Calculate the base projection using the previous year's values (shown in Figure 1), and factor in the 3 percent estimated growth rate. Assume that the special marketing promotion last year resulted in an increase in sales of 200 cases for July and that a special marketing promotion this year will result in an increase in sales for July of 400 cases. Sales volume July August September October November December Previous year 6702 6327 6215 6007 5954 5813 Source line: Course Technology /Cengage Learning. FIGURE 1 Fitter's sales for last year, July through December Sales forecasting Previous year (cases) January February March April May June 5734 5823 5884 6134 6587 6735 Promotion sales (cases) Previous year base (cases) Growth 300 300 5734 5823 5884 6134 6287 6435 3.0 % 172 175 177 184 189 193 Base projection (cases) Promotion (cases) Sales forecast (cases) 5906 5998 6061 6318 6476 6628 500 5906 5998 6061 6318 6476 7128 Source line: Course Technology /Cengage Learning. FIGURE 2 Fitter's sales forecast for January through June

Answer rating: 100% (QA)

Company F has not formally developed its sales forecasting and production patterns Adopting the inst... View the full answer