Question

In: Accounting

Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 415 $ 6,100 February...

Lacourse Inc.'s inspection costs are listed below:

Units Produced Inspection Costs
January 415 $ 6,100
February 365 $ 5,624
March 434 $ 6,315
April 449 $ 6,453
May 391 $ 5,874
June 366 $ 5,627
July 441 $ 6,380
August 392 $ 5,887

Management believes that inspection cost is a mixed cost that depends on units produced.

Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:

Solutions

Expert Solution

Answer:

Unit Variable Cost (b) =[nΣxy − (Σx)(Σy)]/[nΣx2 − (Σx)2]

Total Fixed Cost (a) =(Σy − bΣx)/n

Where,
n is number of pairs of units–total-cost used in the calculation;
Σy is the sum of total costs of all data pairs;
Σx is the sum of units of all data pairs;
Σxy is the sum of the products of cost and units of all data pairs; and
Σx2 is the sum of squares of units of all data pairs.

Month Units(x) Cost(y) x2

xy

January 415 6100 172225 2531500
February 365 5624 133225 2052760
March 434 6315 188356 2740710
April 449 6453 201601 2897397
May 391 5874 152881 2296734
June 366 5627 133956 2059482
July 441 6380 194481 2813580
August 392 5887 153664 2307704
TOTAL 3253 48260 1330389 19699867

We have,
n = 8;
Σx = 3253;
Σy = 48260;
Σx2 = 1330389; and
Σxy = 19699867

Calculating the average variable cost per unit:

b=[(8*19699867) − (3253*48260)]/[(8*1330389) − 32532)]

=(157598936-156989780)/(10643112-10582009)

=609156/61103

=9.97

Calculating the approximate fixed cost:

a=(48260-9.97*3253)/8

=1978

fixed component of inspection cost per month is $1978.

Thank You,Please give an Upvote


Related Solutions

Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 428 $ 6,126 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 428 $ 6,126 February 378 $ 5,637 March 447 $ 6,341 April 462 $ 6,479 May 404 $ 5,887 June 379 $ 5,640 July 454 $ 6,406 August 405 $ 5,900 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 433 $ 6,136 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 433 $ 6,136 February 383 $ 5,642 March 452 $ 6,351 April 467 $ 6,489 May 409 $ 5,892 June 384 $ 5,645 July 459 $ 6,416 August 410 $ 5,905 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 433 $ 6,136 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 433 $ 6,136 February 383 $ 5,642 March 452 $ 6,351 April 467 $ 6,489 May 409 $ 5,892 June 384 $ 5,645 July 459 $ 6,416 August 410 $ 5,905 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
Inspection costs at one of Iuliano Corporation's factories are listed below: Units Produced Inspection Cost February...
Inspection costs at one of Iuliano Corporation's factories are listed below: Units Produced Inspection Cost February 917 $16,207 March 955 $16,616 April 924 $16,251 May 907 $16,107 June 902 $16,296 July 899 $16,183 August 922 $16,343 September 865 $15,762 October 903 $16,132 Management believes that inspection cost is a mixed cost that depends on units produced. Using the high-low method, the estimate of the variable component of inspection cost per unit produced is closest to: $10.73 $0.27 $18.05 $9.49
Copy of Inspection costs at one of Ratulowski Corporation's factories are listed below: Units Produced Inspection...
Copy of Inspection costs at one of Ratulowski Corporation's factories are listed below: Units Produced Inspection Costs April 906 $ 16,312 May 951 $ 16,700 June 912 $ 16,365 July 896 $ 16,210 August 918 $ 16,394 September 903 $ 16,280 October 920 $ 16,432 November 860 $ 15,850 December 899 $ 16,238 Management believes that inspection cost is a mixed cost that depends on units produced. Calculate the following using the high-low method: Variable Cost per unit produced (round...
QUESTION 1 Inspection costs at one of Ratulowski Corporation's factories are listed below: Units Produced Inspection...
QUESTION 1 Inspection costs at one of Ratulowski Corporation's factories are listed below: Units Produced Inspection Costs April 906 $ 16,312 May 951 $ 16,700 June 912 $ 16,365 July 896 $ 16,210 August 918 $ 16,394 September 903 $ 16,280 October 920 $ 16,432 November 860 $ 15,850 December 899 $ 16,238 Management believes that inspection cost is a mixed cost that depends on units produced. Calculate the following using the high-low method: Variable Cost per unit produced (round...
home / study / business / accounting / accounting questions and answers / lacourse inc.'s inspection...
home / study / business / accounting / accounting questions and answers / lacourse inc.'s inspection costs are listed below: units produced inspection costs january ... Your question has been answered Let us know if you got a helpful answer. Rate this answer Question: Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January... Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 430 $ 6,130 February 380 $ 5,639 March 449 $ 6,345 April...
Below is a listing of inspection costs at one of Lockheed Martin's production facilities: Units Produced...
Below is a listing of inspection costs at one of Lockheed Martin's production facilities: Units Produced Inspection Costs April 922 $ 17,912 May 983 $ 18,300 June 928 $ 17,965 July 912 $ 17,810 August 934 $ 17,994 September 919 $ 17,880 October 936 $ 18,032 November 876 $ 17,290 December 915 $ 17,838 The controller of Lockheed Martin has determined that inspection costs are a mixed cost that depend on units of production. Estimate the fixed cost per month...
MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000...
MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000 $400,000 May 14,000 $434,000 June 9,000 $360,000 July 20,000 $550,000 August 21,000 $525,000 September 24,000 $605,000 October 23,000 $589,000 November 28,000 $702,000 December 18,000 $496,000 1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS) Fixed Costs = Variable Cost per Unit = 2) If I manufacture 35,000 units this month, what...
Upward Inc. has projected sales to be 10,300 units in January; 12,400 units in February; 8,800...
Upward Inc. has projected sales to be 10,300 units in January; 12,400 units in February; 8,800 units in March; 10,600 units in April; and 11,800 units in May. There are 860 units on hand on January 1. Management has determined that it needs to carry 4% of the following month’s sales in ending inventory. Assume that each unit requires 4 litres of raw materials. There are 6,300 litres of raw materials on hand at January 1. Management has decided that...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT