Purchase Solution

Estimated total vehicle costs

Not what you're looking for?

Ask Custom Question

PLEASE USE MS EXCEL.

A moving company detailed the miles driven and total moving van costs for the past 5 months as follows:

Number of Miles Total Vehicle Costs
Sept. 3,000 $4,800
Oct. 3,500 5,200
Nov. 5,000 6,100
Dec. 4,000 5,000
Jan. 6,000 6,000

In order to budget vehicle costs for the upcoming season, the mover wants to estimate total vehicle costs using the high/low method.

Please use MS EXCEL to determine:

1. What is the equation to predict estimated total vehicle costs?

2. If the Company expects to drive 9,000 miles in February., what will be the estimated total vehicle costs?

Purchase this Solution
Solution Summary

Response helps in predicting estimated total vehicle costs

Solution Preview

PLEASE USE MS EXCEL.
A moving company detailed the miles driven and total moving van costs for the past 5 months as follows:

Number of Miles Total Vehicle Costs
Sept. 3,000 $4,800
Oct. 3,500 5,200
Nov. 5,000 6,100
Dec. 4,000 5,000
Jan. 6,000 6,000

In order to budget vehicle costs for the upcoming season, the mover wants ...

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

View More Free Quizzes
Related BrainMass Solutions

  • cost-benefit analysis and personal budgeting

    Other repair work, such as to the electrical system, alternator, windshield wipers, bulbs, etc. is expected to total $750 over the life of the vehicle.

  • New Product Development

    It also identifies the quantity of parts per vehicle, unit cost and total cost of each component. From this document, it is estimated the standard cost for materials will be $4,468 per vehicle.

  • Car purchase decision

    First, let's look at the costs of each of the cars: Geo Prism: Repairs of 3000 and annual operating costs of 2280; Total 5280 Honda Civic: Purchase of 3000 and annual operating costs of 2100; Total 5100 His savings the first year (if these are

  • Accounting: Linear regression and Activity Based Costing.

    Monthly production costs for 1,000 units are as follows: Direct materials $40,000 Direct labor 10,000 Variable overhead costs 30,000 Fixed overhead costs 20,000 Total costs $100,000 It is estimated that 10% of the fixed overhead costs assigned

  • Break-even Problems

    (10000/68)*1.5 = $23,220.59 Total cost for Mid-Sizer = 20000 + (10000/48)*1.5 = $20,312.50 Total cost for Sport Off-road Vehicle = 18000 + (10000/40)*1.5 = $18,375 Thus, best alternative is Sport Off-road Vehicle.

  • Economic efficiency

    In that opportunity costs consist of money, time, cost of capital, and any other costs of producing the vehicle, simply gaining the most miles per gallon does not imply that economic efficiency is achieved.

  • Accounting:Ratio analysis.

    Total material purchased from suppliers for the six months is £6,000 ? Administration costs are £500 per month for the first three months and £1,000 per month from July onwards ? Sales and marketing costs are £600 per month ?

  • Energy Efficiency Vs. Economic Efficiency

    In this particular case, the benefits from high energy efficiency of the proposed vehicle may be outweighed by the huge costs incurred on the production of the vehicle.

  • Depletion expense per ton

    The vehicle cost $23,000 and its estimated salvage value is $1,500. After 4 years of straight-line depreciation, the asset's total estimated useful life was revised from 8 years to 6 years and there was no change in the estimated salvage value.

View More Related Solutions