Cambridge inc is preparing its master budget for the quarter ended June 30. it sells a single product for $40 each.Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31, the balance in accounts receivable is $12,000, which represents the uncollected balance on March sales. Budgeted sales for the next four months follow:

Sales in units : april: 800 may:1,000 june:600 july:1,200

the product coast is $20 per unit, and desired ending inventory is 60% of the following month's sales in units. inventory at march 31 is 480 units. purchases are paid 50% in the month of purchase and 50% in the following month. at march 31, the balance in accounts payable is $11,000, which represents the unpaid purchases from march

Operating expenses are paid in the month incurred and consist of:

commisions(10% of sales)

shipping(3% of sales)

office salaries($3,000 per month)

rent($5,000 per month)

depreciation is $2,000 per month

prepare the following budgets for the months of April, may and June (2nd quarter)

sales budget

table of cash receipts

merchandise purchases budget

table of cash disbursements for purchase of merchandise

table of cash disbursements for selling and administrative expenses