Combong.bangibnsaEX 22-18V Total cashcollected in July,$163,050Schedule of cash collections of accounts receivableOBJ. 5Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1, 2016. Projectedsales for each of the first three months of operations are as follows:May$134,000June155,00000July169,000All sales are on account. Sixty-five percent of sales are expected to be collected inboxit the month of the sale, 30% in the month following the sale, and the remainder in thee second month following the sale.ni vionelSHOWPrepare a schedule indicating cash collections from sales for May, June, and July.ME HOW

Cash on credit sales is collected as 65% in month of sales, 30% next month and 5% the following…

Answered: Combong.bangibnsaEX 22-18 V Total cash…

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 17E

See similar textbooks

Similar questions

Accounts Receivable Balance XYZ Corp sells widgets to consumers for $20 each. Its beginning accounts receivable balance was $24,975, and it sold 12,376 widgets throughout the year. The total cash collections for the year amounted to $217,750. Required: Calculate the ending accounts receivable balance.
Ramon Manufacturing has a cash balance of P8,000 on August 1 of the current year.The company’s controller forecast the following cash receipts and cash disbursementsfor the upcoming two months of activity.Receipts PaymentsAugust P 45,000 P 57,000September 66,000 56,000Management desires to maintain a minimum cash balance of P8,000 at all times. If necessary, additional financing can be obtained in P1,000 multiples at a 12% interest rate. All borrowings are made at the beginning of the month; debt retirement, on the otherhand, occurs at the end of the month. Interest is paid at the time of repaying loan principal and is computed on the portion of debt repaid. 1. Determine the ending cash balance in August both before and after anynecessary financing or debt retirement.
Dante Manufacturing has a cash balance of P8,000 on August 1 of the current year.The company’s controller forecast the following cash receipts and cash disbursements for the upcoming two months of activity. Purchases SalesJanuary P 142,000 P 172,000February 148,000 166,000March 136,000 165,000April 154,000 178,000May 160,000 166,000Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The company pays all invoices in the month following purchase and takes advantage of a 3% discount on all amounts due. Cash payments for operating expenses in May will be P119,500; Crispin’s cashbalance on May 1 was P127,800. Required: Determine the following:1. Expected cash collections during May.2. Expected cash disbursements during May.
Marga Corporation has the following historical pattern of credit sales: 70% during the month of sale 4% in the third month after sale 15% in the first month after sale 1% uncollectible 10% in the second month after sale Required: Compute for the total cash collections during the 4th calendar quarter.A/R balance on the Balance Sheet as of Dec. 31
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $110,000 November 138,000 December 201,000 The Accounts Receivable balance on September 30 was $74,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 $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Serendipity, Inc. prepared cash estimates for the 3rd quarter of 2021 (3-months). The following estimates were developed for certain items: July August September Cash sales P 60,000 P 80,000 P 150,000 Credit sales 30,000 60,000 90,000 Purchases 60,000 55,000 75,000 Payroll 40,000 50,000 60,000 Other expenses 20,000 25,000 30,000 In June, credit sales totaled P50,000 and purchases totaled P60,000. May credit sales were P70,000. Accounts receivable collections amount to 50% in the month after the…
Considering the financial statement information below for the The C’mon Cam! Co., how long is the cash cycle? Item Beginning EndingInventory $9,338 $11,550Accounts Receivable 5,670 6,947Accounts Payable 7,689 9,625 Net Sales $82,544Cost of Goods Sold $58,638 a. 28 daysb. 39 daysc. 65 daysd. 93 days
Schedule 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 $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,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 SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 20% 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 $113,000 November 141,000 December 207,000 The Accounts Receivable balance on September 30 was $76,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. Office World Inc. Schedule of 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:…
4C. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2019: (a) Opening cash (including bank) balance on 1 July 2019 OMR 3600 (b) Production in units: Jan 500 Feb800 March 700 April 900 May1000 June850 July890 Aug1050 Sep650 Oct750 Nov 900 Dec800 (c) Raw materials used in production cost OMR 25 per unit. Of this, 75 per cent is paid in the month of production and remaining balance in the month after production. (d) Direct labour costs of OMR 20 per unit are payable in the month of production. (e) Variable expenses are OMR 10 per unit, payable 50 per cent in the same month as production and remaining balance in the month after production. (f) Sales at OMR 70 per unit: Jan 450 Feb 600 March 900 April 800 May 850 June 700 July 1,000 Aug 800 Sep 900 Oct 500 Nov 600 Dec 750 Debtors to pay their accounts one month after that in which sales is made (g) Fixed expenses of OMR 1,200 per month…
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% 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.
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:…

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

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

Publisher:

South-Western College Pub

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

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

Publisher:

South-Western College Pub

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

SEE MORE TEXTBOOKS