Reference no: EM131723166
BUDGET PROJECT - B
The purpose of this budget assignment is to provide each student an opportunity to understand and manage a budget for a commercial outdoor adventure travel company. This business runs some of its own trips as well as contracts with local businesses to run trips. For the contracted trips, only revenues are included in the budget as the business pays all expenses (see revenue line items below). There are additional expenditures for the company listed as well. List all revenues and expenditures for the company in the object classification budget (see excel attachment).
You are also to develop a line item budget for 3 programs (Joshua Tree Yoga Retreat, Anza Borrego Caving, & Scammon's Lagoon Whale Watching). You should provide detailed expenditures, revenues, and a summary of these items on the worksheets provided in the attached excel file. You will then transfer the revenues and expenditures to the Object Classification Budget. All of this will be done in the same file. This is an individual assignment and not intended to be a group project.
Expenditure Line items:
* Director of Outdoor Trips $50,000 per year salary
* Coordinator of Land Trips $30,000 per year salary
* Coordinator of Water Trips $31,000 per year salary
* Land Trips Supervisor (Permanent, Part time) $10.00 per hour, 40 hrs. per week
* Water Trips Supervisor (Permanent, Part time) $9.50 per hour, 40 hrs. per week
* Custodian $14.50 per hour, full time permanent position
* Benefits $3,500 for full time employees, nothing for part time emp.
* First aid kits $250
* Facility rental $1000 per month
* Facility insurance $250 per month
* Postage $70 per month
* Advertising $500 per month
* Phone service $125 per month
* Equipment repairs $400
* Cleaning supplies $150 per month
* Office equipment $3500
* Utilities $700 per month
Revenue Line items:
Kayaking program $120,000
* Backpacking program $222,000
* Winter Camping trips $432,000
* Zion Slot Hiking trips $213,000
* Snowboarding Excursions $543,000
* Thailand Trekking Trips $127,000
Program 1: - Yoga Retreat, Joshua Tree National Park
Description: Come and experience the silence and beautiful simplicity of the high desert of Joshua Tree National Park. Grounding our feet into the earth we lift our arms to the sky in sun salutations greeting the morning light. The retreat entails two morning and two evening yoga sessions with afternoon options of rock climbing, hiking and meditation. Whether you are new to yoga or a seasoned practitioner, this personalized trip is for you. We hope this weekend Yoga Retreat will give you the enjoyment and adventure you are looking for and at the same time revitalize you.
Details:
DAY 1 (Friday)
Depart San Diego at 1:00pm. Make stops for rest breaks, gas and snacks. Arrive at Joshua Tree approx. 4:30pm. Set up camp, enjoy the first Yoga Session watching the sun go down and enjoy dinner around the campfire.
DAY 2 (Saturday)
6:00am Rise for Morning Tea
7:00am - 9:00am Yoga
9:00am - 10:00am Breakfast
10:00am - 11:00am Personal Time
11:00am - 3:00pm Optional Adventure Activity: Introduction to Rock Climbing & Bouldering
1:00pm Lunch
4:00pm - 5:00pm Yoga
5:00pm - 6:00pm Solo Meditation
6:00pm Dinner
7:30pm Campfire
DAY 3 (Sunday)
6:00am Rise for Morning Tea
7:00am - 9:00am Yoga
9:00am - 10:00am Breakfast & Pack Up
10:00am - 1:00pm Drive back to San Diego
Line Item Budget Information:
- 12 trip participants will attend
- Two trip leaders will lead the trip. They make $8.50 and $8.00 per hour and never get off the clock. They are temporary employees and do not receive benefits,
- Breakfast - $5.00 per meal/person, Lunch - $7.50 per meal/person, Dinner - $10.00 per meal/person
- 2 day van rental = $50 per day for a 15 passenger van
- Gasoline = $75
- Contractual camping gear rental= $25 per person (Everyone needs camping gear, including the leaders)
- J-Tree group campsite fees = $75 per night (15 people max. per campsite)
- All the trip fees must include the cost of the leaders (i.e. food and camping gear), and the leaders are not charged a fee for going.
- Make a 10% profit on each participant; for revenue round the trip fee to the next highest dollar (i.e. $43.12 = $44)
Program 2: - Anza Borrego Caving & Camping Trip
Description: Do you want a muddy adventure? Located in the Southern half of the Anza Borrego Desert, Arroyo Tapiado (translation: "mud-wall wash") has some of the most extensive mud caves in the world, with a history that dates to the beginning of their formation 5 million years ago. Many fossils of land creatures from 1 million to 2 million years ago have been found, including bones of mammoth, sabertooth cat, rhinoceros, camel and dire wolf. Some of the caves are more than 1,000 feet long, with rooms up to 80 feet high and 30 feet wide. Some have multiple levels, and one contains a 45-foot-high subterranean dryfall. Sinkholes (skylights) illuminate the interiors of some caves. See for yourself the beautiful, natural rock formations that fill these caves. Then enjoy peaceful camping out under the stars.
Details: For this trip, participants will take vans to the Anza Borrego Desert. Trip departure is 1:00 p.m. on Friday with a return at 1:00 p.m. on Sunday. Participants will spend Friday & Saturday nights camping in Anza Borrego.
Line Item Budget Information:
- 20 trip participants will attend
- The Director of Outdoor Trips & Coordinator of Land Trips will go on the trip. They are salaried employees and do not need their salary to be included in the individual program budget.
- Two trip leaders will also go on the trip. They make $8.00 per hour and never get off the clock. They are temporary employees and do not receive benefits. They start at 1:00 on Friday and ends at 1:00 on Sunday.
- Breakfast - $5.00 per meal/person, Lunch - $7.50 per meal/person, Dinner - $10.00 per meal/person. The first meal is dinner on Friday and the last meal is breakfast on Sunday.
- 2 day van rental = $100 per day for a 15 passenger van & $75 per day for an 12 passenger van
- Gasoline = $125
- Group campsites = $50 each per night (15 people max. per campsite)
- Contractual camping gear rental= $25 per person (Everyone except the two salaried staff need camping gear, including the two temporary trip leaders)
- All the trip fees must include the cost of the full and part-time leaders (i.e. food, campsites, and camping gear), and the leaders are not charged a fee for going.
- Make a 15% profit on each participant; for revenue round the trip fee to the next highest dollar (i.e. $43.12 = $44)
Program 3: Scammon's Lagoon, Whale Watching Tour
Description: Scammon's Lagoon is located approximately 500 miles down the Baja California Peninsula. We will be visiting the winter home of the California Gray Whales. These huge mammals will be exhibiting all kinds of classic behaviors: spy hopping, breaching, sounding and possibly mating in the warm waters of the lagoon. Yes, it's about whale watching, but much more than that. We will enjoy about eight hours of up close and personal whale watching over the course of the weekend on three separate excursions. No other whale watching tour provides this much time on the water in such a short trip. You will also have the chance to tour the largest salt-works in the world. Lastly, there will be time to relax, explore the town and eat some delicious fresh caught seafood and local Mexican cuisine.
Details:
Day 1 (Thursday)
Depart from San Diego at 6:00 a.m. Travel all day, making stops in Tijuana, Ensenada, San Quintin, and Catavina for meals, rest breaks, and gas. Arrive in Guerrero Negro approximately 6:00 p.m. and check into our motel.
Day 2 (Friday)
Depart in van for whale watching at 9:00 a.m. On water approximately 9:45 a.m. and return to shore after (3 hours). Travel to Ojo de Liebre Natural Park for afternoon of whale watching (2 hours).
Day 3 (Saturday)
Depart in van for whale watching at 9:00 a.m. On water at approximately 9:45 a.m. and return to shore after (3 hours). Enjoy a tour of the Salt-works in the afternoon.
Day 4 (Sunday)
Meet at 5:00 a.m., load up the van, and depart at 5:30 a.m. Travel all day making stops in Catavina, El Rosario, San Telmo, and Ensenada for meals, rest breaks and gas. Arrive back in San Diego at 5:00 p.m.
FOOD: As part of the cost, we are providing four breakfasts (Thursday, Friday, Saturday & Sunday), three group dinners (Thursday, Friday & Saturday). The remainder of the meals will be at your expense (lunch on Thursday, Friday, Saturday, & Sunday).
Line Item Budget Information:
- 12 trip participants will attend
- The Coordinator of Water Trips will lead this trip. This person is a salaried employee and does not need their salary to be included in the individual program budget.
- A trip leader will also go on the excursion. The leader starts at 6:00 a.m. on Thursday and ends at 5:00 p.m. on Sunday. The leader makes $8.00 per hour and never gets off the clock. The leader is a temporary employee and does not receive benefits.
- Food (breakfast) - $5 per meal/person
- Food (dinner) - $15 per meal/person
- Lodging - $100 per night based on double occupancy (everyone is sharing a room including guides)
- (3-Hour)Whale Watching Tours = $100 per person
- (2-Hour) Whale Watching Tour = $75 per person
- Salt-works tour = $10 per person
- 4 day van rental = $100 per day, includes Mexico insurance.
- Gasoline = $500
- All the trip fees must include the cost of the full and part-time leaders (i.e. food (not lunch), lodging, and tours), and the leaders are not charged a fee for going.
- Make a 25% profit on each participant; for revenue round the trip fee to the next highest dollar (i.e. $43.12 = $44)
Attachment:- Assignment Files.rar