Question: I have made a scatter plot but i need help with 1 . Estimate the variable and fixed components of the departments cost behavior pattern

I have made a scatter plot but i need help with
1. Estimate the variable and fixed components of the departments cost behavior pattern using the visually fit cost line
Fixed-cost component=
Variable cost per unit of activity=
And
2.using your estimate from the requirement specified an equation to express the departments behavior.
total material-handling cost = $___+$__x
I have made a scatter plot but i need help with

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!

Q:

If you could please do/post the excel solution that would be great! Number of Month January February March April May June Cabinets Produced 800 3,600 1,960 600 1,600 1,300 1,100 1,800 2,280 2,940...

Q:

6.48 (Note Instructors who wish to cover all three cost estimation methods with the same data set may assign this case in conjunction with the following case) "I don't understand this cost report at...

Q:

(Note: Instructors who wish to cover all three cost-estimation methods with the same data set may assign this case in conjunction with the following case.) "I don't understand this cost report at...

Q:

Question \#1 Least-Squares Regression, Scatter graph, Comparison of Activity Bases Professor John Morton is reviewing the finance department's cost records, revealing the following total cost...

Q:

The Anderson Trucking Company has one service department and two regional operating departments. The budgeted cost behavior pattern of the service department is $675,000 monthly in fixed costs plus...

Q:

Mixed Cost Analysis and the Relevant Range ( 10 marks) The Ramon Company is a manufacturer that is interested in developing a cost formula to estimate the fixed and variable components of its monthly...

Q:

The Ramon Company is a manufacturer that is interested in developing a cost formula to estimate the fixed and variable components of its monthly manufacturing overhead costs. The company wishes to...

Q:

Mixed Cost Analysis and the Relevant Range (10 marks) The Ramon Company is a manufacturer that is interested in developing a cost formula to estimate the fixed and variable components of its monthly...

Q:

The Ramon Company is a manufacturer that is interested in developing a cost formula to estimate the fixed and variable components of its monthly manufacturing overhead costs. The company wishes to...

Q:

please answer the below cases separately in excel sheet with steps case 1 Ethics and the Manager, Understanding the Impact of Percentage Completion on Prot Weighted-Average Method (10 marks) Gary...

Q:

Discuss how the examples in this chapter illustrate the major theme of this text: Changes in the macro environment affect individual firms and industries through the microeconomic factors of demand,...

Q:

One ratio measure of fiscal effort is Revenue from own sources/Intergovernmental revenues. TRUE/FALSE

Q:

P 6 - 2 3 Bond valuation and yield to maturity Mark Goldsmith's broker has shown him two bonds. Each has a maturity of 5 years, a par value of $ 1 , 0 0 0 , and a yield to maturity of 1 2 % . Bond A...

Q:

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...