What is the sale price of car racks sold in Washington and California?
business
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?
c) __________________Which state had the lowest
total wholesale price for headlamps?
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
