Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Predict the sales for 20X9 using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6 $680,000 20X7 $590,000

1. Predict the sales for 20X9 using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $720,000 20X6 $680,000 20X7 $590,000 20X8 $620,000 $562,857 projection using the moving average method. Year Sales 20X2 $450,000 20X3 $385,000 20X4 $495,000 20X5 $470,000 ($720,000-$250,000) 20X6 $680,000 20X7 $590,000 20X8 $620,000 $527,143 Predict the 20X9 sales using exponential smoothing. Predict the 20X9 using a trend line technique using (GROWTH function in Excel). Predict the sales for 20X9 using a graphing technique. It has been suggested that sales for the company may be connected to disposable income. Using the information below regarding historical disposable income, predict the sales for 20X9 using regression analysis if a reliable prediction for disposable income for 20X9 is $45,720. Year/Sales 20X2$36,200 20X3$37,140 20X4$38,120 20X5$38,450 20X6$41,190 20X7$43,220 20X8$42,850 5Which method do you think provides the most realistic sales projections for 20X9? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Analysis And Security Valuation

Authors: Stephen H Penman

4th Edition

0073379662, 9780073379661

More Books

Students also viewed these Accounting questions

Question

A greater tendency to create winwin situations.

Answered: 1 week ago