Solution:-
Average Duration = Sum of Duration of Subsequent expansion / no of Duration
= 50 + 80 + 37 + 45 + 39 + 24 + 106 + 36 + 58 + 12 + 92 + 120 + 73 / 13
= 772 / 13
= 59.38
Average duration = 59 months (rounded)
Minimum Duration = 12 Months
Maximum Duration = 120 Months
Using the table below, find the average duration, the minimum duration, and the maximum duration of...
Problem 16-02 Refer to the minimum wage history data in the table below: Oct. 1938 $0.25 Jan. 1978 $2.65 Oct. 1939 0.30 Jan. 1979 2.90 Oct. 1945 0.40 Jan. 1980 3.10 Jan. 1950 0.75 Jan. 1981 3.35 Mar. 1956 1.00 Apr. 1990 3.80 Sept. 1961 1.15 Apr. 1991 4.25 Sept. 1963 1.25 Oct. 1996 4.75 Feb. 1967 1.40 Sept. 1997 5.15 Feb. 1968 1.60 July 2007 5.85 May. 1974 2.00 July 2008 6.55 Jan. 1975 2.10 July 2009 7.25 Jan....
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
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 170 200 210 240 250 270 225 215 215 275 280 300 This year 205 210 140 255 245 220 Forecast...
Product Sales by Month Product X Product Y Product Z $100,000 $80,000 Value $60,000 $40,000 $20,000 May July Sept Nov Apr Aug Oct Dec $0 Jan Mar Feb June Month Activity: Interpret this line graph in 30-50 words. ....
1)Given the data in the table, calculate the four period moving average forecast for unemployment rate for October 2011. Express your result in percent, without the percent sign (e.g., 7.3 for 7.3%). Unemployment Year Month Rate (%) 2010 Oct 6.8 Nov 7.0 Dec 7.5 2011 Jan 8.0 Feb 8.2 Mar 8.5 Apr 8.6 May 8.6 Jun 8.9 Jul 9.1 Aug 8.8 Sep 8.7 Oct
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 19,034 July 99,711 Feb 5,265 Aug 80,177 Mar 80,177 Sep 19,034 Apr 99,711 Oct 80,177 May 19,034 Nov 5,265 June 5,265 Dec 99,711 Sales are collected as follows: In the month of Sales: 43% In the next month: 33% After 2 months: 9% After 3 months: remainder is collected What...
What is the cash collection for October? Sales are: In the month of sales: 25% In the next month: 22% After 2 months: 7% After 3 months: remainder is collected Month Sales $ Month Sales $ Jan 34,599 July 20,706 Feb 33,253 Aug 67,777 Mar 67,777 Sep 34,599 Apr 20,706 Oct 67,777 May 34,599 Nov 33,253 June 33,253 Dec 20,706
The table contains the Sales estimates for the next year. Month Sales $ Month Sales $ Jan 46,442 July 37,618 Feb 36,143 Aug 39,034 Mar 39,034 Sep 46,442 Apr 37,618 Oct 39,034 May 46,442 Nov 36,143 June 36,143 Dec 37,618 The Purchases are 78% of Sales. Purchases are paid in the following month. The administrative expenses of $7,990 are paid each month Tax expenses of $12,127 are...
Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,350 3,150 3,750 2,970 4,500 3,110 3,180 4,620...
1) a) Construct a 95% confidence interval about the mean response at x = 46 using the data set Steam. b) Calculate the R2 value and the coefficient of correlation for the data set Steam. Steam Data Set Month Temperature(x) Usage/1000 (y) Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec 21 24 32 43 50 59 70 74 62 50 41 30 185.79 214.47 288.03 424.84 454.58 539.03 621.55 675.06 562.03 452.93 369.95 273.98