Estimated sales for the next four months are as follows (in $ million): Month Cash sales Credit sales 1 0+ decimals 39.59 79.18 Save 2 42.36 63.54 3 45.33 67.99 The firm collects 10% of credit sales in the month of the sale and the remainder in the following month. Part 1 What are total cash collections in month 2 (in $ million)? 4 48.5 72.75 Part 2 What are total cash collections in month 3 (in $ million)? Attempt 1/1 Attempt 1/1

Estimated sales for the next four months are as follows (in $ million): Month Cash sales Credit sales 1 0+ decimals 39.59 79.18 Save 2 42.36 63.54 3 45.33 67.99 The firm collects 10% of credit sales in the month of the sale and the remainder in the following month. Part 1 What are total cash collections in month 2 (in $ million)? 4 48.5 72.75 Part 2 What are total cash collections in month 3 (in $ million)? Attempt 1/1 Attempt 1/1

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

5. Calculate Karmee Company’s total cash receipts for the month of April.
1. How much cash was estimated to be collected in June?
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?
what is the correct answer?
Mercurius forecasts the following sales figures for the next four months. June July August September 420,000 350,000 380,000 440,000 Cash sales average 15% of total sales. Credit sales are collected 60% in the month of sale and 40% in the month following sale. What is Mercurius' estimated accounts receivable balance on 30 September?(Answer without comma separators, e.g., 1000 instead of 1,000)
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.
Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were as follows: March April May $426,000 $676,000 $546,000 a. Assume that Sequoia’s collection period is 60 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May? b. Now assume that Sequoia’s collection period is 45 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May?
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. 04 $480 Sales 01 $ 210 02 $ 270 a. Accounts receivable at the beginning of the year are $480. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables $ Beginning receivables S Sales Cash collections Ending receivables 03 $ 330 Beginning receivables Sales Cash collections Ending receivables Q1 S Q1 480 210 585 105 $ 01 Answer is complete and correct. 480 210 $ 00 480 210 Q2 105 $ 270 b. Accounts receivable at the beginning of the year are $480. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the…
chedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000 The Accounts Receivable balance on September 30 was $77,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $ $ $ September sales on account: Collected in October October sales on account:…
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year: Q1 Q2 Q3 Q4 Sales $ 750 $ 810 $ 890 $ 980 Accounts receivable at the beginning of the year are $335. The company has a 45-day collection period. a. Calculate cash collections in each of the four quarters by completing the following: Q1 Q2 Q3 Q4 Beginning receivables Sales 750.00 810.00 890.00 980.00 Cash collections Ending receivables
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…
Bluewater, Inc. has the following estimated quarterly sales for next year. The accounts receivable period is 60 days. What is the expected accounts receivable balance to the nearest dollar at the end of the third quarter? Assume that each month has 30 days. Q2 Q3 Q4 $1,300 $1,425 $2,200 Ⓒa. $800 b. $367 c. $950 d. $733 Qe. $867 Q1 Sales $1,850