1. Cash at bank on 1 January 2021 amounted to R155 000. 2. Projected sales per quarter for 2021: First quarter R450 000 Second quarter R750 000 Third quarter R870 000 Fourth quarter R880 000 Sixty percent (60%) of the sales are for cash and forty percent (40%) are on credit. Cash customers are entitled to a 5% cash discount. 3. Collection of credit sales: • 55% of the credit sales are collected in the quarter of the sale. • 35% is collected in the following quarter and the balance is written off as a bad debt.

1. Cash at bank on 1 January 2021 amounted to R155 000. 2. Projected sales per quarter for 2021: First quarter R450 000 Second quarter R750 000 Third quarter R870 000 Fourth quarter R880 000 Sixty percent (60%) of the sales are for cash and forty percent (40%) are on credit. Cash customers are entitled to a 5% cash discount. 3. Collection of credit sales: • 55% of the credit sales are collected in the quarter of the sale. • 35% is collected in the following quarter and the balance is written off as a bad debt.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

South Rims has an accounts receivable balance at the end of 2018 of $357,470. The net credit sales for the year are $769,346. The balance at the end of 2017 was $325,300. What is the accounts receivable turnover rate for 2018 (rounded to two decimal places)? A. 2.02 times B. 2.25 times C. 2.15 times D. 1.13 times
1. Cash at bank on 1 January 2023 amounted to R200 000.2. Projected sales for the first four months of 2023:January R220 000February R600 000March R720 000April R850 000Fifty percent (50%) of the sales are for cash and fifty percent (50%) are on credit. Cash customers are entitled to a 5% cash discount.23. Collection of credit sales:· 60% of the credit sales are collected in the month of the sale.· 30% is collected in the following month and the balance is written off as a bad debt.4. Purchases for the first four months of 2023 are expected to be as follows:January R100 000February R150 000March R160 000April R180 000All purchases are on credit. 50% of the purchases will be paid for in the month of purchase and the remaining 50% in the following month.5. Fixed overheads total R200 000 per year and are paid for equally each month.6. Administrative expenses are paid for in the month in which they are incurred and are estimated at a total of R10 000 per monthAn investment of R200 000…
Please provide answer in text (Without image)
Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 21 3\ 4 Cash sales 32 41 35 31 Sales on credit 185 205 175 155 On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in whole dollars not in thousands of dollars.) Expected Cash Collections Month 3 Month 4 < Prev 3 of 8 Next search
Use the information provided below to prepare the following for January and February 2023:Debtors Collection Schedule The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 0004.26. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000.…
16. On December 31,2021, the Denjay Gift Shop had outstanding accounts receivable balance of P20,000. Denjay's sales are roughly evenly split between credit and cash sales, with half the credit sales collected in the month after sale and the remainder two months after the sale. historical and projected sales for the gift shop are: Month Sales October 2021 150,000 November 2021 200,000 December 2021 300,000 January 2022 (projected) 400,000 How much did Denjay realized during January from sales and collection?
15. On December 31,2021, the Denjay Gift Shop had outstanding accounts receivable balance of P20,000. Denjay's sales are roughly evenly split between credit and cash sales, with half the credit sales collected in the month after sale and the remainder two months after the sale. historical and projected sales for the gift shop are: Month Sales October 2021 150,000 November 2021 200,000 December 2021 300,000 January 2022 (projected) 400,000 Under the circumstances what should the balance in accounts receivable be at the end of January 2022?
Projector Limited has the following projection for the 4 months ending August 2018:MayJuneJulyAugustR’sR’sR’sSales320 000380 000420 000460 000Purchases160 000160 000230 000250 000Rent income11 00011 000??Salaries26 80026 800??1. 50% of the sales are for cash and the balance is on credit.2. All credit sales are collected one month after the sale.3. All purchases are on credit. Creditors are paid in full one month after the month of purchase.4. The tenants rent contract stipulates an increase of 20% from 1 July 2018.5. Salaries are expected to increase to R32 000 per month as at 1 August 2018.6. A new motor vehicle will be purchased during June 2017. Repayments of R6 000 per month will commence on 1 July 2017.7. Advertising costs are expected to be 2% of sales from 1 June 2018.8. A fixed deposit of R25 000 will mature in the month of July 2018.9. On 31 May 2018, the bank is expected to have a favourable balance of R420 000.Required:Prepare a Cash Budget for the three (3) months ending…
9. Company S purchased 1,000 units raw materials amounting to $5,000 and used $4,500 worth for the production during the current month. The standard price for these raw materials is $5.2 per unit. How much is the materials price variance for the current month if Company S analyzes the variance at the point of purchase? O $200 favorable O $200 unfavorable O $700 favorable O $700 unfavorable 10. T Corporation is authorized to issue 500,000 common stock at $10 par value. As of December 31, 2019 the corporation has 350,000 common stock issued and outstanding. On February 14, 2020, the market price of the stock is $17. On the same date, T Corporation acquired 50,000 stocks at $15. On March 5, 2020, the company reissued 25% of the treasury stocks at $20. Which of the following will be included in the entry to record the transaction on March 5, 2020? Debit Treasury Shares $187,500 Debit Common Stock $250,000 O Credit Additional Paid-in Capital $62,500 O Credit Cash $250,000
Use the information provided below to prepare the following for January and February 2023:4.1 Debtors Collection Schedule INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 000 6. Fifty percent (50%) of the purchases are…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. 04 $480 Sales 01 $ 210 02 $ 270 a. Accounts receivable at the beginning of the year are $480. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables $ Beginning receivables S Sales Cash collections Ending receivables 03 $ 330 Beginning receivables Sales Cash collections Ending receivables Q1 S Q1 480 210 585 105 $ 01 Answer is complete and correct. 480 210 $ 00 480 210 Q2 105 $ 270 b. Accounts receivable at the beginning of the year are $480. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Sales Q1 $ 540 Q2 $ 570 Q3 Q4 $ 630 $ 780 a. Accounts receivable at the beginning of the year are $300. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 b. Accounts receivable at the beginning of the year are $300. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables Q1 540 Q2 570 Q3 630 Q4 780 c. Accounts receivable at the beginning of the year are $300. The company…