Answered step by step
Verified Expert Solution
Question
1 Approved Answer
APC Car Washings accountant has just finished the monthly figures for February 2017 and has prepared the following schedules showing current month and year-to-date budgets
APC Car Washings accountant has just finished the monthly figures for February 2017 and has prepared the following schedules showing current month and year-to-date budgets and actual:
Required: Prepare a report comparing Actual to Budget for both the: a. Current month of February, and b. Year-to-date figures to disclose relevant variances for revenue and cost items and to signify whether the variance is favourable (F) or unfavourable (U).
APC Car Washing Performance Analysis and Variance Report February 2017 July 2016 to February 2017 Budget | Actual Budget Actual 195 1,440 1,520 180 Cars expected to be was expected to be washed Expected Revenue per job Total Revenue $30 $5,400 $35 $6,825 $30 $43,200 $33 $50,160 Less: Variable Costs Labour Costs Consumables Motor Vehicle Expenses Total Variable Costs $1,080 $180 $270 $1,530 $1,365 $210 $310 $1,885 $8,640 $1,440 $2,160 $12,240 $10,470 $1,980 $2,790 $15,240 Fixed Costs Advertising Depreciation Insurance Mobile Telephone Costs Office Costs Total Fixed Costs $200 $250 $100 $150 $450 $1,150 $250 $100 $176 $520 $1,246 $1,600 $2,000 $800 $1,200 $3,600 $9,200 $1,600 $2,000 $800 $1,680 $4,350 $10,430 $2,680 $3,131 $21,440 $25,670 Total Costs (Variable + Fixed) Net Income $2,720 $3,694 $21,760 $24.490Step 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