The tickets are purchased from the helicopter operator as they board each helicopter, which can take a maximum of 12 passengers.

For the coming 2015 season, management is considering selling souvenirs. When returning from the island and leaving the helicopter, passengers must walk along the dock and exit at a common spot. The plan for the new season is to place a booth selling souvenirs of the island (i.e., a paperweight in the shape of a natural flowerpot) at the end of the dock. Based on a one-month trial run of a similar idea last year, management estimates 75% of passengers will purchase a souvenir.

Predicted 2015 monthly tour demand (number of passengers) based on prior year experience follows:

March - 450

April - 1,250

May - 5,500

June - 5,000

July - 2,200

August - 400

Note: Sales activity occurs evenly throughout each month - assume 30 day months.

The company will run advertisements in a local magazine at a cost of $180 per month (payable monthly in advance). The company estimates that these ads would increase demand by about 10%.

Additional financial data for summer 2015 follows:

• Tickets for helicopter tours sell for $25 each. All sales will be in cash.
• Sales price for souvenirs will be $1.75 each. All sales will be in cash.
• Cost of goods sold will be $0.70 per souvenir, payable on account one month after delivery. The supplier requires an advance seasonal estimate, but actual orders can be placed at the beginning of each month for guaranteed same-day delivery; souvenirs are purchased in boxes of 144 units per box.
• Docking fees (for ticket sales and helicopter docking space) are $1,600 per month on a minimum six-month contract, payable monthly in advance (only one docking space is required).
• helicopter rental is $2,550/boat per month, paid one month in advance. Helicopters are rented as needed on one-month contracts, one boat is required for every 12 customers expected each day (assuming 30 day months). Gasoline is purchased and paid each morning; the total used is $850 per helicopter each month.

• Wages are $2,000 per month for helicopter operators and $1,100 per month for souvenir sales employees, paid during the first week of the month following the month worked. One person is required to staff a single souvenir booth, and one operator is required for each helicopter. (Note: to avoid requiring on person to work every day, two employees will be hired for each position and they will work alternate days to earn half the monthly rate.)

There are no capital expenditures planned for 2015.

• Money can only be borrowed or repaid in multiples of $1,000 at the beginning of the month, at a cost of 1% interest per month. Interest is paid on the first day of the month following the month borrowed.
• The company will end the year with no inventory (units remaining will be donated to a local school) given they have the current year (2014) printed on them and will be of no use the following year (there is no beginning inventory).
• Income taxes and other incidental charges are to be ignored.

Required:

1.Make a monthly budgeted income statement for the six month period ending August 31, 2015.

2.Make a materials purchases budget for souvenirs.

3.Make a monthly cash budget for the eight-month period beginning in September through to May (note: the ending monthly cash balance cannot drop below zero resulting in a periodic need for borrowing). Hint, borrow $7,000 in September to start the month with a $7,000 cash balance.

4.Prepare monthly budgeted balance sheets for February 30, 2015, through August 31, 2019.

5.Budgeting can be used for planning as well as control. In terms of planning, would you advise management to start selling souvenirs in March? Hint: break-even analysis will assist in answering this question.