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

The Answer is in the image, click to view ...

Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I need to know how to do the sections under Master It! and Solution Ross, Westerfield, Jaffe, and Jordan's Spreadsheet Master Corporate Finance, 11th edition by Brad Jordan and Joe Smolira Version...

Q1 Q2 Q3 : 9.6 Q4 Jimmy Horne commenced a car rental business on 1 January 20x2. Jimmy purchased a vehicle for Sao ooo on 1 January 20X2. He bought another vehicle costing $60 000 on 30 September...

I need help with an Accounting Payroll Project. I have included all of the necessary instructions and attachments. I would appreciate any help or guidance that I can get. I have to prepare the...

if some one would be able to help me describe Hisco's company using the Strengths, Weaknesses, Opportunities, and Threats (SWOT Analysis) based on the information provided. Also,what the best...

Need assistance in describing Hisco's company using the Strengths, Weaknesses, Opportunities, and Threats (SWOT Analysis) based on the information I attached. Also, what would be the best strategy...

if some one would be able to help me describe Hisco's company using the Strengths, Weaknesses, Opportunities, and Threats (SWOT Analysis) based on the in photos attached. Also, what the best strategy...

Need assistance in describing Hisco's company using the (SWOT Analysis) Strengths- Weaknesses- Opportunities- Threats Also, what would be the best strategy would will be for the next two to three...

i really need help, please help me,I need get them done before 9:00pm tonight.I will thumb up. Thank you so much 2020 State of Nebraska Payroll Project Bugeater's Corporation Federal EIN: 47-9876543...

Two companies with different economic-value-added (EVA®) profiles are Dakota Oil Pipeline, Inc., and Arkansas Bank Limited. Adapted versions of the two companies financial statements are...

Compute the maximum diameter sand particle that can be suspended in a 12-lbm/gal fluid having a gel strength of 7 lbf/100 sq ft. Answer: 0.070 in.

A single-input, single-output system has the state variable representation + -10 [8](0) y(t) = [010]x(t) The transfer function of the system T(s) = Y(s)/U(s) is: a. T(s) = b. T(s) = c. T(s) = d. T(s)...

STARTER CODE: # 0. Place your necessary imports here. You may find it useful to be able to plot when debugging and visualizing your result. import numpy as np # 1. Create a 1D vector named `t` and 2D...

Taj Ramaj, a sole-proprietor, created Juicy Lemonade on December 1, 2020. Juicy Lemonade is a wholesaler that specializes in selling organic flavored lemonades to colleges and universities,...

For each of the periodic signals shown in Fig. P2.7-4, find the exponential Fourier series and sketch the amplitude and phase spectra. Note any symmetric property (b) 20x -20n -10n 10n -1/4 (d) 1/4 2n

Attica Prison, located in upstate New York, was built in 1931, was fully paid for many years ago, and is still being used today. During the 1990s, however, the state developed a scheme to raise...

create a flowchart that represents the algorithmic solution to the following problem ( python ) . The program you aim to create needs to gather first a time of the day in 2 4 h format. This needs to...

8. How can an interpreter influence the message?

The geographical location of the sender, i.e. where the sender resides

Subjective norms, i.e. the norms of the target group