You are given the demand and forecast history for Apple iPhone 12. According to this, what is the 3-period weighted moving average forecast for Week 11 with weights 1,2,3? (Use the first weight for the oldest (the least relevant) demand value. Do not round

You are given the demand and forecast history for Apple iPhone 12. According to this, what is the 3-period weighted moving average forecast for Week 11 with weights 1,2,3? (Use the first weight for the oldest (the least relevant) demand value. Do not round

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 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Related questions

Q: Research cloud computing pros and cons. What are the financial pros and cons of cloud-based company…

A: Introduction: Cloud-based operations refer to the use of cloud computing technologies to manage and…

Q: An outline of the five methods of risk mitigation should be provided.

A: Risk mitigation is the process of reducing or preventing the negative impacts of risks to an…

Q: 1) Seaport such as Port Klang, Pasir Gudang, Port Tanjung Pelepas and Penang usually attract heavy…

A: Location planning is a critical process for any business, as it can significantly impact its success…

Q: SLO 1.3 Supplier managed inventories works best for: A) Production material B) Direct material C) A…

A: As per Bartleby guidelines, we can only solve one question at a time...Kindly upload the other…

Q: Describe the technique or method used to select the project. (4) Identify and describe at least five…

A: The above project comes with multiple purposes, and it could offer multiple results/outcomes term…

Q: Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver,…

A: (a) Let Super saver = S, Deluxe = D, Business = B, Type 1 = T1, Type 2 = T2 Maximize Z = 30…

Q: can u get the bcwp, bcws, schedule performance index, cost performance index (in a table)…

A: The following are the formulas used to compute BCWP, BCWS, SPI, CPI BCWP = % of work done × Actual…

Q: weaknesses and opportunities that an eco-friendly packaging manufacturer has

A: Weaknesses: Higher production costs: Eco-friendly packaging materials can frequently be more…

Q: 4 key constraints faced when rebuilding the elliott bay seawall

A: The Elliott Bay Seawall reconstruction is a sizable building project with many challenges that must…

Q: When would you want more space for your belongings?

A: ANSWER : The need for more space for belongings can arise in various operational management…

Q: You are given the demand and forecast history for Apple iPhone 12. According to this, what is the…

A: A weighted moving average forecast is a type of forecasting method used to make predictions about…

Q: What happens to availability when the MTTR (time between failures) approaches zero? Can this be…

A: MTTR stands for Mean Time To Repair. It measures the average time it takes to repair a failed system…

Q: Code A B C D E F G NT 12 16 9 9 20 8 3 CT 10 12 6 4 20 8 1 NC 50 70 45 80 30 50 20 CC 100 100 84 200…

A: Possible path Duration Is duration maximum Critical A-B-D-G 12+16+9+3 = 40 No No A-C-D-G…

Q: What are some threats

A: Due to the trend toward sustainability and environmental responsibility, there is now more demand…

Q: How much time would you expect a customer to wait in line, pay with a debit card, and leave?

A: Given that the arrival rate is 300 per hour and the service rate to verify the debit card is to be…

Q: The following diagram describes a service system where customers go through either of the two…

A: Find the given details below: Given details: System Required time No of workers A1 3 1 A2 4…

Q: b. What is the workstation cycle time required to meet the desired output rate? Workstation cycle…

A: Project schedule helps in calculating different values all related to the production cycle like the…

Q: What is a Type I error and a Type II error?

A: In statistical hypothesis testing, a Type I error is the incorrect rejection of a null hypothesis…

Q: You are given the demand and forecast history for a baby doll sold at a toy store. According to…

A: Let alpha be a, the actual demand of week 9 is D and the forecast of week 9 is F. Given: Alpha (a) =…

Q: 5. Discuss the Resource-Based View (RBV) in strategic management.

A: Strategic Management- Strategic management in a business alludes to the planning, management, and…

Q: The name of the project is launching a new car. Now that you have selected a project (a case),…

A: Launching a new automobile is a challenging and complex endeavor that needs a thorough and…

Q: If the restaurant runs a sale and the customer arrival rate increases by 20%, how would this change…

Q: Jonathan owns and operates 5 car window tinting shops in the Rio Grande Valley area. Each tint shops…

A: The design capacity is the most excellent output that a system, machine, or process can produce…

Q: Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home…

A: To determine the optimal location for SC Consulting's home offices, we need to consider the fixed…

Q: Level of success in the management of the triple constraints of time, cost, and scope

A: The triple constraint of project management can be defined as a triangle which gives you the thought…

Q: AlwaysRain Irrigation, Incorporated would like to determine capacity requirements for the next four…

A: Given-

Q: The grocery store has bulk pecans on sale, which is great since you're planning on making 8 pecan…

A: Buying in bulk can be a great way to save money when cooking or baking for a large event, such as a…

Q: Service organizations display the following characteristics, except that: A. They create more…

A: Here, It is an MCQ question, each option is explained, and each option would differentiate service…

Q: Time estimates Expected Variance Activity Optimistic Most Likely Pessimistic Time (ET) (6²) m 40 50…

A: Formulae used: Expected time is (E)= (O + 4M + P)6. Variance (σ2)=P-O62 Standard Deviation=σ2…

Q: I would appreciate it if you could describe the Service Process Structuring.

A: The structure used to plan and oversee service delivery processes in businesses is referred to as…

Q: Explain the project's advantages to recipients. Enterprise Information and Technology Governance…

A: General advantages that projects can propose to recipients: Improved efficiency: Projects can assist…

Q: Schedule the following activities using CPM: ACTIVITY IMMEDIATE PREDECESSOR ABCDEFGH TAABCDFE А А C,…

A: The critical path or paths shows the longest duration (in time) till beginning to end and it specify…

Q: Name Of Project: Project Duration: North Central Sports Programme 2022 6 Months New Type Of…

A: The projects of a business may differ from company to company. Some projects are of high importance…

Q: Identify the place for extension services within rural development framework

A: The extension is a term which is available to a wide assortment of understandings. Every extension…

Q: ii) Explain possible reason why the kitchen equipment, furniture, layout and the menu offered are…

A: Standardization refers to the process of having a set of standards or guidelines for a particular…

Q: 1. which statement describes the relationship between operations management and information…

A: To be determined: The Relationship between operations management and information technology (IT)…

Q: If the profit per unit on Tables (T) increases to $750 and simultaneously the profit per unit on…

A: Given sensitivity report-

Q: If you want to know how you got, used, and accounted for the machines, explain how.

A: Depreciation is the reduction in the value of an asset over time due to wear and tear, obsolescence,…

Q: The following are historical demand data: YEAR 2 years ago last year SEASON Spring Summer Fall…

A: The seasonal index, also known as seasonal effect or seasonal component, is a gauge of how a given…

Q: 1.) Most fast food restaurants like McDonald, KFC, Pizza Hut,4Fingers, Subway and others are located…

A: Location planning is a critical process for any business, as it can significantly impact its success…

Q: Kelly Foods has two plants and ships canned vegetables to customers in four cities. The cost of…

A: Decision Variables: Suppose-Xij be the no. of cases sent from plant i to customer jWhere i=1,2 and…

Q: 2 ERP articles review.

A: Article 1: "ERP Implementation Challenges: A Review and Future Directions" by Gao, Pan, and Xu…

Q: c. Level or degree of customer/user satisfaction of results and outcomes d. Value created for the…

A: To improve sports development in St. Catherine North Central by giving sports clubs and teams…

Q: Which of the following reasons explains the presence of missing data in survey research?…

A: To be determined: Choose the right reason that explains the presence of missing data in survey…

Q: can u get the bcwp, bcws, schedule performance index, cost performance index (in a table) 58 weeks…

A: The following are the formulas used to compute BCWP, BCWS, SPI, CPI BCWP = % of work done × Actual…

Q: A production process is shown in the figure above. The drilling operation occurs separately from,…

A: To determine the bottleneck- First estimate the process time and in bottleneck condition the process…

Q: 3. Joe's Equipment Distributors sells "Low and Loud" brand lawnmowers. Total demand in 2021 is…

A: Find the Given details below: Given details: Season Year 2018 2019 2020 Fall 50 80 120…

Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…

A: Industry demand, supply, and price changes can all be predicted with a little bit of research and…

Q: b) Describe the importance of quality and the importance of 4M man, machine materials and methods in…

A: Quality is a critical factor in the success of any product, including motor vehicles. It refers to…

Q: The failure of the baggage system at Denver International Airport may have been the result of sloppy…

A: ANSWER : Yes, it is possible to explain the steps involved in project management using an example of…

Question

OQ3

Week Actual Forecast
1 26.7 31.9
2
25.0 32.3
3
51.9 63.4
4
56.7
74.5
5
66.7
69.8
84.5
89.7
91.9
99.2
8
91.5
94.6
9 104.1 115.6
10 123.2 141.0
67
You are given the demand and forecast history for Apple iPhone 12. According to this,
what is the 3-period weighted moving average forecast for Week 11 with weights 1,2,3?
(Use the first weight for the oldest (the least relevant) demand value. Do not round
intermediate calculations. Round your final answers to two decimal places. Hint: If
weights do not add up to 1, they need to be normalized with the sum of the weights,
which is 6 in this case. For example: weight 1 becomes -0.167(@orsdemir, Copyrighted
content. Cannot be posted)

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 Introduction:

VIEW

Step 2 Answer:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Under what conditions might a firm use multiple forecasting methods?
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_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?
Given the following historical data, what is the simple three-period moving average forecast for period 6? Period 1 2 3 4 5 67.67 68.2 67.3 68.4 Value 73 66 64 73 66
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 2 1 Demand 19 21 3 29 Week 1 2 Demand. 19 21 Forecast 19.01 4 38 3 29 5 25 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places); 4 38 7 6 28 36 5 25 8 9 10 24 24 30 6 7 28 36 8 9 10 24 24 30
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places)
11. Consider the following actual and forecast demand levels for Big Mac hamburgers at a local McDonald's restaurant: Day Actual Demand Forecast Demand Monday 88.00 88.00 Tuesday 72.00 88.00 Wednesday 68.00 84.00 Thursday 48.00 80.00 Friday − ? Part 2 The forecast for Monday was derived by observing Monday's demand level and setting Monday's forecast level equal to this demand level. Subsequent forecasts were derived by using exponential smoothing with a smoothing constant of 0.25. Using this exponential smoothing method, the forecast for Big Mac demand for Friday is __________ Big Macs (round your response to one decimal place).
Forecast is calculating estimates of future cycle/s based on data of past cycles -- there is no What? time interval in forecasting
12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month January February March April Мay June Motorcycle Sales 7 10 8 7 12 July August September 10 11 12 October 10 November December 14 16 a Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of dhe next year?
The demand (in number of units) for Apple iPad over the past 6 months at BestBuy is summarized below. Month Nov 2019 Dec 2019 Demand 45 48 Jan 2020 50 Feb 2020 Mar 2020 Apr 2020 42 46 51 Consider the following three forecasting methods: • Two-month weighted moving average, with weights 6 and 2 (more weight assigned to more recent data) Exponential smoothing with a = 0.7. Let the initial forecast for Nov 2019 be 46. • A trend line projection in the form ŷ = a+bx . To simplify computations, transform the value of x (time) to simpler numbers – designate Nov 2019 as x=1, Dec 2019 as x= 2, etc. (a ) For each of the above methods, forecast the demand of Apple iPad for May 2020. (b) Consider only the two-month weighted moving average method, compute the MAD measure and the MSE measure using the data from Jan 2020. (c) Use the trend line to forecast the demand of Apple iPad for Dec 2020. Give your opinion regarding the reliability of the forecast.
Additional Algo 15-12 Forecasting with Seasonality Demand history for the past three years is shown below, along with the seasonal indices for each quarter. Seasonal Index 1.25 Year Year 1 Year 2 Year 3 Quarter 01 02 03 04 01 02 03 04 01 02 03 04 Year 4, 01 forecast Demand 926 819 585 515 912 874 651 552 861 828 571 542 1.176 0.837 0.745 1.25 1.176 0.837 0.745 1.25 1.176 0.837 0.745 Use exponential smoothing with alpha (a) - 0.3 and an initial forecast of 720 along with seasonality to calculate the Year 4, Q1 forecast. Note: Do not round intermediate calculations. Round your answer to the nearest whole number.