what is Canadian Tire's vertical and horizontal analysis of their income statement for last 5 years ? Please provide numbers
Q: a) Using exponential smoothing, with a = .6, then trend analysis, and finally linear regression,…
A: a)
Q: If your forecast for 2022 is 40, using the seasonal index below, what is your forecast for 2nd…
A: Seasonal forecast = Forecast for a period * Seasonal index of that period Given, Total forecast = 40…
Q: Find the monthly forecast and seasonal indices for year 2021, given the following data:
A: Seasonal factors will be determined for each month of each year in this problem, and the average of…
Q: What capabilities would an organisation require to be able to operate without forecasting?
A: A business would require several competencies to avoid relying on projections entirely. Simple…
Q: How is trend analysis conducted?
A: A technique that is used to determine the future on the basis of past trends is termed trend…
Q: Forecasting Food and Beverage Sales The Vintage Restaurant, on Captiva Island, near Fort Myers,…
A: Given Data, Month 1st year 2nd Year 3rd year January 242 263 282 February 235 238 255…
Q: Given the following demand data, Period Demand 57 1 2 55 3 59 4 56 5 60 a. Compute a weighted…
A: Forecasting is the process of estimation in which future demand is determined using the previous and…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: Sum of the Last Quarter = 200+260+260 = 720 Sum of Second last quarter = 165+200+175 = 540 Sum of…
Q: Identify and post the secanrio and rationale of the cultural scenario that is seen as the most…
A: The given case is based on the cultural scenario Cultural scenario - there are a variety of…
Q: How has the Internet's growth impacted how businesses predict in favour of their supply chain…
A: In today's society, organisations cannot function without the Internet. The internet is used to do a…
Q: This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of…
A: Note: I have answered for 4-1 only. Kindly post the other question separately. Hence, the sales in…
Q: In each of the following, name the term defined or answer the question. Answers are listed at the…
A: I have answered for question 1 to 3. Kindly post the remaining questions separately. 1) The demand…
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below 1 2 3 4 7 8 year Actual 10 11 13…
A: Note: Since you have posted multiple parts in the same questions, we will be answering the first…
Q: Explain how forecasting is essential to supply chain planning?
A: Firms need to maintain an adequate level of inventory. Purchasing in sufficient quantities at the…
Q: Why is forecasting better tool than benchmarking?
A: Forecasting is the process of predicting what will occur in the future based on past events and…
Q: Find four years weighted moving average? Forecast for 2019 with weights 1,4,2, ….. , Also find…
A: Given data is
Q: When a new busines is startered, or a patent idea needs fundig, venture capitalst or investment…
A: Whenever a new business is initiated, funding forms the pre-requisite and approaching to the venture…
Q: Q6- Answer "true" or “false" to the following statements: 1. The term compound interest refers to…
A: "Since you have posted questions with multiple sub-parts, we will solve the first three sub-parts…
Q: What forecasting approaches do you know? How is this being applied in your work? Or from your past…
A: Forecasting is an important tool that helps managers in effective and efficient planning. However,…
Q: Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures: Forecast 100…
A: Let At signify actual cost for tth observation, Ft signify predicted cost for tth observation &…
Q: What should be our forecast accuracy target if there is a high degree of volatility in customer…
A: Forecasting is the process of estimating the future demand according to the historic or previous…
Q: What are some of the consequences of poor forecasts? Explain.
A: The Consequences of the poor forecast are:
Q: what is the formula for forecasting revenue in excel?
A: Forecasting is the process of predicting future data based on previous or past data and information.…
Q: Period 1 2 3 4 5 6 1. Compute the four period moving average forecast for period 6 and 7. Assume the…
A:
Q: Distinguish between Planning and Forecasting. Answer must briefly.
A: Future demand is the forecasted demand for the products and services expected from the customers.
Q: The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past…
A: a) It is clear from the results that Exponential smoothing forecast model provides the Lowest mean…
Q: When a new business is started, or a patent idea needs funding, venture capitalists or investment…
A: With the inception of any new enterprise or business, there exists a requirement for the funding and…
Q: A resort cum restaurant spot in the area of Gazipur is open on the days of the week. The manager…
A: Given,
Q: Give examples of industries in which demand forecastingis dependent on the demand for other…
A: Demanding forecasting estimates future demand based on historical data, trends, seasonality, and…
Q: Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures:…
A: The concept used here is forecasting evaluation using Mean absolute deviation and Mean square error…
Q: What effect has improved forecasting had on inventory and capital requirements?
A: Forecasting is a strategy in which a company makes preparations based on previous and historical…
Q: Exotic Wines, Inc. wants to use exponential smoothing with α = 0.35 to forecast demand in bottles…
A: The detailed solution of the question is given in Step 2.
Q: Can you either overestimate or underestimate the actual sales number for a poor forecast?
A: A forecast is a foresight of whatever will occur. While usually practiced in the circumstances of…
Q: In the absence of a trend, how would sales be forecast by moving-average method?
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: The least squares regression method question - rounds your answer to two decimal points.please find…
A: Using least squares method regression method means we need to fit a line where number of accidents…
Q: a) What is the value of your forecast?
A: The weighted moving averages (WMA) are accomplished by multiplying every quantity in the data set…
Q: 4. A major bank is considering installing ATMs at all locations of a grocery store chain. What…
A: Inventory management is a tool used to sourcing and distributing both raw materials and finished…
Q: Prepare a Demand Forecast for “Year 5” using Excel.
A: The provided quarterly data for year 5 can be predicted in excel as follows: 1- In a worksheet, the…
Q: a. Using linear regression analysis, what would you estimate demand to be for each month next year?…
A: THE ANSWER IS AS BELOW:
Q: What are the major consequences of accurate forecasting? explain
A: Forecasting is defined as a process of developing predictions based on the past and…
Q: What is the concept of seasonality? How do we forecast based on seasonal data?
A: Seasonality of time series data refers to the phenomenon of recurrent up and down periods in series…
Q: What kind of forecasting methodology can I use for various items?
A: Forecasting is a technique for estimating future demand based on current and historical evidence.…
Q: implement to improve their fo
A: When it comes to Tesla's financial expectations, CEO Elon Musk has a history of overpromising and…
Q: in your own opinion,why benchmarking is a better planning tool?
A: Note: We are answering question no.1 as the question that needs to be answered is not mentioned.…
Q: Let's say you are playing the stock market and below period 2020 data was provided. For "stock A"…
A: The answer is as below
Q: KTOC/ Kuwait-Tunis Oil Co. started 4 months ago. KTOC noticed that its production increased…
A: Month Production Weights 1 5 0.2 2 7 0.3 3 20 0.1 4 90 0.4 Forecast production for the…
1
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?IN THE MID-1960S, WALT DISNEY’S DREAM was to build a family resort destination like no other. Thedream became a reality when Walt Disney World Resort opened in 1971, featuring Magic Kingdom asthe centerpiece. Today, millions of guests visit the Walt Disney World Resort each year to experience theworld-class theme parks and hotels. Analytics feature prominently in the operations of Walt DisneyWorld.Explain using illustrations how forecasting features in this company’s operations. (Please provide images)IN THE MID-1960S, WALT DISNEY’S DREAM was to build a family resort destination like no other. Thedream became a reality when Walt Disney World Resort opened in 1971, featuring Magic Kingdom asthe centerpiece. Today, millions of guests visit the Walt Disney World Resort each year to experience theworld-class theme parks and hotels. Analytics feature prominently in the operations of Walt DisneyWorld. 1. Explain using illustrations how forecasting features in this company’s operations.2. Explain at least four methods of forecasting that can be used for Disney’s purpose.
- Chapter 14 1. How would you conduct a trend analysis? Provide an example. 2. Explain the three different source of information and forecast assumptions. Chapter 15 3. Explain the four common uses of comparisons that the manager will find helpful. Chapter 16 4. Explain the importance of assumptions when building a budget? Chapter 17 5. Explain the rationale for replacing existing equipment with new equipment.Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.)This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a)What sales would you predict for 2019, using simple four-year moving avaerage? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year and 0.3, 0.15, and 0.05 for the three years before that? (I am able to calculate and know the answer for (a) $65,000 and (b) $73,000. What I don't understand is the following : 4-2 Using exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and $50,000 for 2017 and 2018, what would you forecast for 2019 ? (The first forecast is equal to the value of the preceding year.) (b) Given this forecast and actual 2019 sales of $53,000, what would you then forecast for 2020? 4-3 In Problem 4-1, taking…
- Q3) You work for BMW as a planner. BMW sold 1,081,000 of its BMW-X5 cars in 2019 and sold 1,189,100 of its BMW-X5 cars in 2020. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10% compared to year 2020 (total sales volume = 1,308,010). Find the monthly forecast and seasonal indices for year 2021, given the following data: (Please considers the monthly seasonal effect) MONTH Actual Car Sales (2019) Actual Car Sales (2020) Forecasted Car Sales (2021) Jan 80,000 88,000 Feb 85,000 93,500 Mar 86,000 94,600 Apr 90,000 99,000 May 92,000 101,200 June 100,000 110,000 July 120,000 132,000 Aug 90,000 99,000 Sept 86,000 94,600 Oct 85,000 93,500 Nov 84,000 92,400 Dec 83,000 91,300Using the photo attached, answer the following questions. 1. using the manual trend projection method of forecasting, show how Mr John can forecast demand for tyres for the next two years. SHOW ALL WORKING NO EXCEL SHEETS NO HAND WRITTEN ANSWERS, TYPE IT!Explain what forecasting techniques makes use of written surveys or telephone interviews ?