The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from above, calculate the forecast for period 7 using a four-period moving average:

The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from above, calculate the forecast for period 7 using a four-period moving average:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
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?
Mike Thatcher is a sales manager for an automobile dealership in Alberta. Mike earns a bonus each year based on revenue generated by the number of vehicles sold in the year less related warranty expenses. The quality of automobiles sold each year seems to vary since the warranty experience related to vehicles sold is highly variable. The actual warranty expenses have varied over the past 10 years from a low of 3% of an automobile’s selling price to a high of 10%. In the past, Mike has tended toward estimating warranty expenses on the high end just to be prudent. It is the end of the year and once again he must work with the dealership’s accountant in arriving at the warranty expense accrual for the cars sold this year. Required 1. Does the warranty accrual decision present any kind of ethical dilemma for Mike Thatcher? 2. Since the warranty experience is not constant, what percent do you think Mike should choose for this year? Justify your response.
Three years ago CMSV admissions office began using exponential smoothing with a smoothing constant of 0.25 to forecast the number of applications for admissions each year. Based on the previous experience, this process was begun with an initial estimate of 5000 applications. The actual number of applications turned out to be 4600 in the first year and grew to 5300 in the second year and 6000 last year. Determine the forecasts that were made for each of the past three years. Calculate MSE and MAD for these three years and determine the forecast for the next year.
In order to predict pancakes, John's House of Pancakes uses a weighted moveable average process. It gives a weight of five to the demand in the preceding month, three to request two months ago and one to request three months ago. What is the prediction for August if revenues amounted to 1,000 pancakes in May, 2200 pancakes in June, and 3,000 pancakes in July?
Figure shows summer air visibility measurements for Denver, Colorado. The acceptable visibility standard is 100, with readings above 100 indicating clean air and good visibility, and readings below 100 indicating temperature inversions caused by forest fires, volcanic eruptions, or collisions with comets.a. Is a trend evident in the data? Which time-series techniques might be appropriate for estimating the average of these data?b. A medical center for asthma and respiratory diseases located in Denver has great demand for its services when air quality is poor. If you were in charge of developing a short-term (say, 3-day) forecast of visibility, which causal factor(s) would you analyze? In other words, which external factors hold the potential to significantly affect visibility in the short term?c. Tourism, an important factor in Denver’s economy, is affected by the city’s image. Air quality, as measured by visibility, affects the city’s image. If you were responsible for development of…
Aqua Man Company manufactures and sells a single product. Planned and actual production in its first year of operation was 100,000 units. Planned and actual costs for the year were as follows: Manufacturing Non-manufacturing Variable P600,000 P500,000 Fixed P400,000 P300,000 The company sold 85,000 units of product at a selling price of P30 per unit. Using absorption costing, the company’s operating profit was Select one: a. P1,020,000 b. P975,000 c. P900,000 d. P750,000
The following two demand sets are to be used to test two different basic exponential smoothingmodels. The first model uses 0.1, and the second uses 0.5. In both cases, the modelshould be initialized with a beginning forecast value of 50; that is, the ESF forecast for period 1made at the end of period 0 is 50 units. In each of the four cases (two models on two demandsets), compute the average forecast error and MAD. What do the results mean?Demand Set I Demand Set IIPeriod Demand Period Demand1 51 1772 46 2833 49 3904 55 4225 52 5106 47 6807 51 7168 48 8199 56 92710 51 10 7911 45 11 7312 52 12 8813 49 13 1514 48 14 2115 43 15 8516 46 16 2217 55 17 8818 53 18 7519 54 19 1420 49 20 16
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 5 Mileage 3,000 4,050 3,450 3,800 3,800 d) Using exponential smoothing with α = 0.40 and the forecast for year 1 being 3,000, the forecast for year 6 = ? miles (round your response to the nearest whole number).
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Which control chart is appropriate to analyze the above data? Justify your answer
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Calculate the upper and lower control limits for this chart.
Naïve method versus three period Moving Average The number of major plumbing repair jobs performed by Augur’s Plumbing Service in each of the last six months is listed below. Month Jobs October 92 November 94 December 98 January 95 February 99 March 104 Use the ‘textbook’ naïve method to forecast April jobs (Ft+1 = Xt + (Xt – Xt-1). Use the three- period moving average to forecast jobs in April Based upon the MAD (mean absolute deviation), determine whether the three-period moving average or textbook naïve method is more accurate, based upon forecasts for January through March.