Íà ãîëîâíó    

 Calculation of the family budget on the half - Economic-mathematical modeling

INSTITUTE advertising, tourism and show business PRACTICAL WORK

On the course: "Computer Science".

TAGS: Calculation of the family budget

in the first half.

Fulfilled: student 3rd year

Zor'ko AA

Tel. 211-7003

Check: ___

___ Moscow, 1998

Table Of Contents:

 1. Content (WinWord) ... ... 2

 2. Task (WinWord) ... 3

 3. Sheet 1. Income. (Excel) ... ... 5

 4. Sheet 2. Utilities. (Excel) ... 6

 5. Sheet 3. Accommodation. (Excel) ... ... 7

 6. Sheet 4. Entertainment. (Excel) ... 8

 7. Sheet 5. The total budget. (Excel) ... 9

 8. Diagrams on free agents. (Excel) 10

 9. Notes ... 11

Task:

1. The first sheet of the spreadsheet rename income and create for us the following table by filling in your data:

 The total budget for six months

 Information on the family budget in January February March April May June

 Wages

 Income tax

 Social Security

 Local taxes

 Other deductions

 "Net income"

 Other additional income

 Total monthly income

For various taxes and deductions set some%, such as local taxes - 1% of salary. Since taxes are paid monthly, insert an additional column to the data for January, for these data, and an additional column to calculate the total amount for each article of the half.

2. The second sheet ET rename utilities and build the same table, listing the items of expenditure utilities, such as electricity, rent for an apartment (or house), cable TV, telephone, gas and other. In the lower row, select the data on total expected utilities and general monthly utility costs, taking into account unexpected expenses without them. Contingency is usually allocated about 15% of the amount for general utilities.

3. The third sheet rename Accommodation, create a table similar to the previous ones, but it is necessary to list the articles of residence, for example - food, bakery products. Tea, coffee, sweets, vegetables, fruits and others. Contingency you need to allocate 10% of the total accommodation. Total expenditure on accommodation is to anticipate and unforeseen expenses.

4. The fourth leaf rename Entertainment, in this table, do the same as the previous ones, cost items - movies. Theater, music, dining out, books, etc.. You want. Include contingency items - 17% of the total entertainment.

5. The fifth leaf rename the general budget, which create a summary table for the six months under articles - Total monthly income, utilities, accommodation, entertainment, total. The total budget should be calculated for the six months, taking into account unforeseen expenses and excluding.

6. On the basis of these data, build chart information about the family.

Income

 The total budget for six months

 Information on the family budget

 % In January February March April May June Total

 Wages 15 000,00 p. 15 000,00 p. 15 000,00 p. 15 000,00 p. 20 000,00 p. 20 000,00 p. 100 000,00 p.

 Income tax 12% 1 800.00. 1 800.00. 1 800.00. 1 800.00. 2 400.00. 2 400.00. 12 000,00 p.

 Social protection 2% 300.00. 300.00. 300.00. 300.00. 400.00. 400.00. 2 000,00 p.

 Local taxes 1% 150,00r. 150,00r. 150,00r. 150,00r. 200,00r. 200,00r. 1 000,00 p.

 Other deductions 1% 150,00r. 150,00r. 150,00r. 150,00r. 200,00r. 200,00r. 1 000,00 p.

 "Net income"

 12 600.00. 12 600.00. 12 600.00. 12 600.00. 16 800.00. 16 800.00. 84 000,00 p.

 Other additional income

 5 000,00 p. 1 200,00r. $ 0.00. $ 0.00. 3 000,00 p. 2 000,00 p. 11 200,00r.

 Total monthly income

 17 600.00.

 13 800.00.

 12 600.00.

 12 600.00.

 19 800.00.

 18 800.00.

 95 200,00r.

Utilities income

 Utilities

 % In January February March April May June Total

 Electricity $ 50.00. $ 50.00. 40,00r. 30,00r. 30,00r. 30,00r. 230,00r.

 Phone 20,00r. 20,00r. 20,00r. 20,00r. 20,00r. 20,00r. 120,00r.

 Gas 10,00r. 10,00r. 10,00r. 10,00r. 10,00r. 10,00r. 60,00r.

 Heating 70,00r. 70,00r. 70,00r. 70,00r. 70,00r. 70,00r. 420,00r.

 10,00r removal of solid waste. 10,00r. 10,00r. 15,00r. 15,00r. 15,00r. 75,00r.

 Maintenance 22,00r. 22,00r. 22,00r. 30,00r. 30,00r. 30,00r. 156,00r.

 7,00r antenna. 7,00r. 7,00r. 7,00r. 7,00r. 7,00r. 42,00r.

 Radio 4,00r. 4,00r. 4,00r. 4,00r. 4,00r. 4,00r. 24,00r.

 7,00r intercom service. 7,00r. 7,00r. 7,00r. 10,00r. 10,00r. 48,00r.

 Total expenditure on public services

 200,00r. 200,00r. 190,00r. 193,00r. 196,00r. 196,00r. 1 175,00r.

 Unforeseen expenses 15% 30,00r. 30,00r. 28,50r. 28,95r. 29,40r. 29,40r. 176,25r.

 Given the unexpected expenses

 230,00r.

 230,00r.

 218,50r.

 221,95r.

 225,40r.

 225,40r.

 1 351,25r.

 Accommodation

 % In January February March April May June Total

 Products

 4 000,00 p. 4 000,00 p. 4 050,00r. 4 050,00r. 4 100,00r. 4 100,00r. 24 300.00.

 Drinks 400.00. 400.00. 400.00. 400.00. 450.00. 500.00. 2 $ 550.00.

 Dry food 400.00. 450.00. 500.00. $ 550.00. 600.00. 650,00r. 3 150,00r.

 Petrol 1 200,00r. 1 250,00r. 1 300.00. 1 350.00. 2 000,00 p. 2 000,00 p. 9 100,00r.

 Personal care, cosmetics 1 000,00 p. 300.00. 300.00. 400.00. 500.00. 300.00. 2 800.00.

 Clothing 2 000,00 p. 2 000,00 p. 3 000,00 p. 2 000,00 p. 3 000,00 p. 1 000,00 p. 13 000,00 p.

 Tobacco 240,00r. 240,00r. 250,00r. 250,00r. 260,00r. 260,00r. 1 500.00.

 General living expenses

 9 240,00r. 8 640,00r. 9 800.00. 9 000,00 p. 10 910,00r. 8 810,00r. 56 400.00.

 Unforeseen expenses 10% 924,00r. 864,00r. 980,00r. 900.00. 1 091,00r. 881,00r. 5 640,00r.

 Given the unexpected expenses

 10 164,00r.

 9 504,00r.

 10 780,00r.

 9 900.00.

 12 001,00r.

 9 691,00r. 62 040,00r.

 Entertainment

 % In January February March April May June Total

 Movie

 120,00r. 120,00r. 120,00r. 120,00r. 120,00r. - P. 600.00.

 Theatre 200,00r. 100,00r. 100,00r. 100,00r. - P. - P. 500.00.

 Video 200,00r. 200,00r. 200,00r. 200,00r. 100,00r. 100,00r. 1 000,00 p.

 Music 60,00r. 60,00r. 60,00r. 60,00r. 60,00r. 100,00r. 400.00.

 Books $ 50.00. $ 50.00. $ 50.00. $ 50.00. $ 50.00. $ 50.00. 300.00.

 Trenazhenry 360,00r room. 360,00r. 360,00r. 360,00r. - P. - P. 1 440,00r.

 Cafe 200,00r. 200,00r. 200,00r. 200,00r. 300.00. 500.00. 1 600.00.

 Horse Riding - p. - P. - P. - P. 400.00. 500.00. 900.00.

 Total expenditure on entertainment

 1 190,00r. 1 090,00r. 1 090,00r. 1 090,00r. 1 030,00r. 1 250,00r. 6 740,00r.

 Unforeseen expenses 17% 202,30r. 185,30r. 185,30r. 185,30r. 175,10r. 212,50r. 1 145,80r.

 Given the unexpected expenses

 1 392,30r.

 1 275,30r.

 1 275,30r.

 1 275,30r.

 1 205,10r.

 1 462,50r.

 7 885,80r.

Total budget

 Utilities / y cont. 230,00r costs. 230,00r. 218,50r. 221,95r. 225,40r. 225,40r. 1 351,25r.

 Accommodation / y cont. 10 164,00r costs. 9 504,00r. 10 780,00r. 9 900.00. 12 001,00r. 9 691,00r. 62 040,00r.

 Entertainment / y cont. 1 392,30r costs. 1 275,30r. 1 275,30r. 1 275,30r. 1 205,10r. 1 462,50r. 7 885,80r.

 Total (free money) c / y cont. expenses

 5 813,70r.

 2 790,70r.

 326,20r.

 1 202,75r.

 6 368,50r.

 7 421,10r.

 23 922,95r.

 1. Utilities.

 2. Accommodation.

 3. Entertainment.

 4. Free tools.

© 8ref.com - óêðà¿íñüê³ ðåôåðàòè