Question

December 31, Balance Sheet Data 2017 $ 84,000 2018 $ 78,000 Trade accounts receivable-net Inventory 150,000 (95,000) 140,000 (98,000) Accounts payable-merchandise (credit) Total sales for 2018 were $1,200,000 and for 2017 were $1,100,000. Cash sales were 20% of total sales each year. Cost of goods sold was $840,000 for 2018. .Variable general and administrative (G&A) expenses for 2018 were $120,000. These expenses are the same proportion of sales every year and have been paid at the rate of 50% in the year incurred and 50% the following year. Unpaid G&A expenses are not included in accounts payable. Fixed G&A expenses, including $35,000 depreciation and $5,000 bad debt expense, totaled $100,000 each year. The amount of such expenses involving cash payments was paid at the rate of 80% in the year incurred and 20% the following year. In each year, there was a $5,000 bad debt estimate and a $5,000 write-off. Unpaid G&A expenses are not included in accounts payable. Required: Compute the following: Answer is complete but not entirely correct. 1. The amount of cash collected during 2018 that resulted from total sales in 2017 and 2018. 1,201,000 $ 837.000x The amount of cash disbursed during 2018 for purchases of merchandise. The amount of cash disbursed during 2018 for variable and fixed G&A expenses. 2 $ 175,000 3

Answer 1

|1) Cash collected during 2018: Trade accounts receivable-net in 2017 |Add: Cash collected in 2018 (S1,200,000 - $78,000 - S5,000) Total Cash collected |2) Cash disbursed during 2018 for purchase of merchandise: |Cost of Goods Sold |Add: Inventory of 2018 Less: Inventory of 2017 Inventory Purchases Add: Accounts Payable - Merchandise in 2017 Less: Accounts Payable - Merchandise in 2018 Cash disbursed for Inventory |3) Cash disbursed during 2018 for Variable and Fixed G&A expenses: Variable expenses paid in 2017 (S120,000 * $1,100,000/S1,200,000 * 50/100) |Add: Variable expenses paid in 2017 ($120,000 * 50/100) |Total Cash Collected for Variable Expenses in 2017 & 2018 $84,000 $1,117,000 $1,201,000 $840,000 $140,000 ($150,000) $830,000 $95,000 (S98,000) $827,000 $55,000 $60,000 $115,000 Fixed expenses paid in 2017 (S100,000 S35,000 $5,000 $60,000*20/100) |Fixed expenses paid in 2018 (S100,000 - S35,000 - $5,000 = S60,000*80/100) |Total Cash Collected for Fixed Expenses in 2017 & 2018 |Total Cash Collected for Variable and Fixed Expenses in 2017 & 2018 (S115,000 + $60,000) $12,000 $48,000 $60,000 S175,000