IDS Ltd, who are a major sports equipment manufacturer, have resid and tested a
ID: 2588164 • Letter: I
Question
IDS Ltd, who are a major sports equipment manufacturer, have resid and tested a new trail running shoe. Te aageent are now launch of the new shoe over a six month periood As the Project Manager for the development of then oduct you io and collated the following sales and cost information for the a Expected sales are: Month Number of shoes January February March April May June 200 200 260 300 350 400 The projected selling price is £40. All sales are expected to be on credit and customers are to pay following the month of sale. b each month is based on expected sales. It is The number of shoes produced planned to keep inventory levels constant at their current leve period. Each pair of shoes requires 0.2 kg of raw materials, which costs £10 per kg. All purchases of materials are on credit and suppliers are to be paid in the second month following the month of purchase. d To produce one pair of shoes requires two hours of direct labour at £6 per hour. e Variable production overheads are to be charged at the rate of £2 per unit (pair of f Fixed monthly production overheads are as follows: Wages are paid in the month the shoes are produced. shoes) produced. These are to be paid in the month the units are produced. Rent and rates Insurance Heat and light Depreciation Other £1,000 £400 £800 £200 £250 These are to be paid in the month the units are producedExplanation / Answer
i) Cash budget for the six months period
ii) Number of shoes required to be produced/sold over the trail period is calculated as follows:
Break even units = Fixed cost / contribution margin per unit
Contribution margin per unit
Fixed cost = $32700
Break even units = 32700 / 24
= 1363 units of shoes
Jan Feb Mar Apr May Jun Beginning cash balance $0 -$8,250 -$8,900 -$10,390 -$10,160 -$9,110 Budgeted cash receipts Credit sale $8,000 $8,000 $10,400 $12,000 $14,000 Total cash available for use $0 -$250 -$900 $10 $1,840 $4,890 Cash disbursements Raw material 400 400 520 600 700 Wages $2,400 $2,400 $3,120 $3,600 $4,200 $4,800 Variable overheads $400 $400 $520 $600 $700 $800 Rent and rates $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Insurance $400 $400 $400 $400 $400 $400 Heat & light $800 $800 $800 $800 $800 $800 Other $250 $250 $250 $250 $250 $250 Manager's salary $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 selling/distribution $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Total cash disbursements $8,250 $8,650 $9,490 $10,170 $10,950 $11,750 Ending cash balance -$8,250 -$8,900 -$10,390 -$10,160 -$9,110 -$6,860