West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout the region. BATS R’ US, a cricket bat-making company located in Charlestown, Nevis has been at the forefront of this increasing sales for cricket bats. The monthly demand in sales at BATS R’ US is provided in the table below. 1. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. 2. Compute the MAD for both forecasting methods. 3. Which model is more accurate? 4. Forecast week 8 with the more accurate method. Month Sale of bats 1 119 2 147 3 189 4 217 5 133 6 119 7 147

West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout the region. BATS R’ US, a cricket bat-making company located in Charlestown, Nevis has been at the forefront of this increasing sales for cricket bats. The monthly demand in sales at BATS R’ US is provided in the table below. 1. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. 2. Compute the MAD for both forecasting methods. 3. Which model is more accurate? 4. Forecast week 8 with the more accurate method. Month Sale of bats 1 119 2 147 3 189 4 217 5 133 6 119 7 147

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
What is the fundamental distinction between a weighted average travelling and exponential smoothing?
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 410 7 460 13 540 2 420 8 480 14 550 3 430 9 500 15 570 4 420 10 490 16 580 5 430 11 510 17 590 6 440 12 530 18 600 Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) c. The manager intends to install new equipment when the volume exceeds 990 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)
• Use this information for the question below. Low-Grade Copper Ore $571 per Ton High-Grade Copper Ore $843 per Ton Coloma Cooper Incorporated is able to produce $640 worth of copper from one ton of low-grade copper ore. Because of its higher copper content, Coloma can produce $940 worth of copper from one ton of high-grade copper ore. A mining company is offering to trade 7,250 tons of low-grade copper ore for 5,000 tons of high-grade copper ore. Assuming Coloma currently has 5,000 tons of high-grade ore, what should it do?
Mark Hopper owns Dane Champions, a dog kennel that raises champion Great Danes for showing and breeding. His vision is to be the best-known breeder of Great Danes globally. His strategy is to breed and sell dogs from outstanding lineage from the standpoint of both physical health and good-natured temperaments. Following is information about operations over the last year. Number of breedings Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦.. 10 Number of puppies Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦Ac€¦.. 45 Number of puppies sold…
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this mill. All mileage references use Browns Town as (0,0). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
Eight Glasses A Day: The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgianna is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown, Month May June July Aug Sep Oct Total Forecast 50 60 70 90 80 70 420 Production manager Mark Mercer, has developed the following information. (Note: Costs are in thousands of dollars). Regular production cost: $1 per tankload Regular production capacity: 60 tankloads Overtime production cost: $1.6 per tankload Subcontracting cost: $1.8 per tankload Holding cost: $2 per tankload per month Back ordering cost: $5 per month per tankload Beginning inventory: 0 units Among the strategies being considered are: 1. Level production supplemented by up to 10 tank loads a month from overtime 2. A…
"Place" is one of the 7 P's in the implementation and control for Air Asia. Please explain in details.
As public awareness of the need to recycle, reuse and repair has grown, TerraCycle has found that it has needed to create more recycling centres around the country to meet the new demand. 1. Identify two points of time throughout a one-year period where the capacity of the TerraCycle Recycling Centres will exceed their normal operations capacity and explain why there is an increase in demand during these periods. 2. Discuss at least three different approaches to managing capacity about TerraCycle and the challenges which each approach may face. 3. Recommend one action based on your analysis of TerraCycle to improve capacity management and explain how this could be implemented and monitored in the long run.
Explain the weighted moving average method?
A marketing manager of a pizza parlor propose a campaign to promote online sales in a town during the time of lockdown. It is proposed that customers be compensated with RM7 e-Voucher if delivery time is greater than 20 minutes for addresses located within four kilometers radius from the parlor with minimum order of RM40. The manager collected delivery time of 30 orders out of the total of 180 orders in the month of January of 2021 and found that the delivery time has mean of 15 minutes. In the past, the standard deviation of delivery time for the delivery staff has been found 3 minutes. Estimate at expected cost of late delivery per month.
Problem 20-7 (Algo) Wholemark is an Internet order business that sells one popular New Year greeting card once a year. The cost of the paper on which the card is printed is $0.29 per card, and the cost of printing is $0.10 per card. The company receives $3.75 per card sold. Since the cards have the current year printed on them, unsold cards have no salvage value. Their customers are from the four areas: Los Angeles, Santa Monica, Hollywood, and Pasadena. Based on past data, the number of customers from each of the four regions is normally distributed with mean 2,300 and standard deviation 200. (Assume these four are independent.) What is the optimal production quantity for the card? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round Normsinv value to 4 decimal places. Roundup your answer to the nearest whole number.) Optimal production quantity