Note:-Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure. A tourist center is open on weekends (Friday, Saturday, and Sunday). The owner-manager hopes toimprove scheduling of part-time employees by determining seasonal relatives for each of thesedays. Data on recent traffic at the center have been tabulated and are shown in the following table:1138FridaySaturday 248Sunday158FridaySaturdaySunday2148248158FridaySaturdaySunday3148258168SA IndexWeek4148258168a. Develop seasonal relatives for the shop using the centered moving average method. (Round yourintermediate calculations and final answers to 2 decimal places.)51532731686158273178b. Develop seasonal relatives for the shop using the SA method. (Round your intermediatecalculations and final answers to 4 decimal places.)

Here, I will use two techniques, These are the centered moving average technique and the SA method,…

a. Develop seasonal relatives for the shop using the centered moving average method. (Round your intermediate calculations and final answers to 2 decimal places.) Friday Saturday Sunday b. Develop seasonal relatives for the shop using the SA method. (Round your intermediate calculations and final answers to 4 decimal places.) Friday Saturday Sunday SA Index

a. Develop seasonal relatives for the shop using the centered moving average method. (Round your intermediate calculations and final answers to 2 decimal places.) Friday Saturday Sunday b. Develop seasonal relatives for the shop using the SA method. (Round your intermediate calculations and final answers to 4 decimal places.) Friday Saturday Sunday SA Index

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 31P

See similar textbooks

Similar questions

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?
What are the advantages of exponential smoothing over the moving average and the weighted moving average?
Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 C000) Delayed 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 rate (1) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (5 marks) (ii) Develop the forecasting model that you suggest in (i). Briefly explain your model. (20 marks)
Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival (‘000) 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 Delayed rate 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 a） Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particularmodel? b) Develop the forecasting model that you suggest in (i). Briefly explain your
Problem 7 At Treasure Wine Estates in Napa, CA the Sales and Marketing Department have developed a linear trend equation that can be used to predict sales of its popular wine brands. Ft 90+ 12.5t Where F₁ = Annual sales (000 bottles) t = years A. Are annual sales increasing or decreasing? B. By how much? C. Predict annual sales for year 8 using the equation Note: round your answer
The Northville Post Office experiences a seasonal pattern of daily mail volume every week. The followingdata for two representative weeks are expressed in thousands of pieces of mail:Day Week 1 Week 2Sunday 5 8Monday 20 15Tuesday 30 32Wednesday 35 30Thursday 49 45Friday 70 70Saturday 15 10Total 224 210 a. Calculate a seasonal factor for each day of the week.b. If the postmaster estimates 230,000 pieces of mail to be sorted next week, forecast the volume foreach day of the week.
Freight car loadings over an 18-week period at a busy port are as follows:Weeks Loadings (lbs) Weeks Loadings (lbs) Weeks Loadings (lbs) 1 370 7 415 13 450 2 380 8 425 14 455 3 390 9 435 15 475 4 380 10 425 16 485 5 390 11 435 17 495 6 395 12 445 18 505a. Determine a linear trend line for expected freight car loadings.b. Use the above trend equation to predict expected loadings for Weeks 20 & 21.c. The manager intends to install new equipment when the volume exceeds 950 loadings per week. Assuming the current trend continues, in which week…
Using the exponential smoothing forecast, is it possible to forecast a demand that isbigger than any previously observed demand?a. Yesb. No
Give typed answer Question: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). 1. Forecast Period 6 (August) : ? 2. Forecast Period 7 (September) : ? 3. Forecast Period 8 (October) : ? 4. Forecast Period 9 (November) : ? 5. Forecast Period 10 (December) : ?
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price Number Sold $2.70 760 $3.50 510 $2.00 980 $4.20 250 $3.10 320 $4.05 480 a. Using these data, how many mocha latte coffees would be forecast to be sold according to simple linear regression if the price per cup were $2.80? [Select] What is the MAD? [Select] c. What is the Coefficient of Determination? [Select] [Select] 9 and what does that tell you?
Following data on the demand for sewing machines manufactured by Taylor and Son Co. have been compiled for the past 10 years. Year 1971 1972 1973 1974 1975 78 1976 1977 1978 1979 99 1980 106 Demand 58 65 73 76 87 88 93 in (1000 units) Please estimate the value of demand for next 3 years using trend analysis.