College Bookstore is facing increased competition from online resellers and electronic media forms. To combat eroding sales, management adopted new discounting policies as follows: Students are offered a trade discount based on the number of books purchased: A student purchasing one book gets 0% discount. A student purchasing two books gets a 10% discount. A student purchasing three books gets a 20% discount. A student purchasing four or more books gets a 30% discount. Students are now offered credit terms at the time of purchase. If the student pays within 30 days of the date of purchase, he or she receives a 3% cash discount. (a) Calculate the amount of the sale that should be recorded by College Bookstore for each of the following transactions. How much should be ultimately be collected for each transaction? Student A, 3 books, $425 list price, purchased on August 11, paid on August 19 Student B, 2 books, $210 list price, purchased on August 18, paid on October 4. Student C, 1 books, $90 list price, purchased on Sept. 3, paid on Sept. 3 Student D, 7 books, $1,205 list price, purchased on August 5, paid on Sept. 20 (b) Demonstrate the appropriate journal entry to record the sale and subsequent collection from students A and B.

(a) [lightbulb]

If you elect to solve this problem with the electronic spreadsheet -- all you need to do is enter the number of books in column C and the list price in column D. The rest is automated -- but that is not much of an assignment so I have intentionally included two "errors" in the "If statements" in column H. You will need to identify the errors and correct them to get the right automated answers! Good luck!

Sale Date Books List Price Trade Discount Sale Amount Date Paid Collection A 11-Aug 0 $ - 19-Aug $ - B 18-Aug 0 - 4-Oct - C 3-Sep 0 - 3-Sep - D 5-Aug 0 - 20-Sep - (b) A Accounts Receivable 0.00 Sales 0.00 To record sale to Student A Cash 0.00 Sales Discount 0.00 Accounts Receivable 0.00 To record collection from Student A B Accounts Receivable 0.00 Sales 0.00 To record sale to Student B Cash 0.00 Sales Discount 0.00 Accounts Receivable 0.00 To record collection from Student B