Ellis Sports Shop projects the following sales: April $75,000 May $95,000 June $

Question

Ellis Sports Shop projects the following sales: April $75,000 May $95,000 June $110,000 Ninety percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $60,000 and March sales were $70,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. a) Prepare a monthly schedule of cash receipts for April-June. b) What is the balance of Receivables at the end of June? February March April May June Sales Credit Sales Collections: Cash (10% of Sales) 60% first month after sale 40% second month after sale Total Receipts Receivables at the End of June 90% of June Sales 40% of May Credit Sales Total

Explanation / Answer

Total sale (given) $ 75,000.00 $ 95,000.00 $ 110,000.00 a) Monthly Schedule of cash Reiept April May June Cash Sale $ 7,500.00 $ 9,500.00 $ 11,000.00 Received from debtor on Sale of Feb $ 21,600.00 $ - $ - March $ 37,800.00 $ 25,200.00 $ - April $ - $ 40,500.00 $ 27,000.00 May $ - $ - $ 51,300.00 Total Cash Reciept $ 66,900.00 $ 75,200.00 $ 89,300.00 b) Balance of Receivables at the end of June On May sale $ 34,200.00 On June sale $ 99,000.00 Balance of Receivables at the end of June $ 133,200.00

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.