90.2K

Verified Solution

Link Copied!

Preparation of Individual Budgets During the first calendar quarter of 2016, Williams Corporation is planning to manufacture a new product and introduce it in two regions. Market research indicates that sales will be 9,000 units in the urban region at a unit price of $65 and 7,000 units in the rural region at $55 each. Because the sales manager expects the product to catch on, she has asked for production sufficient to generate a 5,000-unit ending inventory. The production manager has furnished the following estimates related to manufacturing costs and operating expenses:

			Variable		Fixed
			(per unit)		(total)
Manufacturing costs:
Direct materials
A (2 lb. @ $2.50/lb.)			$5.00		-
B (5 lb. @ $1.40/lb.)			7.00		-
Direct labor (2 hours per unit)			10.00		-
Manufacturing overhead
Depreciation			-		$22,500
Factory supplies			0.55		2,500
Supervisory salaries			-		16,250
Other			0.65		9,200
Operating expenses:
Selling:
Advertising			-		12,500
Sales salaries& commissions*			1.25		20,000
Other*			0.50		4,200
Administrative
Office salaries			-		15,000
Supplies			0.40		1,200
Other			0.25		5,000

*Varies per unit sold, not per unit produced.

a. Assuming that the desired ending inventories of materials A and B are 5,000 and 21,000 pounds, respectively, and that work-in-process inventories are immaterial, prepare budgets for the calendar quarter in which the new product will be introduced for each of the following operating factors:

Do not use negative signs with any of your answers below.

1. Total sales

$Answer

2. Production

Answer units

3. Material purchases cost

				Material A	Material B
Total pounds (lbs.) required for production				Answer	Answer
Desired ending materials inventory				Answer	Answer
Total pounds to be available				Answer	Answer
Beginning materials inventory				Answer	Answer
Total material to be purchased (lbs.)				Answer	Answer
Total material purchases ($)				Answer	Answer

4. Direct labor costs

$Answer

5. Manufacturing overhead costs

			Fixed	Variable	Total
Depreciation			Answer	Answer	Answer
Factory supplies			Answer	Answer	Answer
Supervisory salaries			Answer	Answer	Answer
Other			Answer	Answer	Answer
Total manufacturing overhead					Answer

6. Selling and administrative expenses

			Fixed	Variable	Total
Selling expenses:
Advertising			Answer	Answer	Answer
Sales salaries and commissions			Answer	Answer	Answer
Other			Answer	Answer	Answer
Total selling expenses					Answer
Administrative expenses:
Office salaries			Answer	Answer	Answer
Supplies			Answer	Answer	Answer
Other			Answer	Answer	Answer
Total administrative expenses					Answer
Total selling and administrative expenses					Answer

b. Using data generated in requirement (a), prepare a budgeted income statement for the calendar quarter. Assume an overall effective income tax rate of 35%.

Round answers to the nearest whole number. Do not use negative signs with your answers.

Williams Corporation Budgeted Income Statement For the Quarter Ended March 31, 2016
Sales					Answer
Cost of Goods Sold:
Beginning Inventory - Finished Goods				Answer
Material:
Beginning Inventory - Material			Answer
Material Purchases			Answer
Material Available			Answer
Ending Inventory - Material			Answer
Direct Material			Answer
Direct Labor			Answer
Manufacturing Overhead			Answer
Total Manufacturing Cost				Answer
Cost of Goods Available for Sale				Answer
Ending Inventory - Finished Goods				Answer
Cost of Goods Sold					Answer
Gross Profit					Answer
Operating Expenses:
Selling Expenses				Answer
Administrative Expenses				Answer
Total Operating Expenses					Answer
Income before Income Taxes					Answer
Income Tax Expense					Answer
Net Income					Answer

Answer & Explanation Solved by verified expert

See Answer