Question 2 Differentiate between independent and dependent variable in forecasting The last seven weeks of sales at KC car dealership can be seen in Table 2 below. 1. 11. Table 2 Week Sales 1 25 30 3 27 4. 31 27 29 7. 30 a. Use a three-period weighted-moving average forecast to determine a forecas for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) b. Calculate the MAD for this forecast. c. What does the MAD indicate?
Q: Question Completion Status: QUESTION 1 List nested geographic units used by the United States Census…
A: The question is related to list nested geographic units used by the united states census bureau in…
Q: Judgmental forecasts have the following strengths, except___________. a. Can include “inside” and…
A: A prediction based on subjective data. A judgmental forecast is one that is made by someone who is…
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: Q.No.04. What does BOM stands for? Why it is necessary for any firm to have correct forecast of BOM?
A: A Bill of Material serves as a complete list of all the materials and parts that a manufacturer…
Q: Suggested scenario for the question: Your company, a Real Estate agency (SUNNYHOMES) with 3…
A: Sales effectiveness is the output driven by the sales force or workforce based on the organization’s…
Q: QUESTION 3 Forced distribution is a type of special rating instrument which can help address which…
A: Performance appraisal tend to identify the skill efficiency and contribution by employees. It…
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: Sample Size, or Number of measurements in each Subgroup: • Number of Subgroups: • Subgroup…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Discussion Question As one of the newer district sales managers for a fast-growing technology…
A: Ethics in business are the collection of guiding principles which are created to ensure a business…
Q: If the forecasted value of the time series variable for one period is 28.5 and the actual value…
A: Forecasted value = 28.5 Actual value = 32
Q: Process thinking alludes to: Select one: a. Value added activities b. Careful consideration of…
A: 1- OPTION -B - Careful consideration of individual products 2-OPTION -A -Use of…
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: Ethical Question: What would you do? As one of the newer district sales managers for a fast-growing…
A: Ethics is the line between right and wrong and choosing to be always on the right side. These codes…
Q: Q1 Given the Supply chain cost for a service is PKR 195 and the customer value is PKR 225. Determine…
A: Supply Chain Surplus= Revenue generated from customer - Total cost incurred to produce and deliver…
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: 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: Suppose the actual sales and the forecasted, or smoothed sales, for the past 5 months have been…
A: Find the Given Details below: Given Details: Actual Smoothed 54.4 76.8 54.4 75.5 72.3…
Q: A-19 Pandemic on Employment, and (c) Impact of CORONA-19 Pandemic on Business.
A: Corona-19 Pandemic is a continuous worldwide pandemic of Covid sickness 2019 (COVID-19) brought…
Q: 1. Discuss the differences between Qualitative and Quantitative forecasting models. How do…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: question 3 1. The table below summarizes the number of cars sold in thousands, in car dealerships…
A: Make Number of units sold (thousands) Honda 4.8 Audi 3.2 Ford 4.2 Toyota 3.8 Kia…
Q: QUESTION B2 A financial Analyst wants to evaluate the feasibility of his investment options. The…
A: Given- Economic Environment Investment Option Good Fair Poor X 25 8 -15 Y 20 15 -10 Z…
Q: QUESTION # 7 A small restaurant offers tacos to their patrons. One of their specialties is the Mega…
A: Given Information: a) The forecasted demand for using a moving average with n = 3 is :
Q: Q4 ABC University wants to develop forecasts for next year's quarterly enrollment. It has collected…
A: Given data is
Q: Q3 The following table contains the sale of water pumps for the last 10 months in a retail outlet.…
A: Formula:
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: Two most important factor of forecasting techniques what are those ?
A: Forecasting is a method of making predictions. based on historical and present facts.
Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and…
A: Therefore, the forecast in 2012 is $48,000.
Q: QUESTIONS All Ans to 3 Decimal Places Use the Naiive method to forecast for Feb -Aug 2021 2…
A: As per our guidelines, we are supposed to answer only three sub-parts if multiples sub-parts are…
Q: 4. A new car dealership is considering opening branches in three of the largest cities in the state.…
A: Forecasting is the practice of predicting future events by focusing on long-term trends. Basically,…
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: How would you conduct a trend analysis? Provide an example.
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Statement I Statement 2 SC Middle manager are the ones responsible for setting operations goals and…
A: In Bartleby's policy, providing reference is not allowed.
Q: Suppose the actual sales and the forecasted, or smoothed sales, for the past 5 months have been…
A: Find the Given details below: Given Details: Actual Smoothed 54.4 76.8 54.4 75.5 72.3…
Q: QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year…
A: The regression line equation is- y = a + bt where T(t) is the time series Coefficients Intercept…
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: What is Porter’s competitive forces model, how do organizations take advantage of competitive forces…
A: Porter’s five forces can be defined as the tool which helps in understanding the forces that helps…
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 A reputable FMCG company is holding its Annual Sales Conference on January 30th 2021 for…
A: Techniques of forecasting which will be employed by the corporate for its existing and new products…
Q: Forecast for the 11 quarter using exponential smoothing technique.
A:
Q: q. 15 Calculate the accuracy of your MA forecasts using MAD. What does the result tell you?…
A: Given-
Q: QUESTION ONE (a) Mr. Sak is interested in developing and marketing a new drug. The cost of extensive…
A: From the given data: i. Draw a decision tree for Mr. Sak indicating all choices and events
Q: Passenger miles flown on Northeast Airlines, a commuterfirm serving the Boston hub, a re shown for…
A: Given data is
Please solve the question in the picture.
Step by step
Solved in 3 steps with 2 images
- Under what conditions might a firm use multiple forecasting methods?Question 2 i. Differentiate between independent and dependent variable in forecasting. ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8 a. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) b. Calculate the MAD for this forecast. c. What does the MAD indicate?QUESTION 1The 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:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.
- Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?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.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 determine
- Questions: 1. What are some of the potential benefits of a more formalized approach to forecasting? 2. Prepare a weekly forecast for the next four weeks for each product. Briefly explain why you chose the methods you used. (Hint for product 2, a simple approach, possibly some sort of naive/intuitive approach, would be preferable to a technical approach in view of the manager's disdain of more technical methods).QUESTION 1The 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 150a. 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 usingMAD. b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.…QUESTION 5 Choose the answer with the best match. Elements of a Good Forecast, Meaningful: The benefits should outweigh the costs It should work consistently The degree of accuracy of the forecast should be stated The forecasting horizon must cover the time necessary to implement possible changes so that its results can be used The units measured should be useful to those using the forecast QUESTION 6 There are two main approaches to forecasting. Choose the best two: Quantitative, Consumer Judgmental, Quantitative Sales force, Judgmental Historical, Consumer Expert, Executive QUESTION 7 Describe the following: Andon Maintaining equipment in good condition Maintaining a workplace that is clean System for moving work to the next station as it is completed System of lights used at each workstation to…
- QUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors? Month Actual Sales Forecast Jan 2012 438 Feb 420 March 414 Apr 318 May 306 June 240 July 240 Aug 216 Sep 198 Oct 225 Nov 270 Dec 315 Jan 2013 - QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below. Month Demand (10s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…QUESTION 1The 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:- iii. Exponential Smoothing when α= .6 and the forecast for March is 350.QUESTION 1The 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