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)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Memphis Company anticipates total sales for April, May, and June of $990,000 $1,090,000, and $1140,000 respectively. Cash sales are normally 20% of total sales. of the credit sales, 35% are collected in the same month as the sale, 60% are collected during the first month after the sale, and the remaining 5% are not collected. Compute the amount of cash received from credit sales during the month of May.
A company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May.$ Calculate credit sales for June.$ Calculate credit sales for July.$ Calculate credit sales for August.$ Feedback 2. Prepare a schedule of cash receipts for July and August. Round your answers to the nearest whole dollar, if necessary. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers. Bennett Inc.Schedule of Cash ReceiptsFor July and August July…
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
Walton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet Walton expects sales in January year 1 to total $260,000 and to Increase 15 percent per month in February and March All sales are on account. Walton expects to collect 67 percen of accounts receivable in the month of sale, 21 percent in the month following the sale, and 12 percent in the second month following the sole Required a. Prepare a sales budget for the first quarter of year 1 b. Determine the amount of sales revenue Walton will report on the year 1 first quarterly pro forma Income statement. c. Prepare a cash receipts schedule for the first quarter of year 1 d. Determine the amount of accounts receivable as of March 31, your 1 Complete this question by entering your answers In Use tabs below. Required A Required B Required C Required D Prepare a cash receipts schedule for the first quarter of year (out road…
The management of Vuti has supplied the following sales amounts for the next five months: January February March April May R60 000 R75 000 R55 000 R65 000 R50 000 Additional information: • Off all sales 35% are cash sales based in value. • Of credit sales 50% is collected within the month of sales. Two-thirds of the credit sales collected within the month of sales receives 2% discount. A further 30% of credit sales is collected in the following month; and the remaining credit sales is collected in the month thereafter. Bad debts amounts to 3% of the credit sales. Required: Prepare a debtor's collection schedule that clearly shows how credit sales for the five months will be collected. NB: Round off calculations to two decimal places and the final amount to the nearest value.
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 33 29 26 23 21 21 a. Fifty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $23 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.) b. Suppose that from the start of the year the company stretches payables by paying 50% after one month and 30% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)
Top Sdn Bhd had cash of RM13,000 on hand together with trade debtors outstanding balance of RM55,000 as at January 1. During the year, the company expected the following sales to customers by quarter, with collection terms of 50% in cash and 50% in credit receivable in the next quarter: First Second Third Fourth Sales (RM) 110,000 245,000 122,400 149,600 Direct materials purchases in metric tons (MT) costing RM 50.00 per MT payable in the same quarter are as follows: First Second Third Fourth Direct Materials Purchases (MT) 1,300 1,500 1,100 1,000 The production budget showed the following unit production by quarter with an average labour wage rate of RM40.00 payable in the same quarter: First Second Third Fourth Units to be produced 1,500 2,000 1,700 1,500 Top Sdu Bhd planned to pay dividends of RM10,000 per quarter during the year. In July, a new equipment costing RM60,000 will be purchased. An additional cost of RM16,000 was planned for its installation during the fourth quarter.…
The table contains the Sales estimates for the next year. The Purchases are 55% of Sales. Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan 87,400 July 21,931 Feb 89,751 Aug 78,038 Mar 78,038 Sep 87,400 Apr 21,931 Oct 78,038 May 87,400 Nov 89,751 June 89,751 Dec 21,931
The following sales and purchases are expected over the Four-month period from December to March Purchases Sales December OMR 30000 OMR 26000 January OMR 25000 OMR 30000 February OMR 24000 OMR 24000 March OMR 26000 OMR 28000 Additional Information: 1. Wages are paid each month of OMR 2000, which are paid in month that they are incurred 2. 30% of the Sales are on credit - and we allow one-month credit period - and 70% of the sales for immediate settlement 3. 40% of the Purchases are on credit - and 1 month credit period - and 60% of the purchases are for immediate settlement 4. The balance of cash as at 1 January was OMR 9000 If the company is preparing a budget from January to March, what will be the Closing balance of cash on March ? Select one: a. OMR 7800 b. OMR 7200 c. OMR 5800