Please show all work.

Chapter 10 Livanos, Inc. records all ts sales as credit sales and pays cash operating costs in the month incurred. Amounts for 2017 are givern in the table that follows. Additional assumptions are 1) Amounts due from customers are collected 40% in the month of sale and 60% in the following month; 2) The ratio of Cost of goods sold to Sales is 65%; 3) Livanos pays for inventory purchases 20% in the month of the purchase and 80% in the following month; 4) Monthly operating expenses are: Salaries, $60,000; Depreciation, $25,000; Rent, $20,000; and Utilities, $3,000; 5) Accounts payable is only used for inventory acquisitions Use the following worksheet to determine the ending cash balance in May, assuming the beginning cash balance in April is $180, March A May June $400,000 $300,000 $280,000 $250,000 $500,000 Budgeted purchases $120,000 $112,000 $100,000 $200,000 $240,000 Budgeted sales