Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mr. Kevin, a financial analyst for the Bee Company, is assessing monthly distribution costs for budgeting purposes. It collects the following data regarding distribution

image text in transcribed

Mr. Kevin, a financial analyst for the Bee Company, is assessing monthly distribution costs for budgeting purposes. It collects the following data regarding distribution mileage, unit weight, unit volume, as well as related distribution costs, each month during 2018: Month Mileage (KM) Unit Weight (Tons) Unit Volume (M) Distribution Costs ($) 1 18.000 200 880 3.900 2 16.500 80 810 2.000 3 24.800 240 890 4.300 4 26.600 250 912 4.350 5 19.700 220 887 4.200 6 17.300 100 835 2.600 7 17,500 120 848 3.100 8 16.800 90 830 2.300 9 17.600 130. 852 3.200 10 17.700 140 864 3.360 11 28.000 300 933 4.493 12 17.800 190 875 3.800 a. If management decides that the cost driver for distribution costs is mileage (KM), then determine the cost equation for the last quarter of 2018, using the high-low method. What is the value of fixed cost & variable cost per unit? b. If management decides that the cost driver for distribution costs is the unit weight (Tons), then determine the cost equation for the first half of 2018, using the regression analysis method. What is the value of fixed cost & variable cost per unit? If the company wants to increase the number of units weight from 210 tons to 230 tons, how much additional distribution costs must be incurred?

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

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

8th edition

1111534918, 978-1111534912

Students also viewed these Accounting questions

Question

What is the Easterlin Paradox?

Answered: 1 week ago

Question

consider a one dimensional feature vector x

Answered: 1 week ago