Newtake Records Ltd owns a chain of 14 shops selling DVDs and CDs. At the beginning of June the business had an overdraft of 35,000 and the bank had asked for this to be eliminated by the end of November. As a result, the directors have recently decided to review their plans for the next six months. The following plans were prepared for the business some months earlier:

Required:

(a) Prepare an inventories budget for the six months to 30 November also based on the table of plans above.

(b) Prepare a cash budget for the six months ending 30 November which shows the cash balance at the end of each month also based on the plans set out in the table above.

(c) Prepare a budgeted income statement for the whole of the six-month period ending 30 November. (A monthly breakdown of profit is not required.)

(d) What problems is Newtake Records Ltd likely to face in the next six months? Can you suggest how the business might deal with these problems?

Transcribed Image Text:

May June July Aug Sept Oct Nov 000 000 000 000 000 000 000 Sales revenue 180 230 320 250 140 120 110 Purchases 135 180 142 94 75 66 57 Administration expenses 52 55 56 53 48 46 45 Selling expenses 22 24 28 26 21 19 18 Taxation payment - 22 - - Finance payments Shop refurbishment 51 5 5 - 14 18 558 5 5 6 161