The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 40 3 40 O 44.6 O 40 O 46.0 O 43.3 O 42.0
Q: snip
A: Answer: It is important to measure the accuracy of forecasts, for any forecasting technique and…
Q: The options Outlook has for handling the seasonality of magazine are adding workers during the peak…
A: The problem statement right here is to make sure right making plans of manufacturing to meet…
Q: The average demand for January has been 100 and the average annual demand has been 1000. Calculate…
A: Given - Demand for January = 100 units Average annual demand = 1000 units
Q: Please show work
A:
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: Tracy is the the Director of Supply Chain at Circuits Inc. An accurate forecast at Circuits Inc. is…
A: Error = Actual demand - Forecast Absolute Error = Positive Value of Error MAD = Average of Absolute…
Q: Spring and Summer Fashions, a clothing producer, has generated a forecast for the next eight weeks.…
A: Steady production of 1,200 units is maintained. As the production rate per worker isn't given,…
Q: The historical data for 4 periods demand are 65, 60, 80, and 70 respectively. Calculate the weighted…
A: The answers would be as follows:
Q: (a) Compute a weighted average forecast for the data listed below using a weight of 0.40 for the…
A:
Q: A store’s demand figures are given in the table. According to this, what is the linear regression…
A: Forecasting is the process of determining the estimated forecast demand using previous or historic…
Q: he 2-month SMA forecast for Month 6 would be: * 565 haircuts 574 haircuts 578 haircuts 584…
A: THE ANSWER IS AS BELOW:
Q: forecast for weeks 7-24 using 6 week weighted moving average
A: Weighted moving average is a forecasting model which helps to identify the forecasting using the…
Q: The following table shows the actual demand observed over the last 11 years: year 1 2…
A: We can calculate a three-year forecast by using the formula- Three-year moving average method ( Year…
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 6. 7 8 10…
A:
Q: a) The 2-month Simple Moving Average (SMA) forecast for Month 6 would be: A. 565 haircuts B.…
A: In simple moving average, we take forecasted values from the previous two, three or four months as…
Q: Given the following forecast and cost information, Regular time cost $ 40.00 per unit determine the…
A: Given data is Month Forecast 1 570 2 600 3 630 4 650 5 670 6 690 Regular…
Q: Although a demand forecast is usually not accurate, managers must forecast demand. In this context…
A: The answer is as below:
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: Which of the following is a pitfall of using a customer’s forecasts? Customers forecast process not…
A: Customer forecast refers to the most ongoing rolling volume predictions or forecasts for the…
Q: A company wants to produce a weighted moving average forecast for April with the weights 0.40, 0.35,…
A: Forecasting is a method of predicting future trends, based on historical data.
Q: Demand for haircut at PogiPoints Barber Shop has increased steadily for the past few months as seen…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: With alpha = 0.8, the Exponential Smoothing (ES) forecast for Month 6 would be: A. 565 haircuts…
A: With alpha = 0.8, the Exponential Smoothing (ES) forecast for Month 6 would be:
Q: Short term forecast can be used for the following operation.
A: Short term forecastUp to 1 year, usually less than 3 monthsPurchasing, job planning, staff levels,…
Q: Using the exponential smoothing forecast, is it possible to forecast a demand that isbigger than any…
A: Exponential Smoothing:- Like the past 2 techniques, guileless and moving midpoints, the dramatic…
Q: Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown…
A: MAD and MAPE for the 4-year moving average, 4-year weighted moving average, and exponential…
Q: Greenfield Equipment is performing demand forecasting. Actual demand for Week 1 – 550, Week 2 – 490,…
A: THEN WE ARE GIVEN WITH ACTUAL DEMAND OF 5 WEEKS AND A FORECAST OF WEEK 5. DELTA IS ALSO GIVEN AS…
Q: Compute the weighted average forecast using the following weights: 0.20, 0.30, 0.10, and 0.40
A:
Q: Create a minimum cost chase plan for the forecast shown in the table. There is no beginning…
A: Given, Regular production capacity - 350 units and costs - $8 per unit. Overtime is limited to - 50…
Q: Zebra Technologies Corporation (ZTC) manufactures a number of navigation packages for pleasure…
A: Find the Given details below: Month Jan Feb Mar Apr May Jun Total Demand 700 600 400 650 850…
Q: The following table shows the actual demand observed over the last 11 years:…
A:
Q: they need a good forecast so that they will know how many fabrics to purchase and stock. For the…
A: The controlling input of the exponential smoothing calculation is defined as the smoothing factor…
Q: DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: If we use a simple exponential smoothing method with ??=0.3, ??11=100 and ??12=120, what is your…
A: Inventory management is the management in which raw materials and finished products are stored and…
Q: Period Demand 1 40 2 40 3…
A: Assessing strategy in which the last time frame's actuals are utilized as this present period's…
Q: Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average…
A: Find the given details below: Given details: Week Demand 1 300 2 360 3 410 4 289 5…
Q: Consider the following yearly demand values for a particular product. Year Demand 1 360 2 389 410 4…
A: The technical analysis methods used to smooth the data price by creating a regular updated average…
Q: How has the development of the Internet affected the way companies forecast in support of their…
A: Before the advent of the internet, all the forecasts related to supply chain planning were done…
Q: Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14 15 11 18 13 Using the…
A: Given information, Week Value 1 18 2 14 3 15 4 11 5 18 6 13 Total week = 6
Q: The following table is given. What is the demand forecast for period 13 if the Winter model is used?…
A: Given data: Demand forecast for 8th period = 7056 Trend forecast for 8th period = 227 Observing the…
Q: The department manager is using a combination of methods to forecast sales of toasters at a local…
A: Weighted moving average means we have different weights and we calculate on previous months data as…
Q: How does this forecast differ from that using employment as the independent variable? What is the…
A: Forecasting is a method of making well-informed forecasts regarding the direction of future trends…
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: The manager of XYZ carpet cleaning company needs a weekly forecast of the number of customers…
A: Find the Given details below: Given Details: Demand Year 1 Year 2 Year 3 Week 1 102 114…
Q: The options Outlook has for handling the seasonality of magazine are adding workers during the peak…
A: The problem declaration here is to confirm proper preparation of production in directive to meet…
Q: Discuss how flexibility in production systems relates to the forecast horizon and forecast accuracy?
A: To understand the concept of a flexible production system, investigate how flexibility can be used…
Q: Khyber Teaching Hospital is considering the purchase of a new ambulance. The decision will rest…
A: Given data is Alpha = 0.5 Forecast for year 1 = 4000 miles
Q: The following table shows the actual demand observed over the last 11 years:…
A: Given Information:
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: Given the following demand data, compute a simple exponential smoothing forecast for alpha values of…
A: Given data is
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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?Under what conditions might a firm use multiple forecasting methods?
- 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 demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 2 40 3 40The table below comprises of demand from the last 10 months: Month Demand 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 Calculate the exponential smoothing with trend forecast for the second month using a alpha and delta of 0.3 each. Take the initial exponentially smoothed forecast (F1) of 30 and initial trend forecast (T1) of 1. Note: I have tried solving this question and I got 31, but unfortunately it was the wrong answer.