focus on the c part of the question. The demand for a product of a company in each of the last twelve months is shown in the table below; Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Demand 37 40 41 37 45 50 43 47 56 52 55 54 - Use the table to compute the following forecast demand for the company; a. Four months simple moving average b. Four months weighted moving average using the weight of 40%, 30% and 20% and 10%respectively. c. Prepare exponential smoothing forecast using smoothing constants of 0.3 and 0.5 present the final answer in a table form and writed down all calculations clearly

focus on the c part of the question. The demand for a product of a company in each of the last twelve months is shown in the table below; Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Demand 37 40 41 37 45 50 43 47 56 52 55 54 - Use the table to compute the following forecast demand for the company; a. Four months simple moving average b. Four months weighted moving average using the weight of 40%, 30% and 20% and 10%respectively. c. Prepare exponential smoothing forecast using smoothing constants of 0.3 and 0.5 present the final answer in a table form and writed down all calculations clearly

Algebra and Trigonometry (MindTap Course List)

4th Edition

ISBN:9781305071742

Author:James Stewart, Lothar Redlin, Saleem Watson

Publisher:James Stewart, Lothar Redlin, Saleem Watson

ChapterP: Prerequisites

SectionP.FOM: Focus On Modeling: Making The Best Decisions

Problem 7P: Cell Phone Plans Gwendolyn is mulling over the three cell phone plans shown in the table. Gigabytes...

See similar textbooks

Similar questions

What is a carrying capacity? What kind of model has a carrying capacity built into its formula? Why does this make sense?
Cell Phone Plans Gwendolyn is mulling over the three cell phone plans shown in the table. Gigabytes GB of data included Monthly Cost Each additional megabytes MB Plan A Plan B Plan C 1 1 1 25.00 40.00 60.00 2.00 1.50 1.00 From past experience, Gwendolyn knows that she will always use more than 1GB of cell phone data every month. aMake table of values that shows the cost of each plan for 1 GB to 4 GB, in 500 MB increments. bFind formulas that give Gwendolyns monthly cost for each plan, assuming that she uses x gigabytes of data per month where x1. cWhat is the charge from each plan when Gwendolyn uses 2.2 GB? 3.7 GB? 4.9 GB? d Use your formulas from part b to determine the number of gigabytes of data usage for which: (i) Plan A and Plan B give the same cost. (ii) Plan A and Plan C give the same cost. (iii) Plan B and Plan C give the same cost.
The demand and forecast information for the XYZ Company over a twelve-month period has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop forecast accuracy and answer the following questions. Forecast Accuracy Measures Period Actual Demand Forecast Error Absolute Error Error^2 Abs. % Error 1 1,300 1,378 2 2,000 1,676 3 1,800 1,974 4 1,700 2,272 5 2,300 2,570 6 3,800 2,868 7 3,200 3,166 8 3,100 3,464 9 3,900 3,761 10 4,600 4,059 11 4,200 4,357 12 4,300 4,655 Total Average RSFE MAD MSE MAPE Tracking Signal 1. What can be concluded about the quality of the forecasts? Assume that the control limit for the tracking signal is ±3. The results indicate (bias or no bias) in the…
Apply the 3-years moving average method to forecast the required demand for the year 2021from the following historical data.Years 2012 2013 2014 2015 2016 2017 2018 2019 2020Demand 245 325 300 350 295 400 450 380 500
The Monthly demand for unit manufactured by the ABC Company has been as follows: Units 250 290 240 280 300 270 290 Month January February March April May June July a.use a four-week weighted moving average to forecast the units of month august by using weights of 40%, 30%, 20% & 10% respectively. b. use exponential smoothing with α=0.3 to forecast the units of month august. c. calculate the mad & mse (use exponential smoothing method).
Use this data and and generate a model of the annual maintenance expenses based on the age of the bug. If my bus is 4.1 years old, what are the projected annual maintenance costs? (Enter a whole number) Age of Bus (years) Annual Maintenance Cost ($) 2.4 350 2.3 370 2.4 480 3.1 520 3 590 5.8 550 4.8 750 3.8 800 3.6 790 4.9 950 5.5 915
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 ). Using a four-month moving average, determine the two-step-ahead forecast for July through December 2013. (Hint: The two-step-ahead forecast for July is based on the observed demands in February through May.)
Table 1 HPF Demand in the last 12 periods Period Month Demand in '000 Period Month Demand in '000 1 January 37 7 July 43 2 February 40 8 August 47 3 March 41 9 September 56 4 April 37 10 October 52 5 May 45 11 November 55 6 June 50 12 December 54 The manager of the company wants to be certain enough OFC01 are available to complete orders promptly and they have adequate inventory in stock. During the last meeting, a number of forecast techniques have been discussed: Simple moving average n = 4 Weighted moving average with n=4 with the following weights from most recent periods: 0.4, 0.3, 0.2, 0.1 Exponential Smoothing with alpha = 0.2 Linear trend The manager would like to ascertain the best tools that he and his team can effectively manage the production processes. Among the above forecasting methods, which method should be used to forecast the demand for this product? Why? The…
Observations of the demand for a certain part stocked at a parts supply depot during the calendaryear 2013 were: Month Demand Month Demand Jan 89 july 223 Feb 57 august 286 mar 144 sept 212 april 221 oct 275 may 177 nov 188 june 280 dec 312 a) Using a four-month moving average, determine the one-step-ahead forecast for Julythrough December 2013.b) Using a four-month moving average, determine the two-step-ahead forecast for Julythrough December 2013.c) Obtain the MAD for the forecasts obtained in the above sections. Which method gavebetter results? Based on forecasting theory, which method should have given betterresults?
Two pumps capable of delivering 100 hp to an agricultural application are being evaluated in a present economy study. The selected pump will only be utilized for one year, and it will have no market value at the end of the year. Pertinent data are summarized as given follows. If electric power costs $0.10 per kWh and the pump will be operated 4,000 hours per year, which pump should be chosen? Recall that 1 hp = 0.746 kW.
Shan Foods estimated the following demand equation for its product using data from 26 supermarkets around the country for the month of April: Q = - 10,400 - 84P + 40PX + 10.4 l + 0.40 A + 0.50 M (4.002) (34.5) (12.2) (5.04) (0.18) (0.42) R2 = 0.67 n = 47 F = 3.78 Assume the following values for the independent variables: Q = Quantity sold per month P(in cents) = Price of the product = 1000 PX (in cents) =Price of leading competitor’s product = 1200 I(in dollars) = Per capita income of residents = 11,000 A (in dollars) = Monthly advertising expenditure = 20,000 M = Number of microwave ovens sold in the SMSA in which the supermarket is located = 10,000 Using this information, answer the following questions: Compute T stats of each variable Compute elasticities for each variable. How concerned do you think this company would be about the impact of a recession on its sales? Explain. Do you think that this firm should cut its price to increase its market share? Explain.…
Shan Foods estimated the following demand equation for its product using data from 26 supermarkets around the country for the month of April: Q = - 10,400 - 84P + 40PX + 10.4 l + 0.40 A + 0.50 M (4.002) (34.5) (12.2) (5.04) (0.18) (0.42) R2 = 0.67 n = 47 F = 3.78 Assume the following values for the independent variables: Q = Quantity sold per month P(in cents) = Price of the product = 1000 PX (in cents) =Price of leading competitor’s product = 1200 I(in dollars) = Per capita income of residents = 11,000 A (in dollars) = Monthly advertising expenditure = 20,000 M = Number of microwave ovens sold in the SMSA in which the supermarket is located = 10,000 Using this information, answer the following questions: Compute T stats of each variable Compute elasticities for each variable. How concerned do you think this company would be about the impact of a recession on its sales? Explain. Do you think that this firm should cut its price to increase its market share? Explain. e.…