1. PRACTICE: Determine the cost of supplies for Voluntrip. INSTRUCTIONS: After reading Voluntrip's financial projections, create a chart that outlines the cost of supplies for one sales unit. In this case, one sales unit = one day of travel, and the cost of supplies = the cost of services offered for one day of travel. One item could be ground transportation. Ground transportation could include round trip service to and from the airport at \$15 a ride. The total transportation costs for one unit (or one day of travel) =$30. Note that an example of a line item has been provided. This is information that will be incorporated into a full business plan. Before submitting the chart, be sure to print the screen or copy and paste the chart into an Excel spreadsheet, as you will need to refer to this chart again later. Before submitting the chart, be sure to print the screen or copy and paste the chart into an Excel spreadsheet, as you will need to refer to this chart again later. + Row 1-Row Required information INSTRUCTIONS: Before completing each of the activities that follow, read the following Closer Look on Voluntrip, which describes the company's financial projections. Also, before submitting each chart, be sure to print the screen or copy and paste each chart into an Excel spreadsheet, as you will need to refer to these charts throughout. Voluntrip-Financial Projections Ari, Luiz, and Sarita are extremely excited about getting Voluntrip underway. Each owner has agreed to invest $5,000 to start the business, but each also understands that additional capital will be required to sustain the business in the long run. The owners have identified some of the financial needs of the business, and would like your help in capturing the capital needed into the appropriate financial components. The following line items have been identified by Voluntrip, but each item will have to be broken down further to display individual cost components. - Startup Capital: $15,000 - Cost of Supplies: $4.15 (each unit); this will vary based on actual calculations - Economics of One Unit:\$1 (one day of travel; average length of travel 14-21 days) - Monthly Sales Projection: 50 trips (over a period of 6 months) - Operating Costs: (Based on economics of one unit; fixed and variable) - Startup Investment Needed: 25%35% of projected annual profit Each Voluntrip tour package will include: - Customized travel itineraries - Hotel/hostel accommodations - Travel concierge services (point-to-point) - Native tour guides - Online customer account management - Passport and Customs services - Currency conversion and currency exchange services - Meal package - Air travel package - Convenient online booking options - Virtual travel meeting services - Ground transportation options - Convenient payment options - AAA, military, AARP discounts - Extended Customer Service Hours 16:00 a.m. to midnight EST, Monday - Friday, 8:00 a.m. to 5:00 p.m. Saturday and Sunday) 7. PRACTICE: Create a projected movthly/annual income statement. INSTRUCTIONS: After reading Woluntrip's findncid projections, create a proincted monthly/arnval income statement Refer back to the numbers determined in Practice Acbivies 2, 3, 4, 5. 6. and 7 as needed. You will need to calculate all hems. The formula for esch item has been provided in the "Formula conminns. Note, toa, that you need to mulipily the monifhy amounts by 12 to calculate the projected yearly incame statement Do not assume that al amounts ave constant. Before submitting the chart, be sure to print the screen or copy and paste the chart into an Excel spreadsheet, as you will need to refer to this chart again later
