excel 4. Forecasting. Nave method versus three period Moving Average The number of major plumbing...

50.1K

Verified Solution

Question

Finance

excel

4. Forecasting. Nave method versus three period Moving Average The number of major plumbing repair jobs performed by Augurs Plumbing Service in each of the last six months is listed below. Month Jobs October 92 November 94 December 98 January 95 February 99 March 104 a. Use the textbook nave method to forecast April jobs (Ft+1 = Xt + (Xt Xt-1). b. Use the three- period moving average to forecast jobs in April c. Based upon the MAD (mean absolute deviation), determine whether the three-period moving average or textbook nave method is more accurate, based upon forecasts for January through March.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students