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).

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter4: Polynomial And Rational Functions

Section4.6: Rational Functions

Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.

See similar textbooks

Related questions

Q: The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are…

A: Given that -

Q: Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3…

A: Given Information: Consider the given data: Months Cash Sales 1 2145600 2 2175200 3 2255200…

Q: A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are…

A: The trend equation, The quarter relative are The period and demand data set is,Period,…

Q: A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are…

A: Given information: The data represents the values of demand for the periods 1 to 9.

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: Each week, Heldi puts money from her paycheck Into her savings account. The table below shows the…

A: The given data is modelled with a linear best fit equation. X axis represents the number of weeks…

Q: The accompanying data represent the yearly amount of solar power installed (in megawatts) in a…

A: The provided information is as follows:The following data represents the yearly amount of solar…

Q: You plot some data of Real Frequency versus HP Dial Frequency and get a linear trend of y = 1.01 x…

A: From the given data, the equation of the plot between the real frequency and the HP dial frequency…

Q: 0 represent 2000.† (a) Write a linear model for the data.

A: Personal income (in billions of dollars) in the United States was 12,430 in 2008 and 14,167 in 2013.…

Q: A region’s trend of wages for nurses who have received and Masters of Science in Nursing (MSN)…

A: Here we create a linear model by taking last and first point.

Q: A city's population in the year �=1970 was �=991,300. In 1993 the population was 998,200.Compute the…

A: The objective of this question is to calculate the rate of population growth or decline per year…

Q: pllowing are the data on demand for white bread loave Day 2 3 4 5 6 7 8 9 10 11 12 Loaves 199 209…

A: day loaves 1 199 2 209 3 215 4 226 5 233 6 237 7 252 8 257 9 253 10 265 11…

Q: The table below show data that has been collected from different fields from various farms in a…

A: Solution: A. Let X be the grams and Y be the vitamin C content in mg. The regression equation is…

Q: A company has the following monthly sales for the past year. Plot the data points on a line graph…

A: Given data,

Q: A coffee chain sells temperature-controll of mugs for the last twelve months in 201 Month January…

A: a) Here Month (x) = Independent variable Sales (y) = Dependent variable

Q: Assume that the median rent will grow linearly, and use the data in the table below to find a…

A: Given that median rent grows as a linear function.

Q: Does this graph have trends and/or seasonality? What forecasting method is suitable for this data?

A: Introduction: In time series data, trend is the general pattern exhibited by the data over a…

Q: 11+28.9000X₁ con to view the data table. = 22.1

A: A regression model's predictions are measured for accuracy by using standard error of the estimate.…

Q: A patient is classified as having gestational diabetes if their average glucose level is above 140…

Q: Use the Women's Earnings scatterplot below to answer the questions. Women's Earnings as a Percentage…

A: From the scatterplot, the linear regression equation is y^=0.617x-1156.3. Estimate the women’s…

Q: A city's population in the year 1958 was 2,113,000. In 1991 the population was 2,099,800. Compute…

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 following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…
An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017, the data collected is shown in the Table 1 below. FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017. Year JALSH (Y) CPI (X) 2006 0.41 4.7 2007 0.19 7.1 2008 -0.23 11.5 2009 0.32 7.1 2010 0.19 4.3 2011 0.03 5.0 2012 0.27 5.6 2013 0.21 5.7 2014 0.11 6.1 2015 0.05 4.6 2016 0.00 6.4 2017 0.21 5.3 The estimated regression…
Consider the following estimated trend models. Use them to make a forecast for t = 20.a. Linear Trend: yˆy^ = 12.86 + 1.09t (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) Quadratic Trend: yˆy^ = 18.58 + 0.89t − 0.01t2 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) c. Exponential Trend: ln(y)ˆln(y)^ = 1.9 + 0.07t; se = 0.05 (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.)
A network server has an original value of 10, 000 and is to be depreciated linearly over 5 years with a 3000 scrap value. Find an expression giving the book value at the end of year t . What will be the book value of the server at the end of the second year? What is the rate of depreciation of the server?
A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate. Sales data consist of trend and seasonality. Quarter relatives are 1.06 for the first quarter, 1.03 for the second quarter, 0.61 for the third quarter, and 1.30 for the fourth quarter. Using the appropriate values of quarter relatives and the equation Ft = 187 +9.2t for the trend component, estimate demand for periods 9-12. (Round all calculations to two decimal points. Demand Period 9 Demand Period 10 Demand Period 11. Demand Period 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%…
1b) Plot Jresp along with the concentrations of Benzene in blood, fat, non-fat and liver in a 24h window (pdf). Why is Jresp slightly decreasing within 6h of exposure?
Please do it in Excell..
Solve with the help of graph
What do the Forecast for each year add up to?
Which are the graphs for quantitative data?
How can we calculate the Average Rates of Change?