Question: 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.

The question is attached. A B D E F G H K

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

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!