I need help with BUS 280 REAL Small Business - 26143

Request Posted by
ajbrooks1

ajbrooks1

Rating : No Rating
Earned: $0
Request Detail
Price: $20
  • From: Business,
  • Due on: Thu 26 Sep, 2013 (12:13pm)
  • Asked on: Thu 26 Sep, 2013
  • Due date has passed, but you can still Post Solution.
Description

How Do I Forecast Sales?

Research Information and Assignment Questions

 Creekview RV Park (Market Percentage Sales Forecast Model)

    64 rentable spaces 

  • 15 existing competitors (Yellow Pages)  
  • sales price $12/night
  • fixed costs = $62,000/year
  • Blue Ridge Parkway Monthly Use Report shows 136,000 campground visitations in the Haywood County area per year.
  • The following is the monthly percent distribution of total yearly visits.         

+

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

0%

0%

0%

0%

5%

15%

25%

20%

15%

15%

5%

0%

 

Questions:

1.  Assuming equal market share distribution among Creekview RV Park and the competitors, what would be the anticipated market share percentage that Creekview could achieve?

 

 2. What would be the anticipated monthly sales that Creekview could expect given the number of total visits to Haywood County and the monthly distribution of the visits. Assume that Creekview achieves 4% market share for this estimation. Type the sales forecast into the table below.

 Sales forecast per month for Creekview:

Jan

Feb

Mar

Apr

May

Jun

 

 

 

 

 

 

 

Jul

Aug

Sep

Oct

Nov

Dec

 

 

 

 

 

 

 

Munchkinland Child Care Center (Average Sales Price Forecast Model)

  • loan for $250,000 (10 years @ 6% interest rate)
  • maximum capacity 180 children  
  • 60% of competitors have waiting lists for 0 - 4 year olds
  • The following is an estimated breakdown of the distribution of age groups that will be served by Munchkinland.

Group

Market %

Weekly Fee

Infants - 2 yrs.

15%

$70

2 yrs. - 3 yrs.

20%

$60

3 yrs. - 5 yrs.

50%

$55

After school

15%

$40

 

100%

 

 

Questions:

1. Given the age group distribution above, what is the average sales per week for a child that attends Munchkinland?1.

 2. What is the average sales per month for a child (assume 4.3 weeks per month)?

3. What would be the monthly sales Munchkinland could anticipate given the following percent occupancy: Months 1, 2 and 3 = 50% occupancy; Months 4 - 12 = 80% occupancy. Type the sales forecast into the table.

1

2

3

4

5

6

           

 

7

8

9

10

11

12

           
Please Login or Register to Submit the Solution for the Request