HomeworkLib
Question

Answers Provided: Without excel-how do I calculate them with a calculator?-again answers provided Month Orders January...

Answers Provided: Without excel-how do I calculate them with a calculator?-again answers provided

Month Orders
January 130
February 138
March 152
April 160
May 173
June 184
July 191
August 196
September 201
October 211
November 222
December 237

What is the 4-period moving average for May? =145.00

What is the 4-period moving average for June? =155.75

What is the 4-period moving average for July? =167.25

What is the 4-period moving average for August?=177.00

What is the 4-period moving average for September?=186.00

What is the 4-period moving average for October?=193.00

What is the 4-period moving average for November?199.75

What is the 4-period moving average for December?=207.50

What is the 4-period moving average for next January?=217.75

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Let actual orders for period t be denoted by At

Let the forecast for period t be denoted by Ft

For a 4 period moving average, Ft = (At-1 + At-2 + At-3 + At-4)/4

Calculating using the above formula -

Month (t) Orders (A) Forecast (F)
January 130
February 138
March 152
April 160
May 173 =(130+138+152+160)/4=145
June 184 =(138+152+160+173)/4=155.75
July 191 =(152+160+173+184)/4=167.25
August 196 =(160+173+184+191)/4=177
September 201 =(173+184+191+196)/4=186
October 211 =(184+191+196+201)/4=193
November 222 =(191+196+201+211)/4=199.75
December 237 =(196+201+211+222)/4=207.5
January =(201+211+222+237)/4=217.75
0 0
Add a comment
Know the answer?
Add Answer to:
Answers Provided: Without excel-how do I calculate them with a calculator?-again answers provided Month Orders January...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2...

    PYHTON Try! Consider a dictionary for the month months Dictionary = { 1 : "January", 2 : "February", 3 : "March", 4: "April", 5 : "May", 6 : "June", 7 : "July", 8: "August", 9 : "September", 10 : "October", 11: "November", 12 : "December" } . Prints out all the items, both key and value, in the dictionary Prints out all the keys in the dictionary Prints out just the values in the dictionary Loops though using the keys...

  • The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential...

    The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 180.44 $ 626.46 February 180.49 632.84 March 202.81 561.38 April 219.75 551.30 May 188.05 491.58 June 212.77 484.78 July 246.46 609.09 August 193.09 532.86 September 224.87 510.36 October 215.67...

  • The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple...

    The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) IBM AMZN January $ 180.44 $ 626.46 February 180.49 632.84 March 202.81 561.38 April 219.75 551.30 May 188.05 491.58 June 212.77 484.78 July 246.46 609.09 August 193.09 532.86 September 224.87 510.36 October 215.67 610.82 November 200.39 583.73...

  • AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12...

    AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...

  • The past sales history for Store 6 is provided in the table below. Adjust this data...

    The past sales history for Store 6 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years.  Report the re-seasonalized forecast period 36. Month Year Period Store 6 January 1 1 56602 February 1 2 72016 March 1 3 104245 April 1 4 100981 May 1 5 95962 June 1 6 83167 July 1 7 62842 August 1 8 60116 September 1 9 41353 October 1 10 34862 November 1 11...

  • Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83...

    Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83 March 1.70 September 1.70 April 1.85 October 1.65 May 1.90 November 1.70 June 1.87 December 1.75 Use a 3-month moving average and add the 3-month plot to the graph created in part (a). Which is better (using the mean absolute deviation): the 2-month average or the 3-month average? Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of...

  • Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices...

    Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) January Februasy Mareh April June July August September October November December IM $174.44 176.49 190.21 206.45 192.85 208.17 233.16 205.39 220.07 214.47 195.89 175.34 AKZN $611.96...

  • The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16,...

    The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.

  • Problem 8-3 Simple Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices for IBM and A...

    Problem 8-3 Simple Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.) January February March April MAY June July August September October November December IBM AMZN $ 175.04 $ 613.41 176.89 623.12 191.47 574.07 207.78 547.70 192.37 510.30 208.63 495.58 234.49 606.39...

  • The past sales history for Store 7 is provided in the table below. Adjust this data...

    The past sales history for Store 7 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years.  Report the MAD value for the re-seasonalized forecast. Month Year Period Store 7 January 1 1 54483 February 1 2 66981 March 1 3 87332 April 1 4 90292 May 1 5 82586 June 1 6 78925 July 1 7 68756 August 1 8 58782 September 1 9 32654 October 1 10 33480 November...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT