Solutions Manual For Business Driven Information Systems 9th Edition By Paige Baltzan, Amy Phillips (All Chapters, 100% Original Verified, A+ Grade)

Business Driven
Information Systems 9e By
Paige Baltzan, Amy Phillips
(Solutions Manual All
Chapters, 100% Original
Verified, A+ Grade)

All Chapters Solutions
Manual Excel files
download link at the end of
this file.

,BUSINESS DRIVEN PR
Project 1 - Financial Destiny
Input boxes in tan
Output boxes in yellow
Given data in blue
Answers in red

,Personal Monthly Budget
Income 1 $4,300 PROJECTED BALANCE
$1,421
PROJECTED MONTHLY INCOME Extra income $300 (Projected income minus expenses)
Total monthly income $4,600 ACTUAL BALANCE (Actual
$1,015
income minus expenses)
Income 1 $4,000
DIFFERENCE
ACTUAL MONTHLY INCOME Extra income $300 ($406)
(Actual minus projected)
Total monthly income $4,300

HOUSING Projected Cost Actual Cost Difference ENTERTAINMENT Projected Cost Actual Cost Difference
Mortgage or rent $1,000 $1,000 $0 Gym Membership $20 $23 ($3)
Phone $54 $100 ($46) Streaming Services $20 $0 $20
Electricity $44 $56 ($12) Movies $40 $20 $20
Gas $22 $28 ($6) Concerts $0 $0 $0
Water and sewer $8 $8 $0 Sporting events $0 $0 $0
Wi-Fi $34 $34 $0 Live theater $0 $0 $0
Waste removal $10 $10 $0 Other $0 $0 $0
Maintenance or repairs $23 $0 $23 Other $0 $0 $0
Supplies $27 $15 $12 Other $0 $0 $0
Other $50 $33 $17 Subtotals $80 $43 $37
Subtotals $1,272 $1,284 ($12)
LOANS Projected Cost Actual Cost Difference
TRANSPORTATION Projected Cost Actual Cost Difference Personal $0 $0 $0
Vehicle payment $350 $350 $0 Student $250 $250 $0
Bus/taxi fare $0 $0 $0 Credit card $75 $75 $0
Insurance $35 $35 $0 Credit card $20 $20 $0
Licensing $0 $0 $0 Credit card $0 $0 $0
Fuel $100 $186 ($86) Other $0 $0 $0
Maintenance $50 $0 $50 Subtotals $345 $345 $0
Other $0 $0 $0
Subtotals $535 $571 ($36) TAXES Projected Cost Actual Cost Difference
Federal $0 $0 $0
INSURANCE Projected Cost Actual Cost Difference State $0 $0 $0
Home $120 $120 $0 Local $0 $0 $0
Health $50 $50 $0 Other $0 $0 $0
Life $42 $42 $0 Subtotals $0 $0 $0
Other $0 $0 $0
Subtotals $212 $212 $0 SAVINGS OR INVESTMENTS Projected Cost Actual Cost Difference
Retirement account $0 $0 $0
FOOD Projected Cost Actual Cost Difference Investment account $0 $0 $0
Groceries $350 $310 $40 Other $0 $0 $0
Dining out $100 $145 ($45) Subtotals $0 $0 $0
Other $50 $40 $10
Subtotals $500 $495 $5 GIFTS AND DONATIONS Projected Cost Actual Cost Difference
Charity 1 $0 $0 $0
PETS Projected Cost Actual Cost Difference Charity 2 $0 $0 $0
Food $30 $25 $5 Charity 3 $0 $0 $0
Medical $0 $0 $0 Subtotals $0 $0 $0
Grooming $0 $0 $0
Toys $15 $20 ($5) LEGAL Projected Cost Actual Cost Difference
Other $0 $0 $0 Attorney $0 $100 ($100)
Subtotals $45 $45 $0 Alimony $0 $0 $0
Payments on lien or judgment $0 $0 $0
PERSONAL CARE Projected Cost Actual Cost Difference Other $0 $0 $0
Medical $50 $0 $50 Subtotals $0 $100 ($100)
Hair/nails $0 $0 $0
Clothing $50 $100 ($50)
TOTAL PROJECTED COST $3,179
Dry cleaning $0 $0 $0
Health club $75 $75 $0
TOTAL ACTUAL COST $3,285
Organization dues or fees $15 $15 $0
Other $0 $0 $0
TOTAL DIFFERENCE ($106)
Subtotals $190 $190 $0

, BUSINESS DRIVEN PR
Project 2 - Cash Flow
Input boxes in tan
Output boxes in yellow
Given data in blue
Answers in red