The budgeted transactions of Beacon Limited for the quarter ending 31 December 2021 are as follows: Budgeted total sales amount to R546 000. (25% will be sold during October, 40% during November and the rest during December) 75% of all sales are expected to be on credit. Debtors are expected to pay their debts as follows: 60% in the month following the month of the sale 25% in the second month following the month of the sale 10% in the third month following the month of the sale 5% is written off as irrecoverable Actual total sales for the quarter ending 30 September 2021 were as follows: July R66 000 August R96 000 September R132 000 REQUIRED Prepare a schedule showing the total budgeted amounts which Beacon Limited expects to receive from debtors during each month from 1 October 2021 to 31 December 2021

The budgeted transactions of Beacon Limited for the quarter ending 31 December 2021 are as follows: Budgeted total sales amount to R546 000. (25% will be sold during October, 40% during November and the rest during December) 75% of all sales are expected to be on credit. Debtors are expected to pay their debts as follows: 60% in the month following the month of the sale 25% in the second month following the month of the sale 10% in the third month following the month of the sale 5% is written off as irrecoverable Actual total sales for the quarter ending 30 September 2021 were as follows: July R66 000 August R96 000 September R132 000 REQUIRED Prepare a schedule showing the total budgeted amounts which Beacon Limited expects to receive from debtors during each month from 1 October 2021 to 31 December 2021

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

See similar textbooks

Similar questions

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…
The following information is applicable to Shine Wholesalers for the year 2020: Budgeted sales: July August September • In October 2020, sales are expected to increase by 20% relative to sales in September 2020. • Cash sales amount to 20% of total sales. • 55% of all credit sales are collected in the month of sale, with a discount of 10% to those debtors who pay during this time. The outstanding credit sales are collected in equal instalments over the next two months. There are no bad debts. Purchases of raw materials are expected to be sufficient to meet 60% of the total sales for the next month. The company normally settles half of its creditors in the month following the month of purchase. The remaining creditors are paid two months after the month of purchase. Wages and salaries are paid to employees at the end of the month in which they are earned. Wages and salaries are expected to be: June July ● R105 000 R132 000 R165 000 August September October R22 200 R20 500 R23 500 R26 500…
The following information is applicable to Shine Wholesalers for the year 2020: Budgeted sales:July R105 000August R132 000September R165 000 In October 2020, sales are expected to increase by 20% relative to sales in September 2020. Cash sales amount to 20% of total sales. 55% of all credit sales are collected in the month of sale, with a discount of 10% to those debtors who pay during thistime. The outstanding credit sales are collected in equal instalments over the next two months. There are no bad debts. Purchases of raw materials are expected to be sufficient to meet 60% of the total sales for the next month. The companynormally settles half of its creditors in the month following the month of purchase. The remaining creditors are paid twomonths after the month of purchase. Wages and salaries are paid to employees at the end of the month in which they are earned. Wages and salaries areexpected to be:June R22 200July R20 500 Required:Prepare a cash budget for Shine…
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the beginning accounts receivable balance of March? P 80,000 P120,000 P180,000 P200,000 Group of answer choices 1 2 3 4
An entity is budgeting its cash payments for the last quarter of 2020. All purchases are made on account with 2% discount for early payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase, availing of the purchase discount; 45% are paid the next month; and 5% are paid after 2 months from date of purchase. How much is the total cash payment to be made in December 2020?
Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the ending accounts receivable balance of March? P 80,000 P120,000 P180,000 P200,000
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the beginning accounts receivable balance of March? P 80,000 P120,000 P180,000 P200,000
The following is the sales budget for Coore, Inc., for the first quarter of 2019: January February March Sales budget $142,000 $159,000 $174,000 Credit sales are collected as follows: 70 percent in the month of the sale25 percent in the month after the sale5 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales). c. Compute the cash collections from sales for each month from January through March. (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)
ABC Farm is preparing a collection budget for the year. Sales are expected to be P100,000 in January; P200,000 in February; and P300,000 in March. Approximately 60% of the sale is collected during the month of sale and the other 40% is collected in the following month. What is the ending accounts receivable balance of March? P 80,000 P120,000 P180,000 P200,000 Group of answer choices 1 2 3 4
Cash point Ltd prepares quarterly budget as part of the budgetary control system. During the last quarter ending 31st March 2020 the following information is accumulated concerning operations for the next quarter ending 30th June 2020. Sales which are all on credit will amount to Kshs 400,000 in April 2020 the same level as in February and March 2020, increasing at 10% per month for the next six months and thereafter at 5% Sales credit terms are strictly 30 days after-sales. Past experience shows that this policy is effective in 75% of cases. Of the remainder, 20% will pay in subsequent month and 5% never pay up until after 180 days. Inventories are maintained at equivalent of 15 days sales. On 31st March 2020 the inventory level is estimated at Kshs125,000. Goods are bought and paid for within 30 days. During March 2020, merchandise purchases amounted to Kshs 250,000 The unit selling price is Kshs 100 with a profit margin of 40% on sales. The cash balance on 31st March 2020 is Kshs…
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April 10,000 14,000 11,000 15,000 May 18,000 June 20,000 Unit sales Shalom Company sells the product at P15 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. On December 31, 2022, accounts receivable was P60,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) How much is the expected total cash receipts for January?