Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can orderthe correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here.Week12348910Rentals20203426211221261914a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses rounded to two decimal places.)WeekForecast625.25723.258209201019.5What is the forecast for week 11? 20 rentals. (Enter your response rounded to two decimal places.)b. The mean absolute deviation as of the end of week 10 is rentals. (Enter your response rounded to two decimal places.)

Forecasting is the process of estimation in which future demand is determined with the help of…

Answered: b. The mean absolute deviation as of…

b. The mean absolute deviation as of the end of week 10 is rentals. (Enter your response rounded to two decimal places.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...

See similar textbooks

Related questions

Q: A plant has sufficient capacity to manufacture any combination of four different products (A, B, C, ...

A: GIVEN,

Q: What is the importance of quality service or product?

A: As per the Bartleby guidelines, only the first question has been answered.

Q: A manufacturer produces bicycles and motorcycles, each of which must be processed through two machin...

Q: TWENTY-TWO. On international projects, the importing of materials is managed by the procurement team...

A: Procurement is the process of taking decisions related to acquiring goods, services, or works from a...

Q: A large department store operates seven days a week. The manager estimates that the minimum number o...

A: Decision variable: Suppose-X1 be the no. of salespersons having off-days on Monday & TuesdayX2...

Q: explain how containers or cards are used in kanban system

A: The word kanban has a Japanese origin which means to signal. This system is basically used to trigge...

Q: All of the following are characteristics of a project EXCEPT: Select one: a. Has a defined beginnin...

A: A project can be stated as the sequence or series of activities that must be accomplished to attain ...

Q: A high level of flexibility and agility is needed in an IT architecture in order to adapt to evolvin...

A: Principles should be not many in number, future-situated, and endorsed and supported by senior admin...

Q: The Gutuchi Company manufactures purses, shaving bags and backpacks. The construction includes leath...

A: Resource requirements are characterized by the Project Director to lay out the resources expected to...

Q: Which of the following concepts explain why we tend to make errors in affective forecasting?

A: Affective forecasting refers to the prediction of future events on the basis of a current emotion.

Q: What are the advantages of understanding the development of Process Flow Diagram? Is it necessary f...

A: Flowcharts make visual portrayals of processes. For this explanation, they are famous among develope...

Q: Convert the following problem to Standard Form. max z := -2xı + x2 s.t. 2x1 + x2 1 T12 0, а2 freе.

Q: Just answer C and D.

A: As per the Bartelby guidelines, only the first three parts have been answered.

Q: The two main dimensions of quality are: O Ancient and modern O Aesthetic and functional O External a...

A: A quality item is an item that measures up to the assumptions of the clients. The eight components o...

Q: For the Toy Car table above, what are the Planned Order Receipts in the week of 8/31? For the Toy Ca...

A: Instructions and formula used: Net requirements = Gross requirements - previous period Project...

Q: 2. cross-docking is a logistics practice of unloading goods from impound Transportation vehicles and...

A: Inventory management is the management in which raw materials, work-in-progress goods, and finished ...

Q: What makes a good infographics?

A: Infographics are graphic visual that shows the information, data, or knowledge planned to present in...

Q: Professor McGonagall teaches a 50-minute class on MWF. She is so efficient, and her students are so ...

A: Utilization rate is the rate at which the total time of the resources is fully utilized.

Q: Define lean principles.By adopting lean operating systems, critically examine the two (2) possible b...

A: The lean philosophies can be perceived as the philosophy that outcomes in the improved value for the...

Q: A factory manufactures three products, A, B, and C. Each product requires the use of two machines, M...

A: Objective Functions and Constraints: Based on the given details, the objective funct...

Q: max z = 5x, + 3x2 + x3 x1 + x2 + 3xz < 6 5x, + 3x, + бх; 15 s.a. X3, X1, X2 2 0

A: Given LP- Max Z = 5x1+3x2+x3Subject to-x1+x2+3x3≤65x1+3x2+6x3≤15x1, x2, x3≥0

Q: A plant has sufficient capacity to manufacture any combination of four different products (A, B, C, ...

A: Manufacturing cycle time is the complete time taken to change over raw materials into completed good...

Q: Two factor authentication (2FA) is when a website uses two different methods for people trying to ac...

A: Two-factor authentication often called two-factor verification or two-factor authentication 2FA is n...

Q: On projects with a low complexity profile, the project management team typically develops a list of ...

A: A project management is the process of managing activities associated with the project while conside...

Q: A retail store records customer demand during each sales period. The data has been collected in the ...

A: given,

Q: Discuss the merits and demerits of employee-centred approach

A: An employee-centred approach can be stated as the approach in which all people, programs, approaches...

Q: demong view on supplier relationship 7 deming view on supplier relationship

A: Deming - was one of the notable advocates of quality, & his principles regarding the managerial ...

Q: Problem #4 - Hinsdale Company - Modified, from textbook page #205. a. I 400 units and standard devia...

A: Safety stock is the inventory level that the company should maintain to avoid the stock out situatio...

Q: Explain how economic ordering quantity method works

A: Economic ordering quantity(EOQ) is a inventory replenishing method which identifying a fixed quantit...

Q: Consider the following equation: b. Determine the range of optimality for the coefficients of the ob...

A: The range of feasibility is the range over which the double cost is pertinent. As the RHS increases,...

Q: What is a poverty trap? State the crucial assumptions underlying Galor and Zeira’s overlapping gener...

A: The Galor-Zeira model is the first macroeconomic model based on wealth driven poverty trap . The mod...

Q: Deborah Hollwager, a concessionaire for the Amway Center in Orlando, has developed a table of condit...

A: Given-

Q: Explain the many forms of collaboration technologies and how they may be utilised to improve project...

A: Collaborative technologies are a combination of powerful online collaboration software that make it ...

Q: Thank youuu

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

Q: Explain the notion of "infant mortality" in the context ofproduct reliability.

A: Reliability - is based on the probability that an item or product or tool will perform adequately fo...

Q: 6-43 Dillard Travey receives 5,000 tripods annually from Quality Suppliers to meet his annual demand...

A: Given- Annual Demand (D) = 5,000 tripodsOrdering Cost (S) = $15 per orderHolding Cost (H) = 50 cen...

Q: Question 1 Rock View Restaurant is a new fast food restaurant chain. The Operations Manager has divi...

A: Find the Precedence diagram below:

Q: What is non probability sampling and explain the types of the sample

A: Sampling is the utilization of a subset of the population to address the entire populace or to infor...

Q: 28.3-3. A particle moves on a circle through points that have beer marked 0, 1, 2, 3, 4 (in a clockw...

A: given, particle starts point = 0 each step probability = 0.5

Q: ..Here is the question.. please do all parts

A: The study design clarifies the methodology on whether the information can be followed throughout som...

Q: Business process modeling is a graphical representation of a company’s business processes or workflo...

A: Outstanding cycles for dealing with demonstrations effectively and practically. Regardless, if your ...

Q: Q#2: Define “TIIMWOOD” and explain any one of them with example. (Do not exceed 125 words) Q#3: Di...

A: Business Process Reengineering involves the extremist overhaul of center business processes to accom...

Q: A Jack-in-the-box toy includes two components, the jester (part A) and the box (part B). The followi...

A: From the given data, it can be observed that processes A and B are in series. After completing one s...

Q: 1. Explain which of the conversion methods would be suitable for the following. Justify your choice:...

A: As per the Bartleby guidelines, only the first question has been answered.

Q: A data entry clerk entered the incorrect part number for a blender. The part number was the part num...

A: A validity check is an interaction of guaranteeing that an idea or development is adequate with rega...

Q: of baby wet wipes namely WWorganic and WWfragrance. The raw material required, packaging size, produ...

A: Decision Variable: Suppose-x1 be the no. of WW organic baby wet wipes produced per dayx2 be the no...

Q: ially launched a new project on Wednesday (April 28, 2021) designed to increase the contributions of...

A: Project Scope Administration Plan a outline of the vital advances linked to making an rise of the ex...

Q: B .. C E

A: A value stream map shown in the question is prepared to understand the entire process from the persp...

Q: (a) Fit a straight line trend by the method of least square and calculate trend values. (b) What is ...

A: FORMULAS USED IN THE LEAST SQUARE METHOD: STRAIGHT LINE TREND: Y=a+bX WHERE Y IS THE DEPENDENT VARIA...

Question

Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order
the correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here.
Week
1
2
3
4
8
9
10
Rentals
20
20
34
26
21
12
21
26
19
14
a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses rounded to two decimal places.)
Week
Forecast
6
25.25
7
23.25
8
20
9
20
10
19.5
What is the forecast for week 11? 20 rentals. (Enter your response rounded to two decimal places.)
b. The mean absolute deviation as of the end of week 10 is rentals. (Enter your response rounded to two decimal places.)

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

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
James and Maddie work for Statesboro Toolworks. Their boss Jenny tells them that she will promote the person who has the best possible forecast for the firm's DG5-S electric tool. Jenny emailed them the demand data from 10 days worth of sales and then asked each to create a forecast for the next 10 days. The table below shows (1) Actual Demand data (2nd Column), James forecast (3rd column), and Maddie's forecast (4th column). Calculate which of the two has the more accurate forecast. Who gets the promotion? The combatant's forecasts and the actual egg production are shown in the table. Which forecaster was more accurate and should be hired as a result of his performance on this trial? Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Forecast Forecast (James) (Maddie) 102 102 107 106 105 113 115 113 109 118 124 119 142 136 130 154 148 142 166 160 154 181 174 167 198 190 182 206 202 195 Actual Final solution: The person who gets the promotion will be: What is Maddie's MAPE?…
The inventory level for a particular product is shown in the table below. Use the first 8 observations to investigate whether an additive or a multiplicative model is moresuitable for forecasting purposes. (The cyclical component is ignored here because the series istoo short). Using a moving average to represent the trend, what is then your forecast for 1999Quarter 4?
Simple exponential smoothing with a 5 0.3 is being used to forecast sales of digital cameras at Lowland Appliance. Forecasts are made on a monthly basis. After August camera sales are observed, the forecast for September is 100 cameras. Suppose 120 cameras are sold in September. Use the basic equation for simple exponential smoothing to forecast October sales and November sales.
Employing a 4 period moving average, forecast periods 5-8 and determine the forecast error (round 2 decimals)
Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?