Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Expense Forecasting Based on the information provided, prepare an expense forecast for 20X1 using the template below: Spending during January- June 20X1 (6 months) Fixed

Expense Forecasting Based on the information

provided, prepare an expense forecast for 20X1 using the template below: Spending during January- June 20X1 (6 months) Fixed expense items: $210,000 Variable expense items: $1,200,000 One time expense: $50,000 of fixed expense money was spent on preparing for a Joint Commission survey Procedures preformed during January- June 20X1 (6 months) Your department has performed 20,000 procedures during the first six months On November 1,20X1, two new procedure technicians will begin work. The salary and fringe benefit costs for each is:$96,000 yearly DescriptionFixedVariableTOTALYear to Date ExpenseAdjustments Add back "One Time" creditsDeduct "one Time" expensesAdjusted total for year to date expenseAnnualization Divide by months (fixed) 6Multiple by months (fixed) 12Divide by volume20,000Multiply by volume40,000Annualized AmountsAdjustments Add back "One Time" expensesDeduct "One Time" creditsExpense two new techniciansExpense Forecast as of 12/31/X1Calculations: Annualization for Fixed:(Adjusted Total for Year to Date Expense/6) * 12 =Total Annualized AmountsAnnualization for Variable (Adjusted Total for Year to Date Expense/ 20,000) * 40,000 =Total Annualized Amounts

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuation Measuring and managing the values of companies

Authors: Mckinsey, Tim Koller, Marc Goedhart, David Wessel

5th edition

978-0470424650, 9780470889930, 470424656, 470889934, 978-047042470

More Books

Students also viewed these Finance questions