Chapter12Solution - Excel Templates Chapter 12 Student Name<Type your name here> Class<Type your class here> Problem 12-20 Given Data

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Excel Templates Chapter 12 Student Name: <Type your name here> Class: <Type your class here> Problem 12-20 Given Data: Ticket revenue: Seat capacity 100 Occupancy 40% Ticket price $75 Total ticket revenue $3,000 100% Variable expenses: Per person $22.50 Total 900 30% Contribution margin 2,100 70% Tour expenses: Tour promotion $600 350 700 Fuel for bus 125 450 200 Overnight parking fees, bus 50 Room and meals, bus driver and tour guide 175 300 Total tour expenses 2,950 Operating loss $(850.00) Also: the number of buses, drivers, maintence and preparation staff woould not decrease if tour was dropp Salary of bus driver 1 Fee, tour guide 2 Depreciation of bus 3 Liability insurance, bus 4 Bus maintenance and preparation 5 1 Fixed, annual 2 Paid for each tour 3 Due to obsolescence 4 Based on number of buses in fleet 5 Allocation of salaries of mechanics and other service personnel ped <Type your name here> <Type your class here> Excel Templates Chapter 12 Problem 12-20 Part 1 Keep the Tour Drop the Tour Ticket revenue...
View Full Document

This note was uploaded on 10/19/2010 for the course ACCOUNTING 341 taught by Professor Ken during the Spring '10 term at University of Guelph - Humber.

Page1 / 6

Chapter12Solution - Excel Templates Chapter 12 Student Name<Type your name here> Class<Type your class here> Problem 12-20 Given Data

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online