Data Tables

1
Part I

• Data Tables

2
Case Study of Davis Blades

• Manufacturer of in-line skates with multiple
  retail outlets in different regions
• Several different models
• Sales manager at one of the regions tracks data
  on Professional Model to be sure that company
  retains competitiveness
• Desires a detailed report on comparison of
  expenses and costs for manufacturing

3
Cost Volume Profit Analysis(CVP analysis)

• Variable expenses
• change in direct proportion to units produced
• raw materials
• Fixed expenses
• does not depend on units produced or sold
• office renting or machinery leasing
• Mixed - combo of both
• salaries
• Revenue - number of units sold x price per unit
• Breakeven point - Revenue Expenses

4
Graph of Variable Expenses
5
Graph of total monthly expenses
6
Graph of Revenue Per Number of Units Sold
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Part II

• Scenario Management

13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)