A chain of pizza stores has had the following sales for take-out food over the last four evenings-Monday, Tuesday, Wednesday, and Thursday-of 29, 25, 35, and 30 pizzas, respectively. What would be their forecast for Friday using a naïve forecasting approach? Select one: a. 30 pizzas. b. 35 pizzas. c. 29.8 pizzas. d. 25 pizzas.
Q: The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: C) Using a two-period weighted moving average method the forecast for a period is calculated as the…
Q: The Pro Apparel company manufactures baseball-stylecaps with various team logos. The caps come in an…
A: Forecasting is a tool to recognize problems and opportunities in the business and turning it into…
Q: Hair dryers have sold 100, 110, 120, and 130 units at Walgreens stores in Youngstown, Ohio, during…
A: a) 3-month moving average: =110 + 120 + 1303= 120 Dryers.
Q: Choose the type of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…
A: Delphi Technique of forecasting would be appropriate to predict the demand for vacations on the…
Q: Choose the type of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…
A: Forecasting techniques are used to predict the future on the basis of past and present data.…
Q: Choose the type of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…
A: The types of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…
Q: Using a 3 period moving average, what is the forecast for day 8?
A: 3 period moving average is a forecasting model which helps to identify the forecast as the average…
Q: Given forecast errors of 4, 8, and −3, what is the mean absolute deviation (MAD) and mean square…
A: Forecast errors = 4,8 and -3 Absolute errors = 4, 8 and 3
Q: Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using…
A: Weighted Moving Average using the weights of .8, .15, and .05 ExponA use an alpha level of .75ExponB…
Q: Given a 3-quarter period of actual and forecast demand as shown in the table. The company ABC sets a…
A: A forecasting method is a managerial tool which help to predict the unknown future based on…
Q: Select the most suitable forecasting technique (survey, Delphi, averaging seasonal, naive, trend, or…
A: Forecasting may be a technique that uses historical knowledge as inputs to form educated estimates…
Q: a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to…
A: Forecast is the process of estimating the future demand using the previous year's or historical data…
Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…
A: This question is related to the topic forecasting and this topic falls under the business operations…
Q: The manager of a small health clinic would like to use exponential smoothing to forecast demand for…
A:
Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…
A: Find the Given details below: Given details: Month Price Per Chip ($) January 1.90 February…
Q: Do you think that hard rock cafe makes use of time horizons when forecasting?
A: The forecast horizon is that the duration of your time into the destiny that forecasts are to be…
Q: Using a 2-year moving average, the forecast for year 6 = miles (round your response to the…
A: Two year moving average is a forecasting tool which concluding the average demand of previous two…
Q: The Polish General’s Pizza Parlor is a small restaurant catering to patrons with a taste for…
A: a) (56+55+60)/3 = 57 0.50*60 + 0.30*55 + 0.20*56 = 57.7
Q: Auto sales at Carmen's Chevrolet are shown below. Using a 3-week weighted moving average (w₁-0.5,…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Tom’s Towing LLC operates a fleet of tow trucks that it sends to help drivers in need onthe nearby…
A:
Q: Calculate the forecast for Week 16 using - a 2-period moving average - a 3-period moving average…
A: Given data is
Q: A diary product manufacturing company uses simple exponential smoothing with trend to forecast…
A: Given data is Alpha = 0.15 Beta = 0.20
Q: Calanute Beach Resort, a fictional seaside luxury hotel in Goa, India, had the following occupancy…
A: Find the Given details below: Given details: Month Occupancy Rate in % 1 65 2 68 3 72 4…
Q: Given is a historical time series for job services demand in the prior 6 months. Month Demand 1…
A: The weighted average is a forecasting method in which higher weight is given to the most recent data…
Q: Professor Z needs to allocate time among several tasks next week to include time for students'…
A:
Q: Sunrise is planning its purchases of ingredients for bread production. If bread demand had been…
A: Exponential smoothing could be a statistic statement technique for univariate information that may…
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: MAD(Mean Absolute Deviation) = Sum of absolute deviations/Number of periods
Q: Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber…
A: Given data, MAY 42 JUNE 47 JULY 45 AUGUST 40
Q: Based on the time series data presented above, do the forecasts using 2-month moving average (2-MA)…
A: THE ANSWER IS AS BELOW:
Q: The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for…
A: Mean absolute deviation determines the prediction's accuracy by averaging the specified inaccuracy…
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: The exponential smoothing method is a type of forecasting technique. This method is suitable for…
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: A moving average is a method for determining the overall trends in a data collection by taking the…
Q: Sales of hair dryers at the Walgreens stores in Youngstown, Ohio, over the past 4 months have been…
A: Note- We’ll answer the first three subparts of the question since the exact one wasn’t specified.…
Q: Management of Davis’s Department Store has used time-series extrapolation to forecast retail sales…
A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…
Q: Sales of Bluetooth Headphones at the Abdulla Electronics Enterprises in Model Town, India, over the…
A: Since you have asked multiple questions, we will solve the first three questions for you (1.a, 2.b,…
Q: Which of the following is true about naive forecasting? a. It involves a two-period shift between…
A: Naive Forecasting is an estimation technique in which the actual value of the last period is used as…
Q: A check-processing center uses exponential smoothing to forecast the number of incoming checks each…
A: The forecasting technique is used to make predictions based on past and present data. Use in the…
Q: The Dean of a faculty wants to forecast student enrolments for this academic year based on the…
A: Answer: For solving the question, we have these following information. 5 years ago the enrolment…
Q: Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Forecasting The manager of a popular tourist resort wants to use the manual trend projection…
A: The benefit of the forecasting technique is 1) Cost reduction2) Inventory reduction and management…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Using least Square method Marron 5 TV appearancr(X) Demand for Guitars(Y X^2 Y^2 XY 3 4 9 16…
Q: Sales of the Crown Gems have been increasing over the past five years. The operations manager has…
A: Forecasting entails making educated guesses at unknown values based on known values. Exponential…
Q: A concert promoter is forecasting this year's attendance for one of his concerts based on the…
A: The concept of Operation Management: Operation management is the management that applies to a…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Given information, Maroon 5 Tv 3 4 7 6 8 5 Demand for Guitars 3 6 7 5 10 7
Q: Demand for Soft Shag Month Carpet (1,000 yd.) 1…
A: Exponential smoothing forecast is extension of simple moving average forecast. In exponential…
Q: Based upon the reference chapter and člass disc The probabilistic forecast for a textile retail…
A: SOLUTION: NOTE: ACCORDING TO BARTLEBY GUIDELINES WE CAN ANSWER AT A TIME..PLEASE POST SEPARATELY...…
Q: b) The forecast for the next month (Jan) using the naive method= 22 sales (round your response to a…
A: Forecasting is the process of predicting future events or trends based on past and present data.…
Step by step
Solved in 2 steps
- Under what conditions might a firm use multiple forecasting methods?At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.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 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?Canton Supplies, Inc., is a service firm that employs approximately 100 people. Because of the necessity of meeting monthly cash obligations, the chief financial officer wants to develop a forecast of monthly cash requirements. Because of a recent change in equipment and operating policy, only the past seven months of data are considered relevant. The change in operations has had a great impact on cash flow. What forecasting model do you recommend? Use the Moving Average and Exponential Smoothing Excel templates or other Excel tools to help you answer this question. Cash Required Cash Required Month ($1,000) Month ($1,000) 1 186 5 233 2 219 6 241 3 216 7 204 4 270 Find the best number of months to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. Number of months MSE 2 3 4 The model is the best. Find the best single exponential smoothing model by…As a supply chain manager for a company, you are tasked with forecasting the demand for a particular product. To assess the accuracy of your forecasting model, you decide to calculate the Mean Absolute Percent Error (MAPE) for the past seven months. Below is the data representing the actual demand and forecasted demand for each month: Month Actual Demand Forecasted Demand 1 1000 1100 2 900 1200 3 1300 1400 4 1100 700 5 2000 1700 6 1500 1200 7 1600 1500 What is the Mean Absolute Percent Error (MAPE) for the seven-month period? Question 1 options: a) 20.68% b) 17.66% c) 18.38% d) 19.44%
- It has been said that forecasting using exponential smoothing is like driving a car by looking in therear-view mirror. What are the conditions that would have to exist for driving a car that are analogous to the assumptions made when using exponential smoothing?2. What capability would an organization have to have to not need forecasts?3. When a new business is started, or a patent idea needs funding, venture capitalists or investmentbankers will want to see a business plan that includes forecast information related to a profit andloss statement. What type of forecasting information do you suppose would be required?4. Discuss how you would manage a poor forecast.5. Omar has heard from some of his customers that they will probably cut back on order sizes in thenext quarter. The company he works for has been reducing its sales force due to falling demand andhe worries that he could be next if his sales begin to fall off. Believing that he may be able to convince his customers not to cut…The following company sells two family of products. The company begins its roll-up forecast anticipating a need for 60 units of A1 and 75 units of A2 at a cost of $200 per unit and $350 per unit, respectively. In addition, they anticipate a need for 85 units of B1 and 90 units of B2 at a cost of $410 per unit and $525 per unit respectively. Complete the roll-up pyramid forecasting technique for MPC Inc. Fill all the blanks. Allow 1 decimal value.The past two years sales at ACSR Inc. were 3 million and 5 million. Their forecast team used a two-period moving average to forecast its sales this year. But the actual sales for this year were 5 million. Now, the forecast team wants to forecast its sales for next year by using exponential smoothing with alpha equals 0.6. What is the forecast using exponential smoothing with alpha = .6? 2. If we decide to use an alpha of .2 instead of .6, will we be ‘weighting the error from the previous period higher or the Forecast from the previous period higher? Explain briefly or show using math! (In this question I am asking if we change the alpha to a lower alpha, what will be the effect – what will we be ‘weighing’ as more important?)
- A manufacturing firm has developed a skills test, the scores from which can be used to predict workers’ production rating factors. Data on the test scores of various workers and their subsequent production ratings are shown.a. Using POM for Windows’ least squares-linear regression module, develop a relationship to forecast production ratings from test scores.b. If a worker’s test score was 80, what would be your forecast of the worker’s production rating?c. Comment on the strength of the relationship between the test scores and production ratings.The manager of a travel agency asked you to come up with a forecasting technique that will best fit to the actual demand for packaged tours. You have observed and recorded the actual demand for the last 10 periods. You also identified two possible techniques for consideration: 2-month moving averages (F1), and exponential smoothing (F2) with a smoothing constant of 0.25. Using Cumulative Forecasting Error (CFE) and Mean Absolute Deviation (MAD) as your performance measures you will determine the technique that will best fit to the actual demand data provided in the following table.STEP 1: Given start forecast values in period 3, compute forecast values from period 4 to 10. You are asked to provide the forecast values for period 6 and 10 for both techniques. 2-Month MA Exponential Period Demand F1 F2 1 115 -- -- 2 176 -- -- 3 97 146 129 4 141 5 98 6 132 7 114 8 129 9 107…A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and four-period moving average forecasts and answer the following questions. Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 5. What is the MSE for the four-period moving average? Round your answer to two decimal places. 7. Which forecast is the best based on the MSE value?