View the step-by-step solution to:

Question

The question is attached.

Data-setpsd.jpg

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
+

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Managerial Accounting tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors