Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!