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…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The controller of Crane Industries has collected the following monthly cost data for analyzing the behaviour of electricity costs. Total Total Electricity Costs Machine Hours January $ 2,200 260 February 2,940 390 March 3,530 500 April 4,520 685 May 3,150 490 June 4,990 700 July 4,020 645 August 3,800 570 September 5,080 675 October 4,380 615 November 3,360 390 December 6,150 720
Given the following data on the number of pints of ice cream sold at a local ice cream store for a 10-period time frame: Period Demand 1 230 2 220 3 200 4 270 5 300 6 300 7 330 8 340 9 360 10 300 Use a 2-period moving average to forecast demand for period 11 Group of answer choices 350 225 330 335
Describe the results of your two graphs as they compare to the movement of demand. Be specific. Choosing between the three-period and the five-period forecasts, which length of averaging would you use as a purchasing manager of Greenfield’s Tannery? Be sure to factor in the cumulative forecast errors in your answer. Also, make sure you include some rationale about why you are picking the method you do for this particular business. So for example, does picking one method over the other have any impact on how much inventory they will have on hand to meet customer demand? What happens when the demand drops? Which method better supports that?
Data collected on the yearly demand for 50-pound bags of are shown in the following table. Year Demand for fertilze ,000 1 4 2 6 3 4 4 5 6 10 5 8 7 7 8 9 9 12 10 14 11 15 i. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think is best? ii. Develop a trend line for the demand for fertilizer.
The problem is based on the following data given. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 2013 were ( as shown ). What would an MA(1) forecasting method mean? Compare the accuracy of MA(1) and MA(4) forecasts for July through December 2013.
Table 1. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table 1 below. week Demand Forecast Error ABS. Dev Squared Error APE 1 20 2 28 3 22 4 18 5 22 6 22 7 22 8 26 9 23 10 23 11 23 12 27 13 25 14 22 15 23 16 14 17 14 18 15 19 11 20 16 21 22 23 24…
Price elasticity of demand (supply) or simply elasticity of demand (supply) measures the relative or percentage variation experienced by the quantity demanded (supplied) as a consequence of a change in the price of one percent (1%); In other words, it measures the intensity with which buyers (sellers) respond to a change in the priceprice. Elasticity is often used with respect to the price-demand relationship or the price-supply relationship, but the applicability of this concept is not restricted to that single case, but is broader, since the elasticity is calculated in percentages, since it is the only way to obtain a common unit of measure. When calculating the elasticity in arelationship, the units of measurement are maintained, therefore, they do not measure a proportional change, but a propensity, such as the well-known propensit to Keynesian consumption. The rate at which the selling price changes and from a product, with respect to its supply "x", is given by the following…
The percentage of employees who cease their employment during a year is referred to as employee turnover, and it is a serious issue for businesses. The following table shows the cost, in millions of dollars, to a certain company for a given employee turnover percentage in a year.
A local firm is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production unit. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Month Production Days Predicted Demand(in $10,000) Month Production Days Predicted Demand(in $10,000) January 20 595 July 20 410 February 19 225 August 21 130 March 22 565 September 19 405 April 18 205 October 23 315 May 21 230 November 21 355 June 22 120 December 18 350 Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December…
Provide a bar chart (with data labels rounded to two decimal points) showing the average demand for each day of the week (Sun., Mon., etc.) Day Date Weekday Daily Demand Weekend 1 4/25/2016 Mon 297 0 2 4/26/2016 Tue 293 0 3 4/27/2016 Wed 327 0 4 4/28/2016 Thu 315 0 5 4/29/2016 Fri 348 0 6 4/30/2016 Sat 447 1 7 5/1/2016 Sun 431 1 8 5/2/2016 Mon 283 0 9 5/3/2016 Tue 326 0 10 5/4/2016 Wed 317 0 11 5/5/2016 Thu 345 0 12 5/6/2016 Fri 355 0 13 5/7/2016 Sat 428 1 14 5/8/2016 Sun 454 1 15 5/9/2016 Mon 305 0 16 5/10/2016 Tue 310 0 17 5/11/2016 Wed 350 0 18 5/12/2016 Thu 308 0 19 5/13/2016 Fri 366 0 20 5/14/2016 Sat 460 1 21 5/15/2016 Sun 427 1 22 5/16/2016 Mon 291 0 23 5/17/2016 Tue 325 0 24 5/18/2016 Wed 354 0 25 5/19/2016 Thu 322 0 26 5/20/2016 Fri 405 0 27 5/21/2016 Sat 442 1 28 5/22/2016 Sun 454 1 29 5/23/2016 Mon 318 0 30 5/24/2016 Tue 298 0 31 5/25/2016 Wed 355 0 32 5/26/2016 Thu 355 0 33 5/27/2016 Fri 374 0 34…
Develop a three-period moving average forecast for periods 13-15. Period 10 11 12 13 14 Demand 265 359 436 261 462 Calculate the forecasts for periods 13-15 by using a three-period moving average model (enter your responses rounded to the nearest whole number). Period Demand Forecast 10 265 11 359 12 436 13 261

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS