In the past, Peter Kelle’s tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2 years, 200 and 260, respectively were sold in fall, 340 and 300 in winter, 150 and 175 in spring, and 300 and 275 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): | Season | Demand | |--------|--------| | Fall | |

In the past, Peter Kelle’s tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2 years, 200 and 260, respectively were sold in fall, 340 and 300 in winter, 150 and 175 in spring, and 300 and 275 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): | Season | Demand | |--------|--------| | Fall | |

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

1
forgiven product demand the time series trying equation is 53.3+2.1 X what is your forecast demand for period six?
The exclusive Swink Golf Driving Range has had astandard price of $15 per hour. The facility has 36 golfing stations,with average usage of 50%, 10 hours a day, 7 days a week. MorganSwink, the owner, would like to enhance revenue. He proposes newpricing at $10 per hour on weekdays and $20 per hour on weekends.He estimates that weekday usage will increase to 60% and weekendusage will remain at 500/o, even with the price increase. Variable costis a consistent $3 per hour. Which strategy is better?
Demand at Nature Trails Ski Resort has a seasonal pattern.Demand is highest during the winter, as this is the peak ski season.However, there is some ski demand in the spring and even fallmonths. Th e summer months can also be busy as visitors oft encome for summer vacation to go hiking on the mountain trails.Th e owner of Nature Trails would like to make a forecast for eachseason of the next year. Total annual demand has been estimatedat 4000 visitors. Given the last two years of historical data, what isthe forecast for each season of the next year?
The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 2,630 $ 10,783 February 3,130 $ 12,833 March 3,640 $ 13,583 April 1,090 $ 4,469 May 1,770 $ 7,257 June 1,730 $ 7,093 July 4,440 $ 14,854 August 3,860 $ 13,815 September 2,170 $ 8,897 October 1,210 $ 4,961 November 1,790 $ 7,339 December 2,930 $ 12,013 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.) What other factors in addition to…
please answer in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?
A store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?
Show your solution. Please write down your answer. No excel please. Thank you.
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…
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast including trend for the next period.
give details calculation