A company estimates the following sales demand from Jan- July 2021: Sales (Units) 150,000 180,000 120,000 240,000 210,000 180,000 240,000 Month Jan Feb March April May June July Cash sales account for 50% of the total sales. Debtors are granted 2 months credit, of which half is collected in the month following sales, and the other half after 2 months. Determine the collection from sales in each of the months from April – June 2021. Explain how the credit policy offered by a company affects the budgeting exercise. (All workings must be clearly shown)

A company estimates the following sales demand from Jan- July 2021: Sales (Units) 150,000 180,000 120,000 240,000 210,000 180,000 240,000 Month Jan Feb March April May June July Cash sales account for 50% of the total sales. Debtors are granted 2 months credit, of which half is collected in the month following sales, and the other half after 2 months. Determine the collection from sales in each of the months from April – June 2021. Explain how the credit policy offered by a company affects the budgeting exercise. (All workings must be clearly shown)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 9PA: Fitbands estimated sales are: What are the balances in accounts receivable for January, February,...

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
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…
As of January 1, 2021, NUBD Co. had an accounts receivable of P500,000. The sales for January, February, and March were as follows: P1,200,000, P1,400,000, and P1,600,000, respectively. Of each month’s sales, 80% is on account. 60% of account sales is collected in the month of sale, with remaining 40% collected in the following month. What is the accounts receivable balance as of March 31, 2021? A. P720,000 B. P480,000 C. P587,200 D. P512,000
DEF has total forecasted gross purchases of P4,500,000 relating to a major supplier for the coming year. The supplier is offering a credit term of 3/15, n/45. How much is the simple annual effective cost of paying on the 45th day?
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
Wonderland Company estimates sales (in $) for 2021 for the four quarters as follows : Q1 Q2 Q3 Q4 Sales $ 200 $ 300 $ 250 $ 400 The accounts receivable at the beginning of 2021 is $ 120. The account receivable collection period is 45 days. Purchases from suppliers by Wonderland Company for each quarter are 60% of the estimated sales for the next quarter. Sales for Q1 2022 are $ 350. Payments to suppliers are the same as purchases from the previous period (quarter). Each month is assumed to have 30 days. Salaries, taxes and other expenses are estimated at 20% of sales. Interest and dividend expenses are $ 20 each quarter. Capital expenditure for business expansion in 2021 is planned for the second quarter for $ 100. The management of Wonderland Company has a policy to maintain a minimum cash balance (minimum cash balance) of $ 10 each quarter, and in early 2021 there is no cash balance. Question: a. Calculate the cash inflow and cash outflow…
Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
Tauros Company’s usual sales terms are net 60 days, FOB Shipping point. Sales, net of returns and allowances, totaled P2,300,000 for the year ended December 31, 2022, before year-end adjustments. Additional data are as follows: · On December 27, 2022, Taurus authorized a customer to return, for full credit, goods shipped and billed at P50,000 on December 15, 2022. The returned goods were received by Taurus on January 4, 2023, and a P50,000 credit memo was issued and recorded on the same date. · Goods with an invoice amount of P80,000 were billed and recorded on January 3, 2023. The goods were shipped on December 30, 2022. · Goods with an invoice amount of P100,000 were billed and recorded on December 30, 2022. The goods were shipped on January 3, 2023. The adjusted net sales for 2022 should be? a. 2,300,000b. 2,250,000c. 2,230,000d. 2,070,000
Maelstrom limited sells only on credit. They started business in June 2021. The sales are collected as follows: 46% in the current month, 28% in the following month, and 10% two months following the sale Sales for the first six months of operation are expected to be: June 21,101; July 22,162; August 20,486; September 27,766; October 26,537 and November 29,411. Predict the total sales expected to be collected in July. Calculate to two decimal places.
Aston Company reported the following balances at September 30, 2020:Sales Revenue $280,000Sales Returns and Allowances 13,000Sales Discounts 5,000Cost of Goods Sold 160,500Calculate the Net sales for the month.
1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month Total sales July Rp 28.000,00 August 35.000,00 September 42.000,00 Payment terms are set: 3/20/net 30. Based on the experience of the customer's payment method as follows: 60% of sales every month is collected at 20 days after the month of pend. 30% accumulated in the time after 20 days in the same month, i.e. in the first month after the month of Dec. 10% collected in the second month after the month of Dec. Required: prepare a schedule/budget for collection of receivables (receivables collection budget)