Balance Sheet

Assets

Cash $$200,000$

Accounts receivable $1,722,000$

Raw materials inventory $492,500$

Finished goods inventory $1,627,700$

Equipment $3,000,000$

Less: Accumulated depreciation $750,0002,250,000$

Total assets $$6,292,200$

Liabilities and Equity

Liabilities

Accounts payable $$1,005,000$

Loan payable $12,000$

Long$-$term note payable $2,500,0003,517,000$

Equity

Common stock $1,675,000$

Retained earnings $1,100,2002,775,200$

Total liabilities and equity $$6,292,200$

a$.$ Sales for March total $102,500$ units. Budgeted sales in units follow: April, $102,500$; May, $97,500$; June, $100,000$; and July, $102,500.$ The product$$s selling price is $$24\mathrm{.}00$ per unit and its total product cost is $$19\mathrm{.}85$ per unit.

b$.$ Raw materials inventory consists solely of direct materials that cost $$20$ per pound. Company policy calls for a given month$$s ending materials inventory to equal $50\%$ of the next month$$s direct materials requirements. The March $31$ raw materials inventory is $24,625$ pounds. The budgeted June $30$ ending raw materials inventory is $20,000$ pounds. Each finished unit requires $0\mathrm{.}50$ pound of direct materials.

c$.$ Company policy calls for a given month$$s ending finished goods inventory to equal $80\%$ of the next month$$s budgeted unit sales. The March $31$ finished goods inventory is $82,000$ units.

d$.$ Each finished unit requires $0\mathrm{.}50$ hour of direct labor at a rate of $$15$ per hour.

e$.$ The predetermined variable overhead rate is $$2\mathrm{.}70$ per direct labor hour. Depreciation of $$100,000$ per month is the only fixed factory overhead item.

f$.$ Sales commissions of $8\%$ of sales are paid in the month of the sales. The sales manager$$s monthly salary is $$15,000.$

g$.$ Monthly general and administrative expenses include $$60,000$ for administrative salaries and $0\mathrm{.}9\%$ monthly interest on the long$-$term note payable.

h$.$ The company budgets $30\%$ of sales to be for cash and the remaining $70\%$ on credit. Credit sales are collected in full in the month following the sale $($no credit sales are collected in the month of sale$).$

i$.$ All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month $($none are paid in the month of purchase$).$

j$.$ The minimum ending cash balance for all months is $$200,000.$ If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of $1\%$ at each month$-$end $($before any repayment$).$ If the month$-$end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans.

k$.$ Dividends of $$50,000$ are budgeted to be declared and paid in May.

l$.$ No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at $35\%$ in the quarter and budgeted to be paid in the third calendar quarter.

m$.$ Equipment purchases of $$500,000$ are budgeted for the last day of June.