Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below

Post by answerhappygod »

Charlie Owns A Company That Sells And Installs Hot Tubs Sales Are Fairly Consistent From Year To Year The Table Below 1
Charlie Owns A Company That Sells And Installs Hot Tubs Sales Are Fairly Consistent From Year To Year The Table Below 1 (41.81 KiB) Viewed 18 times
Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below shows average sales per month for the previous year. Average Sales per Month Month February 550 March 450 April 600 May 850 June 925 July 675 August 500 a) Calculate the simple 3-month moving average forecast for May - August. (9 points) May: 550+450+600/3=533.33 June: 450+600+850/3=633.33 July: 600+850+925/3 = 791.67 August: 850+925+675/3=816.67 b) Calculate the weighted 3-month moving average for May- August using weights of 0.55, 0.30, and 0.15 (highest weight for the most recent period). (9 points) May = (550*0.15)+( c) Calculate the single exponential smoothing forecast for May- August using an initial forecast (F1) for February of 500, and an a of 0.45. (12 points)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply