DECISION MATRIX
Management has told you that in response to the economic downturn, they are going to implement a 17% workforce reduction, impacting 44 employees and saving an estimated $2.57 million in payroll -- just enough, perhaps, to keep the company in the black for 2009.
They have indicated that they would like $575,000 of those cuts to come from the Retail Division.
FIRST, discuss a layoff and go-forward operating strategy with your team. SECOND, click on the link below to download an interactive spreadsheet that will help you determine how you will get to the $575,000 number. Click on the names at right for more information.
click HERE to download an interactive version of the spreadsheet |
|||||||
| WORKER | FUNCTION | SALARY | KEEP | DISMISS | PAYROLL | AMT SAVED |
AMT STILL NEEDED TO CUT |
| ALL | $ 1,436,000 | $1,436,000 | $0 | $575,000 | |||
| You | VP Retail Operations | $ 125,000 | $ 125,000 | ||||
| Taryn Smith | Retail Coordinator | $ 50,000 | $ 50,000 | ||||
| Shin Liu | Accountant | $ 45,000 | $ 45,000 | ||||
| Marley Mason | Marketing/Advertising Mgr. | $ 45,000 | $ 45,000 | ||||
| Sunil Mandathan | Dir. Retail Info. Systems | $ 100,000 | $ 100,000 | ||||
| Programmer | $ 75,000 | $ 75,000 | |||||
| Systems Support Specialist | $ 55,000 | $ 55,000 | |||||
| Network Administrator | $ 65,000 | $ 65,000 | |||||
| Jack Danella | Dir. New Product Dev. | $ 115,000 | $ 115,000 | ||||
| Karl Neumeyer | New Product Dev. Mgr. | $ 49,000 | $ 49,000 | ||||
| Neil Cassavettes | New Product Dev. Mgr. | $ 45,000 | $ 45,000 | ||||
| Lydia Espinoza | Administrative Assistant | $ 28,000 | $ 28,000 | ||||
| Sharon Christianson | Dir. Retail Operations | $ 100,000 | $ 100,000 | ||||
| Carney Kelly | Dir. Product Manufacturing | $ 105,000 | $ 105,000 | ||||
| Gideon Buckminster | Administrative Assistant | $ 33,000 | $ 33,000 | ||||
| Henderson Store Mgr. | $ 66,000 | $ 66,000 | |||||
| Henderson Employee 1 | $ 30,000 | $ 30,000 | |||||
| Henderson Employee 2 | $ 30,000 | $ 30,000 | |||||
| Henderson Employee 3 | $ 25,000 | $ 25,000 | |||||
| Henderson Employee 4 | $ 22,000 | $ 22,000 | |||||
| Henderson Employee 5 | $ 22,000 | $ 22,000 | |||||
| Henderson Employee 6 | $ 19,000 | $ 19,000 | |||||
| San Diego Store Mgr. | $ 60,000 | $ 60,000 | |||||
| San Diego Employee 1 | $ 25,000 | $ 25,000 | |||||
| San Diego Employee 2 | $ 30,000 | $ 30,000 | |||||
| San Diego Employee 3 | $ 26,000 | $ 26,000 | |||||
| San Diego Employee 4 | $ 24,000 | $ 24,000 | |||||
| San Diego Employee 5 | $ 22,000 | $ 22,000 | |||||
| SD Lease Covenant | 0 | ||||||
Your Direct Reports
Sunil Mandathan, Dir. of Retail Information Sys.Jack Danella, Dir. of New Product Development
Sharon Christianson, Dir. of Retail Operations
Carney Kelly, Dir. Product Manufacturing
Taryn Smith, Retail Coordinator
Shin Liu, Accountant
Marley Mason, Marketing & Advertising Manager
Sunil's Team
ProgrammerSystems Support Specialist
Network Administrator
Jack's Team
Karl Neumeyer, New Product ManagerNeil Cassavettes, New Product Manager
Lydia Espinoza, Administrative Assistant
Sharon's Team
Gideon Buckminster, Administrative AssistantHenderson Store Mgr.
Henderson Employee 1
Henderson Employee 2
Henderson Employee 3
HendersonEmployee 4
Henderson Employee 5
Henderson Employee 6
San Diego Store Mgr.
San Diego Employee 1
San Diego Employee 2
San Diego Employee 3
San Diego Employee 4
San Diego Employee 5