Year/Number of Years Since 1971/Number of stores

• Identify the initial value and the growth rate of your exponential model and explain what they mean in the context of Starbucks Stores. Put your explanations in a text box.

• Use your exponential model to predict the number of Starbucks locations in the following years:

1980, 1990, 2000, 2010, 2020, 2030, 2040, 2050

ou have just begun work at XYZ Manufacturing Company. Among its benefits offerings is a generous qualified 401(k) plan with an employer match. In 2015, your annual salary is $45,000 and you are age 55. You’ve decided to contribute 10 percent of your annual salary to your 401(k) plan even though the Internal Revenue Service allows you to contribute up to $24,000 in 2015 ($18,000 plus a $6,000 catch up contribution for employees age 50 or more). The annual addition is $53,000.

   1   How much more money would you need to contribute to meet the allowable maximum contribution?

   2   In 2015, the company offers a $0.75 match for each dollar that you contribute between 3 percent and 6 percent of your annual salary. How much is the company match based on your 10 percent contribution?

   3   Based on the sum of your answers to questions 9-9 and 9-10, what is the difference between the IRS maximum annual addition for 2015 and the total contribution to your 401(k) plan?

Suppose you are the following data on prices and quantities transacted:

If the economy produced all three (and only these three) goods, compute the nominal GDP in both periods and real GDP at 2006 prices. What is the rate of inflation in 2007, as measured by the change in the GDP deflator?

Suppose a CPI is constructed using weights corresponding to quantities produced in 2006. What is the rate inflation measured by the CPI?

Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the required​ return.)

What is the arithmetic growth rate of the dividends for Davy's Crock Pot Stores​? (Round to two decimal​ places.)

What is the geometric growth rate of the dividends for Davy's Crock Pot Stores​? Round to two decimal​ places.)

What is the required rate of return for Davy's Crock Pot Stores​? Round to two decimal​ places.)

The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July 2013) of a room at two-star, three-star, and four-star hotels in cities around the world in 2013.

e. Compute the covariance between the average price at two-star and three-star hotels, between two-star and four-star hotels, and between three-star and four-star hotels.

f. Compute the coefficient of correlation between the average price at two-star and three-star hotels, between two-star and four-star hotels, and between three-star and four-star hotels.

g. Which do you think is more valuable in expressing the relation-ship between the average price of a room at two-star, three-star, and four-star hotels—the covariance or the coefficient of cor-relation? Explain.

h. Based on (f), what conclusions can you reach about the relationship between the average price of a room at two-star, three-star, and four-star hotels?

3. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:
Year Worldwide Revenue in Billions
2004 8.2
2005 13.9
2006 19.3
2007 24.6
2008 37.5
2009 42.9
2010 65.2
2011 108.2
2012 156.5
2013 170.9
2014 182.8
2015 233.72
2016 215.64
2017 229.23
2018 265.6
2019 260.17

a. 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.
b. 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.
i. Naïve forecast from one prior time period
ii. Calculate a 4-period moving average
iii. 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
c. 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?
d. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
i. Put your regression output in F1 of the same workbook.
ii. Calculate what your forecast is for 2020 in F21.
iii. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

this is the complete qs

You have just begun work at XYZ Manufacturing Company. Among its benefits offerings is a generous qualified 401(k) plan with an employer match. In 2015, your annual salary is $45,000 and you are age 55. You’ve decided to contribute 10 percent of your annual salary to your 401(k) plan even though the Internal Revenue Service allows you to contribute up to $24,000 in 2015 ($18,000 plus a $6,000 catch up contribution for employees age 50 or more). The annual addition is $53,000.

Questions: 9-9. How much more money would you need to contribute to meet the allowable maximum contribution?

9-10. In 2015, the company offers a $0.75 match for each dollar that you contribute between 3 percent and 6 percent of your annual salary. How much is the company match based on your 10 percent contribution?

9-11. Based on the sum of your answers to questions 9-9 and 9-10, what is the difference between the IRS maximum annual addition for 2015 and the total contribution to your 401(k) plan?

The following table provides the project annual budget, total number of projects, and total number of people working on the projects for City of Killingcovid annually:

For A to F, use the data between Yr 2006 and Yr 2015 to calculate the following:

A. The mean of the Number of People Working on the Project.
B. The median of the Budget.
C. The range of Budget.
D. The variance (3 significant figures) of Number of Projects.
E. The standard deviation (nearest integer) of Number of People Working on the Project.
F. The 20% trimmed mean of Number of Projects.

G. Draw a dot plot comparing the Number of People Working on the Project from Yr 1997 to Yr 2006 and those from Yr 2009 to Yr 2018.

H. Using the data for Annual Budget from Yr 2001 to Yr 2017, draw a double stem leaf plot, then calculate the relative frequency.

2.   Calculate Mean Absolute Error ( MAD) for the data in question 1 for the three     methods used. Round MAD to two decimal places. ( 4 marks)

What does MAD measures? which of these three forecasting methods provides better forecast of the revenue data ? ( 2 mark)