ACC 2234–Final Examination_Q #7 Jacques Inc.

docx

School

Algonquin College *

*We aren’t endorsed by this school

Course

2355

Subject

Accounting

Date

Nov 24, 2024

Type

docx

Pages

2

Uploaded by ok1807

Report
The following data pertains to Jacques Inc., a retailer of athletic memorabilia: Oct Actual Nov Budget Dec Budget Cash sales $80,000 $100,000 $60,000 Credit sales 240,000 360,000 180,000 Total sales 320,000 460,000 240,000 The company has a gross profit % of 40%. Management estimates that 5% of credit sales will be uncollectible. Of the credit sales that will be collected, 60% are collected in the month of sale and the remainder in the month following sale. Purchases of inventory are expected to be 100% of the following month’s projected total cost of sales. All purchases are on account and 25% are paid in the month of purchase and are subject to a 1% purchase discount. The balance is paid in the month following purchase. 1. Calculate the cash collections for November. Cash Sales $100,00 0 Add: Collections from credit sales in Oct 240,000 × 95% = 228,000 Cash collected in Nov 228,000 × 40% = 91,200 91,200 Collections from credit sales in Nov 360,000 × 95% = 342,000 Cash collected in Nov 342,000 × 60% = 205,200 205,200 Total Cash Collection in Nov $396,40 0 2. Calculate the cash disbursements for purchases for November. Oct Nov Dec Total Sales 320,000 460,000 240,000 Cost of sales ratio × 60% × 60% × 60% Cost of Sales $192,000 $276,000 $144,000 Payments for purchases in Oct Inventory Purchases in Oct $276,000 % paid in Nov × 75% To be paid for purchases in Oct 207,000 Payments for purchases in Nov Inventory purchases in Nov $144,000 % paid in Nov × 25%
To be paid for purchases in Nov 36,000 Less: Discount (36,000*1%) (360) To be paid for purchases in Nov, net of discount 35,640 Total cash disbursements for purchases in Nov $242,640 3. Calculate the ending balance in accounts receivable on November 30. Credit sales in Oct $240,000 Credit sales in Nov 360,000 Total credit sales $600,000 Less: Collection From Oct sales 228,000 Collection From Nov sales (342,000 × 60%) 205,200 Total Collections (433,200) Ending Balance in A/R in Nov 30 $166,800
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help