National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000)Units 14 Month Feb. Mar. 17 Apr May. Jun. 11 19 21 Jul. 22 Aug. 26 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediete calculations end final answer to 2 decimal places.) Yt thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with a smoothing constant equal to 20, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast |thousands (4) The naive approach. Naive approach thousands (5) A weighted average using .50 for August, .20 for July, and 30 for June. (Round your answer to 2 decimal places.) Weighted average thousands

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000)Units 14 Month Feb. Mar. 17 Apr May. Jun. 11 19 21 Jul. 22 Aug. 26 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediete calculations end final answer to 2 decimal places.) Yt thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with a smoothing constant equal to 20, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast |thousands (4) The naive approach. Naive approach thousands (5) A weighted average using .50 for August, .20 for July, and 30 for June. (Round your answer to 2 decimal places.) Weighted average thousands

College Algebra

10th Edition

ISBN:9781337282291

Author:Ron Larson

Publisher:Ron Larson

ChapterP: Prerequisites

SectionP.6: The Rectangular Coordinate System And Graphs

Problem 2ECP

See similar textbooks

Related questions

Q: Table 1: Which set of data would best be modeled by an exponential function? I Y1 2 3.5 Y1 A X. Y1 -…

A: A general Exponential function is given by f(x) = ax where a>0

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: Note: Hi there! Thank you for posting the question. As the question in the subpart (3) is…

Q: a. Compute the seasonal index for Spring: b. Compute the seasonal index for Summer: c. Compute the…

A: It is given that M1 = Mean(spring) = 625 M2 = mean(summer) = 475 M3 = mean(fall) = 325 M4 =…

Q: In 2013 the average houshold credit card balance was $9,884. In 2016 the average houshold credit…

Q: The following table gives the approximate increase in the average price of a movie ticket every two…

A: given that and the price of movie ticket in 2004 is $6.99. we have to find…

Q: A famous Chinese restaurant would like to find out the change in demand on its dim-sum. After…

Q: (6) A hospital tracks the number of cases that come into its Emergency Room during each eight-hour…

A: Given that a hospital tracks the number of cases that come into its Emergency Room during each…

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: If an asset declines in value from $5,000 to $2,600 over nine years, what is the mean annual growth…

A: Initial value = 5000 Final Value = 2600 Number of years = n = 9

Q: Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December.…

A: Given information: The data presents the sample for the months January through December.

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: Note: Hi there! Thank you for posting the question. As there are multiple sub parts, according to…

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: Introduction: We have solved the problem using Excel. First, we have entered the data as shown…

Q: Maximizing the profit of timber harvesting involves considering all of the following except: A.…

A: Whenever we are harvesting any natural resource , only the outcome of profit source variant is…

Q: shows the statistics for bed count and inpatient service days that Manatee Bay Health Center…

A: Provided data is, Table shows the statistics for bed count and inpatient service days that Manatee…

Q: Annual revenue for Corning Supplies grew by 5.5% in 2010, 1.1% in 2011, -3.5% in 2012, -1.1% in…

A: The annual growth rate represents the percentage of amount which is increased in 1 year. For example…

Q: . Prepare Index Numbers of prices for three years with average price as the Base from the data given…

Q: From the following data find the cyclical variations under both the models che residual method :…

Q: John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number…

A: Given, Claims made four years ago as 1,400 when it should have been 1,200. to find, a. What…

Q: I. The Department of Agriculture obtained the following data representing the one week growth in…

A: As per the honor code, We’ll answer the first question since the exact one wasn’t specified. Please…

Q: TABLE 1: An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index…

A: The intercept of y is the constant value of the regression equation. It is the constant value when…

Q: Using three yearly moving averages, determine the trend and short term. fluctuations. Year : 1989…

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: The number of pounds of steam used per month by a chemical plant is thought to be related to the…

A: The question is about identifying independent and dependent variable Introduction : There are two…

Q: The following table is a selection of average prices for a gallon of gas in the United States. Year…

A: Gas price is given for years(2001 to 2018) We have to calculate index values : 2003 as base year :…

Question

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
Sales
(000)Units
14
Month
Feb.
Mar.
17
Apr
May.
Jun.
11
19
21
Jul.
22
Aug.
26
b. Forecast September sales volume using each of the following:
(1) A linear trend equation.(Round your intermediete calculations end final answer to 2 decimal places.)
Yt
thousands
(2) A five-month moving average. (Round your answer to 2 decimal places.)
Moving average
thousands
(3) Exponential smoothing with a smoothing constant equal to 20, assuming a March forecast of 16(000). (Round your intermediate
forecast values and final answer to 2 decimal places)
Forecast
|thousands
(4) The naive approach.
Naive approach
thousands
(5) A weighted average using .50 for August, .20 for July, and 30 for June. (Round your answer to 2 decimal places.)
Weighted average
thousands

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. The past year’s usage and temperatures are in the following table: Month Temp. Usage/1000 Month Temp. Usage/1000 Jan. 21 185.79 July. 68 621.55 Feb. 24 214.47 Aug. 74 675.06 Mar. 32 288.03 Sept. 62 562.03 Apr. 47 424.84 Oct. 50 452.93 May 50 454.58 Nov. 41 369.95 June 59 539.03 Dec. 30 273.93 Suppose that the monthly average temperature is 47 F. Calculate the fitted value of y and the corresponding residual. Test for significance of regression using α=0.01 (Use ANOVA). Calculate the r2 of the model. Find a 99% CI for .
The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. The past year’s usage and temperatures are in the following table: Month Temp. Usage/1000 Month Temp. Usage/1000 Jan. 21 185.79 July. 68 621.55 Feb. 24 214.47 Aug. 74 675.06 Mar. 32 288.03 Sept. 62 562.03 Apr. 47 424.84 Oct. 50 452.93 May 50 454.58 Nov. 41 369.95 June 59 539.03 Dec. 30 273.93 Find a 99% CI for β1.
The number of pounds of steam used per month by a chemical plant is thought to be related to the average ambient temperature (in F) for that month. The past year’s usage and temperatures are in the following table: Month Temp. Usage/1000 Month Temp. Usage/1000 Jan. 21 185.79 July. 68 621.55 Feb. 24 214.47 Aug. 74 675.06 Mar. 32 288.03 Sept. 62 562.03 Apr. 47 424.84 Oct. 50 452.93 May 50 454.58 Nov. 41 369.95 June 59 539.03 Dec. 30 273.93 Test for significance of regression using α=0.01 (Use ANOVA). Calculate the r2 of the model. Find a 99% CI for .
ans. only number 1
Which of the following could most be considered an ordinal variable? a. Height (ft) b. Weight (kg) c. Body mass index (kg/m2) d. Education level e. Annual Income ($)
The following table is a selection of average prices for a gallon of gas in the United States. Year Gas Price Index Value 2001 [A] 2003 [B] 2004 2018 [A] = Build an index from these values, using 2003 as the base year. Round each index value to the nearest tenth. [B] = = [C] = $1.42 $1.56 $1.85 $2.72 [D] = [C] [D]
The following ACF plots were produced for raw data of monthly sales of two different variables, A and B. Explain in detail which variable (A or B) is likely to be easier to forecast.
Below are given the annual production (in '000 Rs.) of a fertiliser factory : 1998 Year : 1992 1993 1994 1995 1996 1997 Prodn. : 70 75 90 91 85 98 100 (i) Fit a straight line trend by the method of least square and tabulate the trend values.
A hospital is using X bar and R charts to record the time it takes to process patient account information. A sample of five applications is taken each day. The first four weeks’ (20 days’) data give the following values: =16 min =7 min If the upper and lower specifications are 21 minutes and 13 minutes respectively, calculate , Cp and Cpk. Interpret the indices.
Interpolate the Sales for 1990 from the following data. Years : 1988 1989 1990 1991 1992 Sales : 250 290 ? 390 425 Use Parabolic curve method.
at 2 presented based on the Health Information National Trends Survey (HINTS) LALYSIS
The distance (in kilometers) and price (in dollars) for one-way airline tickets from San Francisco to several cities are shown in the accompanying table. Complete parts a through d below. E Click the icon to view the data on airline ticket prices. a. Find the corelation coefficient for these data using a computer or statistical calculator. Use distance as the x-variable and price as the y-variable. (Round to three decimal places as needed.) r= b. Recalculate the correlation coefficient for these data using price as the x-variable and distance as the y-variable. What effect does this have on the correlation coefficient? Select the correct choice below and fill in the answer box to complete your choice. (Round to three decimal places as needed.) Airline Ticket Prices A. The correlation coefficient is r= The correlation coefficient decreases when the order of the variables is changed. B. The correlation coefficient is r= The correlation coefficient remains the same when the order of the…