Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the following statements is most appropriate for determining future costs? A The wage cost per mile is approximately $94.28. B The wage cost

image text in transcribed

Which of the following statements is most appropriate for determining future costs?

A The wage cost per mile is approximately $94.28.

B The wage cost per trip is approximately $94.28.

A.

Neither A nor B are useful in approximating future costs.

B.

Statement B is the most appropriate.

C.

Both statement A and B are appropriate.

D.

Statement A is the most appropriate.

COASTAL TRUCKING, INC. Cost Correlation Worksheet Month Fuel Cost Driver Wages Miles Travelled Jan Feb Mar Apr May Jun Total Number Trucking of Trips Cost $85,610 150 $79,851 145 $78,420 137 $60,870 148 $59,014 160 $62,151 175 $64,049 181 $59,182 - 174 $65,627 148 $62,567 147 $65,510 151 $102,820 170 $845,671 1,886 $72,068 $65,731 $64,349 $47,068 $44,824 $46,827 $47,268 $42,198 $51,003 $48,973 $50,507 $87,039 $667,855 Jul Aug $13,542 $14,120 $14,071 $13,802 $14,190 $15,324 $16,781 $16,984 $14,624 $13,594 $15,003 $15,781 $177,816 21,300 20,100 19,000 14,400 13,400 14,000 14,100 12,900 15,100 14,800 15,200 24,900 199 200 Sep Oct Nov Dec Total Ratio Correlation =CORREL(Range1, Range2) -0.173 e fuel to driver wages fuel cost to miles fuel cost to trips wages to miles wages to trips 0.997 -0.189 -0.203 0.847

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_2

Step: 3

blur-text-image_3

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

Accountability Ethics And Sustainability Of Organizations

Authors: Sandro Brunelli, Emiliano Di Carlo

3rd Edition

3030311929, 9783030311926

More Books

Students also viewed these Accounting questions

Question

Describe why intercultural communication is a necessity

Answered: 1 week ago