Solve the problem by completing the table with the help of MS Excel. Label the final answers.2. The manager of a fabric company needs to accurately forecast the demand for fabric. If the customers donot order enough fabric (in 10,000 yards), they will buy their fabric from one of the company's majorcompetitors. The company has collected the following demand data for the past 10 months. Compute aweighted three-month moving average forecast using weights of (a) 10%, 30 %, 60 %, and (b) 25% 30%45% for the most distant data, next recent, and the most recent respectively.FebMarAprMayJunJulAug SepOctMonth JanDemand 37454750525458606365Forecast Table:MonthActualWMA (10%, 30%, 60%)WMA (25%, 30%, 45%)JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberGraph:

The question is based on a time series Given :

Answered: 2. The manager of a fabric company…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter1: Expressions And Functions

Section1.5: Descriptive Modeling And Accuracy

Problem 29PFA

See similar textbooks

Similar questions

The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute a 3-month moving average forecast for months 4 through 9. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and 0.12 to the months in sequence, starting with the most recent…
#a. Predict the sales resulting from a $15,000 investment in inventory and an advertising budget of $10,000.
Use the data to model deliveries times for a driver based on three parameters. If today's delivery routs requires 42 miles, 8.3 gallons of gas, and has 4 deliveries, how much time should the driver expect to be on the road? (Keep one decimal place) Assignment Miles Gasoline Consumption Deliveries Time 1 100.0 10.0 4.0 9.3 2 50.0 6.2 3.0 4.8 3 100.0 9.5 4.0 8.9 4 100.0 10.3 2.0 6.5 5 50.0 4.7 2.0 4.2 6 80.0 7.8 2.0 6.2 7 75.0 7.7 3.0 7.4 8 65.0 6.4 4.0 6.0 9 90.0 8.8 3.0 7.6 10 90.0 10.0 2.0 6.1 11 50.0 5.0 5.0 7.0 12 45.0 4.9 6.0 7.0 13 85.0 8.1 5.0 9.6 14 65.0 6.6 2.0 6.5 15 40.0 4.0 6.0 7.2 16 50.0 5.5 3.0 6.0 17 75.0 7.4 5.0 9.9 18 75.0 7.6 4.0 8.6 19 65.0 6.8 3.0 4.9 20 90.0 8.4 3.0 7.5 21 95.0 8.8 1.0 7.2 22 95.0 10.2 6.0 9.9 23 50.0 4.6 1.0 5.6 24 80.0 8.6 3.0 7.5 25 90.0 8.6 2.0 7.8 26 80.0 8.8 3.0 7.2 27 75.0 6.9 3.0 7.0 28 95.0 10.0 2.0 8.7 29 90.0 9.2 1.0 6.4 30 100.0 9.4 3.0 9.9 31 60.0 6.0 1.0 4.1 32 90.0…
If you knew that the quantities of demand for wicker) and their prices (8) during the past 30 years had given the following data in Image. Find: 1.b^ 2.b^°
Use the cost model to estimate the average weekly cost per bag when the weekly demand is 107. Round to the nearest cent. $ ______per sleeping bag screenshot attached thanks hn2ioh2n4h2iohn24ioh2 4nh24hi 2oh 2i
Aztec Industries has developed a forecasting model that was used to forecast during a 10-month period. The forecasts and actual demand were as follows: Measure the accuracy of the forecast by using MAD, MAPD, and cumulative error. Does the forecast method appear to be accurate?
Agnes, a General Manager in XXX Company, estimated a multiplicative demand function of the form: using a cross-section data collected in the company sales on 30th June, 2019. The estimation results are as follows: (SEE IMAGE) Write down the estimated demand equation Interpret the coefficients and R2 value Describe any three managerial decisions that can be applied by the manager from the estimated demand function
A manager wishes to predict the annual cost (y) of an automobile based on the number of miles (x) driven. The following model was developed: y = 1,550 + 0.36x. If a car is driven 15,000 miles, the predicted cost is ____________.
Please answer C. and D. Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 25,820 1,700 2 $ 36,290 2,592 3 $ 39,968 2,811 4 $ 31,648 2,222 5 $ 34,809 2,373 6 $ 32,672 2,181 7 $ 32,023 2,205 8 $ 38,334 2,676 9 $ 38,568 2,760 10 $ 46,933 3,572 11 $ 42,157 2,976 12 $ 39,030 2,804 13 $ 34,444 2,415 14 $ 33,173 2,336 15 $ 36,971 2,508 16 $ 26,500 2,099 17 $ 30,663 3,397 18 $ 29,961 2,786 19 $ 27,590 2,412 20 $ 30,003 2,972 21 $ 25,692 2,000 22 $ 24,655 1,794 23 $ 28,892 3,267 24 $ 30,153 3,817 25 $ 28,119 2,592 26 $ 31,690 3,274 27 $ 28,651 2,989 28 $ 29,927 3,050 29 $ 28,438 2,511 30 $ 27,874 2,075…

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Algebra: Structure And Method, Book 1

Algebra

ISBN:

9780395977224

Author:

Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:

McDougal Littell

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Algebra: Structure And Method, Book 1

Algebra

ISBN:

9780395977224

Author:

Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:

McDougal Littell

SEE MORE TEXTBOOKS