ABC Company has a cash balance of $40,000 on August 1 and requires a minimum ending cash balance of $28,960. Cash receipts from sales budgeted for August are $210,960. Cash disbursements budgeted for August include inventory purchases, $32,000; other manufacturing expenses, $52,000; operating expenses, $43,000; bond retirements, $65,000; and dividend payments, $30,000. Required: Prepare a cash budget for ABC Company for August.

ABC Company has a cash balance of $40,000 on August 1 and requires a minimum ending cash balance of $28,960. Cash receipts from sales budgeted for August are $210,960. Cash disbursements budgeted for August include inventory purchases, $32,000; other manufacturing expenses, $52,000; operating expenses, $43,000; bond retirements, $65,000; and dividend payments, $30,000. Required: Prepare a cash budget for ABC Company for August.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget…
Crane Company expects to have a cash balance of $36,000 on January 1,2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $68,000, February $120,000.Payments for direct materials: January $40,000, February $60,000.Direct labor: January $24,000, February $36,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $16,800, February $20,000. These costs include depreciation of $1,200 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $12,000, February $16,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $9,600 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $20,000. The company wants to maintain a minimum monthly cash balance of $16,000. Prepare a cash budget for January and February. ReceiptsCollections from…
Flint, Inc. provided the following information: Projected merchandise purchases . March April $67,000 $75,000 Budgeted cash disbursements $ Flint pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $25,000 per month of which depreciation is $2,000 of this amount. Flint pays operating expenses in the month incurred. Calculate Flint's budgeted cash disbursements for May. May $81,000
Dorel Company expects to have a cash balance of $5,000 on January 1, 2013. Relevant monthly budget data for the first two months of 2013 are as follows: 1. Collections from customers: January $60,000; February $75,000 2. Sales of marketable securities in January are expected to realize $10,000 in cash. 3. Purchase delivery truck in January and paid cash $12,000. 4. Payments to suppliers: January $15,000; February $25,000 5. Direct labour: January $25,000; February $20,000. Wages are paid in the month they are incurred. 6. Manufacturing overhead: January $8,000; February $7,000. These costs include depreciation of $3,000 per month. All other overhead costs are paid as incurred. 7. Selling and administrative expenses: January $10,000; February $12,000. These costs are excluşive of depreciation. They are paid as incurred. Dorel Company has a line of credit at a local bank. It can borrow up to $20,000 at 4% per annum, The company wants to keep a minimum monthly cash balance of $15,000
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month January February March April May Credit Sales $ 300,000 (actual) 400,000 (actual) 559,000 (estimated) 556,000 (estimated) 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale Collections one month after the sale. Collections two months after the sale Uncollectible accounts. 50% 30 Cash balance on March 31 Cash balance on April 30 Cash balance on May 31 15 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1.200,000 (an average of $400.000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash…
From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…
Assume a company is preparing a budget for its first two months of operations. During the first and second months it expects cash sales of $34,000 and $50,000, respectively. It also expects credit sales of $60,000 and $70,000, respectively. The companyvexpects to collect 60% of its credit sales in the month of the sale, 35% in the following month, and 5% is deemed uncollectible. What amount of cash collections would appear in the company's cash budget for the first month
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
Give me correct answer and explanation.
D’s Company Ltd expects to have a cash balance of $45000 on March 1, 2024.Relevant monthly budget data for the months of March and April are as follows:• Collections from customers: March $85000; April $150000• Payments for direct materials: March $50000; April $75000• Direct labour: March $30000; April $45000. Wages are paid in the month they are incurred.• Manufacturing overhead: March $21000; April $25000. These costs include depreciation of$1500 per month. All other overhead costs are paid as incurred.• Selling and administrative expenses: March $15000; April $20000. These costs are exclusive ofdepreciation. They are paid as incurred.• Sales of marketable securities in March are expected to be realised $12000 in cash.D’s Company Ltd. has a line of credit at a local bank that enables it to borrow up to$25000. Thecompany wants to maintain a minimum monthly cash balance of $20000. prepare cash budgets for march n april 2024