Question
A county provides a county-wide van service for senior citizens. The county receives a $100,000 grant each year from the state government in support of
A county provides a county-wide van service for senior citizens. The county receives a $100,000 grant each year from the state government in support of the van service. The county expects to spend $2,500 each year for operating the service. Insurance will cost the county $1,750 per year for each of the two vans.
The county employs a supervisor to run the van service. The supervisors salary is $56,000 per year. They also need one part-time coordinator for every 500 rides they served to organize the routing of the vans and provide service to the senior community. Each coordinator works an average of 10 hours per week for 50 weeks in the year and is paid $7.50 per hour. Supervisors receive benefits worth an additional 20% of their annual salaries. Coordinators do not receive benefits.
Salary and Wage Schedule
Supervisor $56,000 per year
Coordinator $7.50 per hour
All drivers are volunteers. The costs associated with carrying each passenger are $0.25 per mile. The average ride for each passenger is 10 miles. Seniors are asked to pay $3.50 for each ride but only 90% of the riders are able to afford and will pay the fares.
a) Prepare an accrual-based operating budget for the upcoming year, assuming the county provides 5,000 rides during the year. Since there have been fluctuations in ridership in recent years, the county would also like to see what would happen if there is a 10% increase or decrease in the number of rides they provide. Your budget must be properly formatted. The following template will be helpful but feel free to make changes if necessary.
Question a - Flexible Budget | Base case (100%) | Decrease in volume (90%) | Increase in volume (110%) |
Number of rides |
|
|
|
Revenue |
|
|
|
Grant |
|
|
|
Fares |
|
|
|
Total Revenue |
|
|
|
Expenses |
|
|
|
Supervisor Salary |
|
|
|
Coordinator's Salaries |
|
|
|
Benefits |
|
|
|
Total Salaries and benefits |
|
|
|
|
|
| |
Fixed Insurance |
|
|
|
Copying and supplies |
|
|
|
Mileage Expenses |
|
|
|
|
|
| |
Total Expenses |
|
|
|
|
|
| |
Surplus/(Deficit) |
|
|
|
- What are the fixed costs and what are the variable costs in this case?
- What is the contribution margin per ride from each additional rider assuming the county provides 5,000 rides during the year?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started