Concept explainers
Preparing a financial budget−
Learning Objective 4
1. NI $166,100
2. FG inventory $3,150
Bradley Company has the following post-closing
BRADLEY COMPANY Post-Closing Trial Balance December 31, 2018 |
||
Account | Debit | Credit |
Cash | $15,000 | |
23,200 | ||
Raw Materials Inventory | 11,000 | |
Finished Goods Inventory | 25,900 | |
Equipment | 125,000 | |
$35,000 | ||
Accounts Payable | 13,600 | |
Common Stock | 150,000 | |
1,500 | ||
Totals | $200,100 | $200,100 |
The company’s accounting department has gathered the following budgeting information for the first quarter of 2019:
Budgeted total sales, all on account | $305,000 |
Budgeted direct materials to be purchased and used | 32,000 |
Budgeted direct labor cost | 12,500 |
Budgeted |
|
Variable manufacturing overhead | 2,100 |
Depreciation | 1,300 |
Insurance and property taxes | 1,350 |
Budgeted selling and administrative expenses: | |
Salaries expense | 7,000 |
Rent expense | 2,000 |
Insurance expense | 1,100 |
Depreciation expense | 550 |
Supplies expense | 15,250 |
Budgeted cash receipts from customers | 263,500 |
Budgeted income tax expense | 41,000 |
Budgeted purchase and payment for capital expenditures (additional equipment) | 43,000 |
Additional information:
a. Direct materials purchases are paid 70% in the quarter purchased and 30% ii the next quarter.
b. Direct labor, manufacturing overhead, selling and administrative costs, and income tax expense are paid in the quarter incurred.
c. Accounts payable at December 31, 2018 are paid in the first quarter of 2019.
Requirements
1. Prepare Bradley Company’s budgeted income statement for the first quarter of 2019.
2. Prepare Bradley Company’s budgeted balance sheet as of March 31, 2019.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Accounting, The Financial Chapters (12th Edition)
- eBook Print Item Question Content Area Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,831 Direct labor 75,200 73,300 Manufacturing overhead 25,400 25,200 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,392 240,154 Cash payments for purchases 114,300 119,252 Additional data:Capital assets were sold in January for $11,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $- Select - $- Select - Add: Cash Receipts - Select - -…arrow_forwardRequired Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash Accounts receivable 129,808 Inventory 52,508 217,000 Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity ps payable 347,808 Retained earnings Total liabilities and stockholders' equity 488,508 TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise…arrow_forwardRequired Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash $82,000 Accounts receivable Inventory 52,5ee 217,000 Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable 78,000 Common stock 347.000 55,500 Retained earnings Total liabilities and stockholders' equity TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300.000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40%…arrow_forward
- do not give solution in image formatarrow_forwardRequired Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash $ 82,000 Accounts receivable Inventory 52,500 Plant and equipment, net of depreciation 217,880 Total assets $ 488.500 Liabilities and Stockholders' Equity Accounts payable $ 78,000 Common stock 347,880 55,580 Retained earnings Total liabilities and stockholders' equity $ 480,500 TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales.…arrow_forwardRequired Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash $ 82,000 Accounts receivable Inventory 129,000 52,500 Plant and equipment, net of depreciation 217,000 Total assets $ 480,500 Liabilities and Stockholders' Equity Accounts payable $ 78,000 Common stock 347,000 Retained earnings Total liabilities and stockholders' equity TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company…arrow_forward
- Q.Prepare the revenues budget for the year 2018.arrow_forwardttps://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com... Homework Problems i September-actual October-actual November-estimated December-estimated Total estimated for the current year Saved Units 40,000 60,000 80,000 50,000 800,000 Barnum Distributors wants a projection of cash receipts and cash payments for the month of November. On November 28, a note will be payable in the amount of $98,500, including interest. The cash balance on November 1 is $29,600. Accounts payable to merchandise creditors at the end of October were $217,000. The company's experience indicates that 70 percent of sales will be collected during the month of sale, 20 percent in the month following the sale, and 7 percent in the second month following the sale; 3 percent will be uncollectible. The company sells various products at an average price of $11 per unit. Selected sales figures are as follows. Help Budgeted operating expenses for…arrow_forwardanswer first and second sub parts please do it in excelarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education