Ascertain the product cost and gross profit margin percentages of each product.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Soln

Solution needed

1. Dividend per share in a company Rs. 2, earning per share is Rs. 5 and the market value of the share is Rs. 25. What will be its yield? A. O 20% B. 12.5% C. 8% D. 25%

Answer 2

Question

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Answer 6

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

Answer 7

Chapter 9, Problem 72IC

a.

To determine

Ascertain the product cost and gross profit margin percentages of each product.

Answer 8

a.

Expert Solution

Explanation of Solution

Ascertain the product cost and gross profit margin percentages of each product.

FUND.OF COST ACCT >CUSTOM<, Chapter 9, Problem 72IC

Table (1)

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases

Table (2)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	63.6%	13.3%	10%
Krispy Krackle	27.3	46.7	40
Creamy Crunch	9.1	40.0	50

Table (3)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	$21,072	$21.07
Krispy Krackle ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	26,699	26.70
Creamy Crunch ($24,500×63.6%)+($30,000×13.3%)+($15,000×10%)	=	21,730	21.73

Table (4)

Allocated Production Costs:

	Almond Dream	Krispy Krackle	Creamy Crunch
Material cost	$8.00	$2.00	$9.00
Direct labor	42.00	18.00	6.00
Allocated overhead	21.07	26.70	21.73
Production cost per case	$71.07	$46.70	$36.73
Selling price (b)	$85.00	$55.00	$35.00
Product cost	(71.07)	(46.70)	(36.73)
Profit (loss) (a)	$13.93	$8.30	$(1.73)
Profit margin ratio (c) = (a/b)	16.4%	15.1%	(4.9)%

Table (5)

Note (1):

Totals equal hours per case times 1,000 cases.

Hence, the product costs and gross profit margin percentage for the products Almond Dream, Krispy Krackle, and Creamy Crunch are $71.07, and 16.4%, $46.70, and 15.1%, and $36.73, and (4.9)%, respectively.

Answer 9

a.

Expert Solution

Answer 10

a.

Expert Solution

Answer 11

Expert Solution

Answer 12

b.

To determine

Identify whether the management would recommend dropping any product.

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

Answer 13

b.

To determine

Identify whether the management would recommend dropping any product.

Answer 14

b.

Expert Solution

Explanation of Solution

Identify whether the management would recommend dropping any product.

It would be recommended by the management to drop Creamy Crunch, based on the gross profit margin rule, and the table above. 50% of the factory space is used by the product Creamy Crunch, and so it is allocated half of the rent costs. When compared to the two products, the selling price is comparitively low. These are the two characteristics which make this product appear relatively unprofitable.

Answer 15

b.

Expert Solution

Answer 16

b.

Expert Solution

Answer 17

Expert Solution

Answer 18

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)

Table (12)

Hence, in decision making, too much of allocated cost numbers are not to be made.

Answer 19

c.

To determine

Identify whether any of the remaining products should be dropped from the product line.

Answer 20

c.

Expert Solution

Explanation of Solution

Identify whether any of the remaining products should be dropped from the product line.

	Almond Dream		Krispy Krackle
Direct labor hours per case		7		3
Machine hours per case		2		7
Factory space (in sq.ft.) (1)	2,000	(33.3%)	4,000	(66.7%)
Case of output per month	2,000		1,000
Labour hours required	14,000	(82.4)	3,000	(17.6%)
Machine hours required	4,000	(36.4)	7,000	(63.6%)

Table (6)

Note (1):

4,000 square feet of space will be left available by this product mix.

Total rent for factory space:	$15,000 per month
Total machine operating costs:	$30,000 per month
Total other overhead:	$24,500 per month ($69,500−$15,000−$30,000)
Total cases produced per month	3,000 cases
Total labor hours per month	17,000
Total machine hours	11,000 hours

Table (7)

Product allocation base:

Fraction:	Labor (%)	Machine hours (%)	Factory Space (%)
Almond Dream	82.4%	36.4%	33.3%
Krispy Krackle	17.6	63.6	66.7

Table (8)

Allocated costs:

Allocated costs:		Total	Per Case
Almond Dream ($24,500×82.4%)+($30,000×36.4%)+($15,000×33.3%)	=	$36,108	$18.05
Krispy Krackle ($24,500×17.6%)+($30,000×63.6%)+($15,000×66.7%)	=	33,392	33.39

Table (9)

Allocated Production Costs:

	Almond Dream	Krispy Krackle
Material cost	$8.00	$2.00
Direct labor	42.00	18.00
Allocated overhead	18.05	33.39
Production cost per case	$68.05	$53.39
Selling price (b)	$85.00	$55.00
Product cost	(68.05)	(53.39)
Profit (loss) (a)	$16.95	$1.61
Profit margin ratio (c) = (a/b)	19.9%	2.9%

Table (10)

The management should continue to produce Almond Dream, and should Drop Frispy Krackle, based on the gross profit margins of Krispy Krackle, and Almond Dream. The most profitable product is likely to be Almond Dream. However, its margin ratio is only 13.9%.

Calculate the margin ratio of Almond Dream:

	Almond Dream
Material cost	$8.00
Direct labor	42.00
Allocated overhead	23.17
Production cost per case	$73.17
Selling price (b)	$85.00
Product cost	(73.17)
Profit (loss) (a)	$11.83
Profit margin ratio (c) = (a/b)	13.9%

Table (11)

Almond Dream, and Krispy Krackle are found to be equally profitable, if the gross margin for the three products are computed at maximum production:

		Almond Dream	or	Krispy Krackle	or	Creamy Crunch
Cases		3,000		3,000		3,000
Costs
Materials		$ 24,000		$ 6,000		$ 27,000
Labor		126,000		54,000		18,000
Overhead	+	69,500	+	69,500	+	69,500
		$219,500		$129,500		$114,500

Revenue		$255,000		$165,000		$105,000
Total costs	–	219,500	–	129,500	–	114,500
Gross margin		$ 35,500		$ 35,500		$ (9,500)