## What is the sale price of car racks sold in Washington and California?

##### Description

Problem 1: Basic Calculations

On Worksheet #1, calculate and report the

a) \$ __________________ Average revenue

b) \$ __________________ Total Expenses

c) \$ __________________ Pret’s profit

d)   __________________ Store with the highest profit

e) \$ __________________ Total Profit

Problem 2: Pivot Table

On Worksheet #2, calculate and report the

a)    __________________How many tents were sold in Oregon?

b) \$__________________Total sales of backpacks?

d)   __________________How many sleeping bags were sold?

e) \$__________________What is the sale price of car racks sold in Washington and California?

Problem 3: Income Statement

On Worksheet #3, complete the income statement. Report the following. Work through without pushing “undo” (leaving any previous changes the way they are):

a) \$__________________ Net income

b) \$__________________ Net income if travel increases to \$25,000

c) \$__________________ Insert an operating expense called “Transportation Costs” at \$13,500 and increase utilities to \$9000. What is the new net income?

d) \$__________________ Taxes if the tax rate is 10%

e) \$__________________ Gross profit

Problem 4: Breakeven Analysis

On Worksheet #4, calculate and report

a) \$__________________ Total costs

b) \$__________________ Profit

c)  __________________ Breakeven point

d)  __________________ Breakeven point if the fixed cost is \$10,000

e) \$__________________ Fixed cost if the breakeven point is 700

Problem 5: LOOKUP & COUNTIF functions

On Worksheet #5, calculate and report

a) __________________ What is the average review score for all students

b) ____________________________________ Report the lookup function to categorize students as above or below average (average is the mean review score in the question a) )

c) __________________ How many students are above average

d) __________________ How many students are below average

e) ____________________________________ Report the function used to calculate the number of above average students