FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
The treasurer of U Co. has accumulated the budget information presented in the table for the months of March and April pertaining to cash payments. Thirty percent of the merchandise costs are expected to be paid in the month they are incurred and the remaining seventy percent in the following month. All of the operating expenses are paid for by cash in the month they are incurred. The accounts payable balance on March 1 is $30,000.
What is the amount to include in the
|
MARCH |
APRIL |
Merchandise costs |
$60,000 |
$66,000 |
Operating expenses |
50,000 |
55,000 |
Group of answer choices
$62,400
$55,000
$50,000
$30,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Maniarrow_forwardThe 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: Sales 116,000 Manufacturing Costs 49,000 Selling and administrative expenses 34,000 Capital expenditures - June: Sales 143,000 Manufacturing costs 61,000 Selling and administrative expenses 39,000 Capital expenditures - July: Sales 186,000 Manufacturing Costs 67,0000 Selling and administrative expenses 41,000 Capital expenditures 45,000 The company expects to sell about 15% of his merchandise for cash of sales account 65% are expected to be collected in the month following the sale and the remainder of the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,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…arrow_forwardRiff, Inc. is working on its cash budget for June. The budgeted beginning cash balance is $27,000. Budgeted cash receipts total $199,000 and budgeted cash disbursements total $198,000. The desired ending cash balance is $62,000. The excess (deficiency) of cash available over disbursements for June will be:arrow_forward
- Oivas Corporation is preparing its cash budget for September. The budgeted beginning cash balance is $46,000. Budgeted cash seceipts total $160,000 and budgeted cash disbursements total $152,000. The desired ending cash balance is $70,000. The company can borrow up to $120,000 at any time from a local bank, with interest not due until the following month. What is the amount required to borrow in order to have the desired ending cash balance? Oa $15,000 Ob $10,000 Oc $26,000 Od $16,000arrow_forwardA company is preparing its cash budget. Its cash balance on January 1 is $290,000, and it has a minimum cash requirement of $340,000. The following data have been provided: January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 984,500 1,210,000 1,075,000 The amount of the deficiency or excess cash (after considering the minimum cash balance required) for January is a(n) a.excess of $60,000 b.deficiency of $136,700 c.excess of $356,700 d.excess of $26,700arrow_forwardPrepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total.arrow_forward
- Bramble Company expects to have a cash balance of $43,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $81,600, February $144,000. Payments for direct materials: January $48,000, February $72,000. Direct labor: January $28,800, February $43,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $20,160, February $24,000. These costs include depreciation of $1,440 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $14,400, February $19,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.520 in cash. Bramble Company has a line of credit at a local bank that enables it to borrow up to $24,000. The company wants to maintain a minimum monthly cash balance of $19,200. Prepare a cash budget for January and February.arrow_forwardAssets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity Minden Company Balance Sheet April 30 $ 9,000 54,000 30,000 207,000 $300,000 $ 63,000 14,500 180,000 42,500 $300,000arrow_forwardPresented below are summary financial data from Pebble Company’s annual report: Assume that the Pebble Company is all equity financed. Calculate the following ratios for Years 1 and 2: Return on equity, Return on assets (levered), Return on sales (levered), Total asset turnover, Financial leveragearrow_forward
- The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit Sales May $59,000 $283,000 June $43,000 $236,000 July $33,000 $205,000 August $47,000 $268,000 September $46,000 $197,000 Additional information to be used determining the expected cash collections each month that will be used in preparing the cash budget: Collections on Credit sales: 50% in month of sale 20% in month following sale 30% in second month following sale The Accounts Receivable balance on May 1 was $53,000. Of this amount, $41,000 represented uncollected April sales and $12,000 represented uncollected March sales. Part 1: What is the expect cash to be collected in May? Part 2: The budgeted Accounts Receivable on September 1 would be: (195500, 202900, 178900, 224900, OR 173300)arrow_forwardUse the following Information to prepare the July cash budget for Acco Company. Ignore the "Loan activity" section of the budget a. Beginning cash balance on July 1: $72,000. b. Budgeted cash receipts from sales: 25% is collected in the month of sale, 50% In the next month, and 25% in the second month after sale. Sales amounts are May (actual), $1,830,000; June (actual), $1,490,000; and July (budgeted), $1,600,000. c. Budgeted cash payments on merchandise purchases: 80% in the month of purchase and 20% in the month following purchase. Purchase amounts are June (actual), $560,000; and July (budgeted), $730,000. d. Budgeted cash payments for salaries in July: $180,000. e. Budgeted cash payments for sales commissions for July: $110,000. f. Budgeted cash payment for Income taxes In July: $100,000. g. Budgeted cash payment for loan Interest in July: $5,500. Complete this question by entering your answers in the tabs below. Calculation Cash Budget Prepare the July cash budget for Acco…arrow_forwardThe following is the sales budget for Lemonis, Incorporated, for the first quarter of 2021: January February March Sales budget $198,000 $218,000 $241,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $82,000 ($52,000 of which was uncollected December sales). a. Calculate the sales for November. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the sales for December. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. Calculate the cash collections from sales for each month from January through March. (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. November sales b. December sales c. January cash collections c. February cash collections c.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- 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
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education