Complete the cash budget

Problem 8-29 (Algo) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8, 400 Accounts receivable $ 23, 600 Inventory $ 45, 000 Building and equipment, net $ 123, 600 Accounts payable $ 26, 925 Common stock $ 150, 000 Retained earnings $ 23, 675 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) $ 59, 000 April $ 75, 000 May $ 80, 000 June $ 105, 000 July $ 56, 000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $3,200 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $927 per month (includes depreciation on new assets). g. Equipment costing $2,400 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1.000 at the beainning of each month. up to a