The manager of Petro North gasoline service station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The manager has accumulated the sales data and forecast accuracy measures during the past 10 months, which are shown in the table below. Fill all blank spaces in the table labeled a through f. Month Feb Mar Apr May Jun Jul Aug Sep Oct Nov 3-month Simple Moving Average N/A N/A N/A 1310.00 1340.00 1443.33 1566.67 1800.00 a 1673.33 Sales (in gallons) 1130 1360 1440 b 1670 1810 1920 1630 1470 1510 MAD N/A N/A N/A 90.00 210.00 262.22 C 262.00 271.11 255.71 MAPD N/A N/A N/A 0.074 d 0.167 0.172 0.159 0.167 0.159 MSE N/A N/A N/A 8100 58500 e 94072 81038 84245 76021 CE N/A N/A N/A -90 240.00 606.67 960.00 790.00 310.00

The manager of Petro North gasoline service station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The manager has accumulated the sales data and forecast accuracy measures during the past 10 months, which are shown in the table below. Fill all blank spaces in the table labeled a through f. Month Feb Mar Apr May Jun Jul Aug Sep Oct Nov 3-month Simple Moving Average N/A N/A N/A 1310.00 1340.00 1443.33 1566.67 1800.00 a 1673.33 Sales (in gallons) 1130 1360 1440 b 1670 1810 1920 1630 1470 1510 MAD N/A N/A N/A 90.00 210.00 262.22 C 262.00 271.11 255.71 MAPD N/A N/A N/A 0.074 d 0.167 0.172 0.159 0.167 0.159 MSE N/A N/A N/A 8100 58500 e 94072 81038 84245 76021 CE N/A N/A N/A -90 240.00 606.67 960.00 790.00 310.00

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

A company that produces video equipment, including videocameras and televisions, is attempting to forecast what newproducts and product innovations might be technologicallyfeasible and that customers might demand 10 years into thefuture. Speculate on what type of qualitative methods itmight use to develop this type of forecast.
Sales in a company are $188 million in 2009 and increase $208 million in 2010. Compute the percentage increase in sales using the usual formula Compare this value to the approximation The approximation performs (1) percentage change increases. 100 x (1) O better (2) O deteriorates O worst O improves 100 x 100 x (Sales 2010 - Sales 2009) Sales 2009 100 x [In (Sales2010) -In (Sales2009)] (Sales 2010 - Sales2009) Sales 2009 100 x [In (Sales 2010) -In (Sales2009)] = [ (Express your response as a percentage and round to three places) Now, assume that sales in a company are $188 million in 2009 and increase $264 million in 2010. = (Sales2010 - Sales 2009) Sales 2009 % % % 100 x [In (Sales 2010) -In (Sales 2009)] = [ (Express your response as a percentage and round to three places) % when the change is small. The quality of the approximation (2). as the
(Ch7) If the mean time between in-flight aircraft engine shutdowns is 12,500 operating hours, what is the 90 percentile on the distribution of the number of hours until the next shutdown? (hint: convert the mean time between events to the mean events per hour λ, then apply inverse exponential) Question 7Select one: a. 20,180 hours b. 18,724 hours c. 23,733 hours d. 28,782 hours
Define the term, the variation of PW?
Show calculations...
10- What type of data does the data obtained by temperature measurements fall under?I. Interval dataII. Quantitative continuous dataIII. Proportional dataIV. Quantitative discrete data A) II B) I -II C) I - III - IV D) IV E) III - II
The demand of a product of a company is given below for the periods. Can we use Winter method for forecasting demands of the A following 3 periods? Why? If yes, apply it past 4. 6. Demand 27 31 40 31 35 45
Actual sales of TV's for the first six month in 2021 were as follows:January 60 February 80 March 42April 68 May 44 June 72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period 2 Trends: Reduce this average by 6% per month for the next three months 3 Simple Moving Average (SMA): make a forecast for July using a three months simple movingaverage. 4 Weighted Moving Average (WMA): make forecast for July, using a three months weightedmoving average where the weights are 0.5; 0.3 and 0.2 respectively.
2. Montyboy Pet Shop ships boxed can dogfood anywhere in the country. Using the following information, forecast the shipments for the first four months. Seasonal Relative Month January February March 1.2 1.3 1.3 1.1 0.8 0.7 The monthly forecast equation being used is: Yt = 402 + 3t April May June Where: to = January last year Yt = number of shipments Month July August September October November December Seasonal Relative 0.8 0.6 0.7 1.0 1.1 1.4 Question: Determine the trend amounts for the first four months of the next year assuming January, t=24; February, t=25; etc. Note: Round answers to whole numbers.
Solve the second graph! plsss
Please....... Solve this with proper. Calculation
I Consider the demand for trading cards listed below. Month Demand Jan. 51,000 48,000 Feb. March 55,000 April May 58,000 66,000 June 69,000 80,000 July Aug. 95,000 Use Excel to prepare a forecast for September, October, and November using linear regression Print out the sheet of results, as well as a sheet containing the formulas that you used ( can be used to toggle between displaying values and displaying formulas or you can click on Formulas>Formula Auditing→Show Formulas.) and for the cars is 16.000