forecast for weeks 7-24 using 6 week weighted moving average
Q: Be specific in your suggestions for reducing inventory and how to implement them.
A: In retail environment, reducing the level of invenntories is very crucial for increasing the profits...
Q: a. “To do what is right, you need to know what is right!” discuss the quote in relation to quality a...
A: Quality assurance is nothing but an important part of the quality management concentrated or focused...
Q: Give a brief overview of the project life
A: The Project Life is the arrangement of stages through which a project advances. The number of stages...
Q: Gantt Chart and Network Methods. Compare them with a working example not from the text. Neatly draw ...
A: To compare the Gantt chart and Network method from their working example consider the given data/exa...
Q: Grace Greenberg, production planner for Science and Technology Labs, in New Jersey, has the master p...
A: A Small Introduction about production Plan A production plan is made intermittently for a particu...
Q: What is a schedule that can be changed? Because it's good to be able to get schedules back. Are ther...
A: A modification in a previously prepared schedule in order to get more benefits, avoid any predicted ...
Q: Direction: Explain the Porter's Five Forces. 1, Threat of new entrants. 2. Bargaining power of buye...
A: Porter five forces is a powerful tool that is used to identify level of competition in any industry ...
Q: The output of a plant is 4335 pounds of ball bearings per week (five days). If each ball bearing wei...
A: Given data is Output = 4335 pounds Number of days = 5 Weight of ball bearing = 0.0113 gram
Q: three ways in which Human resource management concepts are related to or connected with the top ten ...
A: In an organization, human resource plays an important role in managing the performance of the employ...
Q: John Doe, a fraud examiner, has been hired by ABC Corporation to investigate a shortage of cash, whi...
A: Business frauds are often called illegal activities or operations. Business fraud can be stated as a...
Q: b) - Draw the Activity-on-Node (AON) diagram using the following representation for every node: Acti...
A: Project network is the graphical representation of project activities and their duration to complete...
Q: Implement and explain all the steps of the Branch and Bound method for the following optimization pr...
A: Given that:MAX Z = 5x1 + 12x2 + 4x3subject to8x1 + 5x2 + 3x3 <= 103x1 + 2x2 + x3 <= 4and x1,x2...
Q: In the manufacturing process, what has been called "the mapping of function to form"?
A: The manufacturing process is described as the process through which raw materials are transformed in...
Q: How many units are needed to break even if eaxh completed unit has a value of $100?
A: Break even refers to the level of production at which the revenue of a product is equal to the cost ...
Q: a. Which step is the bottleneck for entire car wash process? For the Deluxe & Standard car wash proc...
A: A Small Introduction about Process Flow A business cycle stream is a consecutive portrayal of int...
Q: Not all business intelligence users are managers interested in forecasting sales figures for the nex...
A: More and more equipment dealers rely on data and statistics to run their businesses. It necessitates...
Q: DETERMINE I) the adjusted seasonal indexes ofautumn: II) the de-seasonalised of period 1: III) th...
A: The adjusted seasonal index of autumn can be computed as below:
Q: According to Andy Growe, “Spending more time on planning should pay off in execution” what does this...
A: According to Andy Growe, “Spending more time on planning should pay off in execution”. This statemen...
Q: A comapny producing electronic equipment purchase batterys at $ 31.5 per unit. The annual requiremen...
A: Annual demand, d = 5501 units Ordering cost, o= $203 Holding cost, h= $5 per unit Lead time, L= 6 da...
Q: Develope a productivity measure for a product that utilizes labor machine time, raw materials and pu...
A: Details given: Units produced = 10,000 Labour hours used = 400 Selling price = $ 11/unit labor rate...
Q: or each project phase (Iniating, planning, executing and closing) identify and describe at least one...
A: In project management, there are five process groups, these are starting with initiating and then, p...
Q: ar Optim
A: Mathematical models may be solved using linear programming, or linear optimization, which is a proce...
Q: 4. A large donor has come on board to support the city in this initiative. This donor has given the ...
A: Decision Variable: Suppose-T be the no. of television advertisementsS be the no. of social media adv...
Q: Products are born, live and die. These phenomena can be represented by a product lifecyle with four ...
A: A product life cycle shows the complete process of a product from the scrap to the ending stage of t...
Q: 2) For each project phase identified in 1(a) above, describe at least four (4) project activities/pr...
A: Here we are discussing four project phases that mark the life of a project. Initiation phasePlanning...
Q: One of your staff members developed the following excel optimal production plan. You must now review...
A: A Small Introduction about Production Plan A production plan is made occasionally for a particula...
Q: A potential project has an initial capital investment of $100,000. Net annual revenues minus expense...
A: A Small Introduction about Project Management Project management gives construction and control o...
Q: Maximize Z=2x,+x2+3x3 3) X+x2+2x3 < 25 + X3 58 X2+ X3S10 Subject to X1 X1, X2, Xz 2 0
A: Given- Max Z=2x1+x2+3x3Subject to-x1+ x2+2x3≤ 25x1+x3≤8x2+x3≤10x1, x2, x3≥0
Q: how would a homebuilder, landlord, or property manager justify the use of energy star appliances in ...
A: Energy star appliances are the products which uses less amount of energy. The more stars a product h...
Q: ss how we, as construction manager, can avoid the delays in the construction. Use all theories neces...
A: You can frequently follow wild construction project costs back to a certain something: an inability ...
Q: One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of ...
A: Develop a spreadsheet as shown below to get the desired answers.
Q: Which of these is different in the Uber Business Model compared to taxis O A. The way the companies ...
A: Note- Hi! Thank you for the question As per the honour code, We’ll answer the first question since t...
Q: Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange o...
A: Given data for stock B is
Q: Evaluate the persuasiveness of Mazzucato’s arguments in The Value of Everything (2018) using the con...
A: A Small Introduction about Critical Management Being basic can be positive and valuable and can b...
Q: _______________ and ______________________ are two ways that debiasing can be achieved. Group of ans...
A: Biasing is phenomenon in which the human being having no reason is being baised from others as due t...
Q: Come up with a decision using each of the different criteria under conditions of uncertainty using t...
A: Given data is
Q: what are 4 principles of good product design.
A: The design of a product is the first and foremost factor that any customer will look and it may also...
Q: 15. Paryente Times, Inc, a publisher headquartered in Manila, wants to assign three recently hired c...
A: The assignment problem is a special type of linear program. In this type of problem, allocation is m...
Q: Think of one of the processes in your life you identified in Unit 3, and apply the 5S methodology to...
A: A Small Introduction about Processes Management process is a course of putting forth objectives, ...
Q: traditional or behavioral economic beliefs
A: Traditional economy is a system in which economic decision are taken on the basis of custom, traditi...
Q: A company has 250 employees. In order to find the tardiness of the employees the company decided to ...
A: In the given context, the company has 250 employees. For finding the tardiness it decided to ask 10...
Q: Which component describes the staff and management a. Key Partners b. Cost Structures c. Core...
A: Business model canvas refers to shared language that gives clear picture about how an organization c...
Q: Digital Photography allows one important criticism within casework. Because photographs are digital,...
A: Digital photography can be stated as the technique of utilizing digital and automation instruments t...
Q: Differentiate between process to process delivery and end to end deli
A: Process to process delivery means delivering the goods and services to the end users with the helps ...
Q: Seat your guest at the table. What will be the order of seating? Where should which person be seated...
A: Listing the stakeholders of the meeting Mr Smith - A renowned businessman from Great Britain Profe...
Q: Determine the product lead time by developing a timeline from the initiation of a purchase order to ...
A: A Small Introduction about Purchasing Purchasing is the purchasing of labor and products. A thing...
Q: Professor Z needs to allocate time among several tasks next week to include time for students' appoi...
A:
Q: What is the overall objective of scheduling?
A: Scheduling - is the technique of arranging, managing & optimizing tasks. It is an essential tool...
Q: Malburn Construction Ltd. Manufactures and distributes window frames. The company uses 600,000 metal...
A: Note: - Since we can answer only up to three subparts we will answer first three subparts(1, 2, and ...
Q: How much is the total sales? b. What is your break-even point in pesos per month
A: Breakeven point indicating the quantity of item of value of revenue which facilitate the no loss no ...
Weighted moving average using Excel:
3.1 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.55, 0.1, 0.1, 0.1, 0.1, 0.05
3.2 Calculate demand forecast for weeks 7-24 using 6 week weighted moving average with weights 0.2, 0.2, 0.2, 0.15, 0.15, 0.1
3.3 Plot the two weighted moving average forecasts together with the actual demand. Comment on the obtained graph.
3.4 Using the
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 7 images
- 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 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_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. 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?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_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?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.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?
- Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P13_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By examining the results of a linear trend line, explain why or why not.The table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 Using the following, forecast the sales for the months up to January the following year:- 1. A simple three-month moving average. 2. A three-period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data. 3. Exponential Smoothing when α= .6 and the forecast for March is 350. 4. Determine which of the three forecasting techniques is the most accurate using MAD.A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were as follows:Day 1 2 3 4 5 6 7 8 9Number sold 36 38 42 44 48 49 50 49 52Day 10 11 12 13 14 15Number sold 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trend-adjusted exponential smoothing? Why? b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with an initial forecast of 50 for day 8, an initial trend estimate of 2, and α = β = .3, develop forecasts for days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?