Question 1. The dean of a school of business is forecasting total student enrollment for this year (2019ys summer session elasses based on the following historical data: YEAR TOTAL ENROLLMENT 2015 2016 2017 2018 2,000 2,200 2,800 3,000 What is this year's forecast using a three-year simple moving average?
Q: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria next…
A: Step 1: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria…
Q: Calculate the Tracking Signal to two decimal places.
A: SOLUTION: Tracking Signal = 2.35 Hence, the solution of this answer is as below:
Q: Forecasting Ticket Revenue for Orlando Magic Basketball Games For its first two decades of…
A: Given data, Team Date Day of Week Time of Year Rating of the opponent Additional sales…
Q: a. Using a three-week moving average, what would you forecast the next week to be number.) Forecast…
A: Forecasting is predicting in advance what future sales/demand can be.
Q: EXERCISE 9 - FORECASTING Question 1 The following data summarizes the historical demand for a…
A: Given- Month Actual Demand March 20 April 25 May 40 June 35 July 30 August 45
Q: New Accounts Period New Accounts Period 200 6 232 11 214 248 12 3 211 250 13 4 228 253 14 235 10 267…
A: Given data is
Q: Successful Companies examine the future outcome using previous evidence."Does RMG in Bangladesh…
A: RMG ( Ready-made garments ) is one of the major drivers of the economy of Bangladesh. Bangladesh is…
Q: Question 03 Suppose you sell stylish leather bags targeting young office going people who can use…
A: Given data is
Q: Calculate the three-period simple moving average forecasts for months 4, 5 and 6.
A: ANSWER IS GIVEN BELOW:
Q: Question 1 One use of short-range forecasts is to determine planning for new products. (A) True (B…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: Discussion #1 & #2
A: As per the Bartleby Honor code we are not supposed to answer more than 1 question at a time. Please…
Q: Using 2-months moving average forecast sales from 5 to 11 months Using 4-months weighted moving…
A: A moving average is a statistical method to calculate the average change in a data series over time.…
Q: Question Three: Jane is trying to forecast demand for her store, using moving average with n=2, Fill…
A: Find the given details below: Given details: Year Quarter Enrollment 1997 1 313 2 285…
Q: Question 4 Jo-Jo Inc is a manufacturing firm that produces soap. The company is owned by two…
A: Decision tree analysis is the technique represented through the graph to solve the business problem.…
Q: Identify two business situations where the Delphi method might be used to generate forecasts. Can…
A: The Delphi approach (also known as the Delphi procedure or process) is a way of gathering expert…
Q: Question 2 Differentiate between independent and dependent variable in forecasting The last seven…
A: The major differences between the dependent variable and independent variable are the following:…
Q: Q1. What are the elements of good forecasting? Note: Write only the questions:
A: What Is Forecasting:- Forecasting is a method that utilizes chronicled information as contributions…
Q: QUESTION 9 The following is the actual sales for Manama Company for a particular good: t Sales 19 23…
A: t sales x y 1 19 2 23 3 22 4 27 5 34
Q: 1. A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August…
A: Since you have asked multiple questions, we will solve the first question with its sub-parts for…
Q: Discussion Question #2 - Present and discuss in detail the benefits and challenges of two…
A: "Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Forecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stocks…
A: Ratio forecasts are utilized to apply a client input ratio to a current gauge to ascertain another…
Q: 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors…
A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…
Q: 1. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of…
A: THE ANSWER IS AS BELOW:
Q: Question 18 A tire company needs a forecast for studded tires in the next forecast period. The…
A: Given: A smoothing constant of alpha = 0.20. The demand for the most recent period = 100 The…
Q: What is the role of the POS system in forecasting at HardRock?
A: Hard Rock is mainly used to collect data about every person who walks through a Hard Rock cafe's…
Q: Question one The president of State University wants to forecast student enrollments for this…
A: Ans :-a) foreeact for thouse year =1800+20000+210003…
Q: i. Differentiate between independent and dependent variable in forecasting. ii. The last seven…
A: The major differences between the dependent variable and independent variable are the following:…
Q: Being an Operational Manager, guide with reasons for the company to use appropriate forecasting…
A: Forecasting in the service sectors may provide some unusual challenges. One of the major challenge…
Q: Seatwork Compute for MAD, MSE and MAPE using Moving Average Model (past 3 Weeks), В. А. Exponential…
A: Forecasting is the process of estimating the future demand or sales using the previous years or…
Q: You have quarterly training data on beer production From 2006 to the end of 2007. Use the average…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: The last four weekly values of sales were 120, 90, 100, 80 and 85 units. The last four forecasts for…
A:
Q: What is Use a naive method to make a forecast?
A: Naïve method of forecasting is a simple forecasting method where the sales or demand of the previous…
Q: Determine the forecast of next year’s quarterly sales revenue for this line of laptops. Show all…
A: Below is the solution:-
Q: Questions: 1. What are some of the potential benefits of a more formalized approach to forecasting?…
A: The process that uses to predict the future based on past data is known as forecasting. The…
Q: Question DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5…
A: 1.) Given Data - YEAR Demand for fertilizer 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9…
Q: Forecast for the 11 quarter using exponential smoothing technique.
A:
Q: Explain the advantages of forecasting tool does exponential smoothing over moving avarages ?
A: The key benefits of exponential smoothing versus moving averages as a forecast.
Q: Q2: Daily high temperature in St. Louis for the last week were as follows: 93, 94, 93, 95, 96, 88,…
A: Formula:
Q: State examples of industries affected by seasonality and reasons to eliminate seasonality in their…
A: To be determined: examples of industries affected by seasonality and reasons to eliminate…
Q: a. Naive b. A four-period moving average c. Exponential smoothing with a = .30; use 20 for week 2…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Under what conditions might a firm use multiple forecasting methods?Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?Question 18 A tire company needs a forecast for studded tires in the next forecast period. The company typically uses an exponential smoothing forecast using a smoothing constant of alpha = 0.20. The demand for the most recent period was 100 and the forecast for the same period was 110. Based on this information, what is the tire company's forecast for the next period? Group of answer choices a. 100 tires b. 102 tires c. 108 tires d. 110 tires e. Impossible to determineQuestion 1 Forecasting calculation X Month Sales (y)(000 units) 1 Feb. 19 2 Mar. 18 3 Apr. 15 4 May 20 5 Jun. 18 6 Jul. 22 7 Aug. 20 8 Sep a. Using a 5-month moving average, calculate September sales b. Calculate September sales Using a 3-month weighted moving average (weights are 0.60, 0.30. 0.10). c. Calculatate Exponential Smoothing (assume February sale is 19) sales in September (alpha 0.2, that means 1-0.2 = 0.8) d. Using regression analysis, what is Y (September sales) if X is 8? (use data> data analysis button> regression)
- Q 6 Identify two business situations where the Delphi method might be used to generate forecasts. Can you think of any difficulties and pitfalls associated with using the Delphi method?QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MADQuestion DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the exponential smoothing model or the weighted average model developed? Explain your answer.
- QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and $50,000 for 2010 and 2011, what would you forecast for 2012? (b) given this forecast and actual 2012 sales of $53,000, what would you then forecast for 20013? (a) (b)Period Actual Forecast Error Abs Error 1 35 40 -5 5 2 38 37 1 1 3 45 41 4 4 4 39 43 -4 4 5 44 42 2 2 6 49 45 4 4 7 46 48 -2 2 8 46 48 -2 2 9 52 47 5 5 10 57 52 5 5 Sum 451 443 8 34 Average 45.1 44.3 0.8 3.4 Calculate the Tracking Signal to two decimal places.