Consider the following information for the month ending June 30, 2012, for the Johnson Company: 

The cash balance, May 31, 2012, is $15,000. Sales proceeds are collected as follows: 80 percent month of sale, 10 percent second month, 10 percent third month. 

Accounts receivable are $40,000 on May 31, 2012, consisting of $16,000 from April sales and $24,000 from May sales. 

Accounts payable on May 31, 2012, are $145,000. Johnson Company pays 25 percent of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition. However, insurance and property taxes are paid annually in December. 

Johnson Company Budgeted Income Statement for the Month Ended June 30, 2012 (in thousands) 

Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes and other possible items that might affect cash.

Transcribed Image Text:

$290 Sales $ 50 Inventory, May 31 Purchases 192 Available for sale 242 Inventory, June 30 Cost of goods sold Gross margin Operating expenses: Wages 40 202 88 36 Utilities Advertising 10 Depreciation Office expenses 1 4 Insurance and property taxes Operating income 3 59 $ 29