I-23.05 Problem

# I-23.05 Problem - (b) Analyze the data and identify the...

This preview shows page 1. Sign up to view the full content.

I-23.05 Books 332 23 433 89 779 54 210 00 Mr. and Mrs. Driggs have four children, all of whom are away at college. Below is a listing of expenses incurred by the kids during a recent month. CHILD Expense Cathy David Rachel Caroline Food 150.76 \$ 344.56 \$ 266.76 \$ 222.92 \$ Rent 475.00 300.00 395.00 225.00 Entertainment 44.67 25.00 321.56 66.56 Electricity 68.90 110.78 55.89 76.99 Auto 220.20 - 124.44 188.88 Insurance 87.76 55.55 144.09 47.75 Phone 45.45 88.09 25.00 37.98 Tuition 825.00 990.00 - 500.00 332.23 . 433.89 . 779.54 . 210.00 . Clothing 66.90 423.65 103.19 385.58 (a) Analyze the data and identify the most expensive child.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (b) Analyze the data and identify the expense category of greatest cost. (c) Comment on the value of line item and object of expenditure analysis of data in a business context. How do modern information systems facilitate such analysis? (d) (optional) Pivot tables are useful tools for enhanced analysis of data. Experiment with the pivot table on the electronic worksheet template, and see if you can confirm you answers to part (a) and part (b). What other ways can the data be sorted?...
View Full Document

Ask a homework question - tutors are online