Assignment Instructions
sales are to customers within the UK.

All sales are to customers within the UK and the sales manager predicts sales for 2020 to be 450,000 products. The sales are seasonal and the sales manager is optimistic that sales will grow at 2% per annum for the next five years. The selling price is expected to remain at £35 per item.

Cost of sales includes direct labour wages and raw materials and packaging. The swimsuits are distributed to central warehouses and then delivered using a postal delivery service to customers.

Estimated shipping and distribution costs in 2020 are £2 per unit. These costs are expected to inflate by 4% per annum.

Raw material prices are expected to increase 2% year on year.

Packaging costs are £1 per unit. Packaging costs are expected to increase by 1% year on year.

The fixed lease for the premises of £650,000 expires on 30th June 2021. A new 5 year lease has been agreed at a price of £700,000 p.a. The rent is paid quarterly in advance.

Utility costs to inflate by 5% p.a.

Wages to increase by 3% p.a. and salaries by 4% p.a.

All other overheads are expected to increase in-line with UK inflation of 3% p.a.

Corporation tax is charged at the rate of 20% on operating profits. The company pays tax for the 12 month period in 4 quarterly instalments paid on the 14th day of July, October, January and April for each 12 month reporting period to 31st December. For the year to 31st December 2020, two payments have already been made in July and October 2020 a further £157,125 corporation tax for the year to 31st December is due, payable in equal instalments in January and April 2021.

The business pays a 8% dividend based on the profit of the previous year with a minimum guaranteed distribution of £45,000 p.a. The dividend is paid in April each year.

There is a planned upgrade to the online sales system to start in September 2021, there will be an initial payment of £600,000 followed by three equal payments of £200,000 in the months October to December.

Depreciation costs will increase by 30% in 2021 and will continue to increase by 5% p.a. in following years.

The opening cash balance at the beginning of 2021 was £135,000.

Retained earnings were £560,000 at the beginning of 2020.

Information relevant to the preparation of the 12 month detailed 2021 Cash Forecast:

Sales are collected 25% in the current month and 74.5% the month after, the remaining 0.5% relate to uncollectable bad debts.

It is company policy to maintain finished goods stock at 25% of the following month’s requirement. The opening stock of finished goods is estimated at 4,500 units at the beginning of November 2020. Each unit requires 1.25 metres. of material at a present cost of £14 per metre. Raw material stocks are maintained at 10% of the following month’s requirements. Opening raw material stocks were 2,100 metres at the beginning of November 2020. Purchases are paid for 20% in the following month and 80% the month after.

All other costs are paid in the month they are incurred in.

Each unit takes 0.5 hours to complete and the company estimates idle time is running at 10%. Labour is currently paid £9 per hour in 2020.2

Ignore sales tax.

  1. Produce a DETAILED Cash Flow for JUST 2021 based on 2020’s Financial Statements and all of the information given above. You will need to use the 12 monthly information given above.

You will need to expand the overhead section by making reasonable assumptions as to what other costs you would expect to be reflected in a manufacturing business and ensure you have accurately included all of the information given to you in Note 1. Please make sure your individual category totals for Sales, Cost of Sales, Distribution, Overheads etc. do actually reconcile to those given in the Financial Statements.

  1. Clearly identify all assumptions used in your model as to how expenses or income have been inflated and translated and which costs you have treated as being fixed as opposed to variable costs.

Last Year’s Results – from the Financial Statements and Notes to the Accounts

Estimated Income Statement – 2020



£
Turnover
15,750,000
Raw materials7,875,000
Wages2,475,000
Packaging450,000
Cost of sales
10,800,000
Gross Profit
4,950,000



Shipping & Distribution
900,000
Overheads
2,478,750
Operating Profit
1,571,250



Tax314,250
Dividend Paid100,560
Profit after tax and dividend
1,156,440



Salaried Staff Costs (excluding Directors)




Average number of Employees14
Average Salary30,000



Directors

Remuneration450,000

sales are to customers within the UK

Calculate Price


Price (USD)
$

This assignment has been solved!

Place your order for a custom solution to this or a similar paper.

Why Choose Us For Your Assignment?

Privacy

We value all our customers' privacy. For that reason, all information stays private and confidential and will never be shared with third parties.

Punctuality

With our service you will never miss a deadline. We use strict follow-ups with our writers to ensure that all papers are submitted on time.

Authenticity

We have no tolerance for plagiarism. All papers go through thorough checking to ensure that no assignments contain plagiarism.

Money Back

You feel unsatisfied with your results? No worries. We offer refunds to our customers if any paper is not written according to the instructions.

Clients Love Us

Client #121678
Client #121678
Read More
This is by far the best I have ever scored in a custom essay. I am surprised the writer handled this assignment so well despite the short notice. I will definitely use your service next time.
Client #21702
Client #21702
Read More
When I was recommended to you by my friends, I wasn't sure you could deliver excellent results for Masters research papers until I submitted my first order. I am all yours now.
Client #20730
Client #20730
Read More
Excellent Services! You are the only assignment helper I can rely on. I have worked with many before and your services are exceptional. I have recommended you to my friends and the results are similar.
Client #20387
Client #20387
Read More
I rarely write reviews online but your services are worth promoting. My paper was so urgent I was sure I was gonna miss the deadline but you turned things around. You are awesome!
Client #20189
Client #20189
Read More
I am a satisfied customer. I know I should have given a 5 star because you deserve it but I will give 4.6 because I almost missed a deadline because of a revision. Luckily it was minor and the writer acted promptly.
Client #20187
Client #20187
Read More
Great paper but there is still some room for improvement. I am impressed by your fast responses and how you tacked my concerns professionally. Thank you for being among the few genuine essay writing service providers.
Client #19783
Client #19783
Read More
I can't thank you enough for being a great part of my college life. I recommended you to two more of my friends. I am sure they will be making their orders soon. I love the fact that you offer free pages for referrals. I will be referring a few more and maybe I won't have to pay for my next two paper, LOL.
Previous
Next