Year   Percentage
2000   28
2001   32
2002   36
2003   40
2004   44
2005   51
2006   53
2007   57
2008   60
2009   66

Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment.

alpha= 0.3 and beta= 0.4. Then calculate MAD.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Quarter   Price
Q1 2017   186.3
Q2 2017   190.9
Q3 2017   195.2
Q4 2017   195.2
Q1 2018   198.7
Q2 2018   201.2

Forecast the price index for Q3 2018 using a​ three-period simple moving average. Then calculate MAD.

1. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:

1. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet.
2. Make the following forecasts for 2020. For all of them, use Mean Squared Error to determine which of the forecasts is the best. Make sure your answers are clearly labeled.
   1. Naïve forecast from one prior time period
   2. Calculate a 4-period moving average
   3. Calculate a 3-period moving average with the following weights for time t: time period t-1=0.8, t-2 = 0.15, t-3=.05
3. In the tab called Apple Smoothing, use the data from 3. to forecast 2020 using an alpha equal to 0.7, 0.8, and 0.9. Using MSE, which one offers the best estimate for 2020?
4. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
   1. Put your regression output in F1 of the same workbook.
   2. Calculate what your forecast is for 2020 in F21.
   3. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

PLEASE PROVIDE STEP BY STEP AND FORMULAS FOR EXCEL, THANK YOU

You have the following historical annual total returns on Terlingua Oil & Gas Exploration:

Calculate the sample standard deviation of annual return.

Assume you are doing a financial analysis for Kroger Inc. Here is one of the income statements that you analyze (all figures in $ Millions):

Based on your analysis of the income statements. What can be said about the progress. Which areas are improving? Sales increased from 2004 to 2005 yet net profit decreased . Why do you think they decreased net income in 2005 with higher sales. sales? 2006 seems to be better. What did the fix?

Business is becoming more and more competitive, and organisations have realised that purchasing and Supply Chain Management (SCM) are key factors in satisfying customers. Buyers and supply chain managers can contribute significantly to the organisation's profits. An organisation can spend as much as 50% of its sales revenue on purchasing parts, services, components and raw material. Therefore, efficient, mutually beneficial and constructive relationships with suppliers are very important to the organisation's short-term financial position and long-term competitive power.

1. Differentiate between constructive and competitive negotiation. (10)
2. Discuss the guidelines for maintaining positive supplier and customer relationships. (10)

The data set below contains 100 records of heights and weights for some current and recent Major League Baseball (MLB) players.

Note: BMI 18.5 - 24.9 normal group, 25 - 29.9 overweight group and > 30 obese group. 

Compute the body mass index (BMI) (703 times weight in pounds, divided by the square of the height in inches) of each major league baseball player

height Weight(pounds) Age
70 195 25
74 180 23
74 215 35
72 210 31
72 210 35
73 188 36
69 176 29
69 209 31
71 200 35
76 231 30
71 180 27
73 188 24
73 180 27
74 185 23
74 160 26
69 180 28
70 185 34
72 197 30
73 189 28
75 185 22
78 219 23
79 230 26
76 205 36
74 230 31
76 195 32
72 180 31
71 192 29
75 225 29
77 203 32
74 195 36
73 182 26
74 188 27
78 200 24
73 180 27
75 200 25
73 200 28
75 245 30
75 240 31
74 215 31
69 185 32
71 175 28
74 199 28
73 200 29
73 215 24
76 200 22
74 205 25
74 206 27
70 186 33
72 188 31
77 220 33
74 210 33
70 195 31
76 244 37
75 195 26
73 200 23
75 200 25
76 212 24
76 224 35
78 210 27
74 205 31
74 220 28
76 195 30
77 200 25
81 260 24
78 228 30
75 270 26
77 200 23
75 210 26
76 190 25
74 220 32
72 180 24
72 205 25
75 210 24
73 220 24
73 211 32
73 200 30
70 180 24
70 190 32
70 170 23
76 230 27
68 155 26
71 185 26
72 185 28
75 200 25
75 225 33
75 225 35
75 220 31
68 160 29
74 205 29
78 235 28
71 250 34
73 210 31
76 190 38
74 160 24
74 200 26
79 205 24
75 222 24
73 195 28
76 205 33
74 220 36

Refer to the Baseball 2016 data, which reports information on the 2016 Major League Baseball season. Let attendance be the dependent variable and total team salary be the independent variable. Determine the regression equation and answer the following questions.

Draw a scatter diagram. From the diagram, does there seem to be a direct relationship between the two variables?

What is the expected attendance for a team with a salary of $100.0 million?

If the owners pay an additional $30 million, how many more people could they expect to attend?

At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis.

What percentage of the variation in attendance is accounted for by salary?

Determine the correlation between attendance and team batting average and between attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables.

Show all work in Excel

Question 1 Sales for the Forever Young Cosmetics Company (in $ millions) are as follows:

(a) Develop a three-year moving average.

(b) Develop a four-year moving average.

(c) Develop a five-year moving average.

(d) Develop a seven-year rmoving average.