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: $ (one day of travel; average length of travel 1421 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 (6:00 a.m. to midnight EST, Monday Friday; 8:00 a.m. to 5:00 p.m. Saturday and Sunday) 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. Definition of One Unit: 1 day of travel Item & Item Description Cost per Qty Quantity $ Cost per Unit (S) $ 15 2 30 EXAMPLE: Ground transportation: Round trip to and from airport - - Total - Projected Monthly Projected Yearly Income Statement Formula Cost Income Statement Formula Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold x selling price) Total Sales (units sold x selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS Total COGS (from COGS per unit x units solid) (from COGS per unit x units solid) Gross Profit (sales - COGS) Gross Profit (sales COGS) Fixed Costs Fixed Costs (from monthly operating costs chart) (from monthly operating costs chart) Variable Costs Variable Costs (from same chart as fixed costs) (from same chart as fixed costs) Total Operating Costs (fixed + variable costs) Total Operating Costs (fixed + variable costs) Profit Before taxes Profit Before taxes (gross profit - operating costs) (gross profit - operating costs) Estimated taxes @ 25% (profit before taxes x 25%) Estimated taxes @ 25% (profit before taxes x 25%) Net Profit / Net Loss (profit before taxes taxes) Net Profit / Net Loss (profit before taxes taxes) 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: $ (one day of travel; average length of travel 1421 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 (6:00 a.m. to midnight EST, Monday Friday; 8:00 a.m. to 5:00 p.m. Saturday and Sunday) 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. Definition of One Unit: 1 day of travel Item & Item Description Cost per Qty Quantity $ Cost per Unit (S) $ 15 2 30 EXAMPLE: Ground transportation: Round trip to and from airport - - Total - Projected Monthly Projected Yearly Income Statement Formula Cost Income Statement Formula Cost Units Sold Units Sold Selling Price per Unit Selling Price per Unit Total Sales (units sold x selling price) Total Sales (units sold x selling price) COGS per unit (from economics of one unit chart) COGS per unit (from economics of one unit chart) Total COGS Total COGS (from COGS per unit x units solid) (from COGS per unit x units solid) Gross Profit (sales - COGS) Gross Profit (sales COGS) Fixed Costs Fixed Costs (from monthly operating costs chart) (from monthly operating costs chart) Variable Costs Variable Costs (from same chart as fixed costs) (from same chart as fixed costs) Total Operating Costs (fixed + variable costs) Total Operating Costs (fixed + variable costs) Profit Before taxes Profit Before taxes (gross profit - operating costs) (gross profit - operating costs) Estimated taxes @ 25% (profit before taxes x 25%) Estimated taxes @ 25% (profit before taxes x 25%) Net Profit / Net Loss (profit before taxes taxes) Net Profit / Net Loss (profit before taxes taxes)