Hockey Den (HD), a retailer of youth hockey sticks. The following is the HD's statement of financial position at the start of this budgeting period. Hockey DEN Statement of Financial Position September 30, 2011 Assets Cash Accounts receivable Inventory 900 unitsxS60) S 20,000 42,000 54,000 $200,000 36,000 Less accumulated depreciation Total assets 164,000 $280,000 Liabilities and Equity Liabilities $ 58,200 20,000 10,000 Accounts payable Income taxes payable (due 10/3 1/2011) Note payable to bank Shareholders' equity Share capital-ordinary Retained earnings $ 88,200 150,000 191,800 $280,000 41,800 Total liabilities and equity Equi ipment is depreciated on a straight-line basis over 10 years (residual value is $20,000) HD sold 700 hockey sticks at $100 per unit in September 2011. Aftler considering sales predictions and market conditions, HD prepares its sales budget for the next fourth month(following table). Analysis of past sales indicates that 40% of the firm's sales are for cash. The remaining 60% are credit sales, these are expected to pay in full in the month following the sales. Budgeted unit sales 1,000 $100 100 100 100 October 2011 November 2011 December 2011 January 2012 1,400 900 HD decided that the number of units in its inventory at each month-end should equal 90% of next month's predicted sales. For example, inventory at the end of October should equal 90% of budgeted November sales, and the November ending inventory should equal 90% of budgeted December sales, and so on. Also, HD's suppliers expect the September 2011 per unit cost of s60 to remain unchanged through January 2012. HD makes full payment during the month following its purchases. HD's selling expenses consist of commissions paid to sales personnel and a $2,000 monthly salary paid to the sales manager. Sales commissions equal 10% of total sales and are paid in the month sales occur HD's general and administrative expense includes salaries of $$4,000 per year, or $4,500 per month (paid cach moath when they are carned). Depreciation on equipment is computed as $18,000 per year, or $1,500 per month. HD does not anticipate disposal of any property, plant and equipment through December 2011, but it does plan to acquire additional equipment for $25,000 cash near the end of December 2011. This is only budgeted capital expenditure form October 2011 through January 2012 Income taxes $20,000 are due and payable in October. Predicted income tax expense for the quarter ending December 31 is 40% of net profit and is due in January 2012. " HD also pays a cash dividend equal to 2% of the par value of ordinary shares in the second month of each quarter HD keep a minimum cash balance of 20,000 each month. If the cash balance exceeds $20,000 at a month-end, HD uses the excess to repay loans. Interest is paid at each month-end at the rate of 1% of the beginning balance of these loans. Required (1) Prepare sales budget for October, November, and December 2011: 2) Prepare merchandise purchases budget for October,November, and December 2011 (3) Prepare selling expense budget, and general and administrative expense budget for October, November, and December 2011; 4) Prepare cash budget for October, November, and December 2011; (5) Prepare bueted inne statement for three months ended December 31, 2011; (6) Prepare budgeted stiement of financial position on December 31, 2011
