Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. insmniohstn3 eniritol ➤ Food expenses are QAR 250 per week. > Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. Insurance QAR 2,460 per year. Vehicle maintenance QAR 2,000 per year. You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
Income
Monthly Salary
Other Income
Total Income
Expenses miom
Rent
Food
Item
Electricity
Telephone
Entertainment
Clothing
Petrol
Insurance
Maintenance
Unexpected expenses
BUBVY
Total Expenses
Remaining salary
Repayment
Process
Svib supe
metab of 101slublesol pino
abs9102 6 920 of beer w LOY V60ST
enoitslusk
rw 1291690 9rit of a
1691
wollot erit no betsd au
008 AT FAO
Out
Instalments
sno
9 21 30
S19W
bruo
on DOMS HAD onstuar
onsnotais Lebiday.
(Poy Jerty shipsb uor
Transcribed Image Text:Income Monthly Salary Other Income Total Income Expenses miom Rent Food Item Electricity Telephone Entertainment Clothing Petrol Insurance Maintenance Unexpected expenses BUBVY Total Expenses Remaining salary Repayment Process Svib supe metab of 101slublesol pino abs9102 6 920 of beer w LOY V60ST enoitslusk rw 1291690 9rit of a 1691 wollot erit no betsd au 008 AT FAO Out Instalments sno 9 21 30 S19W bruo on DOMS HAD onstuar onsnotais Lebiday. (Poy Jerty shipsb uor
Part A:
Use a spreadsheet to prepare a monthly personal budget to show the
available surplus based on the following data.
➤ Monthly salary is QAR 14,600.
➤ Monthly rental expense is QAR 6,650.
19tn3.
onidiol
➤ Food expenses are QAR 250 per week.
➤ Electricity is estimated to be QAR 50 per month.
➤ Ooredoo unlimited usage telephone plan is QAR 320 per month.
Entertainment is estimated to be QAR 500 per week.
➤Clothing expenses are estimated to be QAR 5,000 per year.
Fuel QAR 50 per week.
➤Insurance QAR 2,460 per year.
➤ Vehicle maintenance QAR 2,000 per year.
➤You decide that you must leave a budgeted surplus of QAR 1,000 per
month to cover unexpected expenses.
Transcribed Image Text:Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. ➤ Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. 19tn3. onidiol ➤ Food expenses are QAR 250 per week. ➤ Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. ➤Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. ➤Insurance QAR 2,460 per year. ➤ Vehicle maintenance QAR 2,000 per year. ➤You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education