Question

The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,400 $ 19,600 $ 39,000 $ 126,000 $ 23,175 $ 150,000 $ 18,825 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 49,000 $ 65,000 $ 70,000 $ 95,000 $ 46,000 c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,200 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $945 per month (includes depreciation on new assets). g. Equipment costing $1,400 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Answer 1

Answer is given below with full working

Sales Budget Sales Budget Cash sales Sales on Account April $65,000 $39,000 $26,000 May $70,000 $42,000 $28,000 June $95,000 $57,000 $38,000 Total $230,000 $138,000 $92,000 A Schedule of Expected Cash Collection Cash Sales Credit Sales April $39,000 $19,600 $58,600 May $42,000 $26,000 $68,000 June $57,000 $28,000 $85,000 Total $138,000 $73,600 $211,600 Total Collections Cost of Goods Sold April $65,000 May $70,000 Sales Cost of Goods Sold -75% June $95,000 $71,250 Total $230,000 $172,500 July $46,000 $34,500 Inventory Purchase Budget Budgeted Cost of Goods Sold Add : Closing stock (80% of next month COGS) Total Needs Less Opening Stock Required Purchase (On Account) April $48,750 $42,000 $90,750 $39,000 $51,750 May $52,500 $57,000 $109,500 $42,000 $67,500 June $71,250 $27,600 $98,850 $57,000 $41,850 Total $172,500 $27,600 $200,100 $39,000 $161,100 B Schedule of Cash payment for purchases April May Total $23,175 $25,875 Payment March Purchase April Purchase May Purchase June Purchase Total payment for purchases $25,875 $33,750 $33,750 $20,925 $54,675 $23,175 $51,750 $67,500 $20,925 $163,350 $49,050 $59,625 Selling and Administrative Expense budget Sales commission (12% of Sales) Other expenses ( 6% of Sales) Rent Selling and Administrative Expense paid in Cash Depreciation Total Selling and administrative expense April $7,800 $3,900 $2,200 $13,900 $945 $14,845 May $8,400 $4,200 $2,200 $14,800 $945 $15,745 June $11,400 $5,700 $2,200 $19,300 $945 $20,245 Total $27,600 $13,800 $6,600 $48,000 $2,835 $50,835 | Cash Budget April $7,400 $58,600 $66,000 May $4,620 $68,000 $72,620 June $4,105 $85,000 $89,105 Total $7,400 $211,600 $219,000 $59,625 $14,800 $54,675 $19,300 Opening Balance of Cash Cash Collections from customers Cash available for disbursement Payments for Merchandise purchase (paid at end of the month) Selling and administrative expense Purchase of Equipment Cash paid for disbursements Net Cash available Financing Borrowings (at the beginning of the month) Repayments at the end of Quarter) Interest (at 1% per month) Total financing Closing cash balance $49,050 $13,900 $1,400 $64,350 $1,650 $163,350 $48,000 $1,400 $212,750 $6,250 $74,425 $1,805 $73,975 $15,130 $3,000 $6,000 -$300 $2,970 -$90 $5,910 -$9,000 -$90 $9,090 $6,040 $9,000 $9,000 $210 -$210 $6,040 $230,000 $172,500 $57,500 Shilow Company Absorption Costing Format Income Statement For the Quarter Ended June 30 Sales Less Cost of Goods Sold Gross profit Selling and administration expenses Sales commission (12% of Sales) $27,600 Other expenses ( 6% of Sales) $13,800 Rent $6,600 Depreciation $2,835 Profit Before Interest Interest on Short term loan Net Income $50,835 $6,665 $210 $6,455 Shilow Company Balance Sheet As on June 30 Assets Current Assets Cash Accounts receivable Inventory $6,040 $38,000 $27,600 $71,640 Fixed Assets Building and Equipment Additions during the quarter $126,000 $1,400 $127,400 -$2,835 $124,565 $196,205 Less : Depreciation during the year Total Assets Total Liabilities and Shareholders Equity Current liabilities Accounts payable $20,925 Stockholders' equity Common Stock Retained earnings $150,000 $25,280 $175,280 Total Liabilities and Stockholders' Equity $196,205 Budgeted Statement of Retained Earnings Retained earnings - Opening Balance Add: Net profit Retained earnings - Closing Balance $18,825 $6,455 $25,280 Accounts receivable closing balance Opening Balance Add : Sales Less: Collection Closing Balance $19,600 $230,000 -$211,600 $38,000 Accounts payable closing balance Opening Balance Add: Purchases Less: Payment Closing Balance $23,175 $161,100 -$163,350 $20,925