Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


Budgeting Control

Budgeting Control

Budgeting Control


This is Resit Assignment:

· Individual task

· You must answer all the questions.

· When solving problems, you must clearly explain all the steps you are doing, and why are you making those steps.

· Show all your workings, a numeric answer is not enough.

· You should submit a document in Excel format showing all calculations.


· Use one page per answer.

· Cover, Table of Contents, References and Appendix are excluded of the total wordcount.

· Font: Arial 12,5 pts.

· Text alignment: Justified.



Weight: This task is a 100% of your total grade for this subject. Re-sits are capped at 70%


It assesses the following learning outcomes:

· Develop an understanding and working knowledge of real-world budget issues.

· Prepare cash budgets and predicted a pro forma income statement and a pro forma balance sheet.

· Cash Budget

· Flexible budgeting

· Analysis of variances







You are working as a financial advisor for Mr. Petersen, who is a well-known investor. Today Mr. Petersen has explained to you a new business project that he has, and he wants you to prepare projected financial statements to have an idea of the profitability of the project.

Following we have the data that Mr. Petersen has delivered to you:

Sales: The expected sales are 2.000.000 units, for the first year, the sales will grow at a 20% year over year until year 5.

The sales price per unit is 2.8€ per unit.

Direct materials: The recipe of the product explains that direct material will have a cost of 1.5€ per unit.

Production labor: The first year the plant needs 3 technicians with a cost of 32500€ per person per year, 30 production workers with an annual cost of 28.000€ per employee per year, and 1 manager with a cost of 90.000€ per person per year. The next years the production labor will increase, due to the fact that the production of the plant will also be increasing. The year 2 the cost will be 7.25% higher than year 1, the year 3 the cost will be 16% higher than year 1, the year 4 the cost will be 22% higher than year 1 and in year 5 the cost will be 30% higher than year 1.

Investment: the required investment is 7.500.000€, of which 5.000.000 will be depreciated over a period of 10 years and the rest will be depreciated over a period of 4 years. No more investments will be required during the years 2 until 5.

Utilities expense: We expect a cost of 0.18€ per unit on the first year, and the energy cost will have a growth per unit of 7% year over year.

Quality control: the control will be outsourced, and we expect a cost of 3% of our sales per year.


General and administration costs are expected to be 200.000€ for the first year. For the following years the cost should increase a 5% year over year.


The days to collect accounts receivable are 60, the days to pay suppliers are also 60.

The company will need an inventory of 30 days.

Mr. Petersen is ready to invest 4.000.000€. The investments need to be paid upfront and the rest of money needed will come from a bank credit line, you should make your own estimation of the amount needed. The loan will be returned in 5 years starting at the end of year 2, so finishing at the end of year 7.

The tax rate is 25% and the interest rate is 4.5%.

Mr. Petersen is requesting from you a proposal of Profit & loss account for the next 5 years and a balance sheet for the same period.

(Hint start preparing the detailed cash planning for the first 12 months)

(50 points)

Mr Petersen is also requesting from you a detailed cash planning for the first 12 months, considering that the monthly sales will be distributed 5% for the months of January to April, 8% for May and June,11% July to October, 10% for November and the remaining sales in December.

Mr Petersen wants to have a minimum cash of 50.000€. (50 points)


9-10 The student demonstrates an excellent understanding of the concepts.
8-8.9 The student demonstrates a good understanding of the concepts.
7-7.9 The student demonstrates a fair understanding of the concepts.
6-6.9 The student demonstrates some, but insufficient understanding of the concepts.
3-5.9 The student demonstrates insufficient understanding of the concepts. They may mention some relevant ideas or concepts, although it is clear that the relationship between them is not understood by the student.
1-2.9 The student demonstrates insufficient understanding of the concepts and does not mention any relevant ideas or concepts.
0 The student leaves the question blank or cheats.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Writers Hero only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Writers Hero are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Writers Hero is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Writers Hero, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.