The following data represent the number of refrigerators sold for each of the past five months...
The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances.
| Month | Sales |
| 1 | 25 |
| 2 | 20 |
| 3 | 40 |
| 4 | 35 |
| 5 | 30 |
1. Using two-period simple moving average to fill the rest of the table
2. Using forecasting command ,The sale forecast for Month 6 is
3. Using forecasting command , The sale forecast for Month 7 is
Homework Answers
Add Answer to:
The following data represent the number of refrigerators sold
for each of the past five months...
Using Excel Sheet to answer the following make sure you submit the file with the work...
Using Excel Sheet to answer the following make sure you submit the file with the work required The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances. Month Sales 1. Using two-period Simple moving average to fill the rest of the table 2. Using forecasting command.The sale forecast for Month 6 is 3. Using forecasting command. The sale forecast for Month 7 is
The following data represent the number of sweatshirts sold for each of the past six days...
The following data represent the number of sweatshirts sold for each of the past six days for a department store. Day 2 4 Sales 12 8 4 14 Using an exponential smoothing technique with alpha equal to 0.4, what is the forecasting error for pay 4 OA. -4.6 O B. 6.0 C. OD. 8.8 The following data represent the number of complaints per month that customer service received at a large retailer over the last 15 months. Month Complaints 10...
The following data represent the number of sweatshirts sold for each of the past six days...
The following data represent the number of sweatshirts sold for each of the past six days for a department store. Day Sales 1 7 2 12 3 8 4 4 5 9 6 14 Using an exponential smoothing with trend adjustment technique with alpha equal to 0.3 and beta equal to 0.6, what is the sales forecast for Day 7? Round to the final answer to one decimal place.
Use the following sales data to answer the questions. Month Sales January 
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
The Emmett Bath Tub Company sells bathtub in West Virginia. The number sold for the past...
The Emmett Bath Tub Company sells bathtub in West Virginia. The number sold for the past several months is given along with the forecasts using both 3-month moving average and exponential smoothing (α = .2). Determine the better forecast using the MSE. Month Sales 3-month moving average Error Exponential Smoothing Error Jan 13 Feb 18 March 15 Apr 12 May 14 June 15 July 10
During the past five months the emergency room at the new district Hospital has observed the...
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. Week No of Patients 105 119 122 128 117 136 141 126 143 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. (4 marks) b) What...
The following time series shows the number of units of a particular product sold over the...
The following time series shows the number of units of a
particular product sold over the past six months.
a. Use
= 0.2 to compute the exponential smoothing values for the time
series, forecast the sales volume for month 7, and fill in the
unknown spaces.
Compute the number (i):
Compute the number (ii):
Compute the number (iii):
What is the mean square error (MSE)?
b. Consider the following 3-month moving average for the above
time series and forecasting the...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
During the past five hours, the Port of Long Beach in California unloaded large quantities of...
During the past five hours, the Port of Long Beach in California unloaded large quantities of grain from ships and relevant data are summarized in the table below: Hour Quantity unloaded (tons) -------------------------------------------- 1 3,406 2 3,440 3 3,298 4 3,372 5 3,436 -------------------------------------------- 1) Use the naïve approach to develop a forecast of the tonnage of grain unloaded in each hour up to the 5th hour. (2) Repeat (1) above by using the 2-hour simple moving average method. (3)...
Given is a historical time series for job services demand in the prior 6 months. Month...
Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 817 2 736 3 816 4 718 5 805 6 785 Use the table below to answer all questions: Month Demand Forecast 1 817 F1 2 736 F2 3 816 F3 4 718 F4 5 805 F5 6 785 F6 7 F7 If the demands forecast is Not Possible (NP) to generate for a particular month, then you must type in NP...
Using Excel Sheet to answer the following make sure you submit the file with the work required The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances. Month Sales 1. Using two-period Simple moving average to fill the rest of the table 2. Using forecasting command.The sale forecast for Month 6 is 3. Using forecasting command. The sale forecast for Month 7 is
The following data represent the number of sweatshirts sold for each of the past six days for a department store. Day 2 4 Sales 12 8 4 14 Using an exponential smoothing technique with alpha equal to 0.4, what is the forecasting error for pay 4 OA. -4.6 O B. 6.0 C. OD. 8.8 The following data represent the number of complaints per month that customer service received at a large retailer over the last 15 months. Month Complaints 10...
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. Week No of Patients 105 119 122 128 117 136 141 126 143 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. (4 marks) b) What...
The following time series shows the number of units of a
particular product sold over the past six months.
a. Use
= 0.2 to compute the exponential smoothing values for the time
series, forecast the sales volume for month 7, and fill in the
unknown spaces.
Compute the number (i):
Compute the number (ii):
Compute the number (iii):
What is the mean square error (MSE)?
b. Consider the following 3-month moving average for the above
time series and forecasting the...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
Most questions answered within 3 hours.
-
Ken believes the average age of men who come to get a haircut at
his barber...
asked 13 minutes ago -
(Ratio Analysis): Last year Co. XYZ had sales of $ 400,000, with
“cost of goods sold”...
asked 21 minutes ago -
can someone please write the balanced chemical
equation for the synthesis of Bromoacetanilide
from;
aniline +...
asked 17 minutes ago -
1. If a corporation purchases land and building and subsequently
tears down the building and uses...
asked 28 minutes ago -
Consider a 23-year bond with 7 percent annual coupon payments.
The market rate (YTM) is 6.4...
asked 31 minutes ago -
a tuba creates a 4th harmonic of frequency 116.5 Hz. what is the
frequency of the...
asked 38 minutes ago -
A coconut mass 2kg falls from a 30m tall tree. The coconut falls
and comes to...
asked 41 minutes ago -
Group Policies
Research GROUP POLICY OBJECTS (GPO'S)
You can start in the Windows Server 2012 eBook...
asked 45 minutes ago -
software engineering
Problems.
Create a use case diagram for class registration for a
university.
Create a...
asked 45 minutes ago -
You are trying to convince your friend who wants to attend
medical school to take BY123...
asked 1 hour ago -
Subject: C++
I have created a class called QueueOfIntegers in a file called
QueueOfIntegers.h, which is...
asked 59 minutes ago -
calculate the number of molecules of gas in a
container of 2.0 liter at 30 degrees...
asked 1 hour ago