You are not logged in.
Pages: 1
There is only one bus.
The customer pays $100 for a ticket
5 customers can be on the bus at one time
3 tours can happen in one hour
I need some help writing a math formula for accounting. I need to write a formula which shows how many tickets for a tour need to be sold for a company to break even and put it into MS Excel. I know that BE point =fixed+variable+profit, what I am having trouble is with the kind of product being sold, as it is not like a regular item with a fixed cost (buy a shoe at cost for $2 and sell if for $4 kind of thing) you would sell. The tickets are for a bus tour, so you can have 5 customers per tour, 3 tours per hour, and you have to take into account gas and maintenance of the bus.
Given Information
Fixed:
Rent: $1000 per month
Insurance: $200 per month
Employee Salary: $2000 per month
Variable:
Employee rate (only one hourly employee): $10 per hour
Fuel consumption: 15 gal/hour
Fuel price: $3.00 per gallon
Average maintenance for bus: $50 per hour
Price charged to customer: $100 per ticket
Average amount of customers per tour: 5
Average tours per hour: 3
Any help would be appreciated. Thanks
Pages: 1