Question

Problem 21-3A (Part Level Submission) Hill Industries had sales in 2016 of $6,880,000 and gross profit of $1,192,000. Management is considering two alternative budget plans to increase its gross profit in 2017. Plan A would increase the selling price per unit from $8.00 to $8.40. Sales volume would decrease by 10% from its 2016 level. Plan B would decrease the selling price per unit by $0.50. The marketing department expects that the sales volume would increase by 107,000 units. At the end of 2016, Hill has 43,000 units of inventory on hand. Ir Plan A is accepted, the 2017 ending inventory should be equal to 5% of the 2017 sales. Ir Plan B is accepted, the ending inventory should be equal to 60,000 units. Each unit produced will cost $1.80 in direct labor, $1.40 in direct materials, and $1.20 in variable overhead. The fixed overhead for 2017 should be $1,995,000. (a) your answer is partially correct. Try again. Prepare a sales budget for 2017 under each plan. (Round Unit selling price answers to 2 decimal places, e.g. 52.70.) HILL INDUSTRIES Sales Budget Plan B Expected unit sales 952000 Unit selling price 17 Total sales T 7215000 Click if you would like to Show Work for this question: Open Show Work

Answer 1

Correct Answer:

Hill Industries
Sales Budget
For the year ended December 2017
	Plan A	Plan B
Expected unit sale	$          7,74,000	$          9,67,000
Units selling price	$                   8.40	$                   7.50
Total sale	$        65,01,600	$        72,52,500

Working:

Total sale in the year 2016 = $ 6,880,000 at $ 8 per unit, therefore total number of units sold in the year 2016 = (6880000/8) = 860,000

Number of unit sold in 2017 plan A = 860,000 * 0.90 = 774,000 units at $ 8.40 per unit

Plan B, number of units sold = 860,000+ 107000 = 967000 units at $ 7.50 per unit

End of answer.

Please give a thumbs-up, it will be highly appreciated.

Thanks.