Please draft a budgeted receipt schedule from debtors for the period of 1 January 2023 to 30 June 2023. Month of 2023 Budgeted total sales: 1. January 140 000 2. February 132 000 3. March 128 000 4. April 115 000 5. May 120 000 6. June 150 000 Additional information: Total sales for September 2022, October 2022, November 2022 and December 2022 were R 120 000, R128 000 and R134 000 and R140 000 respectively. The goods sold on credit were 60% of actual sales. Customers will pay their debt as follows: ⚫ 0% in the first month after the month of sale ⚫ 60% in the second month after the month of sale ⚫ 30% in the third month after the month of sale ⚫ 10% in the fourth month after the month of sale

Please draft a budgeted receipt schedule from debtors for the period of 1 January 2023 to 30 June 2023. Month of 2023 Budgeted total sales: 1. January 140 000 2. February 132 000 3. March 128 000 4. April 115 000 5. May 120 000 6. June 150 000 Additional information: Total sales for September 2022, October 2022, November 2022 and December 2022 were R 120 000, R128 000 and R134 000 and R140 000 respectively. The goods sold on credit were 60% of actual sales. Customers will pay their debt as follows: ⚫ 0% in the first month after the month of sale ⚫ 60% in the second month after the month of sale ⚫ 30% in the third month after the month of sale ⚫ 10% in the fourth month after the month of sale

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter8: Budgets And Bank Reconciliations

Section: Chapter Questions

Problem 2.3C

See similar textbooks

Similar questions

Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
Budgeted selling and administrative expenses for King Tire Co. In P7-2 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expense budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-2, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 40%.
Relevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.
Light Up Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2020. (Click the icon to view the additional information.) All sales are made on account with 70% of sales made in a quarter collected in the same quarter and 30% collected in the following quarter. Calculate the cash collected from receivables in each of the 4 quarters of 2020. (If an input field is not used in the table, leave the input field empty; do not enter a zero.) Schedule of Cash Collections Accounts receivable balance on 1-1-2020 (Fourth-quarter sales from prior year) From first-quarter 2020 sales From second-quarter 2020 sales From third-quarter 2020 sales From fourth-quarter 2020 sales Total collections 1 2 Quarters 3 4
REQUIRED Use the information provided below to prepare the following for Protea Limited for January, February and March 2023: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION Protea Limited is in the process of formulating plans for the first quarter of 2023. 1. The following sales figures show the growth expected: Year Month 2022 December 2023 January 2023 February 2023 March 2. 3. Sales R460 000 R560 000 R640 000 R720 000 7. Forty percent (40%) of the sales is expected to be for cash and the balance is on credit. Twenty percent (20%) of the credit sales is expected to be collected in the month of the sale and 75% in the month after the sale. The remaining 5% is usually written off as bad debts. Debtors who settle their accounts in the month of the sale are entitled to a 5% discount. 4. The purchase of inventory is the company's largest expenditure and the cost of these items equals 60% of the current month's sales (excluding any discounts). Sixty percent (60%) of the…
The following information pertains to Yoyo Projects for the three months ended 31 May 2020: Actual Budgeted March R April R May R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional Information: It is expected that debtors will settle their accounts as follows: 20 % in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of invoice The remaining 5% is usually written off as bad Trade creditors are paid in the month after purchase at a discount of 5%. 50% of the salaries and wages are weekly wages. Since wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were Expenses are paid as they The favourable…
Use the information provided below to prepare the following for November and December 2021: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION The following budgeted information was provided by Sentinel Enterprises: 1. The expected bank balance on 31 October 2021 is R20 000 (favourable). 2. Credit sales are forecast as follows: October 2021 November 2021 December 2021 R280 000 R240 000 R320 000
The following information pertains to Omega Projects Ltd for the three months ended 31 December 2020. Actual Budgeted October November December R R R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional information: It is expected that debtors will settle their accounts as follows: 20% in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of The remaining 5% is usually written off as bad Trade creditors are paid in the month after the purchases at a discount of 5%. 50% of the salaries and wages are weekly wages. Because wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were…
Splish Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. 19 Sales: 27,900 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $6 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 14,100 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $201,000 Income taxes: 30% of income before income taxes
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Required:Prepare a Cash Budget for the period 1 November and 31 December 2018
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available:Actual BudgetedAugust RSeptember ROctober RNovember RDecember RSales:CashCredit194 500287 300235 700350 000275 000410 000250 500400 400368 000697 000Purchases 510 000 490 000 495 000 520 000 680 000Salaries & Wages 72 600 72 600 72 600 72 600 72 600Sundry Expenses 17 800 18 400 22 000 22 600 25 700Additional information:1. Cash in respect of credit sales is collected as follows: 50% within 30 days 30% within 60 days 15% within 90 days The balance is written off as irrecoverable. BAD DEBT - IGNORE2. The following discounts are allowed on sales: 10% on cash sales 7.5% on credit sales if accounts are settled within 30 days.3. All salaries, wages and sundry expenses are paid in cash.4. Sundry expenses include depreciation of R4 200 per month. Exclude depreciation5. Seventy-five (75%) of all purchases are on credit and paid within 30 days. The balance is paid…
АCTIVITY From the following information obtained from the books of Maruti LLC, prepare cash budget for the quarter ending 30h June 2020. Sales (OMR) 80,000 Purchase (OMR) Wages (OMR) Expenses (OMR) 5,000 Month January February March 45,000 20,000 18,000 22,000 24,000 80,000 40,000 42,000 6,000 6,000 April May June 80,000 90,000 85,000 80,000 50,000 45,000 35,000 7,000 20,000 18,000 6,000 5,000 Special information 1. Advance payment of income tax in May OMR 4,000. 2. Purchase of plant in April OMR 10,000 3. Rent OMR 300 payable each month 4. 10% of purchase and sales are in cash terms 5. Credit purchases are paid after one month and credit sales are collected after 2 months 6. Time lag in wages and expenses ½ month 7. Cash and bank balance on April 1st OMR 13,000