A company is working on their budgets for the year 2021. The table below has a few of their expectations for 2021. Accounts Receivable on January 1 Sales in January Sales in February Sales in March Sales in April $35,221 $50,735 $54,654 $58,517 $59,497 Historically, this company's collection pattern for sales has been 16% as cash sales and 84% on account. The sales on account get collected 75% one month following the sale and the remainder two months following the sale. The Accounts Receivable on January 1 is the result of credit sales in December 2020 and thus is expected to be collected according to the sales on account pattern (75%/25%). How much should this company expect in Cash Collections for the month of January? (round to the nearest whole dollar/input code 0)

A company is working on their budgets for the year 2021. The table below has a few of their expectations for 2021. Accounts Receivable on January 1 Sales in January Sales in February Sales in March Sales in April $35,221 $50,735 $54,654 $58,517 $59,497 Historically, this company's collection pattern for sales has been 16% as cash sales and 84% on account. The sales on account get collected 75% one month following the sale and the remainder two months following the sale. The Accounts Receivable on January 1 is the result of credit sales in December 2020 and thus is expected to be collected according to the sales on account pattern (75%/25%). How much should this company expect in Cash Collections for the month of January? (round to the nearest whole dollar/input code 0)

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

Capstone, Inc. is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. Capstone, Inc. gathered the following information from the managers. Sales Unit sales for November 2019 112500 Unit sales for December 2019 104,000 Expected unit sales for January 2020 116,000 Expected unit sales for February 2020 115,500 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 135,000 Expected unit sales for May 2020 145,000 Unit selling price $13.00 Capstone, Inc. likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019,…
Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be $38,000. The company expects credit and cash sales to increase 10% for the month of February. Credit sales are collected in the month following the month in which sales are made. Based on this information, the amount of cash collections in February would be:
The following forecasted information was taken from the books of Pakhama Enterprises. Month 2020 Budgeted Sales(R)January 120 000February 140 000March 168 000April 144 000May 128 000June 100 000 The following information is also provided for Pakhama Enterprises:60% of all sales is on credit.Debtors are expected to pay their debts as follows:• 70% in the first month after the sale (after 30 days)• 20% in the second month after the sale (after 60 days)• 7 % in the third month after the sale (after 90 days)• 3% is irrecoverable Credit losses are written off at the end of the month in which the last instalment is received.Debtors will amount to R104 994 on 1 Jan…
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
In 2021 the company “AROFAH” will prepare a cash budget. The cash receipts and disbursements plan for the first six months (January to June) are as follows: Admission Plan: Sales Receipts: Sales are made in cash as much as 50% and 50% credit of sales. Of credit sales, 60% is received one month after the month of sale and the remaining is received 2 months after the month of sale. The total receipts of receivables in January and February are IDR 200,000 and IDR 300,000, respectively. The acceptance plans are: A. The amount of sales are: B. Other receipts are: January IDR 1,400,000 January IDR 200,000 February IDR 1,500,000 February IDR 300,000 March IDR 1,500,000 March IDR 100,000 April IDR 1,600,000 April IDR 200,000 May IDR 1,700,000 May IDR 400,000 June IDR 1,650,000 June IDR 500,000 2. Expediture Plan : A. Purchase of raw materials: B. Purchase of…
Pelican Merchandising & More is a family-owned store. The business is now approaching the end of the year and is in the process of identifying its cash needs for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2022. (i) Extracts from the sales and purchases budgets are as follows:Month2021 - 2022CashSalesSalesOn AccountCashPurchasesPurchasesOnAccountNovember 2021 $138,100 $480,000 $345,000December 2021 $156,500 $600,000 $25,800 $380,000January 2022 $170,975 $650,000 $44,625 $400,000February 2022 $135,740 $700,000 $30,400 $480,000March 2022 $226,420 $800,000 $55,100 $540,00 A schedule of expected cash disbursements for accounts payable (purchases on account) for each of the months January to March.
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…
Your data collection has yielded the following: (i) Extracts from the sales and purchases budgets are as follows: Month November 2023 - March 2024 Cash Sales Sales on Account Purchases November $151,000 $480,000 $375,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $508,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $521,000 An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 2/30, n90:45% in the month of sale30% in the first month following the sale.25% in the second month following the sale. (iii) Expected purchases include cash purchases of $28,000 in January and $21, 000 in March.All other purchases are on account. Accounts payable are settled as follows, in accordancewith the credit terms 4/30, n60:75% in the month in which the inventory is purchased.25% in the following month (iv) The management of Toyota &…
Suppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)
A sendai clothing wholesaler was preparing its sales budget for the first quarter of 2020. Forecast sales are as follows: January $ 203,000 February $ 227,000 March $ 248,000 Sales are 40% cash and 60% on credit. 55% of the credit accounts are collected in the month of sales, 35% in the month following the sale, and 10% in the following month. Accounts receivable at the beginning of 2020 are $ 82,950 (10% of November credit sales of $ 150,000 and 45% of December credit sales of $ 151,000). Prepare a sales budget and cash collections for January, February, and March, 2020