Question

In: Operations Management

PROBLEM 1: Sales records for the last six quarters for Howard Bakery which is famous for...

PROBLEM 1:


Sales records for the last six quarters for Howard Bakery which is famous for its multi-grain bread are given below: (Sales data are in thousands of pounds, but ignore the last three zeros for ease of computation.)

Quarter                             Sales ($)

  1. 240
  2. 260
  3. 300
  4. 280
  5. 320
  6. 360
  1. Using a three-quarter simple moving average method, forecast sales for each

successive quarter.

  1. Using a three-quarter weighted moving average method, forecast sales for each successive quarter. (Use weights of 0.1, 0.3 and 0.6 for each quarter where 0.1 is for the most distant quarter, 0.3 for the next most distant quarter, and 0.6 for the most recent quarter.)  
  2. Evaluate the two forecasts using the Cumulative Forecast Error (CFE) method (also called Bias or Arithmetic Sum of Forecast Error). Which of the two forecasts above—(a) or (b) is better based on the CFE test? Note: Show your computations.

Solutions

Expert Solution

Formulae to be used:

Error = Actual- Forecast

CFE= Sum of errors

  • Forecast of a period with n period moving average = average of last n periods demand
  • Weighted Forecast of July period = (0.6*sales of most recent period + 0.3*sales of next most recent period+ 0.1*sales of third recent period)

a.

t Actual, At 3 period moving average forecast, Error= Actual- Forecast
q1 240
q2 260
q3 300
q4 280 266.67 13.3
q1 320 280.00 40.0
q2 360 300.00 60.0
q3 320.00
113.33
CFE

b.

t Actual, At Forecast weighted moving average(wts 0.6, 0.3,0.1) Error= Actual- Forecast
q1 240
q2 260
q3 300
q4 280 282.00 -2.0
q1 320 284.00 36.0
q2 360 306.00 54.0
q3 340.00
88.00
CFE

c. Weighted moving average forecast is better than moving average forecast because its CFE is less than the other.


Related Solutions

Advertising expenditures and sales for the last 5 quarters have been as follows: Quarter Advertising expenditures...
Advertising expenditures and sales for the last 5 quarters have been as follows: Quarter Advertising expenditures Sales 1 1 4 2 1 5 3 2 6 4 2 7 5 4 8 In quarter 3, a new product was introduced that would influence sales in quarter 3. 4 and 5. The following model is established: y=β1x1+β2x2+ ε where y=sales, x1=advertising expenditures, x2 is a variable that is 1 when the new product is available and 0 otherwise, and ε is...
Based on an analysis of the last six months’ sales, your boss notices that sales of...
Based on an analysis of the last six months’ sales, your boss notices that sales of beef products are declining in your chain’s restaurants. As beef entrée sales decline, so do profits. Fearing beef sales have declined due to several newspaper stories reporting E.coli contamination discovered at area grocery stores, he suggests a survey of area restaurants to see if the situation is pervasive. What do you think of this research suggestion? How, if at all, could you improve on...
The regions with the six highest volumes of sales for a corporation last year are shown...
The regions with the six highest volumes of sales for a corporation last year are shown below. 1. Southwest 2. Northeast 3. Northern 4. Southeast 5. Western 6. Northwest Determine whether the data are qualitative or quantitative and identify the data​ set's level of measurement. Are the data qualitative or​ quantitative? Quantitative Qualitative What is the data​ set's level of​ measurement? A. Interval B. Nominal C. Ratio D. Ordinal
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent,...
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent, driven by a 50 percent increase in the demand for bran muffins. Most of the increase was attributed to a report that diets rich in bran help prevent certain types of cancer. You are the manager of a bakery that produces and packages gourmet bran muffins, and you currently sell bran muffins in packages of three. However, as a result of this new report,...
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent,...
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent, driven by a 50 percent increase in the demand for bran muffins. Most of the increase was attributed to a report that diets rich in bran help prevent certain types of cancer. You are the manager of a bakery that produces and packages gourmet bran muffins, and you currently sell bran muffins in packages of three. However, as a result of this new report,...
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent,...
The American Baker’s Association reports that annual sales of bakery goods last year rose 15 percent, driven by a 50 percent increase in the demand for bran muffins. Most of the increase was attributed to a report that diets rich in bran help prevent certain types of cancer. You are the manager of a bakery that produces and packages gourmet bran muffins, and you currently sell bran muffins in packages of three. However, as a result of this new report,...
ABC Company has the following sales budget for the last six months of 2020:
  Note: Not all sales are always collected. Remember Bad Debt Expense. So don’t worry if the problems do not add up to 100%.   1. ABC Company has the following sales budget for the last six months of 2020:                   July                             $9,000                                          August                      $8,000                                          September                 $11,000                   October                      $9,000                        Historically, the cash collection of sales has been as follows:                                     35% of sales collected in the month of sale,                                     45% of sales collected in the month...
Copper Corporation has the following sales budget for the last six months of 2016:
Copper Corporation has the following sales budget for the last six months of 2016:July$200,000October$180,000August160,000November200,000September220,000December188,000Historically, the cash collection of sales has been as follows:65 percent of sales collected in month of sale,25 percent of sales collected in month following sale,8 percent of sales collected in second month following sale, and2 percent of sales is uncollectable.Cash collections for October are$117,000.$174,000.$184,800.$199,000.$176,400.
The following are the data regarding quarterly sales: Quarters Sales 1 500 2 350 3 250...
The following are the data regarding quarterly sales: Quarters Sales 1 500 2 350 3 250 4 400 5 450 6 350 7 200 8 300 9 350 10 200 11 150 12 400 Find the forecast value of the sales for each quarter starting with Quarter 6, by using a 4-quarter moving average.                   Evaluate this forecasting method using MAD.                   Evaluate this forecasting method using MSE.                   Evaluate this forecasting method using MAPE.                   Evaluate this forecasting method...
1. Kingda Ka is one of Six Flags famous roller coasters. It does not have a...
1. Kingda Ka is one of Six Flags famous roller coasters. It does not have a running engine. A hydraulic launcher “shoots” the roller coaster with an initial velocity of 57 m/s and relies on the conservation of energy to take care of the rest until the end of the ride. The first hill that the roller coaster goes over is 127 meters above the original launch height. After the coaster returns to the original launch height, it goes over...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT