The Glory Mountain State Ski Area owned and managed by a state public authority - expects to attract 292,500 skier days during the coming ski season. A skier day represents one skier at the mountain for one day. In addition to a $2,000,000 per year subsidy provided by the state, Glory currently earns its revenue from three sources: lift ticket sales, ski lessons, and food sales in the mountains lodges. Forty-five percent of the customers come to the mountain on weekends and pay an average of $60 per day to ski. The remaining 55 percent of the skiers come during the week and pay an average of $45 per day for a lift ticket. On average, 10 percent of the people who visit Glory take ski lessons. An average person taking lessons pays $80 for each lesson. Management also estimates that each skier spends an average of $4 per day on food. Food costs average 40 percent of total food revenue. Glorys central management staff is paid $1,800,000 per year. The remainder of Glorys staff is seasonal and is paid on an hourly basis. The table below shows the number of employees by job title, the number of days they work on average, their hourly wages, and the number of hours they work each day. Only ski instructors and patrol costs vary with skier days. Benefits add 30 percent to direct salary costs for all workers including management. Equipment costs and usage are also shown in the table below. For equipment, number refers to the number of pieces of equipment. Equipment costs depend on the number of days the area is open during the season. The hourly fuel cost represents the cost of fuel to operate the equipment for each hour they are open. Number Days Worked Hours Worked Hourly Wage Instructors & Ski Patrol 275 100 7 $20.00 Lift Attendants, Maintenance & Grooming 140 130 10 $18.00 Kitchen Staff 50 130 8 $12.00 Equipment & Fuel Costs 60 130 6 $65.00 Insurance costs are $15,000 per day for each of the 130 days the area expects to be open. Energy costs are $2,240,000 per year and are based on the number of days the area is open. Neither energy nor insurance costs vary based on skier days.

Question:

Question 5: Prepare a special-purpose budget for the Glory Kids Center. Do not include the incremental lift ticket revenue from the expected increase in the volume of skier days in your estimate.

After completing these analyses, Dan Finn asks you to update the budget to include the impact of installing the wind turbine, replacing the snowmaking equipment and operating the Glory Kids Center. In addition, Glory will have to issue a $6,000,000 bond to finance the acquisition of the equipment. The coupon rate on the bond will be 5 percent. It will require Glory to pay interest every six months and to repay the full $6 million of principal in 20 years. The bonds will be issued on the first day of Glorys fiscal year, and all equipment will be put in service that same day.