You have been asked to prepare the monthly cash budget for June and July for the Merchandise and Mercantile Company. The company sells a unique product that is specially made for it by a major product manufacturer. The selling price is $35.00 per unit. All sales are on account. Merchandise purchases are also on account. The policy of the company is to purchase sufficient quantity of product to ensure that each month's ending inventory is 50% of the following month's expected sales quantity The assignment file contains extracts from the general journal showing the journal entries pertaining to certain relevant transactions that have occurred and a set of entries the bookkeeper has provided that indicate the transactions expected to occur affecting cash, accounts payable, accounts receivable, and merchandise inventory accounts due to the projected sales revenues and projected merchandise purchases on the master budget. This analysis, with other additional data, is shown below. Assume today is May 31, 20X1, and that all dollar amounts are in thousands of dollars. Cr May 31 4,950 April 30 51,000 24.990 2,040 May 31 140,000 20,400 68,600 Information From Accounting Records and Planning Documents Dr Extracts From the May 31 Adjusted Trial Balance Cash 5,400 Merchandise inventory 11,800 Accounts receivable 31,000 Accounts payable Extracts From the General Journal Accounts receivable, April sales 51,000 Revenue Cash 24,990 Accounts receivable, April sales Bad debt expense, percentage of April sales 2,040 Allowance for doubtful accounts Accounts receivable, May sales 140,000 Revenue Cash 89,000 Accounts receivable, April sales Accounts receivable. May sales Merchandise inventory 19,800 Accounts payable, May purchases Accounts payable, May purchases 14,850 Cash, payment May purchases Projected Entries to the General Journal for Selected Anticipated Transactions as per Master Budget Accounts receivable, June sales 206,500 Revenue Cost of sales for June 23,600 Inventory Accounts payable, May purchases 4,950 Cash, May purchases Cash 3,570 Accounts receivable, April sales Accounts receivable, July sales 130,550 Sales revenue Accounts receivable, August sales 165,550 Sales revenue Period fixed expenses, August 2,950 Accumulated depreciation, August Cash Variable operating expenses (percent of sales) 16,555 Cash 19,800 14,850 June 30 206,500 23.600 4,950 3,570 July 31 130,550 August 31 165,550 975 1.975 16,555 Required: 1. Calculate the cost per unit of merchandise inventory. Cost per unit 2. Prepare a schedule showing the quantity of sales, ending inventory, beginning inventory and the quantity of product purchased in May, June, and July May June July Sales Ending inventory Beginning inventory Purchases Cost 3. Use the price per unit of inventory purchased and the quantity purchased to determine the expenditure for purchases in May, June, and July May June July Cost of purchases 4. Calculate the percentages of sales the company expects to collect in the month of the sale and in the two months following the sale. What is the percentage of uncollectible sales? Assume that the percentages calculated for the month for which data is provided also apply to sales for any month of the year. % collected in April % collected in May % collected in June % uncollectible Total 5. Calculate the percentages of May and June merchandise purchases the company expects to pay in June May June % Merchandise purchases % 6. Calculate the balance in the accounts receivable on June 30. Assume all receivables are due to sales on account. Balance 1 7. Calculate the balance in the cash account on June 30, based on the transactions projected to occur in June. Use the collection and disbursement percentages previously calculated. Assume that fixed expenses occur evenly in each month of the year. Balance 8. Prepare a cash budget for July, in good form. Use the collection and disbursement percentages previously calculated. (Amounts to be deducted should be indicated by a minus sign.) Cash budget for July Cash Budget Month Ended July 31, 20XX July cash collections: July cash disbursements for merchandise purchases: Selling and administration expenses