| October | November | |
| Receipt from cash sales | 535,000 x 20% = 107,000 | 550,000 x 20% = 110,000 |
| Collection from August credit sales | 400,000 x 45% = 180,000 | 0 |
| Collection from September credit sales | 420,000 x 50% = 210,000 | 420,000 x 45% = 189,000 |
| Collection from October credit sales | 0 | 428,000 x 50% = 214,000 |
| Total cash collections during the month | 497,000 | 513,000 |
Credit sales for August = Total sales x 80%
= 500,000 x 80%
= $400,000
Credit sales for September = Total sales x 80%
= 525,000 x 80%
= $420,000
Credit sales for October = Total sales x 80%
= 535,000 x 80%
= $428,000
Credit sales for November = Total sales x 80%
= 550,000 x 80%
= $440,000
Kindly give a positive rating if you are satisfied with this solution and please ask if you have any query.
Thanks
18) Lafayette Company's experience shows that 20% of its sales are for cash and 80% are...
During the last week of August, Oneida Company's owner approaches the bank for a $108,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,240. The owner plans to increase the store's inventory by $60,000 during September and needs the loan to pay for inventory acquisitions. The bank's loan officer needs more information about Oneida's ability to repay the loan and asks the owner to forecast the...
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Tiara Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Budgeted credit sales for the last six months of the year follow. $ June July August September October November December 32,000 30,000 35,000 40,000 45,000 50,000 42,500 I Required: A. What would be the estimated total...
just need the rest of the uncollectibles
Problem 20-6AA Merchandising: Preparation of cash budgets (for three periods) LO P4 During the last week of August, Oneida Company's owner approaches the bank for a $100,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,000. The owner plans to increase the store's inventory by $80,000 during September and needs the loan to pay for inventory acquisitions. The bank's...
Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows: September $50,000 (actual) Fourth Quarter October 40,000 November 35,000 December 60,000 Experience has shown 20 percent of sales are collected in the month of sale, 70 percent are collected in the following month, and 10 percent are never collected. Prepare a cash receipts schedule for Power Ridge Corporation covering the fourth quarter (October through December). Power Ridge Corporation Cash Receipts Schedule September October November...
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 of 2016 are as follows: August $129,000...
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart 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 $109,000 November 136,000 December 199,000 The Accounts Receivable balance on September 30...
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, 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 of 2016 are as follows: August $109,000...
During the last week of August, Oneida Company's owner approaches the bank for a $98,500 loan to be made on September 2 and repaid on November 30 with annual interest of 15%, for an interest cost of $3,694. The owner plans to increase the store's inventory by $60,000 during September and needs the loan to pay for inventory acquisitions. The bank's loan officer needs more information about Oneida's ability to repay the loan and asks the owner to forecast the...