Please help with Part III: preparing a cash budget.

Below are Part I & II for reference. [Part II was answered by Sonali].

PART I

Premier Ties is a division of Menswear, International. The division has an exclusive franchise to act as the nationwide distributor of a designers silk ties. Sales of this product have grown so rapidly over the past few years that the division vice president has decided to implement quarterly budgeting and planning procedures, starting April 1the beginning of the second quarter in the companys fiscal year. The following data has been assembled for the division:

Recent and forecasted sales in units are as follows:

January (actual) 20,000

February (actual) 24,000

March (actual) 28,000

April 35,000

May 45,000

June 60,000

July 40,000

August 36,000

September 32,000

The increase in sales before and during June reflects the increased activity surrounding Fathers Day. Premier prices this product at 70% over cost. All sales are on credit, net 15 days. Historically, 25% of sales have been collected in the month of sale, 50% in the following month, and the remaining 25% in the second month following the sale. Uncollectible accounts have been insignificant. Accounts receivable at the beginning of the second quarter is $229,500.

The division tries to maintain an inventory equal to 90% of the next months sales in units. The ties cost the company $5 each. Premier pays for 50% of its purchases in the month of purchase and the remaining 50% in the month after purchase. Accounts payable for purchases at the beginning of the second quarter is $85,750.

Premier pays all other cash operating costs in the month in which they are incurred. The division pays quarterly salaries of $66,000 plus a $0.50 commission per unit sold. Other quarterly operating expenses consist of: utilities, $42,000; insurance, $7,200; depreciation, $45,000; miscellaneous, $9,000.

1. Prepare a sales budget in units and dollars by month and for the quarter

2. Prepare a schedule of cash collections from sales by month and for the quarter

3. Prepare a purchases budget in units and dollars by month and for the quarter

4. Prepare a schedule of cash payments for purchases by month and for the quarter

5. Prepare a selling and administrative expense budget in dollars by month and for the quarter. List each expense separatelyyou may assume that quarterly fixed expenses are incurred uniformly during the quarter.

ANSWER TO PART 1:

PART II

Premier plans to purchase land for $25,000 cash in June. The company also declares dividends of $12,000 per quarter. The dividend is declared in the last month of the quarter and paid in the first month of the following quarter.

At the end of each quarter, Premier makes a tax payment equal to 20% of budgeted income before tax. For purposes of this project, you may assume that the payment is debited to income tax expense.

At the beginning of the year, Premier borrowed $150,000 on a five-year 12% note payable with interest to be paid annually at December 31.

The divisions balance sheet at March 31 is as follows:

PREMIER TIES

BALANCE SHEET

At March 31

ASSETS

Cash $ 44,000

Accounts receivable 229,500

Inventory 157,500

Prepaid insurance 14,400

Property, plant and equipment, net 322,700

Total Assets $768,100

LIABILITIES AND STOCKHOLDERS EQUITY

Accounts payable $ 85,750

Dividends payable 12,000

Interest payable 4,500

Note payable 150,000

Common stock, no par 300,000

Retained earnings 215,850

Total Liabilities and Stockholders Equity $768,100

PART 2

Prepare a budgeted income statement for the quarter only using the contribution format. List each cost separately.

At the bottom of your worksheet, answer the questions below. Use operating income (income before interest and taxes) in your calculations. Round your answers to the nearest whole unit, dollar or one percent as necessary. Be sure to label your answers.

What is the division contribution margin ratio?

What is the quarterly budgeted break-even point in units?

What is the margin of safety in units for the quarter?

What is operating leverage for the quarter?

If the division wants to earn income before interest and taxes of $350,000 for the quarter, how many units must it sell?

PART II ANSWER

Requirement 2

a. Contribution margin ratio = Contribution margin / Sales = $420000 / $1190000 = 35.29% = 35%

b. Budgeted break-even point in units = Total fixed costs / Contribution per unit = $169200 / $3 = 56400 units

Contribution per unit = $420000 / 140000 units = $3

c. Margin of safety in units = Actual sales - Break-even sales = 140000 - 56400 = 83600 units

d. Operating leverage = Contribution margin / Net operating income = $420000 / $250800 = 1.67 = 167%

e. Number of units to sell for target operating income = (Total fixed costs + Target operating income)/Contribution per unit = ($169200 + $350000) / $3 = 173066.67 = 173067 units

PART III

REQUIREMENTS

1. Prepare a cash budget by month and for the second quarter, listing each category of payment separately. (HINT: Ending cash balance at April 30 should be $24,125.) The second quarter includes April, May, and June.

MAY 28000 35000 4500060000 8.5 8.5 8.5 8.5 8.5 38000 297500 382500 510000 74375 119000 1487 95625 127500 50 191250 51000 59500 74375 459000 244375 303875 393125 MAY JUNE 31500 40500 144500 220000 292500 210000 110000 146250 105000 5750 110000 146250 195750 256250 251250 MAY JUNE 17500 2250030000 14000 1 00 78900 86400