Preparation of Individual Budgets During the first calendar quarter of 2016, Williams Corporation is planning...
60.1K
Verified Solution
Link Copied!
Question
Accounting
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
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!