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 (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_forwardManagement Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.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
- Business Studies / Business Math / Semester 2, 2020/2021 / BUSINESS MATH M Cost of an item is OMR 335, If the markup is 28% on the cost, find the selling price; ed O a. OMR 93.8 rked out of 1.00 O b. OMR 126 O. OMR 241.2 Next page 2g question O d. OMR 429 Course Orientation Business Math Jump to... TOSHIBAarrow_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
- ttps://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_forwardBUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…arrow_forwardRequired Information TES-417 Inc. is a retaller. 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 Accounts receivable Inventory 129,880 52, see 217,000 Plant and equipment, net of depreciation. Total assets $ 480.500 Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings 55, see 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. The company pays for…arrow_forward
- *CAN YOU ANSWER PART 4* Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30. The following information is available Deacon CompanyBalance SheetMarch 31 Assets Cash $ 68,200 Accounts receivable 42,000 Inventory 63,400 Buildings and equipment, net of depreciation 122,000 Total assets $ 295,600 Liabilities and Stockholders’ Equity Accounts payable $ 96,400 Common stock 70,000 Retained earnings 129,200 Total liabilities and stockholders’ equity $ 295,600 Budgeted Income Statements April May June Sales $ 178,000 $ 188,000 $ 208,000 Cost of goods sold 106,800 112,800 124,800 Gross margin 71,200 75,200 83,200 Selling and administrative expenses 19,000 20,500 23,500 Net operating income $ 52,200 $ 54,700 $ 59,700 Budgeting Assumptions: 60% of sales are cash sales and 40% of sales are credit sales. Twenty…arrow_forward* CengageNOWv2 | Online teachin x .com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $146,000 $185,000 $248,000 Manufacturing costs 61,000 80,000 89,000 Selling and administrative expenses 42,000 50,000 55,000 Capital expenditures 60,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 85% are expected to be…arrow_forwardSales Compr April 30 Assets Cash Arcounts receivable $13,500 Inventory 38,500 40-750 Buildings and equipment, net of depreciation Total assets 202.000 $319,750 Accounts payable Note payable 567.750 $15.500 Common stock 150,000 Retained earnings 36,200 Total Habilities and stockholders' equity $319,756 The company is in the process of preparing a budget for May and has assembled the following date Sales are budgeted at $263,000 for May. Of these sales, $78.900 will be for cash: the remainder will be credit sales. One-half of a moth's credit sales are allacial in the the s remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May Purchases of inventory are expected to total $193,000 during May. These purchases will all be on account Forty percent of all purchases are paid for in the month of pchar, the following month. All of the April 30 accounts payable to suppliers will be paid during May The May 31 inventory balance is budgeted at…arrow_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