Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The question is attached. A B D E F G H K L M A B C D E F G H Number of Operating

The question is attached.

image text in transcribed
A B D E F G H K L M A B C D E F G H Number of Operating Number of Miles Trips Costs High/Low Method Cost Driven January 700 29965 Variable cost/unit of activity= January 16800 February 720 27910 Fixed cost February 14200 March 925 33503 March 21000 April 650 26312 Insert text box BELOW showing resulting H/L equation and fill in the box with Two options 1) Hand crunch numbers and input resulting April 12000 May 500 25160 highlighting color like this one. Be sure to tell what the x and y variables values; OR May 10000 June 880 29605 July 685 21496 represent (e.g., x = ?; y= ?) 27320 2) Use Excel formulas and cell references to June 17000 August 610 arrive at costs WITHOUT using any actual July 500 September 745 28247 numbers. August 16000 October 1020 37511 September 15100 November 1100 30974 For anyone unfamiliar with Excel, a basic October 26900 December 1050 34987 arithmatic formula begins with "=" and contains November 19800 cell references (e.g., B4, C9) rather than 25000 numbers. December Cost Prediction To multiply, use "*" Number of trips Predicted cost To divide, use "/' 1,000 -To add or subtract FIRST before multiplying or dividing, you must put parentheses around the cell references you wish to add or subtract. Number of Trips Number of Miles Sheet3 + D Number of Trips Number of Miles Sheet3 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Arne E. Jorgensen

1st Edition

8759340886, 9788759340882

More Books

Students also viewed these Accounting questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago

Question

Why should a consultants progress be regularly monitored?

Answered: 1 week ago