In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 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, what is the demand for summer going to be (enter your responses as whole numbers): 468 O 2 O250

In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 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, what is the demand for summer going to be (enter your responses as whole numbers): 468 O 2 O250

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

Related questions

Q: In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each…

A: Average = 1100 Projected sales = 1300 Future Sale(F)= 1300/1100 = 1.18 Average demand(D) F…

Q: Use the decomposition technique to forecast demand for the next four quarters. (Do not round…

A: Seasonal average = Average of each quarter of every given year. Seasonal indices = Deseasonalized…

Q: Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an…

A: YearQtrPeriodUnitsLast1112221833264416This1516262437284818

Q: (Round your answers to 0 decimal place,e.g.,200.) Season Forecast Fall Winter Spring Summer

A: Demand is the total quantity of goods and services that an individual is willing to purchase at…

Q: Using exponential smoothing method, forecast the demand for the fourth period. The historical demand…

A: Exponential smoothing is a forecasting method that uses a weighted moving average to forecast the…

Q: I using the multiplicative seasonal model, the demand level for George's sailboats in the spring of…

A: Multiplicative seasonal method is a model of forecasting technique that using in seasonal adjusted…

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: Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta…

A: C 208Explanation:

Q: Given current demand in this period of 103, a forecast for this current period of 99, and an alpha…

A: Exponential smoothing is a forecasting model which helps to identify the forecasting value based on…

Q: Using the moving average forecast, is it possible to forecast a demand that is biggerthan any…

A: Forecasting is the procedure of prediction making for the future grounded on past as well as present…

Q: ) Based on Table 1, calculate forecast volume using and 5 periods-moving average. b) Based on Table…

A: Given the data stated below, For this dataset, I would use forecasting techniques like 5…

Q: Forecast demand again with a weighted moving average in which sales in the most recent year are…

A: ANSWER IS AS BELOW:

Q: The current data for five trees that will be analyzed in the exercise are shown in the following…

A: Inventory position is the total inventory an organization has in its supply chain. It includes the…

Q: Suzy's Temporary Employee (STE) business, located in a big city, can do an online criminal…

A: In-house Fixed Cost = $30,000In-house Variable Cost per search =…

Q: What is the EBM, if total basic employment is 128,500 and total employment is 350.000? 20) What…

A: EBM stands for Employee Base Measure, which is a measure of the number of jobs that a business or an…

Q: Assume an initial starting Ft of 200 units, a trend (Tt) of 8 units, an alpha of 0.30, and a delta…

A: The objective of the question is to calculate the forecast including trend for the next period using…

Q: Calculate the average number of units sold per station. Calculate the seasonal index. Calculate the…

A: Here, I will determine the average seasonal index for each quarter,

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: iven an actual demand this period of 100, a forecast value for this period of 130, a 6, what is the…

A: Exponential smoothing is a time series forecasting method that assigns exponentially decreasing…

Q: Determine Fall's seasonal factor from the information below. Seasons Past Sales Spring 350 Summer…

A: First we have to calculate the average quarterly demand for each year as :Sum of demand for each…

Q: Dave's Bar-B-Q operated a moble kitchen that serviced construction sites, office buildings, and…

A: From the given data, Let F3 = forecast value for third week of june Y2= 6 F2=4.7…

Q: Using exponential smoothing with a = 0.40 and a forecast for year 1 of 7.0, provide the forecast…

A: Let me state the given data, Yearactual demand1828344751367713812991013117Here, I will apply the…

Q: Given the following forecast and steady regular output of 550 every month, what total cost would…

A: Forecasting is the process of predicting the future demand based on the previous information and…

Q: The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and…

A: Find the given details below: Period12345Forecast Requirements2020202020In Transit400000Note that,…

Concept explainers

Forecasting in Business

Forecasting is the process of predicting the future based on the past and the present data and circumstances. In other words, forecasting is the act of making a detailed analysis of future events based on the decisions made in the past as well as the present. Forecasting plays a very important role in operational management as it helps in planning and decision-making. It is not only important for the success of a business but also contributes to individual growth and success. Many business organizations or companies have failed due to the shortcomings of their forecasting.

Question

In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and
260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 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, what is the demand for summer going to be (enter your responses as whole numbers):
468
250
330
153

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)
The department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.3, and an initial forecast of 30.0 for period 1. a. Calculate the MAD covering periods 2-10. b. Calculate the tracking signal covering periods 2-10. c. What do you recommend? Period (t) Demand (At) 1 24 2 23 3 26 4 36 5 26 6 30 7 32 8 26 9 25 10 28
Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for two independent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions. Output results from the regression analyses were as follows: Driver 1 R squared Intercept X variable (slope) At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information, what is the budgeted amount for Cost Pool A for next month? O A. $3,280 OB. $2,624 O C. $3,464 O D. $3,785 0.46 $551.00 Driver 2 $0.55 0.80 $970.00 $0.33
10.3. The Ashton Furniture Company manufactures coffee tables and chests of drawers. Last year the company’s cost of goods sold was $3,700,000, and it carried inventory of oak, pine, stains, joiners, and brass fixtures, work-in-process of furniture frames, drawers and wood panels, and finished chests and coffee tables. Its average inventory levels for a 52-week business year were as follows: Raw Materials Average Inventory Unit Cost Oak 8000 $6.00 Pine 4500 4.00Brass fixtures 1200 8.00Stains 3000 2.00Joiners 900 1.00 Work-in-Process Frames 200 $30Drawers 400 10Panels 600 50Chests…
forgiven product demand the time series trying equation is 53.3+2.1 X what is your forecast demand for period six?
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…
Show your solution. Please write down your answer. No excel please. Thank you.
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.
Please help with this. Thank you for your assistance.
Problem 12-15 (Algo) Given the data shown below, calculate the slope and intercept using simple linear regression. (Round your intermediate calculations and final answers to 1 decimal place.) Period: Demand: 1 2 3 4 5 6 22 29 42 50 54 61 Slope Intercept