Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and...

70.2K

Verified Solution

Question

Finance

Budgeted Income Statement and Balance Sheet

As a preliminary to requesting budget estimates of sales, costs,and expenses for the fiscal year beginning January 1, 20Y9, thefollowing tentative trial balance as of December 31, 20Y8, isprepared by the Accounting Department of Regina Soap Co.:

Cash$113,800
Accounts Receivable223,000
Finished Goods46,800
Work in Process31,200
Materials51,300
Prepaid Expenses3,800
Plant and Equipment523,500
Accumulated Depreciation—Plant and Equipment$225,100
Accounts Payable202,100
Common Stock, $10 par250,000
Retained Earnings316,200
$993,400$993,400

Factory output and sales for 20Y9 are expected to total 27,000units of product, which are to be sold at $100 per unit. Thequantities and costs of the inventories at December 31, 20Y9, areexpected to remain unchanged from the balances at the beginning ofthe year.

Budget estimates of manufacturing costs and operating expensesfor the year are summarized as follows:

Estimated Costs and Expenses
    Fixed
(Total for Year)
    Variable
(Per Unit Sold)
Cost of goods manufactured and sold:
Direct materials_$25
Direct labor_8
Factory overhead:
  Depreciation of plant and equipment$27,000_
  Other factory overhead8,4004.5
Selling expenses:
Sales salaries and commissions96,90012.5
Advertising81,000_
Miscellaneous selling expense7,0002
Administrative expenses:
Office and officers salaries63,7006.5
Supplies3,2001
Miscellaneous administrative expense1,7001.5

Balances of accounts receivable, prepaid expenses, and accountspayable at the end of the year are not expected to differsignificantly from the beginning balances. Federal income tax of$229,200 on 20Y9 taxable income will be paid during 20Y9. Regularquarterly cash dividends of $1 per share are expected to bedeclared and paid in March, June, September, and December on 25,000shares of common stock outstanding. It is anticipated that fixedassets will be purchased for $141,000 cash in May.

Required:

1. Prepare a budgeted income statement for20Y9.

Regina Soap Co.
Budgeted Income Statement
For the Year Ending December 31, 20Y9
$
Cost of goods sold:
$
Cost of goods sold
Gross profit$
Operating expenses:
Selling expenses:
$
Total selling expenses$
Administrative expenses:
$
Total administrative expenses
Total operating expenses
Income before income tax$
$

2. Prepare a budgeted balance sheet as ofDecember 31, 20Y9.

Regina Soap Co.
Budgeted Balance Sheet
December 31, 20Y9
Assets
Current assets:
$
Inventories:
$
Total current assets$
Property, plant, and equipment:
$
Total property, plant, and equipment
Total assets$
Liabilities
Current liabilities:
$
Stockholders' Equity
$
Total stockholders’ equity
Total liabilities and stockholders’ equity$

Answer & Explanation Solved by verified expert
3.8 Ratings (669 Votes)
    See Answer
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!
Become a Member

Transcribed Image Text

Budgeted Income Statement and Balance SheetAs a preliminary to requesting budget estimates of sales, costs,and expenses for the fiscal year beginning January 1, 20Y9, thefollowing tentative trial balance as of December 31, 20Y8, isprepared by the Accounting Department of Regina Soap Co.:Cash$113,800Accounts Receivable223,000Finished Goods46,800Work in Process31,200Materials51,300Prepaid Expenses3,800Plant and Equipment523,500Accumulated Depreciation—Plant and Equipment$225,100Accounts Payable202,100Common Stock, $10 par250,000Retained Earnings316,200$993,400$993,400Factory output and sales for 20Y9 are expected to total 27,000units of product, which are to be sold at $100 per unit. Thequantities and costs of the inventories at December 31, 20Y9, areexpected to remain unchanged from the balances at the beginning ofthe year.Budget estimates of manufacturing costs and operating expensesfor the year are summarized as follows:Estimated Costs and Expenses    Fixed(Total for Year)    Variable(Per Unit Sold)Cost of goods manufactured and sold:Direct materials_$25Direct labor_8Factory overhead:  Depreciation of plant and equipment$27,000_  Other factory overhead8,4004.5Selling expenses:Sales salaries and commissions96,90012.5Advertising81,000_Miscellaneous selling expense7,0002Administrative expenses:Office and officers salaries63,7006.5Supplies3,2001Miscellaneous administrative expense1,7001.5Balances of accounts receivable, prepaid expenses, and accountspayable at the end of the year are not expected to differsignificantly from the beginning balances. Federal income tax of$229,200 on 20Y9 taxable income will be paid during 20Y9. Regularquarterly cash dividends of $1 per share are expected to bedeclared and paid in March, June, September, and December on 25,000shares of common stock outstanding. It is anticipated that fixedassets will be purchased for $141,000 cash in May.Required:1. Prepare a budgeted income statement for20Y9.Regina Soap Co.Budgeted Income StatementFor the Year Ending December 31, 20Y9$Cost of goods sold:$Cost of goods soldGross profit$Operating expenses:Selling expenses:$Total selling expenses$Administrative expenses:$Total administrative expensesTotal operating expensesIncome before income tax$$2. Prepare a budgeted balance sheet as ofDecember 31, 20Y9.Regina Soap Co.Budgeted Balance SheetDecember 31, 20Y9AssetsCurrent assets:$Inventories:$Total current assets$Property, plant, and equipment:$Total property, plant, and equipmentTotal assets$LiabilitiesCurrent liabilities:$Stockholders' Equity$Total stockholders’ equityTotal liabilities and stockholders’ equity$

Other questions asked by students