A cost accountant has derived the following data on the weekly output of standard size boxes...

A cost accountant has derived the following data on the weekly output of standard size boxes from a factory.

Week	Output (thousands)	Total cost (thousand dollars)
1	20	60
2	2	25
3	4	26
4	23	66
5	18	49
6	14	48
7	10	35
8	8	18
9	13	40

(a) Determine the regression equation from which we can predict the total cost in terms of the weekly production. (4%)

(b) In the following week it is planned to produce 15,000 standard size boxes. Estimate the total cost of producing this quantity. (1%)

Solutions

Expert Solution

Week	Output (thousands) X	Total cost (thousand dollars) Y	*XY**	X^2	Y^2
1	20	60	1200	400	3600
2	2	25	50	4	625
3	4	26	104	16	676
4	23	66	1518	529	4356
5	18	49	882	324	2401
6	14	48	672	196	2304
7	10	35	350	100	1225
8	8	18	144	64	324
9	13	40	520	169	1600
Sum	112	367	5440	1802	17111

Regression equation=> Y’=a+bX

Where = = 2.138

= = 14.168

Regression equation Y’= 14.168+2.318X

b) For 15000 units the total cost is y= 11.93+(2.318*15000) = 34781.9

c) Correlation coefficient=

Correlation coefficient= 0.93

The relation between output and cost are strongly related because the correlation is greater than 0.75

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Eagle Company uses a standard cost system that has provided the following data: Units of output...

Eagle Company uses a standard cost system that has provided the following data: Units of output manufactured: 85 Direct labor: Standard hours allowed: 2 hours per unit of product Standard wage rate: $16.10 per hour Actual direct labor: 190 hours, total cost of $3,439 A. The direct labor rate variance for the period was: B. The direct labor efficiency variance for the period was: C. The journal entry to record the cost of direct labor used in this period includes:

Q 22 The following data relates to actual output, actual costs and variances for the four-weekly...

Q 22 The following data relates to actual output, actual costs and variances for the four-weekly accounting period number 4 of a company from Bole which makes only one product. The value of work in progress at the end of period 4 was the same as the value of work -in - progress at the beginning of the month Actual production of product XY 18,000 units Actual costs incurred GHS'000 Direct materials purchased and used (150,000 kg) 210 Direct labour...

Yilan Company is considering adding a new product. The cost accountant has provided the following data....

Yilan Company is considering adding a new product. The cost accountant has provided the following data. Expected variable cost of manufacturing$49 per unit Expected annual fixed manufacturing costs$68,000 The administrative vice president has provided the following estimates. expected sales commission $3 per unit Expected annual fixedadministrative costs 52000 a)If the sales price is set at $67, how many units must Yilan sell to break even? b)Yilan estimates that sales will probably be 10,000 units. What sales price per unit will...

Cahill Company is considering adding a new product. The cost accountant has provided the following data:...

Cahill Company is considering adding a new product. The cost accountant has provided the following data: Expected variable cost of manufacturing $ 57 per unit Expected annual fixed manufacturing costs $ 216,000 The administrative vice president has provided the following estimates: Expected sales commission $ 3 per unit Expected annual fixed administrative costs $ 104,000 The manager has decided that any new product must at least break even in the first year. Required Use the equation method and consider each...

Walton Company is considering adding a new product. The cost accountant has provided the following data:...

Walton Company is considering adding a new product. The cost accountant has provided the following data: Expected variable cost of manufacturing $ 50 per unit Expected annual fixed manufacturing costs $ 68,000 The administrative vice president has provided the following estimates: Expected sales commission $ 5 per unit Expected annual fixed administrative costs $ 52,000 The manager has decided that any new product must at least break even in the first year. Required Use the equation method and consider each...

Vernon Company is considering adding a new product. The cost accountant has provided the following data:...

Vernon Company is considering adding a new product. The cost accountant has provided the following data: Expected variable cost of manufacturing $ 42 per unit Expected annual fixed manufacturing costs $ 70,000 The administrative vice president has provided the following estimates: Expected sales commission $ 8 per unit Expected annual fixed administrative costs $ 50,000 The manager has decided that any new product must at least break even in the first year. Required Use the equation method and consider each...

Solomon Company is considering adding a new product. The cost accountant has provided the following data:...

Solomon Company is considering adding a new product. The cost accountant has provided the following data: Expected variable cost of manufacturing $ 43 per unit Expected annual fixed manufacturing costs $ 60,000 The administrative vice president has provided the following estimates: Expected sales commission $ 5 per unit Expected annual fixed administrative costs $ 52,000 The manager has decided that any new product must at least break even in the first year. Required Use the equation method and consider each...

The following are the weekly output of a machine for the past five years. Weeklyoutput (in...

The following are the weekly output of a machine for the past five years. Weeklyoutput (in 1000 units) 0 - 2 2 - 4 4 - 6 6 - 8 8 - 10 Frequancy 1 5 4 3 1 Compute (a) Moment co-efficient of skewness β1 ? = μ32μ23 (b) Co-efficient of kurtosis β2 = μ4μ22

Given the following data Output Total cost output total cost 0 6 1 14 2 20...

Given the following data Output Total cost output total cost 0 6 1 14 2 20 3 24 4 32 5 45 6 60 What is the value of total fixed cost? _______ What is the value of total variable cost when output= 4? _______ What is the value of average total cost when output equals 6?______ What is the marginal cost of the fifth unit?_______ AT what level of output is marginal cost at its minimum value? _____

Murphy’s, Inc. has the following production and cost data for two of its products, Standard and...

Murphy’s, Inc. has the following production and cost data for two of its products, Standard and Deluxe: Standard Deluxe Contribution margin per unit $67.62 $37.30 Machine hours needed per unit 2.10 1.00 A total of 80,000 hours is available each period for the production of the two products. The demand for both products is strong and Murphy will be able to sell as many of either product as it can produce. Ignoring qualitative issues, which of the two products should...

Subjects