1. The Middlebury town council has invited the circus to come to town. The circus owners are trying to determine how many tickets they will need to sell in order to break even. They esti-mate their total fixed costs to be $400,000. The variable cost is $10 per ticket. If circus manage-ment sets the ticket price at $60, how many tickets does the box office have to sell for the circus to break even?
2. Clifftownâs Parks and Recreation Department is introducing a new summer day camp for children in elementary school, providing programming from 8:00 a.m. to 5:00 p.m. Monday BUDGET TOOLS30through Friday. The proposed day camp program is 10 weeks long and is planned for 50 children. Fixed costs include staff, equipment, and facilities costs, and the total fixed cost is estimated at $15,000 for the 10 weeks. The camp will serve lunch and snacks each weekday at a weekly cost of $15 per child. How much should the Parks and Recreation Department charge per child for the program to break even?
3. In Clifftown, the parks and recreation director learns that his department has received a grant that can cover 50% of the fixed costs of the new summer day camp. How does this reduction in the total fixed cost change the breakeven price?
4. Clifftown Catering Company (CCC) has contacted the parks and recreation director about serving meals at the camp. CCC will provide snacks and lunches for all the campers each week for $8 per camper per week, in exchange for hanging a CCC banner at the camp and having CCC brochures made available. If the Parks and Recreation Department agrees to this arrangement and takes advantage of the grant mentioned in assignment 3, what would the new breakeven price be?
5. Unemployment among high school graduates is quite high due to a recession. City Community College is considering a new program to help young people get the training they need to be more employable. The college has collaborated with the municipal hospital to build a nurseâs aide program, a 1-year program that would lead to immediate employment. Initial finan-cial analysis indicates that the total fixed cost of the program will be $200,000, which includes the cost of a 1-year rental of the facilities plus utilities, insurance, and administrative costs. The vari-able cost and step cost together are $10,000 per student, which pays for faculty salary, student lunches, and teaching materials and textbooks. The state kicks in $5,000 per student, and the tuition based on market analysis is $6,000. Given that the nurseâs aide program has never been offered in the region before and will be under financial pressure due to current funding cuts, the collegeâs board of trustees would like to know how many students would need to be enrolled for the program to break even. The board also wants to know what other options it will have to miti-gate these financial issues if the expected enrollment is below the breakeven point, given the high profile of the program at a time when employment and economic recovery are critical.
Consider two possibilities:
(1) Funding is limited to $100,000, or (2) with the benefit of effi-ciencies, variable and step costs can be reduced to $9,500. You are required to do a financial analysis of the proposed program. Please provide a spreadsheet solution and a written explana-tion of your approach.
1. Nonpersonnel expenses: You have been tasked with computing baseline budget targets for the upcoming budget cycle. Using Table 12.2 as your starting point, make the following adjustments:
(a) Solar panels have been installed with an expected 5% decrease in utility cost, for a savings of about $7,611.
(b) The inspection program was started in FY 2014 and had funding for three fourths of the year. All of the start-up costs were incurred in FY 2014. The annual-ized value of the inspection supplies for the remain-ing one fourth of the year is $81,899.
(c) Inflation is expected to be 2% except for utilities, which will see no increase, and for leased space, which by contract will have a 3% inflationary increase.
(d) The number of service units will not change.
(e) All departments are expected to achieve a 1% improvement in efficiency on all lines of cost and in all programs.
(f) Budget baselines are not given out with cents, so round to the nearest dollar.
2. Personnel expenses: You have been tasked with com-puting baseline budget targets for the upcoming budget cycle. Using Table 12.3 as your starting point, make the fol-lowing adjustments:
(a) All employees are expected to receive a 3% cost-of-living increase in the next year.
(b) The fixed benefit rate will increase by $12.50 per full-time equivalent (FTE) employee. There are 50 FTEs.
(c) The variable benefit rate will increase by 1.25% for all employees in the next year.
(d) Budget baselines are not given out with cents, so round to the nearest dollar.
3. What is the total computed baseline for this department?
4. The Syracuse Mobile Health Unit has the budget shown in Table 12.4:
(a) What is the base budget?
(b) What is the baseline budget for next year, assuming a 3% increase in NPS and a 4% increase in salaries?
(c) Now assume that there is another part-time nurse practitioner who earns $30,000 in the current fiscal year and that starting in the new fiscal year, this individual will be a full-time nurse practitioner with a starting salary of $60,000. What is the base budget? What is the baseline budget?
1. The Seaside Humane Society has performed the following transactions. Summarize the transactions using the accounting equation.
Transaction A: A generous cash donation of $25,000 was received.
Transaction B: The Society purchased a new piece of medical equipment (an asset) for $10,000 and will pay for it in 90 days, creating a liability.
Transaction C: Payroll was distributed, resulting in a decrease of cash in the amount of $2,000.
What are the balance sheet totals after these transactions, assuming the Society had beginning balances of zero?
2. The Little League Organization performed the following transactions. Summarize the transactions using the accounting equation.
Transaction A: Registration for the upcoming baseball season generated $35,600 in regis-tration fees. All fees are paid in cash.
Transaction B: The League purchased new baseballs and uniforms on credit from the local sports store. The transaction total was $12,453.
Transaction C: Landscaping services in the amount of $5,632 were purchased with cash to prepare the fields for play.
What are the balance sheet totals after these transactions, assuming the League had beginning balances of zero?
3. The local homeless shelter had the following transactions. Summarize the transactions using the accounting equation.
Transaction A: Utility bills were paid using cash and totaled $1,345.
Transaction B: The city provides a subsidy of $1 for each breakfast provided by the shelter. A bill was generated and delivered to the city for 6,000 eligible meals.
Transaction C: Volunteers and staff will be painting the inside of the shelter this weekend. Supplies were purchased on credit from the local hardware store, and the total cost was $1,500.
Transaction D: Cash was used to pay the credit debt on the paint and supplies.
What are the totals in the accounting equation after these transactions?
What are the ending balances on the balance sheet if the shelter had the following beginning balances: assets = $20,000; liabilities = $5,000; net assets = $15,000?
1. The Middlebury town council has invited the circus to come to town. The circus owners are trying to determine how many tickets they will need to sell in order to break even. They esti-mate their total fixed costs to be $400,000. The variable cost is $10 per ticket. If circus manage-ment sets the ticket price at $60, how many tickets does the box office have to sell for the circus to break even?
2. Clifftownâs Parks and Recreation Department is introducing a new summer day camp for children in elementary school, providing programming from 8:00 a.m. to 5:00 p.m. Monday BUDGET TOOLS30through Friday. The proposed day camp program is 10 weeks long and is planned for 50 children. Fixed costs include staff, equipment, and facilities costs, and the total fixed cost is estimated at $15,000 for the 10 weeks. The camp will serve lunch and snacks each weekday at a weekly cost of $15 per child. How much should the Parks and Recreation Department charge per child for the program to break even?
3. In Clifftown, the parks and recreation director learns that his department has received a grant that can cover 50% of the fixed costs of the new summer day camp. How does this reduction in the total fixed cost change the breakeven price?
4. Clifftown Catering Company (CCC) has contacted the parks and recreation director about serving meals at the camp. CCC will provide snacks and lunches for all the campers each week for $8 per camper per week, in exchange for hanging a CCC banner at the camp and having CCC brochures made available. If the Parks and Recreation Department agrees to this arrangement and takes advantage of the grant mentioned in assignment 3, what would the new breakeven price be?
5. Unemployment among high school graduates is quite high due to a recession. City Community College is considering a new program to help young people get the training they need to be more employable. The college has collaborated with the municipal hospital to build a nurseâs aide program, a 1-year program that would lead to immediate employment. Initial finan-cial analysis indicates that the total fixed cost of the program will be $200,000, which includes the cost of a 1-year rental of the facilities plus utilities, insurance, and administrative costs. The vari-able cost and step cost together are $10,000 per student, which pays for faculty salary, student lunches, and teaching materials and textbooks. The state kicks in $5,000 per student, and the tuition based on market analysis is $6,000. Given that the nurseâs aide program has never been offered in the region before and will be under financial pressure due to current funding cuts, the collegeâs board of trustees would like to know how many students would need to be enrolled for the program to break even. The board also wants to know what other options it will have to miti-gate these financial issues if the expected enrollment is below the breakeven point, given the high profile of the program at a time when employment and economic recovery are critical.
Consider two possibilities:
(1) Funding is limited to $100,000, or (2) with the benefit of effi-ciencies, variable and step costs can be reduced to $9,500. You are required to do a financial analysis of the proposed program. Please provide a spreadsheet solution and a written explana-tion of your approach.
1. Nonpersonnel expenses: You have been tasked with computing baseline budget targets for the upcoming budget cycle. Using Table 12.2 as your starting point, make the following adjustments:
(a) Solar panels have been installed with an expected 5% decrease in utility cost, for a savings of about $7,611.
(b) The inspection program was started in FY 2014 and had funding for three fourths of the year. All of the start-up costs were incurred in FY 2014. The annual-ized value of the inspection supplies for the remain-ing one fourth of the year is $81,899.
(c) Inflation is expected to be 2% except for utilities, which will see no increase, and for leased space, which by contract will have a 3% inflationary increase.
(d) The number of service units will not change.
(e) All departments are expected to achieve a 1% improvement in efficiency on all lines of cost and in all programs.
(f) Budget baselines are not given out with cents, so round to the nearest dollar.
2. Personnel expenses: You have been tasked with com-puting baseline budget targets for the upcoming budget cycle. Using Table 12.3 as your starting point, make the fol-lowing adjustments:
(a) All employees are expected to receive a 3% cost-of-living increase in the next year.
(b) The fixed benefit rate will increase by $12.50 per full-time equivalent (FTE) employee. There are 50 FTEs.
(c) The variable benefit rate will increase by 1.25% for all employees in the next year.
(d) Budget baselines are not given out with cents, so round to the nearest dollar.
3. What is the total computed baseline for this department?
4. The Syracuse Mobile Health Unit has the budget shown in Table 12.4:
(a) What is the base budget?
(b) What is the baseline budget for next year, assuming a 3% increase in NPS and a 4% increase in salaries?
(c) Now assume that there is another part-time nurse practitioner who earns $30,000 in the current fiscal year and that starting in the new fiscal year, this individual will be a full-time nurse practitioner with a starting salary of $60,000. What is the base budget? What is the baseline budget?
1. The Seaside Humane Society has performed the following transactions. Summarize the transactions using the accounting equation.
Transaction A: A generous cash donation of $25,000 was received.
Transaction B: The Society purchased a new piece of medical equipment (an asset) for $10,000 and will pay for it in 90 days, creating a liability.
Transaction C: Payroll was distributed, resulting in a decrease of cash in the amount of $2,000.
What are the balance sheet totals after these transactions, assuming the Society had beginning balances of zero?
2. The Little League Organization performed the following transactions. Summarize the transactions using the accounting equation.
Transaction A: Registration for the upcoming baseball season generated $35,600 in regis-tration fees. All fees are paid in cash.
Transaction B: The League purchased new baseballs and uniforms on credit from the local sports store. The transaction total was $12,453.
Transaction C: Landscaping services in the amount of $5,632 were purchased with cash to prepare the fields for play.
What are the balance sheet totals after these transactions, assuming the League had beginning balances of zero?
3. The local homeless shelter had the following transactions. Summarize the transactions using the accounting equation.
Transaction A: Utility bills were paid using cash and totaled $1,345.
Transaction B: The city provides a subsidy of $1 for each breakfast provided by the shelter. A bill was generated and delivered to the city for 6,000 eligible meals.
Transaction C: Volunteers and staff will be painting the inside of the shelter this weekend. Supplies were purchased on credit from the local hardware store, and the total cost was $1,500.
Transaction D: Cash was used to pay the credit debt on the paint and supplies.
What are the totals in the accounting equation after these transactions?
What are the ending balances on the balance sheet if the shelter had the following beginning balances: assets = $20,000; liabilities = $5,000; net assets = $15,000?
1. The Middlebury town council has invited the circus to come to town. The circu
Need help Working on This or a Similar Assignment?
We specialize in custom-written, original papers. No prewritten essays here—order your plagiarism-free and AI-free paper today for guaranteed originality.