Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 3 You are to prepare a 12 month forecastlbudget for the business up to 30 April 2023. Using the figures below complete a cash

image text in transcribed
Task 3 You are to prepare a 12 month forecastlbudget for the business up to 30 April 2023. Using the figures below complete a cash flow forecast for Dysonica PLC. Capital introduced 20,000 Sales estimated at 25,000 in the first month increasing by 40% each month thereafter Insurance 6000 paid in monthly instalments Salaries 26,500 per month with an annual 20% pay rise for all employees in November Raw materials (Cost of purchases) 60% of sales Miscellaneous 50 per month Rent 18,000 per month Review at month 6 increased to 25,000 per month Accountant's fee 1500 paid in month 1 Utilities 2500 paid quarterly (July, October, January, April) Telephones 1000 paid quarterly (July, October, January, April) Vehicles New Van 5000 and new car for manager at 15000 in the first month 200 every month there after Marketing costs 5% of sales for the first six months increasing from month 7 to 10% Water 100 per quarter (July, October, January, April) Logistics 3000 per month increasing by 50% in the 4th month due to an increase in transportation and storage costs in the UK. Machinery 1500 paid monthly Based on your cash flow forecast create a 12 month budget to assist Dysonica with future spending, cost reduction and finance management

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Economics questions

Question

Explain how joint products and by-products are different. LO.1

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago