Question

In: Statistics and Probability

Use the following table to answer questions: Month Sales (in $1,000) January 123 February 135 March...

Use the following table to answer questions:

Month

Sales (in $1,000)

January

123

February

135

March

130

April

140

May

144

June

154

July

140

August

150

September

140

  1. Using a two month moving average, what is the forecast for October?
    1. 142
    2. 143
    3. 144
    4. 145
  1. Using a 3 month weighted moving average where the latest month has a weight of 0.5 and the month before that 0.3 and the oldest month has a weight of 0.2, what is the forecast for October?
    1. 142
    2. 143
    3. 144
    4. 145
  1. The Forecast for May was 141. Using an alpha of 0.3, what is the forecast for October using exponential smoothing (round your answer to the nearest integer)?
    1. 142
    2. 143
    3. 144
    4. 145

Solutions

Expert Solution

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE PLEASE SUPPORT ME WITH YOUR RATING.....

***PLEASE GIVE ME "LIKE"......THANK YOU...


Related Solutions

Given the following information for Nugget Corporation, answer the questions below. November December January February March...
Given the following information for Nugget Corporation, answer the questions below. November December January February March Sales $300,000 $250,000 $275,000 $325,000 $350,000 Cash collected in month of sale 10% Credit collections:      Collected in month of sale 10%      Collected in month following the sale 75%      Collected in second month following the sale 15% Each question should have one amount in the answer field. You must format your answers as follows: $x,xxx Total collections from cash sales for the...
Given the following information for Nester Company, answer the questions shown below: December January February March...
Given the following information for Nester Company, answer the questions shown below: December January February March Sales $500,000 $550,000 $450,000 $600,000 Purchases $120,000 $140,000 $115,000 $150,000 Twenty percent of purchases are paid in cash at the time of purchase. The remaining balance is paid in the month following the purchase. Monthly operating expenses are as follows: Sales salaries $10,000 Depreciation expense $2,500 Property taxes $2,000 paid at the end of each calendar quarter Sales commissions 1.5% paid in the month...
Given the following information for Nugget Corporation, answer the questions below. November December January February March...
Given the following information for Nugget Corporation, answer the questions below. November December January February March Sales $300,000 $250,000 $275,000 $325,000 $350,000 Cash collected in month of sale 10% Credit collections: Collected in month of sale 10% Collected in month following the sale 75% Collected in second month following the sale 15% Each question should have one amount in the answer field. You must format your answers as follows: $x,xxx 1 Total collections from cash sales for the quarter ending...
SALES PER MONTH DURING THE LAST YEAR 20X1 JANUARY $ 550,000 FEBRUARY $ 825,000 MARCH $...
SALES PER MONTH DURING THE LAST YEAR 20X1 JANUARY $ 550,000 FEBRUARY $ 825,000 MARCH $ 575,000 APRIL $ 870,000 MAY $ 1,080,000 JUNE $ 1,065,000 JULY $ 1,070,000 AUGUST $ 1,060,000 SEPTEMBER $ 1,180,000 OCTOBER $ 1,140,000 NOVEMBER $ 1,290,000 DECEMBER $ 1,460,000 I. Sales Projection: 20X2 After consulting the Company's Management Committee, it was agreed that business plans and strategies were deemed appropriate, a 35% increase in sales reported during the months of last year 20x1. All sales...
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14 10 -Compute the RSFE, MAD and tracking signals for months January to April?
It is January 1 of Year 2. Sales for Harry Company for January, February, and March...
It is January 1 of Year 2. Sales for Harry Company for January, February, and March are forecasted to be as follows: January, $200,000; February $400,000; March, $500,000. 80% of sales are credit sales; the remaining 20% of sales are cash sales. Of these credit sales, 10% are collected during the month of sale, 30% in the following month, and 60% in the second following month. TOTAL sales for November and December of Year 1 were $200,000 and $400,000, respectively....
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march...
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march april may cash 17,000 19640 16200 15380 17390 credit 40,000 42000 48000 50000 49500 if collections of credit sales are 70% the first month and 30% the second month, what would be the cash receipts for march, april, and may
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production in units 19,600 20,600 19,300   One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 25% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Garrison 16e Rechecks 2017-10-03 Multiple Choice 20,925 pounds 20,575 pounds 20,275 pounds 18,325 pounds , Depasquale Corporation is...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in units 18,500 19,500 17,400 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 19,970 pounds 18,630 pounds 18,870 pounds 20,130 pounds
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT