Question: In the end, Michael complied with Robert's request and input his mileage information. Michael's mileage was added to the other vehicles' mileage information, with the

In the end, Michael complied with Robert's request and input his mileage information. Michael's mileage was added to the other vehicles' mileage information, with the quarterly totals listed below. Total fleet expenses on the income statement are a combination of the five costs shown here.
\table[[,\table[[Vehicle],[Insurance]],\table[[Registration],[Fees]],Fuel,\table[[Depreciation],[(Shed & Vehicles)]],\table[[Vehicle],[Maintenance]],\table[[Miles],[Driven]]],[Q1.,$1,900,$1,100,$3,120,$5,400,$2,304,24,000],[Q2,1,900,1,100,3,640,5,400,2,436,28,000],[Q3,1,900,1,100,2,990,5,400,2,048,23,000],[Q4,1,900,1,100,3,770,5,400,2,504,29,000]]
(a)
Your answer is correct.
The accountants planned to use the account analysis method to explain and predict the Fleet Expenses. Based on the information provided, which of the five costs are fixed? Which costs are variable based on miles driven? Which costs are mixed?
Vehicle Insurance
Fixed cost
Registration Fees
Fuel
Depreciation (Shed & Vehicles)
Vehicle Maintenance
eTextbook and Media
Attempts: 2 of 3 used
(b)
For any mixed costs, use the high-low method to separate the fixed and variable components, using miles driven as the cost driver. (Round variable cost per unit to 3 decimal places, eg.15.256.)
Y-$
x+$
 In the end, Michael complied with Robert's request and input his

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 Accounting Questions!