The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows:Week123456Actual No. of Patients272936202435Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using thisdata. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demandlevels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 threeperiods ago.a) What is the value of your forecast?The value of the forecast ispatients (round your response to two decimal places).کے

A technique called forecasting is used to make predictions about the future based on facts from the…

Answered: a) What is the value of your forecast?…

a) What is the value of your forecast? The value of the forecast is patients (round your response 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.6: Moving Averages Models

Problem 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...

See similar textbooks

Related questions

Q: Article 1: South African pears will soon be on sale in China for the first time • Consumers in China…

A: Green transport refers to using transportation methods and strategies to reduce the negative impact…

Q: Solve the linear programming problem by the simplex method. Minimize x-7y subject to the constraints…

A: Min Z = x + 7 y subject to 2 x + 5 y ≥ 30 - 3 x + 5 y ≥ 5 8 x + 3 y ≤ 85 -…

Q: (d) BICO is a company which manufactures bottles made from polyethylene terephthalate. The company…

A: Decision variable G1 R1 , G1 R2 , G1 R3 , G1 R4 , G1 R5 , G2 R1 , G2 R2 , G2 R3 , G2 R4 , G2 R5…

Q: Consider the following all-integer linear program. Max 1x1 + 1x2 s.t. 5x1 + 7x2 ≤ 42…

A: MAX zx = x1 + x2 subject to 5 x1 + 7 x2 ≤ 42 x1 + 5 x2 ≤ 20 2 x1 +…

Q: The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest…

A: Ans) Concept: 2 year moving average is one of the method of forecasting. In 2 year moving average,…

Q: Represent Campus's inventory as a matrix A. A = Textbooks Fiction Nonfiction Reference…

A: The total inventory will be the sum of inventory in matrix A and matrix B.

Q: From To W Y Z Demand A $4 $6 $8 30 B $3 $7 $2 65 с $3 $6 $5 40 Capacity 35 50 50 135

A: Using any of the methods, such as the North-West Corner, Least Cost Method, or Vogel's Approximation…

Q: What type of firm generally has the highest proportion of inventory to total assets? a) Retailers.…

A: Inventory indicating the goods, materials and services keeping and producing by the firm for earn…

Q: Which of the following is considered to be a hygiene factor by the motivator/hygiene theory?…

A: Ans) Hygiene factors includes those factors who presence may not necessarily increase the…

Q: General Appliance Corporation (GAC) produces refrigerators at three plants: Akron, Evansville, and…

A: Transportation problem is a special case of asignment problem covered in Linear programming…

Q: invest a total of $50,000. Because of the risk, he will limit his investment in oil leases and…

A: Linear programming is an optimization technique that can be used when there are limited resources…

Q: Who has the lowest productivity? Workers Orders Processed Customer Type Hours Worked Wage/hr:…

A: Productivity per labor $ = output/(labor hours* labor wage per hr)

Q: Product design has been identified as the real key to worldcompetitive business. The steps in the…

A: Product design is a concept where strategies and plans are made to ensure how the product will…

Q: Question 2: State whether the following statements are true or false. If the statement is false,…

A: Operations management is a field of study that includes all about maintaining the quality of work…

Q: The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is…

A: Given data: Monthly demand (d) = 50 cars Then Annual demand (D) = 50 × 12 = 600 cars Ordering cost…

Q: Draw a project network. A project network with 11 activities and 13 directed arcs is shown. Activity…

A: NOTE: We are allowed to do first three sub-parts only. The critical path method is a project…

Q: Discussion Questions* 1. Name and justify several factors that Hoffman could use in forecasting…

A: Forecasting – Several Factors: As per the given case, Hoffman can use the following…

Q: 1. List down 5 current challenges in OM specifically in Strategic Management

A: NOTE: We are allowed to do one question only at a time. Operations management is a critical…

Q: Referring to the above problem, solve it by the vogel approximation method

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: one of your projects team members is highly regarded for her skills in the company. she is assigned…

A: A high-visibility project means that the project is highly important for the company and in market…

Q: Solve the following linear program by the solver method

A: Linear Programming is a statistical and mathematical technique used in operations management.…

Q: Draw a project network. (Submit a file with a maximum size of 1 MB.) (b) Identify the critical path.…

A: NOTE: We are allowed to do three sub-parts only. The critical Path Method is a project management…

Q: Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile…

A: Decision Variables:Suppose-x4 = No. of 4-cylinder connecting rods produced next weekx6 = No. of…

Q: An accounting firm is capable of processing 20 EZ tax forms per day, and the average number of forms…

A: Queuing theory is the study of waiting for lines/queues. This model helps to determine the length…

Q: An architect firm uses an average of 60 boxes of copier paper a day. The firm operates 280 days a…

A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…

Q: Bobby, another enterprising barber, is thinking about advertising in the local newspaper because he…

A: Assume that service is distributed exponentially and that client arrival is Poisson distributed.…

Q: 2. Supply management is not an isolated department. Explain how it is related to other departments.

A: Supply chain management is the management in which different processes, technologies, and employees…

Q: Dave Fletcher was able to determine the activity times for constructing his laser scanning machine.…

A: Activity Immediate Predecessors Duration A - 5 B - 8 C A 2 D A 1 E B 3 F B 5 G…

Q: 3. If an organization is having difficulty trying to get customers' opinions into the definition of…

A: General introduction about quality: Quality means differently to different people. For some, it…

Q: Provide examples for each of the categories below: Process Type and Structure Example 1 Example 2…

A: 1. Service Backend Process - The way in which the company works so that a customer receives service.…

Q: A manufacturer can produce an item for $139/unit with a fixed cost of $56,034. The alternative is to…

A: The break-even point is the point at which the total cost of production equals the total revenue…

Q: Suppose a project manager is reviewing the project management plan, the work performance data, and…

A: A project, according to the Project Management Institute (PMI), is a short-term activity that is…

Q: The firm needs to satisfy all demand each day, but would like to minimize the total costs. The…

A: In the given question, there are 4 plants and 3 customers who will receive the widgets produced by…

Q: 1-What is the difference between qualitative forecasting techniques and quantitative forecasting…

A: Forecasting is the process of identifying trends in order to predict future outcomes. Forecasting is…

Q: What type of inventory would be destroyed in a supermarket?

A: A supermarket has a huge variety of inventory as it provides different kinds of goods all under one…

Q: K The following table gives the map coordinates and the shipping loads for a set of cities that we…

A: The best method for calculating the location for central hub is center of gravity method. This…

Q: Carlos Cavalas, the manager of Echo Products’ Brazilian Division, is trying to set the production…

A: Required production = Expected sales + Desired ending inventory - Beginning inventory

Q: Disucss the functions of operation management in the manufacturing and production in any company.…

A: The role of operation management is to see that resources are properly transformed into goods and…

Q: A Company is in the process of preparing a budget for launching a new product. The following table…

A: NOTE: We are allowed to do one question only. A critical path is a project management technique…

Q: Find the optimal solution to this linear programming problem. Min 3X+3Y s.t. 12X+4Y>=60…

A: NOTE : As no particular, method has been specified, I have solved this using graphical method.…

Q: (a) What is total profit now? (b) What will be the profit with the new machine? (c) Should the…

A: Here, Given data, Before adding a new piece of equipment, Variable cost=0.75 per unit, Selling…

Q: Provide a critical evaluation of the deployment of emerging web-based and cloud-based technologies…

A: Amazon's organizational structure is horizontal and it allows for greater flexibility and speedy…

Q: Calculate average waiting time for ATM user at the BBT location 2. Calculate average length of…

A: NOTE: We are allowed to do the first three sub-parts only. Given: Arrival rate (A) = 21 Service…

Q: Consider the following model. Maximize subject to x₂ + x₂ x1 x₂ + x3 Z = 4x₁ + 8x₂ + 10x3 + 6x4 x3 +…

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

Q: enterprise wide risk management system (EWRMS) with particular emphasis on how this differs from a…

A: Basic risk management Organizations with…

Q: The Hard to Beat Bakery is deciding whether to buy or repair an existing oven that they have been…

A: Probability Revenue ($) Cost ($) Repair 950,000 Good performance 20% 10,000,000…

Q: What are project mangement constraints and Why are they important when developing a project…

A: Project management implies the process of leading a team achieve the deliverables within a set…

Q: Given the following AOA network diagram and activity duration information, determine the Earliest…

A: The CRITICAL PATH consists of three parts: - The first part is the "strategic fit" which has to do…

Q: Calculate the forecasted sales revenue for May using the following data. Month Sales…

A: Here, the data set contains the month column and sales revenue column, the dataset table is…

Q: Which of the following is not information needed to use the transportation model? Multiple Choice…

A: A transportation model is a type of mathematical model that is used in operations management to…

Question

The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows:
Week
1
2
3
4
5
6
Actual No. of Patients
27
29
36
20
24
35
Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this
data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand
levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three
periods ago.
a) What is the value of your forecast?
The value of the forecast is
patients (round your response 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

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows:
Week
1
2
patients (round your response to two decimal places).
4
5
Actual No. of Patients
27
29
36
20
24
35
Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method
uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago.
a) What is the value of your forecast?
The value of the forecast is

Solution

by Bartleby Expert

SEE SOLUTION

Similar questions

Under what conditions might a firm use multiple forecasting methods?
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 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_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 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_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?
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 owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b? Is it guaranteed to produce better forecasts for the future?
The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.
Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.