all sales are given in the first column try to solve it with the same sales figure whether the answer is positive or negative.
Solved it immediately for good
Rental/Property Selling and Admin Expected Sales Revenue Expected Expenses Expenses Purchases Budget Column1 [] [] [] [] Jan 60,000 48000 5000 1800 2800 Feb 40,000 80,000 4200 2400 3400 Mar 45,000 81,000 3000 1500 1800 Apr 40,000 90,000 2500 1000 1000 May 50,000 75.000 4000 2000 2000 Jun 60,000 48000 2800 2400 2400 Jul 40,000 80,000 2400 2500 2500 Aug 45,000 81,000 4200 2400 2400 Sep 65,000 80,000 2800 2600 2600 Oct 45,000 90,000 2500 2600 2600 Nov 40,000 60,000 2400 2400 2400 Dec 60,000 48000 3000 1500 1500 A. Based on the above data, you have been asked to produce a 12-month cash budget. The following information is also available Opening Balance as on 1st Jan was 8000 Shares were issued in Mar & Jun @ 2000 in each month to meet deficit of funds Debentures were issued in October and December @ 2500 in each month to infuse funds Make use of variance analysis to show the impact of the different individual scenarios below: Prepare a memorandum that includes the following. 1. Discounting prices by 20 per cent, which in turn increases sales volume per month by 10 per cent 2. Increasing the marketing budget by 10 per cent per month, which in turn generates an Expenses on Marketing Prepare budgets for planning, control and decision making Cash budget PROBLEM 1. Column1 [] [] [] Jan 60,000 48000 5000 1800 2800 Feb 40,000 80,000 4200 2400 3400 Mar 45,000 81,000 3000 1500 1800 Apr 40,000 90,000 2500 1000 1000 May 50,000 75,000 4000 2000 2000 Jun 60,000 48000 2800 2400 2400 Jul 40,000 80,000 2400 2500 2500 Aug 45,000 81,000 4200 2400 2400 Sep 65,000 80,000 2800 2600 2600 Oct 45,000 90,000 2500 2600 2600 Nov 40,000 60,000 2400 2400 2400 Dec 60,000 48000 3000 1500 1500 A. Based on the above data, you have been asked to produce a 12-month cash budget. The following information is also available: Opening Balance as on 1st Jan was 8000 Shares were issued in Mar & Jun @ 2000 in each month to meet deficit of funds Debentures were issued in October and December @ 2500 in each month to infuse funds Make use of variance analysis to show the impact of the different individual scenarios below: Prepare a memorandum that includes the following. 1. Discounting prices by 20 per cent, which in turn increases sales volume per month by 10 per cent 2. Increasing the marketing budget by 10 per cent per month, which in turn generates an additional 20 per cent in sales revenue 4. Reducing rental/property related costs by 15 per cent per month
