Question

Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5)

[The following information applies to the questions displayed below.]

FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements.

		Type of Box
	C				P
Direct material required per 100 boxes:
Paperboard ($0.34 per pound)		50	pounds			90	pounds
Corrugating medium ($0.17 per pound)		40	pounds			50	pounds
Direct labor required per 100 boxes ($14.00 per hour)		0.35	hour			0.70	hour

The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 410,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours.

Indirect material	$	12,450
Indirect labor		82,190
Utilities		34,500
Property taxes		23,000
Insurance		18,000
Depreciation		36,500
Total	$	206,640

The following selling and administrative expenses are anticipated for the next year.

Salaries and fringe benefits of sales personnel	$	118,500
Advertising		24,500
Management salaries and fringe benefits		139,000
Clerical wages and fringe benefits		41,000
Miscellaneous administrative expenses		6,400
Total	$	329,400

The sales forecast for the next year is as follows:

	Sales Volume				Sales Price
Box type C		415,000	boxes		$	135.00	per hundred boxes
Box type P		415,000	boxes			195.00	per hundred boxes

The following inventory information is available for the next year. The unit production costs for each product are expected to be the same this year and next year.

	Expected Inventory January 1			Desired Ending Inventory December 31
Finished goods:
Box type C	14,000	boxes		9,000	boxes
Box type P	24,000	boxes		19,000	boxes
Raw material:
Paperboard	17,000	pounds		7,000	pounds
Corrugating medium	7,000	pounds		12,000	pounds

Prepare a master budget for FreshPak Corporation for the next year. Assume an income tax rate of 40 percent.

1. Prepare the sales budget for the next year. (Round "Sales price per unit" to 2 decimal places.)

2. Prepare the production budget for the next year.

3-a. Prepare the direct-material budget for paperboard.
3-b. Prepare the direct-material budget for corrugating medium.

4. Prepare the direct-labor budget for the next year. (Do not round intermediate calculations. Round "Direct labor required per box (hours)" to 4 decimal places.)

5. Prepare the production-overhead budget for the next year.

6. Prepare the selling and administrative expense budget for the next year.

7. Prepare the budgeted income statement for the next year. (Do not round intermediate calculations.)

I have finished all but 7!

Answer 1

Calcultaion of Predetermined manufacturing Overhead rate

Estimated Overhead   $206,640

Estimated Direct Labor hour 4305 hours [(0.35 * 410000/100) + (0.7 * 410000/100)]

Predetermined Overhead Rate 48

Calculation of Manufacturing Cost per unit: C Box P Box

Direct Material:

Paperboard     0.170 (50/100 * .34) 0.306 (90/100 * .34)

Corrugating medium 0.068 (40/100 * .17) 0.085 (50/100 * .17)

Direct labor 0.049 (.35/100 * 14) 0.098 (.70/100 * 14)

Applied Manufacturing overhead   0.168 (48/100 * .35) 0.336 (48/100 * .70)

Manufacturing Cost per unit 0.455     0.825

Budgeted Income Statement:-

Sales Revenue 1,369,500 [(415000/100 *135) + (415000/100 *195)]

Less: Cost of Goods Sold 531,200 [(415000 * 0.455) + (415000 * 0.825)]

Gross Margin 838,300

Less: Selling and Administrative expenses 329,400

Income before Taxes 508,900

Income Tax Expenses (40%) 203,560

Net Income 305,340

If you like the answer, kindly give a ?.