Question

In: Statistics and Probability

Suppose a company has the following sales for the last six months (January – June): Month...

Suppose a company has the following sales for the last six months (January – June):

Month Period Sales
January 1 16
February 2 25
March 3 20
April 4 20
May 5 31
June 6 35
July 7 26
August 8 (a)

Use exponential smoothing (a= 0.10) to forecast the sales for August (to 2 decimals). What is the value?

Compute the MSE for the exponential smoothing method from the above question (to 2 decimals).

Use a 2-period moving average to forecast the sales for August (to 2 decimals). (i.e.find (a) using a 2-period moving average)

Solutions

Expert Solution


Related Solutions

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.
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January 80,000 February 90,000 March 120,000 April 150,000 May 180,000 June 120,000 Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month. Three kilograms of materials...
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...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March $41,000 June $47,000 April 50,000 July 58,000 May 32,000 August 62,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales.    March $52,000 June $58,000 April 61,000 July 69,000 May 43,000 August 73,000    Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 35 percent are collected in the month of sale, 25 percent are collected in the following month, and 30 percent are collected two months after...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $269,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $251,000 September $52,000 $269,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 9% are collected in the third month following sale, and the remaining...
Thomas Train has collected the following information over the last six months.
Thomas Train has collected the following information over the last six months.MonthUnits producedTotal costsMarch10,000$25,600April12,00026,200May19,60028,000June13,00026,450July12,00026,000August15,00026,500Using the high-low method, what is the variable cost per unit?Round to two decimal places.
Milford Company has the following sales projection (in units) for the next six months: Feb: 2100...
Milford Company has the following sales projection (in units) for the next six months: Feb: 2100 Mar: 2300 Apr: 1900 May: 2600 Jun: 2200 Jul: 1700 Each unit sells for $37 through April and $42 starting in May. Milford has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 1900 2600 2200 6700 Selling price per unit x $37 x $42 x $42 Sales revenue $70300 $109200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT