PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month period. Month Demand Forecast 1 492 488 2 470 484 3 485 480 4 493 490 5 498 497 6 492 493 Required: Compute for the MAD, MSE, and MAPE.
Q: A forecast of 240 units in January, 320 units in February, and 240 units in March has been approved…
A: January Forecast = 240 February Forecast = 320 Product C Forecast = 240*0.25 = 60 in January 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: . Nowjuice, Inc., produces Shakewell® fruit juice. A planner has developed an aggregate forecast for…
A:
Q: Explain how flexibility in productions system relates to the forecast horizon and forecast accuracy?
A: Investigate how flexibility can be used in a manufacturing system to understand the concept of a…
Q: Sanders Bears produces stuffed animals. Sanders is in the process of implementing a cost…
A:
Q: b. Discuss how forecasting accuracy relates to the practical application of aggregate planning.
A: Aggregate planning is the process that involves the development, analysis and other operational…
Q: Prepare a Master Production Schedule (MPS) for an Agri-Chemical company given the following…
A: First calculate the projected-on hand inventory for each period using the following formula.…
Q: Chambers Hotel use the simple exponential smoothing technique to forecast its occupancy for every…
A: Given- Actual demand for last Saturday At = 42 rooms Forecast for last Saturday Ft = 50 rooms…
Q: The Bango Toy Company produces several types of toys to seasonal demand. The forecast for the next…
A: : Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
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: 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: Given the following forecast and cost information, determine Production Costs the total cost of a…
A: Total cost = regular cost+overtime cost+subcontracting cost Given regular cost 50 overtime…
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: The demand data for Double T Computer Services appears below. The company wants you to forecast the…
A: THE ANSWER IS AS BELOW:
Q: Product A is an assemble-to-order product. It has a lot size of 150, and currentlyhas an on-hand…
A:
Q: The forecasted requirements for an electric hand drill for the next 6 weeks are 15, 40, 10, 20, 50,…
A: Find the Calculation methods below: Requirement = (Maximum value of Demand and Customer order)Net…
Q: Forecast demand again with a weighted moving average in which sales in the most recent year are…
A: ANSWER IS AS BELOW:
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: Task 2: A small Tennessee company makes fused magnesia and silica. To prepare input for the planning…
A: Given data is Production quantity = 40000 pounds Safety stock = 30000 pounds
Q: 1- Dwayne Cole, owner of a Florida firm that manufactures display cabinets, develops an 8- month…
A: a) Formulate a spreadsheet as shown below to find the optimal cost, plan cost = $2608300
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: a) Graph the seasonal data and attach the graph to this page. b) Determine the slope for each day of…
A: The regression equation is of the form y=mx+b where, y is the value of a dependent variable, m is…
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: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Forecasting is the process of estimating the future demand using previous or historic data or…
Q: After reviewing the forecasting demonstration and looking over the slides, complete the following…
A: Production capacity is the greatest yield that can be accomplished in the production of fabricated…
Q: he hotel has experi nced the following occupancy rates for ne past the coliseum opened. Compute an…
A: Forecasting refers to making predictions or estimations regarding future outcomes. Forecasting is…
Q: Al Maha Plastic manufacturing Companies last Six weekly values of Sales were 90, 110, 115, 135, 140,…
A: ERROR= ACTUAL SALES -FORECAST MAD = ABSOLUTE CUMULATIVE ERROR/ WEEK NUMBER TRACKING SIGNAL=…
Q: Problem #1: Extension of the solved problem in the class The washing machine plant is interested in…
A: Given data is Starting inventory = 200 units Production in 40 days = 520 units Workers in 40 days =…
Q: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Error represents the deviations in the forecasted values in comparison to actual value. %error=…
Q: Assume that the actual sales volume were 1,800; 2,000; 1,700; 1,600; 1,900; and 2,100 for Days 1 to…
A:
Q: Estimate the number of sales personnel needed for an XYZ company having a forecast for FY 21 as…
A: Salesforce forecasting based on the expected demand and the annual sales turnover helps to identify…
Q: Spring and Summer Fashions, a clothing producer, has generated a forecast for the next eight…
A: The steady production of 1,200 units is maintained. As the production rate per worker is not given,…
Q: An aggregate plan is to be developed for the forecast of demand covering nine periods shown in Table…
A: Aggregate planning is a process for creating a long-term manufacturing strategy that assures a…
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: hundred bolts. Workers can be assigned to other jobs if production is less than regular. The…
A: given,
Q: Seatwork Compute for MAD, MSE and MAPE using Moving Average Model (past 3 Weeks), В. А. Exponential…
A: Forecasting is the process of estimating the future demand or sales using the previous years or…
Q: Understand the importance of operation management in organization. Define errors in forecast to make…
A: Project management is a list of a project activities and deliverables, usually with a start and…
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: 1. Develop an aggregate plan for the following forecast 3 4 5 6 7 8 9 Total Period 1 2 Forecast 190…
A: Total worker = 20 Production = 10 unit per period Cost= P6.00 per unit. Inventory Carrying cost =…
Q: a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in…
A: Below is the solution:-
Q: After reviewing the forecasting demonstration and looking over the slides, complete the following…
A: Demand Forecasting is the cycle wherein verifiable deals information is utilized to foster a gauge…
Q: March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400…
A: Given: March demand forecasted (Ft-1) = 590 Units March actual demand (At-1) = 400 Units Alpha =…
Q: • Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an…
A: Forecasting is the activity of making estimated valuations of future activities based on past and…
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: 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: Forecast for the 11 quarter using exponential smoothing technique.
A:
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…
A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20
Q: Using the double exponential smoothing forecast, is it possible to forecast a demand thatis bigger…
A: Forecasting is a prediction method that can use historical data and current market trends and…
PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month period.
Month Demand
1 492 488
2 470 484
3 485 480
4 493 490
5 498 497
6 492 493
Required: Compute for the MAD, MSE, and MAPE.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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?Under what conditions might a firm use multiple forecasting methods?Period Demand 1 2 3 4 5 64 ៩៩៨៖ 62 65 61 66 a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the next most recent, 0.2 for the next, and 0.1 for the next. (Round all your answers to two decimal points.) Forecast Period 5 Forecast Period 6 b. If the actual demand for period 6 is 65, forecast demand for period 7 using the same weights as in part a. Forecast Period 7
- The following table shows the actual demand observed over the last 11 years: Year 1 Demand 8 2 9 3 5 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year Forecast 4 5 4 10 6 5 13 7 6 7 8 7 11 9 8 14 10 9 8 11 10 13 12 11 8Given the following data, use exponential smoothing (a=0.20) to develop a demand forecast. Assume the forecast for the initial period is 6. Period Demand Period Forecast 2 2 1 3 7 9 8 The exponential smoothing forecast is (round your responses to two decimal places): 1 5 6 6.00 2 3 4 8 4 5 13 6 s D 6 7The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 700 3 810 4 800 5 900 6. 700 7 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? iii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method.
- The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 31 34 33 35 37 Month 1 3 4 5 a. Calculate the single exponential smoothing forecast for these data using an a of 30 and an initial forecast (F3 of 31 (Round your answers to 2 decimal places.) Answer is complete and correct. 1 7 B D 10 6 Month 1 2 10 3 4 5 6 7 8 9 10 Exponential Smoothing 31.000 31.000 31.00 - 32.210 b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a 6 of 0.30, an initial trend forecast (7 of 1, and an initial exponentially smoothed forecast (F) of 30. (Round your answers to 2 decimal places.) 33.00 34.24 ⒸAnswer is complete but not entirely correct. FIT 30.00 Ⓒ 32.61 Ⓒ 34.000 34.00 35.75 34.77 Ⓒ 35.74 Ⓒ 37.02 37.910 36 38 40 40 41 37 20 37.810 38.00 40.29 41.276 c-2. Which is best? et Calculate the mean absolute deviation (MAD) for the test nine months of forecasts, Round your answers to 2 decimal places) Answer is complete but not entirely…Zeus Computer Chips Inc. used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters:2007 2008 2009I 4,800 I 3,500 I 3,200II 3,500 II 2,700 II 2,100III 4,300 III 3,500 III 2,700IV 3,000 IV 2,400 IV 1,700Use the decomposition technique to forecast the four quarters of 2010.The following table shows the actual demand observed over the last 4 years: Year Demand 1 8 Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers) Year Forecast (NA) 2 8 2 Using exponential smoothing with a=0.50 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place). 1 Year Forecast (ES) 7.0 2 3 3 6 3 4 4 10 4 5 5