Concept explainers
Prepare a

Answer to Problem 3BP
Company B | ||
Cash Budget | ||
For the Month Ended November 30 | ||
Particulars | $ | $ |
Cash balance at beginning of month | 37,200 | |
Add: Receipts | ||
Collections on receivables ( refer Schedule A – Table 2) | 820,000 | |
Sale of fully | 9,000 | 829,000 |
Total cash available | 866,200 | |
Less: Payments | ||
Payments for purchases of merchandise (refer Schedule B – Table 3) | 477,000 | |
Payments on operating expenses (10) | 185,000 | |
Payment on note payable | 102,250 | 764,250 |
Cash balance at end of month | 101,950 |
Table (1)
Therefore, the cash balance at the end of the November is $101,950.
Explanation of Solution
Budget:
Budget is an effective tool to achieve the financial and operational goals of the business. Budget is the key element of the financial planning and it assists managers to control the business cost. Management should set the budgeted amount at reasonable and achievable levels.
Prepare the schedule of cash collections on accounts receivable, and cash payments for purchases of merchandise as follows:
Schedule A:
Schedule A—Collections on Receivables in November | $ |
September sales (1) | 15,000 |
October sales (2) | 175,000 |
November sales (3) | 630,000 |
Total collections on receivables | 820,00 |
Table (2)
Schedule B:
Schedule B—Payments for Purchases of Merchandise | $ |
On October purchases (8) | 217,000 |
On November purchases (9) | 269,500 |
Total payments for purchases of merchandise | 486,500 |
Table (3)
Working note:
Calculate the cash received from the September sales
Calculate the cash received from the October sales
Calculate the cash received from the November sales
Calculate the inventory (units) at the end of the September
Calculate the inventory (units) at the end of the October
Calculate the inventory (units) at the end of the November
Calculate the number of units purchased and cost of purchase for the each months
Particulars |
Units (A) |
Cost of per unit (B) |
Purchases |
Inventory at end of September (4) | 9,000 | ||
Add: Purchases in October | 72,000 | $7 | $432,000 |
Available for sale in October | 81,000 | ||
Less: Sales in October | 70,000 | ||
Inventory at end of October | 11,000 | ||
Add: Purchases in November | 87,000 | $7 | $522,000 |
Available for sale in November | 98,000 | ||
Less: Sales in November (estimated) | 90,000 | ||
Inventory at end of November | 8,000 |
Table (4)
(7)
Calculate the cash paid for the merchandise purchase for the month October
Calculate the cash paid for the merchandise purchase for the month November
Calculate the operating expense under cash budget
Want to see more full solutions like this?
Chapter 23 Solutions
Financial & Managerial Accounting With Connect Plus Access Code: The Basis For Business Decisions
- A trial balance will balance even if A. a journal entry to record the purchase of equipment for cash of $52100 is not posted. B. a $13100 cash dividend is debited to dividends for $13100 and credited to cash for $1310. C. a $510 collection on accounts receivable is credited to accounts receivable for $510 without a corresponding debit. D. a purchase of supplies for $595 on account is debited to supplies for $595 and credited to accounts payable for $559.arrow_forwardEquipment costing $15200 is purchased by paying $3800 cash and signing a note payable for the remainder. The journal entry to record this transaction should include a credit to Notes Payable. credit to Notes Receivable. credit to Equipment. debit to Cash.arrow_forwardAt December 1, 2025, a company's Accounts Receivable balance was $20160. During December, the company had credit sales of $54000 and collected accounts receivable of $43200. At December 31, 2025, the Accounts Receivable balance is A. $30960 debit. B. $30960 credit. C. $74160 debit. D. $20160 debit.arrow_forward
- Whispering Winds Corp.'s trial balance at the end of its first month of operations reported the following accounts and amounts with normal balances: Cash $14720 Prepaid insurance 460 Accounts receivable 2300 Accounts payable 1840 Notes payable 2760 Common stock 4600 Dividends 460 Revenues 20240 Expenses 11500 Total credits on Whispering Winds Corp's trial balance are A. $28980. B. $30360. C. $29900. D. $29440arrow_forwardSwifty Corporation's trial balance reported the following normal balances at the end of its first year: Cash $14440 Prepaid insurance 530 Accounts receivable 2660 Accounts payable 2130 Notes payable 3190 Common stock 4100 Dividends 530 Revenues 22040 Expenses 13300 What amount did Swifty Corporation's trial balance show as total credits? A. $31460 B. $32520 C. $30930 D. $31990arrow_forwardMonty Inc., a major retailer of high-end office furniture, operates several stores and is a publicly traded company. The company is currently preparing its statement of cash flows. The comparative statement of financial position and income statement for Monty as at May 31, 2020, are as The following is additional information about transactions during the year ended May 31, 2020 for Monty Inc., which follows IFRS. Plant assets costing $69,000 were purchased by paying $47,000 in cash and issuing 5,000 common shares. In order to supplement its cash, Monty issued 4,000 additional common shares. Cash dividends of $35,000 were declered and paid at the end of the fiscal year. create direct method cash flow statement, show your workarrow_forward
- Following is additional information about transactiona during the year ended May 31, 2020 for Monty Inc., which follows IFRS. Plant assets costing $69,000 were purchased by paying $47,000 in cash and issuing 5,000 common shares. In order to supplement iRs cash, Monty Issued 4,000 additional common shares. Cash dividends of $35,000 were declared and paid at the end of the fiscal year. PRepare a direct Method Cash FLow using the format.arrow_forwardmake a trail balancearrow_forwardOn July 31, 2025, the general ledger of Cullumber Legal Services Inc. showed the following balances: Cash $4,960, Accounts Receivable $1,860, Supplies $620, Equipment $6,200, Accounts Payable $5,080, Common Stock $4,340, and Retained Earnings $4,220. During August, the following transactions occurred. Aug. 3 5 Collected $1,490 of accounts receivable due from customers. Received $1,610 cash for issuing common stock to new investors. 6 Paid $3,350 cash on accounts payable. 7 Performed legal services of $8,060, of which $3,720 was collected in cash and the remainder was due on account. 2 2 2 2 2 12 Purchased additional equipment for $1,490, paying $500 in cash and the balance on account. 14 Paid salaries $4,340, rent $1,120, and advertising expenses $340 for the month of August. 18 20 24 26 27 Collected the balance for the services performed on August 7. Paid cash dividend of $620 to stockholders. Billed a client $1,240 for legal services performed. Received $2,480 from Laurentian Bank;…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





