Question

I have the following data Week of Expenses Revenues Profit 6-Dec-04 103,084 122,533 19,449 13-Dec-04 99,584...

I have the following data

Week of Expenses Revenues Profit
6-Dec-04 103,084 122,533 19,449
13-Dec-04 99,584 131,036 31,452
20-Dec-04 94,936 137,813 42,877
27-Dec-04 100,757 114,495 13,738
3-Jan-05 102,736 120,579 17,843
10-Jan-05 94,866 182,122 87,256
17-Jan-05 96,158 137,983 41,825
24-Jan-05 97,013 104,668 7,655
31-Jan-05 97,796 117,807 20,011
7-Feb-05 106,315 157,735 51,420
14-Feb-05 92,307 145,685 53,378
21-Feb-05 89,923 129,758 39,835
28-Feb-05 100,546 130,642 30,096
7-Mar-05 99,270 85,895 (13,375)
14-Mar-05 98,632 125,994 27,362
21-Mar-05 100,273 113,194 12,921
28-Mar-05 100,006 127,209 27,203
4-Apr-05 105,531 114,713 9,182
11-Apr-05 92,774 145,468 52,694
18-Apr-05 103,169 151,959 48,790
25-Apr-05 105,794 68,623 (37,171)
2-May-05 98,534 126,485 27,951
9-May-05 97,474 97,000 (474)
16-May-05 102,492 121,350 18,858
23-May-05 105,295 137,074 31,779
30-May-05 99,640 152,589 52,949
6-Jun-05 101,201 153,171 51,970
13-Jun-05 99,726 136,244 36,518
20-Jun-05 96,206 101,012 4,806
27-Jun-05 100,878 156,135 55,257
4-Jul-05 99,439 125,567 26,128
11-Jul-05 95,537 154,901 59,364
18-Jul-05 105,354 128,439 23,085
25-Jul-05 89,897 116,745 26,848
1-Aug-05 91,257 168,639 77,382
8-Aug-05 104,675 148,706 44,031
15-Aug-05 93,216 141,687 48,471
22-Aug-05 102,284 141,879 39,595
29-Aug-05 103,959 106,889 2,930
5-Sep-05 97,823 169,328 71,505
12-Sep-05 97,765 126,747 28,982
19-Sep-05 108,032 154,728 46,696
26-Sep-05 101,433 162,576 61,143
3-Oct-05 96,548 138,661 42,113
10-Oct-05 93,295 158,689 65,394
17-Oct-05 100,227 135,165 34,938
24-Oct-05 97,876 112,240 14,364
31-Oct-05 102,985 118,904 15,919
7-Nov-05 100,099 141,778 41,679
14-Nov-05 102,245 161,104 58,859
21-Nov-05 102,353 140,226 37,873
28-Nov-05 105,811 133,108 27,297
  1. Having thought about Mr. James’s suggestion, you consider several options as an estimate of lost profits.  These include 1) the full year, 2) the last six months only, 3) a weighted average that gives twice the weight to the last six months as to the first six months, or 4) some other weighted average.  Which method do you think gives the most accurate estimate of lost profits?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the data below to answer this questions. Period Employment Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30...
Use the data below to answer this questions. Period Employment Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30 Apr-01 1,914.60 May-01 1,961.50 Jun-01 1,960.60 Jul-01 1,953.40 Aug-01 1,940.20 Sep-01 1,928.00 Oct-01 1,909.20 Nov-01 1,896.40 Dec-01 1,881.40 Jan-02 1,880.20 Feb-02 1,884.00 Mar-02 1,902.60 Apr-02 1,913.40 May-02 1,937.40 Jun-02 1,990.90 Jul-02 1,994.80 Aug-02 2,013.10 Sep-02 2,002.30 Oct-02 1,982.50 Nov-02 1,969.00 Dec-02 1,959.20 Jan-03 1,928.20 Feb-03 1,952.40 Mar-03 1,980.40 Apr-03 1,972.00 May-03 1,987.80 Jun-03 2,018.70 Jul-03 2,027.80 Aug-03 2,030.20 Sep-03 2,012.20 Oct-03 2,032.30 Nov-03 2,008.30...
Use the data below to answer this questions. a.) Generate a scatter of the data b....
Use the data below to answer this questions. a.) Generate a scatter of the data b. ) Report the monthly averages (January for all years, February for all years etc.) c.) Is there seasonality? Is there a trend? d.) How can you forecast the value for March 2020? Generate that forecast. e.) (Not technical) This forecast will for sure be wrong. Why? Reference period Employment 3 Persons Jan-01 1,879.50 Feb-01 1,901.00 Mar-01 1,925.30 Apr-01 1,914.60 May-01 1,961.50 Jun-01 1,960.60 Jul-01...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 5.39 Feb-06 4.83 Mar-06 5.41 Apr-06 4.64 May-06 4.05 Jun-06 3.41 Jul-06 3.92 Aug-06 3.46 Sep-06 5.06 Oct-06 5.44 Nov-06 4.96 Dec-06 4.17 Jan-07 3.48 Feb-07 4.7 Mar-07 4.38 Apr-07 3.82 May-07 4.19 Jun-07 4.35 Jul-07 3.83 Aug-07 5.42 Sep-07 3.29 Oct-07 4 Nov-07 3.42 Dec-07 3.24 Jan-08 5.21 Feb-08 4.84 Mar-08 4.59 Apr-08 3.82 May-08 3.61 Jun-08 4.34 Jul-08 4.94 Aug-08...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date...
Consider a portion of monthly return data (In %) on 20-year Treasury Bonds from 2006–2010. Date Return Jan-06 3.13 Feb-06 4.15 Mar-06 3.18 Apr-06 4.94 May-06 4.34 Jun-06 4.19 Jul-06 5.12 Aug-06 5.26 Sep-06 3.81 Oct-06 3.1 Nov-06 3.87 Dec-06 4.89 Jan-07 3.94 Feb-07 3.42 Mar-07 4.13 Apr-07 3.54 May-07 4.58 Jun-07 4.19 Jul-07 4.62 Aug-07 3.89 Sep-07 3.62 Oct-07 3.92 Nov-07 4.46 Dec-07 3.23 Jan-08 4.78 Feb-08 4.71 Mar-08 5.05 Apr-08 3.46 May-08 3.15 Jun-08 4.82 Jul-08 3.87 Aug-08...
Given the following history, use a three-quarter moving average to forecast the demand for the third...
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC     Last year 165 185 200 230 240 265 210 200 195 265 290 315   This year 175 200 165 260 260 200   Forecast...
Year Month Return Year Month Return 2006     Jan 3.95 2008     Jul 3.29 2006     Feb 3.77 2008...
Year Month Return Year Month Return 2006     Jan 3.95 2008     Jul 3.29 2006     Feb 3.77 2008     Aug 4.62 2006     Mar 5.29 2008     Sep 4.81 2006     Apr 3.77 2008     Oct 5.16 2006     May 4.47 2008     Nov 3.69 2006     Jun 5.2 2008     Dec 5.15 2006     Jul 3.9 2009     Jan 5.29 2006     Aug 4.33 2009     Feb 3.19 2006     Sep 4.41 2009     Mar 3.89 2006     Oct 5.14 2009     Apr 4.48 2006     Nov 3.24 2009     May 5.27 2006     Dec 4.13 2009     Jun 3.93 2007     Jan...
FOR4. The Excel file Unemployment Rates provides data on monthly rates for 4 years. (8 pts)...
FOR4. The Excel file Unemployment Rates provides data on monthly rates for 4 years. (8 pts) a.         Develop 3- and 6-months moving average forecasts, and exponential smoothing forecasts (use alpha of your choice) b.         Using MAD as a criterion, explain which model yields better forecast? DATA: Unemployment Rates Year Month Rate (%) 2009 Jan 7.8 2009 Feb 8.3 2009 Mar 8.7 2009 Apr 9.0 2009 May 9.4 2009 Jun 9.5 2009 Jul 9.5 2009 Aug 9.6 2009 Sep...
Rounded to the nearest whole number, what is the standard deviation for Google weekly closing prices...
Rounded to the nearest whole number, what is the standard deviation for Google weekly closing prices from December 12, 2008 to December 4, 2009?   4-Dec-09 585.01 27-Nov-09 579.76 20-Nov-09 569.96 13-Nov-09 572.05 20-Nov-09 551.1 30-Oct-09 536.12 23-Oct-09 553.69 16-Oct-09 549.85 9-Oct-09 516.25 2-Oct-09 484.58 25-Sep-09 492.48 18-Sep-09 491.46 11-Sep-09 472.14 4-Sep-09 461.3 28-Aug-09 464.75 21-Aug-09 465.24 14-Aug-09 460 7-Aug-09 457.1 31-Jul-09 443.05 24-Jul-09 446.72 17-Jul-09 430.25 10-Jul-09 414.4 2-Jul-09 408.49 26-Jun-09 425.32 19-Jun-09 420.09 12-Jun-09 424.84 5-Jun-09 444.32 29-May-09 417.23...
A local bookstore recorded their revenue (in thousands) for the last 36 months starting in September,...
A local bookstore recorded their revenue (in thousands) for the last 36 months starting in September, as provided below. a. find the deseasonalized line of best fit b. use the additive model of seasonal forecasting to predict the revenue for each month of the next academic year c. use the multiplicative model of seasonal forecasting to predict the revenue for each month of the next academic year d. what is the predicted total profit for the academic year for each...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for two of Vanguard’s mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. a. Calculate the sample correlation coefficient rxy. b. Specify the competing hypotheses in order to determine whether the population correlation coefficient is different from zero. H0: ρxy ≥ 0; HA: ρxy < 0 H0: ρxy ≤ 0; HA: ρxy > 0 H0: ρxy = 0; HA: ρxy ≠ 0 c-1....