How would you conduct a trend analysis? Provide an example.
Q: a) Using exponential smoothing, with a = .6, then trend analysis, and finally linear regression,…
A: a)
Q: 1. a.) What is forecasting? b. Explain the importance of forecasting for managers like you? c.) What…
A: Forecasting is simply analyzing and evaluating the past or present data to determine or predict the…
Q: Following are two weekly forecasts made by two different methods for the number of gallons of…
A: Given - Week Forcast Actual Demand 1 0.95 0.72 2 1.08 1.00 3 0.95 1.07 4 1.22 0.97
Q: What are the different Forecasting Approaches? Explain each in detail
A: A Small Introduction about Forecasting Forecasting is done to figure out what kind of demand could…
Q: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…
A: Using excel for performing regression with Sales as the dependent variable and period as independent…
Q: How forecasting helps in different disciplines of management science? Make a comparison between…
A: Forecasting is a prediction method that can use historical data and current market trends and…
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: It is a common saying that the only thing certain about a forecast is that it will be wrong. What is…
A: Forecasting is the process of predicting future demand values based on historical data. The…
Q: nformation, What will be - forecast of June, using month weighted moving erage with the following…
A: Given Information:
Q: Forecasting is critical in modern times. It is believed that it started as a consequence of the…
A: BUSINESS FORECASTING is a gauge or expectation of future advancements in business like deals,…
Q: Assignment What if we use a 3-month simple moving average? Kroger sells (among other stuff) bottled…
A:
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: 20- Forecasting is very important in predicting the future sales of a company. Can you identify the…
A: Below is the solution;-
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: Explain the trade-off between responsiveness and stability in a forecasting system that uses…
A: Forecasting is the process of making assumptions of the future on the basis of past and present data…
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: 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: Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange…
A: Given data for stock B is
Q: 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or…
A: The process used to predict future data and analysis of the trend is known as forecasting. With the…
Q: Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast…
A: Find the given details below: Given Details: Period Year Call Volume forecast Error 1 1 30 45…
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: 2)Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual…
A: Auto sales over a 4-month period - Month Actual Forecast 1 92 89 2 96 98 3 101 105 4 100…
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: 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: Exponential Smoothing, Exponentially Smoothed MAD, and Tracking SignalThe XYZ Company was flooded by…
A: Formula:
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: 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: 6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing…
A: Error = Real demand - Forecast Absolute Error = Positive value of Error Error Square = square of…
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: 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: Discuss the techniques of forecasting and its types. Also explain the limitations of each technique?
A: Forecasting - The process which is related with making the predictions for the future and the basis…
Q: How much does the forecasting process at Deckers correspond with the “typical forecasting process”…
A: Forecasting is the tool which uses the historical data as the inputs to make the informed estimates…
Q: Forecasting is critical in modern times. Business organizations manifested more concern with…
A: It is at the national, industry, and firm levels that business forecasting takes place. Forecasts…
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: 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: Th e manager of a small health clinic would like to useexponential smoothing to forecast demand for…
A: In exponential smoothing; Here,
Q: Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for…
A:
Q: 20. Mercado Foundation, aims to help the pandemic front liners of education of Santa Cruz,…
A: Manufacturing is the process of converting the raw materials and resources into finished output for…
Chapter 14
1. How would you conduct a trend analysis? Provide an example.
2. Explain the three different source of information and
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.
Step by step
Solved in 6 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?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
- 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors associated with a particular forecast over the past 5 months, in chronological order: 5, 10, -15, 0, 8. In which month was the forecast perfectly accurate? In which month was the forecast the least accurate? In which month or months was the forecast too high? (Noteshaper Ramp Up # 23) 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 95 Jan 13 - 17 80 Jan 20 - 24 65 Jan 27 – 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha =…Weekly demand for an item averaged 100 units over the past year. Actual demand forthe next eight weeks is shown in what follows:a. Plot the data on graph paper.b. Letting a = 0.25, calculate the smoothed forecast for each week.c. Comment on how well the forecast is tracking actual demand. Is it lagging or leading actual demand?4 .Substitute for Problem # 4 on in attachment)-Calculate the MAD,revised MAD and the Revised Forecast for months 1-6 for the following three groups,where the Forecast stands for Forecast Demand.Has your forecast improved ? Tell me how would you go about improving the revised forecast( for each of the three groups)without actually doing so? Estate Planning Group Auditing and Accounting Group Business Consulting Group Month Actual Demand Forecast Actual Demand Forecast Actual Demand Forecast 1 100 125 270 230 140 135 2 90 125 240 230 130 135 3 110 125 280 230 160 135 4 115 125 260 230 180 135 5 130 125 300 230 200 135 6 115 125 220 230 190 135
- Which would result in a positive budget forecasting error? 1. Overlooking a source of investment income II. Not taking into account an expense paid once а year II. Switching to a less costly gym v. Underestimating annual car expenses V. Overestimating expected capital gainsInterpret the MAD of the most accurate among the forecasting models below. A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month.2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.