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