Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table shows the quarterly sales of Undercover Umbrellas over a period of two years. Sales are shown at quarterly intervals throughout the yea

image text in transcribed
The following table shows the quarterly sales of "Undercover Umbrellas" over a period of two years. Sales are shown at quarterly intervals throughout the yea
\table[[Year,Quarter,Sales ( million),\table[[4-point moving average],[(f million)]]],[2019,1,8.4,],[2019,2,2.3,],[2019,3,1.6,],[2019,4,6.9,],[2020,1,8.8,],[2020,2,2.7,],[2020,3,2.4,],[2020,4,Not available,]]
The first 4-point moving averages has been calculated (see table above).
i) Calculate the next three 4-point moving averages:
Second 4-point moving average: million pounds
Third 4-point moving average: million pounds
Fourth 4-point moving average: million pounds
ii) A trendline was used to predict the next 4-point moving average and obtained a value of 5.3 million pounds
Use this value to predict the sales for the 4th quarter of 2020.
The predicted sales for the 4th quarter of 2020 are: million pounds
image text in transcribed

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

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

1259307417, 978-1260153132, 1260153134, 978-1259307416

Students also viewed these Accounting questions

Question

Determine the voltage Vo in the circuit shown. 12V 4 4 4 V. 2 2I

Answered: 1 week ago