STR/581 - STRATEGIC PLANNING & IMPLEMENTATION

profilePERU
tasks-budget-pandl.xlsx
Home>Business & Finance homework help>Operations Management homework help>STR/581 - STRATEGIC PLANNING & IMPLEMENTATION

Tasks - WBS

[Strategy Name]
[Organization Name]
Strategy Leader: John Doe
Start Date: 1/5/09
WBS Number Task Description Task Leader Start End Duration (Days) Task preceded by
1 Site Selection John 1/05/09 1/16/09 12
1.1 Sub Task level 2 Jim 1/05/09 1/05/09 1
1.2 Sub Task level 2 Dale 1/05/09 1/05/09 1
1.2.1 Sub Task level 3 Sandra 1/06/09 1/08/09 3 1.1, 1.2, 1.3
1.2.2 Sub Task level 3 Sandra 1/05/09 1/05/09 1
1.3 Sub Task level 2 Chuck 1/05/09 1/08/09 4 1.2
1.4 Sub Task level 2 Roxanne 1/05/09 1/16/09 12
2 Design Jane 1/05/09 1/16/09 12
2.1 Sub Task level 2 Chuck 1/05/09 1/11/09 7
2.2 Sub Task level 2 Jamey 1/09/09 1/15/09 7 1.3
2.3 Sub Task level 2 Melanie 1/05/09 1/11/09 7
2.4 Sub Task level 2 Roger 1/07/09 1/16/09 10 1.2.2
3 Permit Process Bill 1/12/09 2/07/09 27
3.1 Sub Task level 2 Sandra 1/12/09 1/17/09 6 2.3
3.2 Sub Task level 2 Roxanne 1/19/09 1/24/09 6 3.1
3.3 Sub Task level 2 Roxanne 1/24/09 1/31/09 8 1.4
3.4 Sub Task level 2 Sandra 1/30/09 2/07/09 9
4 Site Work Bill 2/07/09 3/01/09 23
4.1 Sub Task level 2 Dale 2/07/09 2/09/09 3
4.2 Sub Task level 2 Chuck 2/09/09 2/22/09 14 4.1
4.3 Sub Task level 2 Greg 2/07/09 2/28/09 22
4.4 Sub Task level 2 Keshia 2/13/09 3/01/09 17

Plan Budget Example

STRATEGIC PLAN BUDGET EXAMPLE
[Strategy Name]
WBS Number Task Description Plan Budget Expected Timing of Expense
1 Site Selection
1.1 Sub Task level 2 $ 25,000 1/16/09
1.2 Sub Task level 2 $ 13,000 1/16/09
1.2.1 Sub Task level 3 $ 9,700 1/16/09
1.2.2 Sub Task level 3 $ 37,000 1/16/09
1.3 Sub Task level 2 $ 41,000 1/16/09
1.4 Sub Task level 2 $ 900 1/16/09
Total $ 126,600
2 Design
2.1 Sub Task level 2 $ 88,000 1/16/09
2.2 Sub Task level 2 $ 400 1/16/09
2.3 Sub Task level 2 $ 2,765 1/16/09
2.4 Sub Task level 2 $ 7,900 1/16/09
Total $ 99,065
3 Permit Process
3.1 Sub Task level 2 $ 200 2/7/09
3.2 Sub Task level 2 $ 500 2/7/09
3.3 Sub Task level 2 $ 1,000 2/7/09
3.4 Sub Task level 2 $ 800 2/7/09
Total $ 2,500
4 Site Work
4.1 Sub Task level 2 $ 342,000 3/1/09
4.2 Sub Task level 2 $ 127,000 3/1/09
4.3 Sub Task level 2 $ 96,500 3/1/09
4.4 Sub Task level 2 $ 298,000 3/1/09
Total $ 863,500
Grand Total $ 1,091,665

5 yr P&L example

5 YEAR P&L FORECAST FOR XYZ CORP. (SIMPLE EXAMPLE - Delete data and alter as needed)
[Strategy Name]
Category 2009 2010 2011 2012 2013
REVENUE
Gross Sales $ 19,500,300 $ 21,450,330 $ 23,595,363 $ 25,954,899 $ 28,550,389
Minus returns $ 97,502 $ 107,252 $ 117,977 $ 129,774 $ 142,752
Minus discounts $ 390,006 $ 429,007 $ 471,907 $ 519,098 $ 571,008
Net Sales $ 19,012,793 $ 20,914,072 $ 23,005,479 $ 25,306,027 $ 27,836,629
EXPENSES
Salaries and Wages $ 2,786,300 $ 2,869,889 $ 2,955,986 $ 3,044,665 $ 3,136,005
Health Insurance and Benefits $ 975,205 $ 1,043,469 $ 1,116,512 $ 1,194,668 $ 1,278,295
Workmens Comp Insurance $ 334,356 $ 344,387 $ 354,718 $ 365,360 $ 376,321
Training Expense $ 125,000 $ 125,000 $ 125,000 $ 125,000 $ 125,000
Travel & Entertainment $ 245,000 $ 245,000 $ 245,000 $ 245,000 $ 245,000
Company vehicle expenses $ 97,400 $ 97,400 $ 97,400 $ 97,400 $ 97,400
General Supplies $ 1,145,600 $ 1,168,512 $ 1,191,882 $ 1,215,720 $ 1,240,034
Leases $ 4,500,000 $ 4,500,000 $ 4,500,000 $ 4,500,000 $ 4,500,000
Taxes all types $ 145,000 $ 145,000 $ 145,000 $ 145,000 $ 145,000
Utilities $ 47,000 $ 47,470 $ 47,945 $ 48,424 $ 48,908
Outside Services $ 1,900,450 $ 1,938,459 $ 1,977,228 $ 2,016,773 $ 2,057,108
Proposed Plan Expenses (from Plan Budget) $ 1,091,665 $ - 0 $ - 0 $ - 0 $ - 0
Total Expenses $ 13,392,976 $ 12,524,586 $ 12,756,671 $ 12,998,010 $ 13,249,072
Profit/Loss $ 5,619,817 $ 8,389,486 $ 10,248,808 $ 12,308,017 $ 14,587,558