The balance sheet of Pixelize Inc., a photographic supplies distributor, as of May 31 is given below:

Pixelize Inc. has not budgeted previously, so it is limiting its master budget planning horizon to just one month ahead€”namely, June. The company has assembled the following budget data relating to June:
a. Sales are forecast to be $250,000; $60,000 will be received in cash; the balance will be credit sales. One-half of the credit sales for a month are collected in the month of sale, and the balance is collected the next month. The entire May 31 accounts receivable balance will be collected in June.
b. Inventory purchases are expected to total $200,000 during the month of June. All of these purchases will be on account. Forty percent of all inventory purchases is paid for in the month of purchase with the other 60% paid the next month. The entire balance of the May 31 accounts payable to suppliers will be paid during June.
c. The inventory balance for June 30 is budgeted at $40,000.
d. The selling and administrative expenses budget for June is $51,000, excluding depreciation. All of these expenses will be paid in cash. The depreciation budget is $2,000 for the month.
e. The May 31 note payable that appears on the balance sheet will be paid in June. Interest expense for the month of June (all borrowings) will be $160, to be paid in cash.
f. Warehouse equipment totalling $9,000 will be acquired for cash in June.
g. In June, the company will borrow $18,000 from the bank by issuing a new note payable to the bank for that same amount. The new note will be due in one year.
Required:
1. Prepare a cash budget for June. Support your budget with a schedule of expected cash collections from sales and a schedule of expected cash disbursements for inventory purchases.
2. Prepare a budgeted income statement for June. Use the absorption costing income statement format as shown in Schedule 9.
3. Prepare a budgeted balance sheet as of June 30.

Transcribed Image Text:

PIXELIZE INC. Balance Sheet May 31 Assets $ 8,000 72,000 30,000 500,000 $610,000 Cash.. Accounts receivable.. Inventory.... Buildings and equipment, net of depreciation . Total assets.. Liabilities and Shareholders' Equity $ 90,000 15,000 420,000 85,000 $610,000 Accounts payable . Note payable.. Common shares Retained earnings.. Total liabilities and shareholders' equity.