Question

The monthly demand (in Units) for a product from February until November 2010 are: 475,576,657,617,747,725,809,834,803,906 Use...

The monthly demand (in Units) for a product from February until November 2010 are:

475,576,657,617,747,725,809,834,803,906

Use the linear trend projection method to predict the demand in February 2011

Note: use at least 4 decimal places in the calculation and answer

Homework Answers

Answer #1

Please refer the image for the solution

Demand in February 2011 = 472.8935

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
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop Company in Des Moines:    Month Actual Demand Forecast Demand May 108 104 June 80 100 July 112 99 August 112 101 September 105 100 October 106 106 November 125 102 December 115 111 For the given forecast, the tracking signal = ___ MADs (round your response to two decimal places).
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...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23 Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponential smoothing using...
The annual demand for a product is 15,900 units. The weekly demand is 306 units with...
The annual demand for a product is 15,900 units. The weekly demand is 306 units with a standard deviation of 80 units. The cost to place an order is $33.50, and the time from ordering to receipt is eight weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 99 percent service probability. (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round "z" value to...
The demand for Carolina Industries’ product varies greatly from month to month. Based on the past...
The demand for Carolina Industries’ product varies greatly from month to month. Based on the past two years of data, the following probability distribution shows the company’s monthly demand: Unit Demand Probability 300 0.20, 400 0.30, 500 0.35, 600 0.15 (a) If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? Monthly order quantity = (b) Assume that each unit demanded generates $70 in revenue...
The monthly demand function for x units of a product sold by a monopoly is p...
The monthly demand function for x units of a product sold by a monopoly is p = 6,100 − 1/2x2  and its average cost is C = 3,030 + 2x dollars. Production is limited to 100 units. a) Find the profit function, P(x), in dollars. b) Find the number of units that maximizes profits. (Round your answer to the nearest whole number.) c) Find the maximum profit. (Round your answer to the nearest cent.)
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 the following estimated trend models. Use them to make a forecast for t = 19....
Consider the following estimated trend models. Use them to make a forecast for t = 19. a. Linear Trend: yˆ = 14.19 + 1.09t (Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) y^= ______________ b. Quadratic Trend: y^ = 18.65 + 0.91t − 0.04t2(Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) y^: ____________ c. Exponential Trend:  ln(y)^ = 2.1 + 0.08t; se = 0.01 (Round...
Upload speeds for data are increasing with technological advances. The speeds are recorded in the table...
Upload speeds for data are increasing with technological advances. The speeds are recorded in the table for each year. a-Make a graph of the data large enough to include 2019. b-Find the slope between years 2008 and 2011, accurate to 3 decimal places. c- Show your calculation for the mean point; plot and label the mean point. d- Add a trend line to the graph. e-Use your trend line to make a prediction for the upload speed in 2018. f-Find...
The demand for Carolina Industries’ product varies greatly from month to month. Based on the past...
The demand for Carolina Industries’ product varies greatly from month to month. Based on the past two years of data, the following probability distribution shows the company’s monthly demand: Unit Demand Probability 300 0.20 400 0.30 500 0.35 600 0.15 a. If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? b. Assume that each unit demanded generates $70 in revenue and that each unit...