Exotic Wines, Inc. wants to use exponential smoothing with α = 0.35 to forecast demand in bottles sold. The demand the last four months are 3,221, 3,197, 3,645, and 3,912 bottles. The forecast for bottles was 3,221 bottles for the second month. What is the forecast for the fifth month? Round your answer to the nearest whole number. bottles:
Q: Assuming that after analyzing two years, 8 time periods of quarterly demand data with four seasons…
A: Given data: seasonal factors are: S1: 1.03, S2: 0.92, S3: 0.88, and S4: 1.32 Estimated level L8 =…
Q: Using exponential smoothing method, forecast the demand for the fourth period. The historical demand…
A: Exponential smoothening is a time series forecasting method that uses the previous data to forecast…
Q: A retail store records customer demand during each sales period. The data has been collected in the…
A: This question is related to the Topic -Forecasting approach and this topic falls under the…
Q: Rosa’s Italian restaurant wants to develop forecasts of daily demand for the next week. Th e…
A: Solution - Given that Day Week 1 Week 2 No of Customers No of Customers Tuesday 52 48…
Q: The Oceanside Hotel is adjacent to City Coliseum, a 24,000-seat arena that is home to the city’s…
A: Given data is
Q: (a) Compute a weighted average forecast for the data listed below using a weight of 0.40 for the…
A:
Q: No single forecast methodology is appropriate under all conditions True or false?
A: Answer: What is Forecasting: Forecasting is an attempt to predict future events which will be used…
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 current demand in this period of 103, a forecast for this current period of 99, and an alpha…
A: Exponential smoothing is a forecasting model which helps to identify the forecasting value based on…
Q: The demand data for Double T Computer Services appears below. The company wants you to forecast the…
A: THE ANSWER IS AS BELOW:
Q: The number of internal disk drives (in million) made at a plant in Taiwan during the past 5 years…
A: a. Forecast using simple linear regression: Year (X) Disks (Y) X×Y X2 1 142 142 1 2 156 312…
Q: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 21 27 37 26 29 36 20 25 28 The forecast for weeks 2 through 10…
A: Forecasting is the procedure of doing estimations of upcoming activities on the basis of past and…
Q: Zeus Computer Chips Inc. used to have major contracts to produce the Centrino-type chips. The market…
A:
Q: Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing…
A:
Q: When a business is started, or a patent idea needs funding, venture capitalists or investment…
A: A profitability forecast is a set of figures included in a business plan. The result of forecasting…
Q: Calculate the forecast for the 4th quarter of 2016 using the Weighted average method w1-0.7, w2=0.3.…
A: Weighted average forecast uses different weights which are assigned to past data to predict the data…
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 4 7 8 10 11…
A: Given - Table for demand seen in past years- Year Actual Demand 1 6 2 9 3 4 4 9 5 13…
Q: Explain the forecasting term with the help of least squares ?
A: Least Squares Method The least squares technique is a type of mathematical regression analysis that…
Q: Using exponential smoothing method, forecast the demand for the fourth period. The historical demand…
A: ANSWER IS AS BELOW:
Q: John's House of Pancakes uses a weighted moving average method to forecast pancake sales. It…
A: Weighted moving average:In weighted moving average equal weights are assigned to all periods in the…
Q: Find four years weighted moving average? Forecast for 2019 with weights 1,4,2, ….. , Also find…
A: Given data is
Q: Given the following demand data, Period Demand 1 44 2 42 3 44 4 42 5 47 a. Compute a weighted…
A: Given data is
Q: 3. You are using a 3 period moving average to calculate your forecast. Demand for period 1 was 90…
A: Given information:Demand period 1=90unitsDemand period 2=80unitsDemand period4=90unitsHere we have…
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: 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: 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: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: Given table- Year Sales 1 450 2 502 3 520 4 570 5 575
Q: orecast demand for each week, including week 10, using exponential smoothing with a 5 .5 (initial…
A: Exponential smoothing is forecasting method which identifying the farecasting value based on the…
Q: The following table shows the actual demand observed over the last 11 years:…
A:
Q: Assume that you want to open a facility to produce wheelbarrows. Please analyze the market and…
A: A market analysis is the crucial and thorough qualitative and quantitative assessment of the…
Q: Maria sells banana que every afternoon. She sells her product everyday except during Sundays. The…
A:
Q: Using exponential smoothing method, forecast the demand for the fourth period. The historical demand…
A: Alpha=0.9 At Ft Period Demand Forecast 1 41 41 2 42 0.9(41)+0.1(41)=41 3…
Q: A retail store records customer demand during each sales period. The data has been collected in the…
A: given,
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: The techniques used to forecast the value for smoothing the time series data with the help of the…
Q: West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(1, 2,…
Q: hundred bolts. Workers can be assigned to other jobs if production is less than regular. The…
A: given,
Q: a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the…
A: A weighted moving average forecast is a forecast of future values based on past values. A weighted…
Q: Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α…
A: Given: Year Sales volume 2012 40 2013 48 2014 44 2015 46 2016 57 2017 41 2018 52…
Q: Given the actual demand of 300, the previous forecast of 300, and an alpha of 0.048 , which one of…
A: The actual demand =300 The previous forecast = 300 Alpha = 0.048
Q: Sales for a product for the past three months have been 203, 365, and 293. Use a three-month moving…
A:
Q: Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Use a…
A: Given data; Three months actual demands are 200,350,287. Fourth month actual demand = 300
Q: Using exponential smoothing method, forecast the demand for the fourth period. The historical demand…
A: Exponential Smoothing: The exponential smoothing process is continuing to practice past data of the…
Q: 5. Demand for patient surgery at Washington General Hospital has increased steadily in the past few…
A: Forecasting is the process of estimating the future demand and sales based on the previous month or…
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…
Q: Not all the items in your office supply store are evenly distributed as far as demand is concerned,…
A: Given- Week Demand Week 1 250 Week 2 350 Week 3 550 Week 4 650
Q: The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years…
A: Regression is a statistical technique used in finance, investing, and other fields to identify the…
Q: Local city government statistics show the rate of new driver’s license applications to be as…
A:
Exotic Wines, Inc. wants to use exponential smoothing with α = 0.35 to
bottles:
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
- Under what conditions might a firm use multiple forecasting methods?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?
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?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?The following table contains the demand from the last 10 months. Calculate the exponential smoothing with trend forecast for these data, using an a of 0.30, a 8 of 0.30, an initial trend forecast (T1) of 1, and an initial exponentially smoothed forecast (F1) of 30. Round your intermediate calculations and answers to two decimal places. MONTH ACTUAL DEMAND Ft Tt 1 2 3 4 5 6 7 8 00 9 10 31 34 33 35 37 36 38 40 40 41 FITTSuppose a four period weighted average is being used to forecast demand. Weights for the periods are: Wt-4 = 0.1 Wt-3 = 0.2 Wt-2 = 0.3 Wt-1 0.4 Demand observed in the previous four periods was: At-4 = 325 At-3 = 361 At-2 = 478 At-1 = 400 What will be the demand forecast for period t? (Keep one decimal place in your answer).
- XYZ Chips Inc. (XCI) produces Centrino-type chips. The market has been inclining with ups and downs during the last eight years because of its new chips. The demands over the last 12 periods were 95, 115, 130, 122, 105, 125, 140, 134, 125, 142, 160, and 153 thousand pieces. Forecast the demand for the next 4 periods (periods 13 to 16) using an appropriate forecasting technique.Given the following data, use exponential smoothing (α = 0.10) to develop a demand forecast. Assume the forecast for the initial period is 9. Period Demand 1 2 10 13 1 9.00 3 7 The exponential smoothing forecast is (round your responses to two decimal places): Period 2 Forecast 9.10 3 9.40 4 6 4 8.80 5 8.70 5 10 6 9.10 6 4 7 8.50KTOC/ Kuwait-Tunis Oil Co. started 4 months ago. KTOC noticed that its production increased significantly. Production reported was: 5, 7, 20, 90 Liters respectively over the past 4 months. KOTC estimated weights for past 4 months were: 0.2, 0.3, 0.1, 0.4. KOTC is seeking your help to forecast its production for the following cycle. What is MAD and is it false or true value (statement)?