Question

In: Accounting

1. Your client's company wants to determine the relationship between its monthly operating costs and a...

1. Your client's company wants to determine the relationship between its monthly operating costs and a potential cost driver. The output of regression analysis showed the following information:

Intercept Coefficient = 89,500

X Variable 1 Coefficient = 62.50

R- square = 0.9855

What is the company's monthly cost equation?

A. y = $62.50x + $89,500

B. y = $89,500x + $62.98

C. y = $89,500x + $98.55

D. y = $98.55x + $89,500

2. The managerial accountant at the Bookcase Factory prefers regression analysis to the high?low method because it is a more accurate method. The managerial accountant uses regression output and analyzes the following data to predict future costs:

y =$250x + $625

where,

y = total monthly utility cost

x = number of guests

What is the intercept coefficient, or the vertical intercept of the fixed cost line, in the equation listed above?

A. $625

B. y

C. $250x+ $625

D. $250x

3. Hyper Color Company manufactures widgets. The following data is related to sales and production of the widgets for last year.

Selling price per unit

$160

Variable manufacturing costs per unit

$62

Variable selling and administrative expenses per unit

$5

Fixed manufacturing overhead (in total)

$33,000

Fixed selling and administrative expenses (in total)

$8,000

Units produced during the year

1,800

Units sold during year

900

Using variable costing, what is the contribution margin for last year?

A. $144,000

B. $55,800

C. $204,300

D. $83,700

Solutions

Expert Solution

  • Answer to Q1

The correct answer is Option ‘A’: y = $62.5x + $89,500

Under regression analysis, cost equation is: y = bx +a, where,
y = total cost,
b = Variable cost per unit
x = number of variable units, and
a=total fixed cost.

Accordingly, given in question 62.5 is variable cost per unit (‘b’ part of equation) and 89500 is fixed cost (‘a’ part of equation).

  • Answer to Q2

As mentioned above, cost equation: y = bx (total variable cost) + a (total fixed cost)

Intercept coefficient is the fixed cost of the equation.
In the given equation, $250 is variable cost per unit and ‘x’ is number of units, while $625 is the fixed cost.

Hence, the correct answer is Option ‘A’: $625 is the intercept coefficient of the fixed cost line.

  • Answer to Q3

Sale price per unit = $160
Total Variable cost per unit = $ 62 + $ 5 = $ 67

Contribution margin per unit = Unit Sale price – Unit variable cost.
Unit contribution = $ 160 - $ 67 = $ 93

Total Contribution margin = Units Sold x unit contribution
Total contribution margin = 900 units x $ 93 = $ 83,700

Hence, the correct answer is Option ‘D’: $ 83,700


Related Solutions

A regional transit company wants to determine whether there is a relationship between the age of...
A regional transit company wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Age of Bus (years) Annual Maintenance Cost ($) 1 350 2 370 2 480 2 520 2 590 3 550 4 750 4 800 5 790 5 950 Instructions: Input the data into an SPSS work sheet making sure that all your variables are labelled appropriately Create...
A regional transit company wants to determine whether there is a relationship between the age of...
A regional transit company wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Age of Bus (years) Annual Maintenance Cost ($) 1 350 2 370 2 480 2 520 2 590 3 550 4 750 4 800 5 790 5 950 Instructions: Input the data into an SPSS work sheet making sure that all your variables are labelled appropriately Create...
An automobile dealer wants to see if there is a relationship between monthly sales and the...
An automobile dealer wants to see if there is a relationship between monthly sales and the interest rate. A random sample of four months was taken. Here are the results of the sample y x Monthly Sales Interest Rate % 22 9.2 20 7.6 10 10.4 45 5.3 The estimated least squares regression equation is: Ŷ= 75.061 ‐ 6.254X a. Obtain a measure of how well the estimated regression line fits the data. b. You want to test to see...
Corporation wants to find an equation to estimate some of their monthly operating costs for the...
Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017​: DATA TABLE : Month Maintenance Costs Machine Hours Health Insurance Number of Employees Shipping Costs Units Shipped January $4,450 158 .    $8,560 58    $22,784      7,120 February $4,375 125 $8,560    79 $26,272 8,210 March $4,675 233    $8,560    91    $25,440 7,950 April $4,880 315    $8,560...
A researcher wants to determine if there is a linear relationship between height and weight. The...
A researcher wants to determine if there is a linear relationship between height and weight. The following table represents the data collected. Display the data in a scatter plot on your calculator, draw a quick sketch below. Then find the linear regression and put the line of best fit on the sketch. Then state the value for the correlation coefficient and determine if this is a positive correlation or no correlation using the table in the back of the book....
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires, in thousands, and the number of acres burned, in hundreds of thousands. Based on this data, decide if the correlation is significant at alpha = 0.05. Number of fires x 73 74 58 48 80 65 54 49 Number of acres burned y 64 46 22 23 51 12 29 10 5. When x = 61 what is y and what does it mean I this context. 6....
An environmentalist wants to determine the relationship between the number of fires in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the number of acres burned in hundreds of thousands. Based on the data, decide in the correlation is significant at alpha = 0.05. Number of fires (x) - 73 | 74 | 58 | 48 | 80 | 65 | 54 | 49 Number of acres burned (y) - 64 | 46 | 22 | 23 | 51 | 12 | 29 | 10 Determine...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the...
An environmentalist wants to determine the relationship between the number of fires in thousands, and the number of acres burned in hundreds of thousands. Based on the data, decide in the correlation is significant at alpha = 0.05. Number of fires (x) - 73 | 74 | 58 | 48 | 80 | 65 | 54 | 49 Number of acres burned (y) - 64 | 46 | 22 | 23 | 51 | 12 | 29 | 10 Find...
An architect wants to determine the relationship between the heights (in feet) of a building and...
An architect wants to determine the relationship between the heights (in feet) of a building and the number of stories in the building. The data for a sample of 10 buildings are shown. Stories (x) 64 54 40 31 45 38 42 41 37 40 Height (y) 841 725 635 616 615 582 535 520 511 485 Is there a significant linear correlation between the two variables ? Use α = .05 What would be the best predicted Height of...
Exhibit I Fineprint Company Summary of Monthly Operating Costs volume, units                    150,000 Manufacturing Costs: Monthly...
Exhibit I Fineprint Company Summary of Monthly Operating Costs volume, units                    150,000 Manufacturing Costs: Monthly Cost      Direct material - variable $                    6,000      Direct labor - variable                        1,500      Direct labor - fixed                        3,000      Manufacturing OH - variable                        1,500      Manufacturing OH - fixed                        3,375 Total Manufacturing Costs $                  15,375 Non-manufacturing Costs:      Sales - variable                        1,500      Sales - fixed                        1,875      Corporate - fixed                        3,750 Total Non-manufacturing Costs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT