Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 30, 2024

Progress Stores: Preparation of budget financial statements Question : create an income statement ; statement of financial position and cash flow statement for 2020 using

Progress Stores: Preparation of budget financial

statements

Question : create an income statement ; statement of financial position and cash flow statement for 2020 using the information from the directors below . Also see this years financial statements included below for 2019. Format for 2020 years financial statements ar included below.

Brief for a Managing Director

You are Managing Director of Progress Stores, a rapidly expanding company specialising

in medium sized stores, selling a wide variety of low-price consumer goods including food

products.

It is now December and time for preparation of the budget for the next financial year,

which begins on 1 January. Next year is to be a particularly vital one for the company, as

the plan is to increase the number of stores from their present number of eight to

twelve by the purchase of four new stores during the year. In addition to this expansion,

there are also plans to modernise three of the existing stores.

You have put aside this afternoon to work on the first draft prior to a management team

meeting this evening. Unfortunately the Chief Accountant who promised you the figures

by lunchtime is fog-bound at t h e Cape Town Airport.

Accordingly you are calling the management team together to have a go at doing it

yourselves. Each manager has the relevant information for his/her particular area of the

business and together with the attached draft accounts for the current year you have all

the information needed to prepare the budget Statement of Comprehensive Income and

Statement of Financial Position (SOFP) for the next financial year.

Your own particular contribution to the budget is in respect of the activities over which

you personally have control, selling/advertising and distribution.

Selling/advertising costs for the year just ending will be R320,000. With the new store

expansion, however, much new advertising and sales promotion is necessary, so you

expect this cost to rise to R600,000 in the budget year. All this will be cash outlay, there

being no credit available for this type of cost.

Because of the cash flow problems likely to be created by the expansion, you are not

purchasing any new vehicles and will fill any gaps by hiring. This extra cost, together with

increased drivers wages and maintenance costs, will push up distribution costs by

R120,000 compared with this years level. This figure includes R50,000 of depreciation

on existing lorries and vans which will need to be deducted from the vehicles figure on

the SOFP.

You have now asked the management team to come along to your office with all the

relevant information. You expect everyone to do their bit and help in the budget

preparation.

Brief for a Stores Director

You are Stores Director of Progress Stores, a rapidly expanding company specialising in

medium-sized stores, selling a wide variety of low-price consumer goods including food

products.

It is now December and time for preparation of the budget for the next financial year,

which begins on 1 January. Next year is to be a particularly vital one for the company, as

the plan is to increase the number of stores from their present number of eight to twelve

by the purchase of four new stores during the year. In addition to this expansion, there

are also plans to modernise three of the existing stores.

There is a management team meeting this evening to discuss next years budget. You

have provided the relevant information to the Chief Accountant and you expected to

receive your first draft figures by lunchtime. Unfortunatelythe Chief Accountant is fogbound

at Cape Town Airport with the only copy, and the managing director wants you

and the rest of the management team to have a go at putting the figures together

yourselves.

In your own role, you have the following information about next years plans:

The expansion programme in existing stores and general price inflation will increase

sales by R5.8m. In addition the new stores opened during the year will further push

up sales by R2.7m.

Quite obviously this increase in sales is going to mean the recruitment of extra staff

and this will push up total wages and salary costs by R620,000. Other stores costs are

also bound to rise and they will total R1,120,000 next year, which includes R300,000

depreciation on furniture and fittings. This depreciation will need to be deducted

from the cost of Fixtures and Fittings on the SOFP.

One innovation coming next year is the launch just before Christmas of your own

credit card. Credit sales of R400,000 are included in the above total sales figure, and

this revenue will not have been received by the end of the financial year. You will

therefore need to include a trade receivable balance in the SOFP for the first time.

The managing director has now asked you to go along to his/her office with all the

relevant information. He/she expects everyone to do their bit and help in the budget

preparation.

Brief for a Purchasing Director

You are Purchasing Director of Progress Stores, a rapidly expanding company specialising

in medium- sized stores, selling a wide variety of low-price consumer goods including

food products.

It is now December and time for preparation of the budget for the next financial year,

which begins on 1 January. Next year is to be a particularly vital one for the company, as

the plan is to increase the number of stores from their present number of eight to

twelve by the purchase of four new stores during the year. In addition to this expansion,

there are also plans to modernise three of the existing stores.

There is a management team meeting this evening to discuss next years budget. You

have provided the relevant information to the Chief Accountant and you expected to

receive your first draft figures by lunchtime. Unfortunatelythe Chief Account is fogbound

at Cape Town Airport with the only copy, and the managing director wants you

and the rest of the management team to have a go at putting the figures together

yourselves.

In your own role, you have the following information about next years plans:

With the increased sales level, you are obviously going to have to step up the

purchasing programme. Forecasts from the Stores Director indicate that purchases

for next year will have to be R17.8m, which is based on a closing inventory level at

stores and distribution depots of R4.1m.

There have been some problems this year with suppliers who have been worried by

rumours that the company was over-stretching itself and having cash problems.

Although the Managing Director assured you that all was well, he/she has asked you

to pay bills more quickly next year and reduce the trade payables (now at about two

and a half months) to R2m by the end of the year (about 41 days).

You have also taken charge of the detailed arrangements of the new store openings

and shop fittings in existing stores. Purchase of property for new stores will be R2.5m

in the year and shop fittings in these stores will cost R720,000. Shop fittings in existing

stores will cost a further R580,000.

The Managing Director has now asked you to go to his/her office with all the relevant

information. He/she expects everyone to do their bit and help in the budget preparation.

Brief for a Resources Director

You are Resources Director of Progress Stores, a rapidly expanding company specialising