Lazarus Consulting is a large computer consulting company in New York. Pete Lazarus, the CEO and founder, is well known for his philanthropic efforts. Pete knows that most of his employees contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. Pete began a program that matches 50 percent of each employee donation. The only stipulations are that the charity must be a nonprofit organization and the company will match only up to $2,000 per year per employee.

■ What was the total donation amount per organization?

■ What were the average donations per organization?

Project Number Project Name Project Type Page Number Plug-In Focus Area Project Level Skill Set 1. Introductory Financial Excel T2 Personal Formulas AYK.4 Destiny Budget Introductory T1, T2 Hardware and Introductory 2 Cash Flow Excel T2 Cash Flow Formulas AYK.4 Formulas 3 Technology Budget Excel AYK.4 Software 4 Tracking Excel T2 Employee Introductory Formulas AYK.4 Relationships Donations Introductory nvert Excel T2 Global Formulas AYK.5 Currency Commerce Total Cost of Introductory Ownership 6 Cost Excel T2 Formulas AYK.5 Comparison Excel or Project Introductory 7. Time T12 Project Management Gantt Charts AYK.6 Management Excel T2, T4 Strategic Analysis Intermediate 8. Maximize Formulas or AYK.6 Profit Solver Security Analysis Filtering Data Intermediate Excel T3 Conditional AYK7 Formatting, Autofilter, Subtotal Conditional Formatting 10 Gathering Excel T3 Data Intermediate AYK.8 Data Analysis 11 Scanner Excel T2 Strategic Analysis Intermediate Formulas AYK.8 System Competitive Pricing 12 Excel T2 Profit Intermediate Formulas AYK.9 Maximization 13 Adequate Acquisitions Excel T2 Break-Even Intermediate Formulas AYK.9 Analysis 14 Customer Excel T3 CRM Intermediate PivotTable AYK.9 Relations Assessing the Value of 15 Excel T3 Data Intermediate PivotTable AYK. 10 Analysis Information 16 Growth, Excel T2, T3 Data Advanced Average, AYK.11 Trend, Growth Trends, and Forecasts Forecasting 17 Shipping Costs Excel T4 SCM Advanced Solver AYK. 12 18 If, LookUp Formatting Grades Excel T3 Data Advanced AYK. 12 Analysis