om/hm.tpx The following data relate to the operations of Shlow Company a wholesale distributor of consumer goods Current assets as of March 31 Cash Accounts receivable Inventory Building and equipment, net Accounts payable Captai stock 5 7800 s 20.400 $ 40.200 $128,400 s 23,925 150.000 s 22.67 a.The gross margin is 25% of sales b. Actual and budgeted sales data March (actual) Apri May June S 51,000 67.000 s 72.000 97,000 48.000 C. Sales are 60% for cash and 40% on credt Credit sales are collected inthe 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 folowing month's budgeted cost of goods sold e. One-haif of a month's inventory purchases is paid for in the month of purchase,the oher hai is ped for in the toloingmnth. The accounts payblea arche r nventory f Monthly expenses are as follows: com missions. 12% of sales: rent $2.400 per monet oeer expenses addr g depreciation), e% of sales Assume mat these expenses are pedeemy Dap ect a $963 per month (includes depreciation on new assets) g Equipment costing $1,600 will be purchased for cash in April. h M ment 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 alows the company to bormow in increments d The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quare Required: Using the data above 1. Complete the following schedule m s ALIENWARE