Question

In: Accounting

Jill Jackson collects the following data to identify cost drivers of distribution costs at Saratoga Corporation....

Jill Jackson collects the following data to identify cost drivers of distribution costs at Saratoga Corporation. Distribution costs include the costs of organizing shipments and moving packaged units. Jackson thinks that because the product is heavy, the number of units moved will affect distribution costs significantly, but she is uncertain.

Jackson estimates the following regression equations for each cost driver:

(a) y =$1349 +$.496x, where x = number of packaged units moved

(b) y =$10417 +$63.77x, where x = number of shipments made (Note: The dependent variable y = total distribution costs.)·

Required:

1. Evaluate each cost driver based on the following criteria: economic plausibility, goodness of fit, and slope. Based on this analysis, which cost driver do you think Jill Jackson should use?

2. Jackson forecasts that 50,000 units in 190 shipments will be made next month. Using each of the regression • equations above, what are forecasted variable and fixed overhead costs? (Be sure to clearly identify FC vs VC.) Why do these amounts differ?

3. Overall, what insights do the analyses provide about controlling distribution costs at Saratoga Corporation?

Solutions

Expert Solution

1) As according to Jackson the moving cost is the major issue . In first equation its slope is approx 0.00036 and slope of second equation is approx 0.0061, which is approx 10 times of first one. But in a shipment there is multiple units that decreases the distribution cost as seen by second cost driver equation(equation 2).In equation 1 distribution cost increases whenever each unit added this means as we increase number of unit value of y given by equation 1 becomes more and more than value of y given by equation 2.

So cost driver given by equation 2 is preffered.

2) For 50,000 units in 190 shipment equation 1 gives after putting x= 50,000 gives forecasted variable (y) = 26149.00 while for equation 2 , x takes value = 190 this gives value of forecasted variable( y) = 22533.3.

Now cost of 1 unit(overhead cost ) from equation 1 is 0.522 while that from equation 2 is 0.45.

Forecased variable (y) gives value of 50,000 units in both equation so we have to divide it by 50,000 to get fixed overhead cost.

3) As we increase the number of shipments which has multiple units in it then cost driver given by equation 2 becomes more and more economical than other one. This means in order to decrease or control distribution cost Saratoga Corporation has to ship more and more units in shipments with the help of cost driver given by equation 2.


Related Solutions

Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...
Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $96 ,000 48,000 Machine hours Materials handling 144,000 72,000 Material moves Machine 336,000 24,000 Machine setups Inspections - 120,000 Inspection hours Total $ 576,000 $264 ,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection hours...
Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...
Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 36,000 18,000 Machine hours Materials handling 54,000 27,000 Material moves Machine 126,000 9,000 Machine setups Inspections - 45,000 Inspection hours Total $ 216,000 $ 99,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection hours...
Slack Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...
Slack Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $20,000 $10,000 Machine hours Materials handling 30,000 15,000 Material moves Machine setups 70,000 5,000 Machine setups Inspections - 25,000 Inspection hours $120,000 $55,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 10,000 5,000 Material moves 3,000 1,500 Machine setups 700 50 Inspection hours - 1,000 It...
ABC Corporation has three support departments with the following costs and cost drivers: Support Department Cost...
ABC Corporation has three support departments with the following costs and cost drivers: Support Department Cost Cost Driver Graphics Production $200,000 number of copies made Accounting 500,000 number of invoices processed Personnel 400,000 number of employees ABC has three operating divisions, Micro, Macro, and Super. Their revenue, cost, and activity information are as follows: Micro Macro Super Revenues $700,000 $850,000 $650,000 Direct operating expenses 50,000 70,000 100,000 Number of copies made 20,000 30,000 50,000 Number of invoices processed 700 800...
An insurance company collects data on​ seat-belt use among drivers in a country. Of 1300 drivers...
An insurance company collects data on​ seat-belt use among drivers in a country. Of 1300 drivers 30-39 years​ old, 22​% said that they buckle​ up, where as 384 of 1200 drivers 55-64 years old said that they did. At the 10% significance​ level, do the data suggest that there is a difference in​ seat-belt use between drivers 30-39 years old and those 55-64? Calculate the test statistic z=
An insurance company collects data on​ seat-belt use among drivers in a country. Of 2000 drivers...
An insurance company collects data on​ seat-belt use among drivers in a country. Of 2000 drivers 30 -39 years​ old, 23​% said that they buckle​ up, whereas 482 of 1800 drivers 55-64 years old said that they did. Find a 90​% confidence interval for the difference between the proportions of​ seat-belt users for drivers in the age groups 30-39 years and 55-64 years. Construct a 90​% confidence interval.
A study of car accidents and drivers who use cell phones collects the following sample data....
A study of car accidents and drivers who use cell phones collects the following sample data. had accident in the last year had no accidents in the last year cellular phone user 23 282 non cellular phone user 46 407 Formulate the hypotheses Determine the expected frequencies of those who had accidents in the last year to use for the chi-square test of independence. Test the hypotheses Please show your work. Thanks! and if possible can you explain how to...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 60,000 30,000 Machine hours Materials handling 90,000 45,000 Material moves Machine 210,000 15,000 Machine setups Inspections - 75,000 Inspection hours Total $ 360,000 $165,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 54,000 27,000 Machine hours Materials handling 81,000 40,500 Material moves Machine 189,000 13,500 Machine setups Inspections - 67,500 Inspection hours Total $ 324,000 $ 148,500 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 54,000 27,000 Machine hours Materials handling 81,000 40,500 Material moves Machine 189,000 13,500 Machine setups Inspections - 67,500 Inspection hours Total $ 324,000 $ 148,500 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT