Concept explainers
QUESTION 3- Cash Budgets
Jamieson Ltd is preparing to set up business on 1/7/2022 and has made the following
|
July |
August |
Sept |
Oct |
Nov |
Dec |
Total |
Sales |
$525,000 |
588,000 |
616,000 |
630,000 |
658,000 |
672,000 |
3,689,000 |
Purchases |
$300,000 |
336,000 |
352,000 |
360,000 |
376,000 |
384,000 |
2,108,000 |
The expected selling price is $70 per unit.
The cash collection pattern from debtors is expected to be:
Cash customers - 30% of sales revenue will be for immediate cash and cash discount of 5% will be allowed.
Credit customers - 70% of sales revenue will be from credit customers. These creditors will pay
their bills 50% in month after sale and the remainder in the second month after sale.
The purchases will be paid for 50% in month after purchase when 2% cash discount will be received. The remaining purchases will be paid for in the second month after purchase.
Expected costs: Wages $45,000 per month payable as incurred.
Variable
Fixed overheads (including
Equipment will be purchased in July costing $48,000 which will have a useful life of 5 years. To finance this purchase a loan of $50,000 will be secured at the rate of 10% per annum. Interest to be paid monthly, but capital loan repayments will not commence until January 2023.
You are required to:
- Prepare a schedule of budgeted cash collections for sales for each of the months July to December, 2022.
- (a) Prepare a schedule of budgeted cash disbursements for purchases for each of the months July to December, 2022
- Prepare a
cash budget for six months July to December 2022.
Step by stepSolved in 2 steps with 4 images
- Problem 19-8 Forecasting Payments (LO2) Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows: Sales forecast First $ 396 Quarter 1 2 3 4 Quarter in Coming Year Second Third $ 333 $ 343 Calculate Paymore's cash payments to its suppliers assuming that two-thirds of the purchases are paid for in the quarter that they are purchased and one-third are paid in the following quarter. Note: Do not round intermediate calculations. Round your answers to the nearest whole dollar amount. X Answer is not complete. Payment S 75,000 X Fourth $ 391 Following Year First Quarter $ 391arrow_forwardCash Budget Brindle Arts had the following Cash Budget for Quarter 1, 2022. The company requires a minimum cash balance of $ 50,000 Fill in the missing values: **If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect. January February March Quarter 1 Beginning Cash balance $ 50,000 $ 166,756 $ 50,000 Add cash collections Total cash available $ 662,638 $ 673,643 $ 812,693 $ 1,931,075 Less total cash disbursements: Purchases $ 185,078 $ 189,439 Direct labor $ 86,875 $ 82,875 $ 249,750 Variable manufacturing OH $ 65,156 $ 62,156 $ 187,313 Fixed manufacturing OH $ 83,333 $ 83,333 Variable S&A $ 38,750 $ 43,750 $ 125,000 Fixed S&A $ 38,333 $ 38,333 Equipment $ 150,000 $…arrow_forwardrrarrow_forward
- Problem 5-2 Rancho, Inc. forecasts the following sales for the second quarter of 2020, as well as actual March sales: March (actual) April May June 2nd Q. Total $3,000 $4,000 $5,000 $6,000 $15,000 In addition: The company makes 60% cash sales and 40% credit sales. It collects all credit sales in the month after the sale. The firm budgets $4,400 for monthly operating expenses. That amount includes $400 for depreciation. The firm pays all of its cash-based expenses in the month incurred. Rancho, Inc. had $100 of cash at March 31, 2020, and it must maintain a minimum $500 cash balance at the end of every month to ensure liquidity. The company has a line of credit with its bank that allows borrowing in $100 increments at 12% interest. All borrowing takes place at the beginning of the month in which the company requires cash. The company must repay principal in hundred dollar increments. The credit facility requires Rancho, Inc. to repay all accrued interest to date whenever…arrow_forwardQUESTION 4 REQUIRED Use the information provided by empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection schedule 4.2 Cash Budget INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 february 2024. 2. Budgeted sales figures for 2024 are as follows: January February March April Cash Sales R320 000 R370 000 R310 000 R 250 000 Credit Sales R370 000 R390 000 R320 000 R300 000 3. Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: 80% is collected in the month after sale 20% is collected two months after the sale 4. Purchases of inventory are expected to be as follows: January February March April Total Purchases R410 000 R460 000 R400 000 R380 000 5. Sixty percent (60) of then purchases is for cash to take advantage of a discount of 15%. The balance is purchased on…arrow_forwardNovember December January February March Actual Actual Forecast Forecast Forecast 80 000 150 000 180 000 240 000 300 000 • The cash from sales are received as follows: o 30% in the month of sale o 40% 1 month after sale o 30% 2 months after sale • Purchases are 65% of sales • Cash purchases are made in the following manner: o 20% cash in the month of purchase o 40% 1 month after purchase o 40% 2 months after purchase • Cash dividends of R15 000 was received in January • Rentals of R7 500 are due and paid at the end of each month • The company has 1 salaried employee who is paid each month • Wages incurred and paid equate to 8% of the previous months sales • The company bought a new machine in March for R250 000. Only a deposit of R130 000 was due and payable in March • A provisional tax payment of R30 000 was made at the end the February • R15 000 interest was paid against the company’s bank account in February • Dividends declared at the end of March amounted to R20 000. A 1st payment…arrow_forward
- Question: 129 A company plans to purchase inventory for the second half of 2014 as follows: July $ 1,00,000 August $ 75,000 September $ 2,25,000 October $1,25,000 November $ 2,50,000 December $ 30,000 They usually pay 50% of inventory purchases in the month of purchase, 35% in the following month, and 15% in the second month. Based on the information, what are the forecasted December cash payments? a. $15,000 b. $18,750 c. $87,500 d. $121,250arrow_forwardComplete g cash budget table please and thank youarrow_forwardQuestion 9arrow_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