Chapter 21, Problem 21.3BPR

Budgeted income statement and supporting budgets

The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March 2016:

1. a. Estimated sales for March:

Batting helmet	1,200 units at $40 per unit
Football helmet	6,500 units at $160 per unit

1. b. Estimated inventories at March 1:

Direct materials:		Finished products:
Plastic	90 lbs.	Batting helmet........	40 units at $25 per unit
Foam lining	80 lbs.	Football helmet.......	240 units at $77 per unit

1. c. Desired inventories at March 31:

Direct materials:	Finished products:
Plastic50 lbs.	Batting helmet.........	50 units at $25 per unit
Foam lining65 lbs.	Football helmet........	220 units at $78 per unit

1. d. Direct materials used in production:

In manufacture of batting helmet:
Plastic	1.20 lbs. per unit of product
Foam lining	0.50 lb. per unit of product
In manufacture of football helmet:
Plastic	3.50 lbs. per unit of product
Foam lining	1.50 lbs. per unit of product

1. e. Anticipated cost of purchases and beginning and ending inventor)’ of direct materials:

Plastic	$6.00 per lb.
Foam lining	$4.00 per lb.

1. f. Direct labor requirements:

Batting helmet:
Molding Department	0.20 hr. at $20 per hr.
Assembly Department	0.50 hr. at $14 per hr.
Football helmet:
Molding Department	0.50 hr. at $20 per hr.
Assembly Department	1.80 hrs. at $14 per hr.

1. g. Estimated factory overhead costs for March:

Indirect factory wages	$86,000	Power and light	$4,000
Depreciation of plant and equipment	12,000	Insurance and property tax	2,300

1. h. Estimated operating expenses for March:

Sales salaries expense	$184,300
Advertising expense	87,200
Office salaries expense	32,400
Depreciation expense—office equipment	3,800
Telephone expense—selling	5,800
Telephone expense—administrative	1,200
Travel expense-—selling	9,000
Office supplies expense	1,100
Miscellaneous administrative expense	1,000

1. i. Estimated other income and expense for March:

Interest revenue	$940
Interest expense	872

1. j. Estimated tax rate: 30%

Instructions

1. 1. Prepare a sales budget for March.
2. 2. Prepare a production budget for March.
3. 3. Prepare a direct materials purchases budget for March.
4. 4. Prepare a direct labor cost budget for March.
5. 5. Prepare a factory overhead cost budget for March.
6. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be $15,300, and work in process at the end of March is desired to be $14,800.
7. 7. Prepare a selling and administrative expenses budget for March.
8. 8. Prepare a budgeted income statement for March.

To determine

Budgeting is a process to prepare the financial statement by the manager to estimate the organization’s future actions. It is also helpful to satisfy the everyday activities.

To Prepare: The sales budget for the month ending March 31, 2016.

Explanation of Solution

The following table shows the sales budget.

Company G Sales Budget For the Month Ending March 31, 2016
Product and Area	Unit Sales Volume	Unit Selling Price ($)	Total Sales ($)
	(A)	(B)	(A) × (B)
Birdhouse	1,200	40	48,000
Bird feeder	6,500	160	1,040,000
Total Revenue from Sales			1,088,000

Table (1)

To determine

To Prepare: The production budget for the month ending March 31, 2016.

Explanation of Solution

The following table shows the production budget.

Company G Production Budget For the Month Ending March 31, 2016
Details	Units
	Batting Helmet	Football Helmet
Expected Units to be Sold	1,200	6,500
Add: Desired Inventory, March 31	50	220
Total Units Required	1,250	6,720
Less: Estimated Inventory, March 1	(40)	(240)
Total Units to be Produced	1,210	6,480

Table (2)

To determine

To Prepare: The direct materials purchase budget for the month ending March 31, 2016.

Explanation of Solution

The following table shows the direct materials purchase budget.

Company G Direct Materials Purchase Budget For the Month Ending March 31, 2016
Details	Units
	Plastic	Foam Lining
Required units for production:
Batting Helmet	1,452 (1)	605 (2)
Football Helmet	22,680 (3)	9,720 (4)
Add: Desired inventory, March 31	50	65
Total units required	24,182	10,390
Less: Estimated inventory, March 1	(90)	(80)
Total units to be purchased (A)	24,092	10,310
Unit price (B)	$6	$4
Total (A) × (B)	$144,552	$41,240
Total direct materials to be purchased	185,792

Table (3)

Working Notes:

Calculate the direct material (plastic) for batting helmet.

$\begin{array}{c}\text{Direct material (plastic) cost for batting helmet}\text{=}1,210\times 1.20\text{lb}\text{.}\\ =1,452\text{lb}\text{.}\end{array}$ (1)

Calculate the direct material (foam lining) for batting helmet.

$\begin{array}{c}\text{Direct material (foam lining) cost for batting helmet}\text{=}1,210\times 0.50\text{lb}\text{.}\\ =605\text{lb}\text{.}\end{array}$ (2)

Calculate the direct material (plastic) for football helmet.

$\begin{array}{c}\text{Direct material (plastic) cost for football helmet}\text{=}6,480\times 3.50\text{lb}\text{.}\\ =22,680\text{lb}\text{.}\end{array}$ (3)

Calculate the direct material (foam lining) for football helmet.

$\begin{array}{c}\text{Direct material (foam lining) cost for football helmet}\text{=}6,480\times 1.50\text{lb}\text{.}\\ =9,720\text{lb}\text{.}\end{array}$ (4)

To determine

To Prepare: The direct labor cost budget of Company B.

Explanation of Solution

The following table shows the direct labor cost budget for molding and assembly department.

Company B
Direct Labor Cost Budget
For the Month Ending March 31, 2016
Particulars	Molding Department	Assembly Department
Hours Required for Production:
Batting helmet	242 (5)	605 (6)
Football helmet	3,240 (7)	11,664 (8)
Total Hours Required (A)	3,482	12,269
Hourly Rate (B)	$20	$14
Total Cost (A) × (B)	$69,640	$171,766
Total Direct Labor Cost	241,406

Table (4)

Working Notes:

Calculate the hours required for the production of batting helmet in molding department.

$\begin{array}{c}\text{Hours required for production}\text{=}1,210\times 0.20\text{hr}\\ =242\text{hrs}\end{array}$ (5)

Calculate the hours required for the production of batting helmet in assembly department.

$\begin{array}{c}\text{Hours required for production}\text{=}1,210\times 0.50\text{hr}\\ =605\text{hrs}\end{array}$ (6)

Calculate the hours required for the production of football helmet in molding department.

$\begin{array}{c}\text{Hours required for production}\text{=}6,480\times 0.50\text{hr}\\ =3,240\text{hrs}\end{array}$ (7)

Calculate the hours required for the production of football helmet in assembly department.

$\begin{array}{c}\text{Hours required for production}\text{=}6,480\times 1.80\text{hr}\\ =11,664\text{hrs}\end{array}$ (8)

To determine

To Prepare: The factory overhead cost budget of Company G.

Explanation of Solution

The following table shows the factory overhead cost budget.

Company G
Factory Overhead Cost Budget
For the Month Ending March 31, 2016
Particulars	Amount ($)
Indirect factory wages	86,000
Depreciation of plant and equipment	12,000
Power and light	4,000
Insurance and property tax	2,300
Total	104,300

Table (5)

To determine

To Prepare: The cost of goods sold budget of Company G.

Explanation of Solution

The following table shows the cost of goods sold budget.

G Company
Cost of Goods Sold Budget
For the month ending March 31, 2016
Particulars	Amount ($)	Amount ($)	Amount ($)
Finished goods inventory, March 1			19,480 (9)
Work-in-process inventory, March 1		15,300
Direct material:
Direct materials inventory, March 1	860 (10)
Direct materials purchases	185,792
Cost of direct materials available for use	186,652
Less: Direct materials inventory, March 31	(560) (11)
Cost of direct materials placed in production	186,092
Direct labor	241,406
Factory overhead	104,300
Total manufacturing cost		531,798
Total work-in-process during the period		547,098
Less: Work-in-process inventory, March 31		(14,800)
Cost of goods manufactures			532,298
Cost of finished goods available for sale			551,778
Less: Finished goods inventory, March 31			(18,410) (12)
Cost of Goods Sold			533,368

Table (6)

Working Notes:

Calculate the beginning finished goods inventory.

$\begin{array}{c}\text{Beginning finished goods inventory}=\left(40\times \$25\right)+\left(240\times \$77\right)\\ \text{=}\text{\$1,000}\text{+}\text{\$18,480}\\ \text{=}\text{\$19,480}\end{array}$ (9)

Calculate the beginning direct material.

$\begin{array}{c}\text{Beginning}\text{direct mateial purchased}\text{=}\left(90\times \$6\right)+\left(80\times \$4\right)\\ \text{=}\text{\$540}\text{+}\text{\$320}\\ \text{=}\text{\$860}\end{array}$ (10)

Calculate the ending direct material.

$\begin{array}{c}\text{Ending}\text{direct mateial purchased}\text{=}\left(50\times \$6\right)+\left(65\times \$4\right)\\ \text{=}\text{\$300}\text{+}\text{\$260}\\ \text{=}\text{\$560}\end{array}$ (11)

Calculate the ending finished goods inventory.

$\begin{array}{c}\text{Ending finished goods inventory}=\left(50\times \$25\right)+\left(220\times \$78\right)\\ \text{=}\text{\$1,250}\text{+}\text{\$17,160}\\ \text{=}\text{\$18,410}\end{array}$ (12)

To determine

To Prepare: The selling and administrative expenses budget of Company G.

Explanation of Solution

The following table shows the selling and administrative expenses budget.

Company G
Selling and Administrative Budget
For the Month Ending March 31, 2016
Particulars	Amount ($)	Amount ($)
Selling expense:
Sales salaries expense	184,300
Advertising expense	87,200
Telephone expense	5,800
Travel expense	9,000
Total selling expense		286,300
Administrative expense:
Office salaries expense	32,400
Depreciation expense – office equipment	3,800
Telephone expense – Administrative	1,200
Office supplies expense	1,100
Miscellaneous administrative expense	1,000
Total administrative expenses		39,500
Total Operating Expenses	325,800

Table (7)

To determine

To Prepare: The budgeted income statement of Company G.

Explanation of Solution

Prepare the budgeted income statement of Company G.

Company G
Budgeted Income Statement
For the Month Ending March 31, 2016
Particulars	Amount ($)	Amount ($)
Revenue from sales		1,088,000
Less: Cost of goods sold		(533,368)
Gross profit		554,632
Operating expenses:
Selling expenses	286,300
Administrative expenses	39,500
Total operating expenses		(325,800)
Income from operations		228,832
Other revenue and expenses:
Interest revenue	940
Interest expense	(872)	68
Income before income tax		228,900
Income tax expense (30%)		(68,670)
Net Income	160,230

Table (7)