attach the spreadsheet please
In the small town of Eysers, the Council managed to collect half million pounds from its citizens. Unfortunately, the Council spent all of this, and other 69 thousand besides. Naturally, the good people of Eyes objected to being asked for another 69 thousand pounds. So they got rid of the council and appointed new one. Have a look at last year's budget, and see if you can do better. Here's the budget where the previous council overspent by thousand pounds: Budget 500.000 E15.000 12.000 E15 000 E16000 14000 19000 48000 24000 30000 80000 42000 11000 335.000 65.000 4 5000 10000 12000 12000 NNN Total 20000 20000 24000 24000 11000 200 56 Police Officers 5 Ambulance drivers 6 Fomen/women 7 School teachers 8 Refuse collectors Your salary 10 11 Total Couter 12 Moneylet 13 14 Equipment and costs 15 Police Cars 16 Ambulances 17 Finangines 18 Bin Lorry 19 School Books 20 21 Total Cost Emment 22 Money left 23 24 Extra 25 Village Care 26 Fass and Fates 22 Concerts indoor) 26 Concerts outdoors 29 Ducks 30 Swans 31 32 Total Cost Extras 33 Final Budget 34 Total Spending 35 Monthly spending 36 Budget Mini Dar 37 99,000 166.000 20000 50000 30000 50000 200 500 1 1 2 2. 10 6 Total 20000 50000 60000 100000 2000 3000 295000 E 569,000.00 47416,67 334,000.00 TASK1 Open a spreadsheet and construct the same budget as above putting appropriate formulas where necessary. Give the spread sheet the name version. ID) Create a copy of the spreadsheet in sheet two and give it the name Version2. Make the necessary adjustments on version2 so that you do not have a negative figure in cell B33. (Note: no handover was done and so you have to try and figure things out by younelo In the small town of Evercrease, the Council managed to collect half a million pounds from its citizens. Unfortunately, the Council spent all of this, and another 69 thousand besides. Naturally, the good people of Evercrease objected to being asked for another 69 thousand pounds. So they got rid of the council and appointed a new one. Have a look at last year's budget, and see if you can do better. Here's the budget where the previous council overspent by 69 thousand pounds: 1 Budget 500.000 3 Salaries 4 Police Officers 5 Ambulance drivers 6 Firemen women 7 School teachers 8 Refuse collectors 9 Your salary E16.000 12.000 15,000 16.000 E14 000 11000 Number 3 2 2 5 3 1 48000 24000 30000 80000 42000 11000 235,000 265,000 Number 4 5000 10000 12000 12000 200 NNN 20000 20000 24000 24000 11000 55 199,000 165,000 11 Total Cost Salaries 12 Money Left 13 14 Equipment and Costs 15 Police Cars 16 Ambulances 17 Fire engines 18 Bin Lorry 19 School Books 20 21 Total Cost Equipment 22 Money Left 23 24 Extras 25 Village care 26 Fairs and Fetes 27 Concertsindoors 28 Concerts outdoors) 29 Ducks 30 Swans 31 32 Total Cost Extras 33 Final Budget 34 Total Spending 35 Monthly spending 36 Budget Minut Extras Number 1 1 20000 50000 30000 50000 200 500 NN- Total 20000 50000 60000 100000 2000 3000 10 6 235000 E 569,000.00 E 47,416,67 334,000.00 TASK 1 Open a spreadsheet and construct the same budget as above putting appropriate formulas where necessary. Give the spread sheet the name version l. Create a copy of the spreadsheet in sheet two and give it the name Version2. Make the necessary adjustments on version2 so that you do not have a negative figure in cell B33. (Note: no handover was done and so you have to try and figure things out by yourself) In the small town of Evercrease, the Council managed to collect half a million pounds from its citizens. Unfortunately, the Council spent all of this, and another 69 thousand besides. Naturally, the good people of Evercrease objected to being asked for another 69 thousand pounds. So they got rid of the council and appointed a new one. Have a look at last year's budget, and see if you can do better. Here's the budget where the previous council overspent by 69 thousand pounds: c D 500.000 16.000 12000 15.000 16.000 E14 000 11.000 Number 3 2 2 5 3 1 48000 24000 30000 80000 42000 11000 E235.000 265,000 Number 4 1 Budget 2 3 Salaries 4 Police Officers 5 Ambulance drivers 6 Firemen/women 7 School teachers 8 Refuse collectors 9 Your salary 10 11 Total Cost Solaries 12 Money Left 13 14 Equipment and Costs 15 Police Cars 16 Ambulances 17 Fire engines 18 Bin Lorry 19 School Books 20 21 Total Cost Equipment 22 Money left 23 24 Extras 25 Village Care 26 Fairs and Fetes 27 Concertsindoors) 28 Concerts(outdoors) 29 Ducks 30 Swans 31 32 Total Cost Extras 33 Final Budget 34 Total Spending 35 Monthly Spending 36 Budget Minus Extras 37 5000 10000 12000 12000 200 NN 2 2 56 20000 20000 24000 24000 11000 99.000 156.000 20000 50000 30000 50000 200 500 Number 1 1 2 2 10 6 Total 20000 50000 60000 100000 2000 3000 235000 569,000.00 47,416.67 334,000.00 TASK 1 Open a spreadsheet and construct the same budget as above putting appropriate formulas where necessary. Give the spread sheet the name versionl. 1) Create a copy of the spreadsheet in sheet two and give it the name Version2. Make the necessary adjustments on version2 so that you do not have a negative figure in cell B33. (Note: no handover was done and so you have to try and figure things out by yourself)
