Green Bay Packers Resource Allocation Model

1
Green Bay Packers Resource Allocation Model

• Adam P. Rohan
• Katz Graduate School of Business
• Fall 2003

2
The Packers 2002

• Overall Record 12-5 (includes Playoff Loss)
• Overall Ranking
• Offense 12th of 32
• Defense 12th of 32

3
Areas of Strength/Weakness

• Strengths
• QB 3 Time MVP
• RB 2 Time Pro-Bowl
• OL Pro Bowl Caliber
• Weaknesses (Defenses wins championships)
• DL
• LB
• WR

4
The Salary Cap

• A set amount of money that each of the NFLs 32
  teams are allowed to spend on player salaries
• For 2003 75.007 Million

5
The Salary Cap

• Determined using the formula
• Projected Defined Gross Revenues x CBA
  Percentages Players Share DGR
• Players Share Projected League wide Benefits
  Amount Available for Player Salaries
• Amount Available for Player Salaries / Number of
  Teams Unadjusted Salary Cap Per Team
• Minimum Team Salary (MTS) 56

6
What is Salary?

• For the purposes of the Salary Cap salary is
  all compensation paid to a player including
• Money
• Property
• Investments
• Loans
• Includes Signing Bonuses, LTBE

7
Green Bay Resource Allocation Model

• Rank all Players by Position
• Use statistics commonly used to evaluate a player
  and the position
• Example QB Completions, yards, interceptions,
  TDs

8
(No Transcript)
9
(No Transcript)
10
Resource Allocation Model

• Rank Positions by importance
• Import player rankings
• Set Priorities

11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
Go To Solver

• Place data in Excel Spreadsheet
• Player Ranking
• Total Salary Cap Number
• Priority Ranking