Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. b) Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: 2018 (0.1), 2019 (0.3) and 2020(0.6).

Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. b) Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: 2018 (0.1), 2019 (0.3) and 2020(0.6).

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 2AGP

See similar textbooks

Related questions

Q: My App is a small but growing start-up that sees demand for several of its apps increasing quickly.…

A: a) From the given information, the smoothing parameter is 0.30. Given that the forecast for the…

Q: Calculate the regression equation of sales on expenditure. Find also the possible sale when the…

Q: Polulation Growth at a School 1200 y= 39.5x + 765.5 1000 800 600 400 200 years: year 12021 -…

A: We have to predict the population growth at a new school in the year 2030 using the given graph of…

Q: vt 14. Calculate trend values by the method of Least Square from the data given below 4. and…

Q: Cynthia’s Design Studios had sales in the last four months of $12,700, $14,500, $19,100, and…

A: Given :Cynthia’s Design Studios had sales in the last four months of $12,700, $14,500, $19,100, and…

Q: A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate. Sales…

A: The forecasting trend equation is: Ft=187+9.2t.The quarter relatives are Q1=1.06, Q2=1.03, Q3=0.61,…

Q: The line graph below shows the average US price for one gallon of gasoline on the first Monday of…

A: The given line graph shows the average US price for one gallon of gasoline on the first Monday of…

Q: Silver Tin 23.8 13.4 31.21 12.83 35.24 15.75 20.2 12.4 14.69 8.37 15 11.29 13.41 8.99 11.57 5.65…

A: It is given that the price of silver and tin over a recent 9 year period.

Q: mex PLC has gathered following information on the sales of face mask from April 2020 to eptember…

A: Let months following April be denoted by 1, 2, 3 and so on. And

Q: During periods when the unadjusted federal minimum wage is constant, identify the trend that you…

A: Introduction: The unadjusted federal minimum wages are shown using the solid line, whereas the…

Q: The following table gives the average monthly exchange rate between the U.S. dollar and the euro for…

A: The given data is as follows: January1.289February…

Q: 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the…

A: Definition of Correlation coefficient: Correlation coefficient is a measure of degree or extent of…

Q: Table 3 shows the actual per liter prices for unleaded petrol for June of each year between 1978 and…

A: Inflation: An increase in the price due to the change in time is referred to as inflation. This…

Q: In an ever-changing economy, the price of fuel is never constant for too long. The following table…

A: Laspeyre's method are used to estimate the price of commodities in the base year as well as the…

Q: 1-8. The linear trend of sales of a company is Rs. 6,50,000 in 1995 and it rises by Rs. 16,500 per…

A: The linear trend equation for forecast can be given as: y^=a+bx, where, y^ be the forecasted value…

Q: Amex PLC has gathered following information on the sales of tace mask fPom Api September 2020. Month…

A: Let months following April be denoted by 1, 2, 3 and so on. And

Q: The equation for yearly sales (in 000 dollars) for a commodity with year 2011 as originy = 91.6…

Q: A network server has an original value of 10, 000 and is to be depreciated linearly over 5 years…

Q: The Pennsylvania State University had enrollments of 40,571 students in 2000 and 41,289 students in…

Q: Table #2.3.7 contains the value of the house and the amount of rental income in a year that the…

A: There are various types of graphs that are constructed for quantitative variables. One of the widely…

Q: Eloise needs to finish a 516-page report on international trade so she can present it at the big…

Q: Give an example of a nominal variable for people in recovery for substance abuse

A: Nominal variable: This type of variable are basically qualitative variables taking categories with…

Q: Using the photo attached, One Stop Car Repairs ollects data on the actual demand for its services…

A: Given data:

Q: ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned…

A: ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned…

Q: An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index return…

A: Given data:

Question

Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020.

Year	Sales ($ 000)
2015	4500
2016	5100
2017	4900
2018	5400
2019	5670
2020	6000

You are required to;

a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021.

b) Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: 2018 (0.1), 2019 (0.3) and 2020(0.6).

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 12 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

The equation for yearly sales (in 000 dollars) for a commodity with year 2011 as originy = %3D 91.6 +28.8X. Determine the trend equation to give monthly trend values with Jan. 2012 as origin and calculate the trend for March, 2012.
What is the forecast, including both trend and seasonality, for the fourth quarter of 2021. The regression equation is Y = 507.20 + 23X. X is for time period with time period 1 being first quarter 2021. The seasonal index is: 1QT = 0.76, 2QT = 1.20, 3QT = 0.68 (Please keep 2 decimal for your answer) Your Answer: Answer forrect order.
Calculate trend values by the method of least square from the data given below and estimate the sales for 1983 : Year 1976 1977 1978 1979 1980 : Sales of Co. ('000,000) : 70 74 80 86 90
Illustration 15.35. In trying to evaluate the effectiveness of its advertising campaign, a firm compiled the following data: Year: 1973 1974 1975 1976 1977 1978 1979 1980 48 Expenditure ('000): 12 Sale (lacs): 15 15 23 24 38 42 5.0 5.6 5.8 7.0 7.2 8.8 9.2 9.5
Describe the five-step process used to calculate the variance in the rate of return for an investment
Monthly sales have been found to follow a linear trend of y = 10 + 8x, where y is the number of items sold and x is the number of the month. Monthly deviations from the trend have been calculated and follow an additive model. In month 12, the seasonal variation is estimated to be -6. What is the forecasted number of items to be sold in month 12?
At the end of Year 5, your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts. You ask the service firm to provide several years of data on the percentage of uncollectible accounts based on the age categories of accounts receivable at the beginning of the year. With these historical percentages, you estimate a trend line (dashed line) to predict the percentage of uncollectible accounts for Year 6, the upcoming year. Graphs were provided to management from your analysis of each of the three age categories, as well as balances of accounts receivable by age category at the end of Year 5 as follows: Percentage of Uncollectible Accounts: 1-30 Days Past Due 8% 6% 4% 2% 0% 4% Year 1 Not Yet Past Due 2 3% 3 5% 5 6% 6 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 8 $0 18% 16% 14% 12% 10% 16% 14% Year 1 2 3 $128,000 14% Not Yet Past Due Accounts Receivable by Age: End of Year 5 $84,000 15% 1-30 Days Past Due 6 46% 44% 42% 40% 38%…
A popular television show recently released a video preview for the upcoming season on its website. As fans of the show discover the video, the number of views of the preview video has grown each day during the last 2 weeks. The number of days since the release of the video and the natural log of the number of video views is shown in the scatterplot. Based on the scatterplot and residual plot, what type of model would be appropriate for summarizing the relationship between days and number of views? An exponential model is appropriate because the residual plot does not show a clear pattern. A linear model is appropriate because the scatterplot shows a strong, positive linear relationship. A power model is appropriate because the scatterplot of days and natural log of views is strong and linear. An exponential model is appropriate because the relationship between days and the natural log of views is linear, and the residual plot does not show a clear pattern.
How does one do a trend analysis?
Calculate range and its co-efficient from the following statistical data: Profits ( $ in 000's) 125, 50, 30, 20, 80, 85, 90, 160, 180, 100, 170, 185, 155, 200, 140, 145.
Explain trend projection with regression?
Which are the graphs for quantitative data?