Question

In: Operations Management

A sporting store has recorded its recent sales as follows. Season 2 years ago Last year...

A sporting store has recorded its recent sales as follows.

Season

2 years ago

Last year

This year

Spring

700

950

900

Summer

450

500

400

Fall

1,150

1,100

1,350

Winter

1,400

1,500

1,600

The company estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall?

Select one:

a. 1,000

b. 1,200

c. 1,920

d. 1,440

e. 1,600

Solutions

Expert Solution

Answer: d.1440

Explanation:

Seasonal Average = Average Seasonal Demand over last years

Total Yearly Demand = Demand per year = Sum of demand for all season for a particular year

Grand Total = Sum of total yearly demand

Overall Average = Average demand per season over last 3 years = Grand Total /12

Seasonal Index = Seasonal Average/Overall Average

Seasonal Forecast for next year = Seasonal Index*annual demand for next year/4

Seasonal Forecast for fall = 1.2*4800/4 = 1440

Formula:


Related Solutions

Sporting Goods is a retailer of sporting equipment. Last​ year, Terry​'s sales revenues totalled $2,500,000. Of...
Sporting Goods is a retailer of sporting equipment. Last​ year, Terry​'s sales revenues totalled $2,500,000. Of this​ amount, approximately $1,612,000 were​ variable, while the remainder were fixed. Since Terry​'s Sporting Goods offers thousands of different​ products, its managers prefer to calculate the​ break-even point in terms of sales dollars rather than units. 1. What Terry current operating​ income? (Prepare a contribution margin format income​ statement.) 2. What is Terry contribution margin​ ratio? 3. What is Terry ​break-even point in sales​...
Flash Inc. was founded 5 years ago. It has been profitable for the last 2 years,...
Flash Inc. was founded 5 years ago. It has been profitable for the last 2 years, but it has needed all of its earnings to support growth and thus has never paid a dividend. Management has indicated that it plans to pay a $1 dividend starting one year from today, then it will increase the dividend growth by 50% for the next two years, and then the company will achieve a long run growth rate of 6%. Assuming a required...
The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 205 Summer...
The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 205 Summer 140 Fall 375 Winter 575 last year Spring 475 Summer 275 Fall 685 Winter 965 Use regression analysis and seasonal indexes to forecast next summer’s demand. (Do not round intermediate calculations. Round your answer to the nearest whole number.)
Cowboys Copies, Inc., wants to upgrade its copy machines. Its last update was 2 years ago,...
Cowboys Copies, Inc., wants to upgrade its copy machines. Its last update was 2 years ago, when it spent $1,150 on equipment with an assumed life of 5 years and. The firm uses MACRS depreciation. The old equipment can be sold today for $800. A new system can be installed today for $1,500. This will have a 3 year life and will be depreciated under MACRS 3 year schedule. At the end of 3 years, the new equipment will be...
      The profits of a firm for the last five years were as follows.       Year...
      The profits of a firm for the last five years were as follows.       Year Profit (OMR) 2015 10,000 2016 20,000 2017 30,000 2018 20,000 2019 18,000 Calculate the value of goodwill on the basis of four years’ purchase of weighted average profits based on weights 1,2,3,4 and 5 respectively to the profits for 2015, 2016, 2017, 2018 and 2019.                                                                         (3 marks) Write any six need for valuation of goodwill                  (2 marks)
The daily sales of a small retail store in Calgary for the last year are normally...
The daily sales of a small retail store in Calgary for the last year are normally distributed with a mean of $2050, and a standard deviation of $300. What is the probability of daily sales exceeding $2,500? From a sample of 5 days, what is the probability of having a sample mean less than $2,200? a. 0.0668; 0.8682 b. 0.4332; 0.0668 c. 0.0668; 0.9332 d. 0.0668; 0.9795 e. 0.4332; Approximately 100%
2. A large sporting goods store is placing an order for bicycles with its supplier. Four...
2. A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold...
A firm has $40 million in sales last year. Its asset to sales ratio is .4...
A firm has $40 million in sales last year. Its asset to sales ratio is .4 and its net profit margin of .07. The firm plans to maintain its current retention ratio is .6; its payables amount to $400,000 million, and it does not have any bank loans as notes payable. If 20% increase in sales is anticipated, how much additional financing is required?        
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $85 million on equipment with an assumed life of 5 years and an assumed salvage value of $25 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $70 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it...
PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $115 million on equipment with an assumed life of 5 years and an assumed salvage value of $15 million for tax purposes. The firm uses straight-line depreciation. The old equipment can be sold today for $80 million. A new modem pool can be installed today for $150 million. This will have a 3-year life and will be depreciated to zero using straight-line depreciation....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT