1 | Budgeted income statement | |||||
$ | $ | |||||
Sales | 308500 | |||||
Less: Cost of goods sold | 71600 | |||||
Gross profit | 236900 | |||||
Less:selling and administrative expenses | ||||||
Salaries expense | 13000 | |||||
Rent expense | 5500 | |||||
Insurance expense | 1300 | |||||
Depreciation expense | 500 | |||||
Supplies expense | 6170 | 26470 | ||||
Income before tax | 210430 | |||||
Less: Income tax expense | 40000 | |||||
Net income | 170430 | |||||
2 | ||||||
Budgeted balance sheet | ||||||
$ | ||||||
Assets | ||||||
Current assets: | ||||||
Cash | (Note:1) | 116480 | ||||
Accounts receivable | (Note:2) | 69000 | ||||
Raw materials inventory | (Note:3) | 13000 | ||||
Finished goods inventory | (Note:4) | 9050 | ||||
Total | A | 207530 | ||||
Property,plant and equipment: | ||||||
Equipment | (145000+41000) | 186000 | ||||
Less: Accumulated depreciation | (65000+1500+500) | 67000 | ||||
Equipment (net) | B | 119000 | ||||
Total assets | A+B | 326530 | ||||
Laibilities and stockholder's equity | ||||||
Current labilities | ||||||
Accounts payable | (Note:5) | C | 14400 | |||
Stockholder's equity: | ||||||
Common stock | 100000 | |||||
Retained earnings | (41700+170430) | 212130 | ||||
Total stockholder's equity | D | 312130 | ||||
Total laibilities and stockholder's equity (C+D) | 326530 | |||||
Note:1-Cash balance | ||||||
$ | $ | |||||
Beginning balance | 18000 | |||||
Add: | ||||||
Cash receipts from customers | 262300 | |||||
280300 | ||||||
Less: | ||||||
Direct material purchase paid-(36000*60%) | 21600 | |||||
Direct labor | 14000 | |||||
Manufacturing overhead: | ||||||
Variable manufacturing overhead | 2900 | |||||
Insurance and property taxes | 1050 | |||||
Selling and administrative expense: | ||||||
Salaries expense | 13000 | |||||
Rent expense | 5500 | |||||
Insurance expense | 1300 | |||||
Supplies expense | 6170 | |||||
Income tax expense | 40000 | |||||
Accounts payable-Beginning balance | 17300 | |||||
Payment for capital expenditures | 41000 | 163820 | ||||
Ending balance | 116480 | |||||
Note:2- Accounts receivable balance | ||||||
$ | ||||||
Beginning balance | 22800 | |||||
Add: Sales on account | 308500 | |||||
331300 | ||||||
Less: Cash receipt from customers | 262300 | |||||
Ending balance | 69000 | |||||
Note:3-Raw materials inventory balance | ||||||
$ | ||||||
Beginning balance | 13000 | |||||
Add: raw materials purchased | 36000 | |||||
49000 | ||||||
Less: Materials used | 36000 | |||||
Ending balance | 13000 | |||||
Note:4-Finished goods inventory balance | ||||||
$ | $ | |||||
Beginning balance | 25200 | |||||
Add: Total manufacturing cost | ||||||
Direct materials used | 36000 | |||||
Direct labor cost | 14000 | |||||
Budgeted manufacturing overhead: | ||||||
Variable manufacturing overhead | 2900 | |||||
Depreciation | 1500 | |||||
Insurance and property taxes | 1050 | 55450 | ||||
80650 | ||||||
Less: Cost of goods sold | 71600 | |||||
Ending balance | 9050 | |||||
Note:5-Accounts payable | ||||||
$ | $ | |||||
Beginning balance | 17300 | |||||
Add: Direct material purchase-36000*40% | 14400 | |||||
31700 | ||||||
Less: beginning balance paid | 17300 | |||||
Ending balance | 14400 |
i Data Table -X1 Credit Vinson Company Post-Closing Trial Balance December 31, 2018 Account Debit Cash...
P22-40A (book/static) Bradley Company has the following post-dosing trial balance on December 31 2018 11! (Click the icon to view the post-closing trial balance) The company's accounting department has gathered the following budgeting information for the first quarter of 2019 Click the icon to view the budgeting information ) Additional information a Direct materials purchases are paid 70% in the quarter purchased and 30% in the next quarter b. Direct labor, manufacturing overhead, selling and administrative costs, and income tax...
Need help with the second part! Please! Sosa Company has the following post-closing trial balance on December 31, 2018 E (Click the icon to view the post-closing trial balance.) The company's accounting department has gathered the following budgeting information for the first quarter of 2019 E (Click the icon to view the budgeting information.) Additional information: a. Direct materials purchases are paid 70% in the quarter purchased and 30% in the next quarter, b. Direct labor, manufacturing overhead, selling and...
Dump Company Post-Closing Trial Balance December 31, 2016 Account Debit Credit Cash $ Accounts Receivable 27,000 18,000 18,000 Merchandise Inventory 1,500 50,000 12,000 Prepaid Insurance Equipment and Fixtures Accumulated Depreciation Accounts Payable Salaries and Commissions Payable Common Stock 21,000 6,600 23,000 51,900 Retained Earnings $ 114,500 $ 114,500 Totals For the Quarter Ended March 31, 2017 Sales Revenue $ 121,700 60,850 Cost of Goods Sold Gross Profit Selling and Administrative Expenses: 60,850 Commissions Expense 6,085 5,000 Salaries Expense Rent Expense...
Read the requirements Requirement 2. Prepare Huber Company's budgeted balance sheet as of March 31, 2019. Huber Company Budgeted Balance Sheet March 31, 2019 Assets Current Assets Cash 10000 Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets Property, Plant, and Equipment: Equipment Less Accumulated Depreciation Total Assets Liabilities Current Liabilities Accounts Payable Stockholders' Equity Common Stock 50000 Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Questo any has th 1 Data Table e icon to...
On December 31, Harris Company had the following adjusted trial balance: Account Titles Debit Credit Cash 11,580 9,370 5,250 42,200 Accounts Receivable Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Capital Stock Retained Earnings Dividends Sales 8,000 28,740 20,500 22,800 15,900 70,100 Sales Discounts Sales Returns and Allowances Cost of Goods Sold Selling Expenses General and Administrative Expenses 640 2,140 42,060 10,300 10,700 150,140150,140 Required Prepare the second closing entry to close the expense accounts and contra-revenue accounts to Income Summary...
ang Company has provided the following budget information for the first quarter of 2018: Click the icon to view the budget information.) Additional data related to the first quarter of 2018 for Vang Company (Click the icon to view the data.) Read Х More Info Requirement 1. Prepare Vang Company's schedule of cash receipts from customers and schedule of cash payments for th Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash...
Hinton Company Adjusted Trial Balance At December 31 Account Debit Credit $ Cash Accounts Receivable 19,331.600 2,990,000 530,000 23.400 3,000,000 $ 150.000 930.000 58,400 230.000 33,000 970.000 21,600,000 Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Accounts Payable Uneamed Service Revenue Wages Payable Interest Payable Notes Payable Common Stock Dividends Service Revenue Wage Expense Utilities Expense Selling Expense Administrative Expense Repairs Expense insurance Expense Interest Expense Supplies Expense Depreciation Expense--Equipment 45.000 3,754,000 730.400 96.100 45.100 130,000 37.000 19.800 40.000 557.000 150,000 $...
i Data Table Irvine Inn Company Unadjusted Trial Balance December 31, 2018 Balance Account Title Debit Credit Cash 15,600 Accounts Receivable 13.900 2.600 Prepaid Insurance 1,700 Office Supplies 410.000 Building Print Done $ 370,000 4,300 Accumulated Depreciation-Building Accounts Payable Salaries Payable Unearned Revenue Common Stock 3,200 53,860 1.800 18.200 Dividends Service Revenue Salaries Expense Insurance Expense Depreciation Expense-Building 3.200 En A -- 3,200 53,860 1,800 18,200 Unearned Revenue Common Stock Dividends Service Revenue Salaries Expense Insurance Expense Depreciation Expense–Building Advertising...
Balance Sheet December 31, 2018 Assets Current Assets: Cash Accounts Receivable Raw Materials Inventory 66,000 35,000 6,800 11.600 119,400 Finished Goods Inventory Total Current Assets Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation 142,000 (106,000) 36,000 155,400 Total Assets Liabilities 5,000 Current Liabilities: Accounts Payable Stockholders' Equity Common Stock, no par $ Retained Earnings Total Stockholders' Equity 110,000 40,400 150,400 Total Liabilities and Stockholders' Equity $ 155,400 1. Prepare Gilder's operating budget and cash budget for 2019 by quarter. Required...
i Data Table Stone Sign Company Adjusted Trial Balance January 31, 2018 Balance Account Title Debit Credit Cash 15,400 Office Supplies 1,500 Prepaid Rent 1,400 Equipment 60,000 Accumulated Depreciation Equipment $ 7,000 Accounts Payable 3,800 Salaries Payable 100 Unearned Revenue 4,200 Notes Payable (long-term) 4,300 Common Stock 48,800 Dividends 800 $ Print Done X Х Data Table - 1,400 60,000 $ 7,000 3,800 100 Prepaid Rent Equipment Accumulated Depreciation Equipment Accounts Payable Salaries Payable Unearned Revenue Notes Payable (long-term) Common...