WFPA
La Mono Bella
WFPAExercise2.xlsx1
| Product Line | A | B | C | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $1,800,000 | ? | $1,600,000 | ? | $5,200,000 | ? |
| Growth % | 22% | 238% | -10% | |||
| Sales Staff | 5 | ? | 5 | ? | 22 | ? |
| Support Staff | 2 | ? | 3 | ? | 24 | ? |
| Assume all product lines are similar in terms of needed resources and resources skills are the same for each product line | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
2
| Store Location | Orange County | Pasadena | Malibu | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $1,800,000 | ? | $1,600,000 | ? | $5,200,000 | ? |
| Growth % | 22% | 238% | -10% | |||
| Sales Staff | 8 | ? | 15 | ? | 12 | ? |
| Support Staff | 3 | ? | 5 | ? | 6 | ? |
| Assume all all stores are similar in terms of needed resources and resources skills and that moving staff from store to store is easily done. | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
3
| Product Line | A | B | C | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $1,800,000 | $1,600,000 | $5,200,000 | |||
| Growth % | 67% | 150% | -5% | |||
| Sales Staff | 8 | ? | 4 | ? | 12 | ? |
| Support Staff | 3 | ? | 2 | ? | 6 | ? |
| Assume all product lines are similar in terms of needed resources and resources skills are the same for each product line | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
4
| Store Location | Orange County | Pasadena | Malibu | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $1,800,000 | ? | $1,600,000 | ? | $5,200,000 | ? |
| Growth % | 67% | 150% | -5% | |||
| Sales Staff | 8 | ? | 4 | ? | 12 | ? |
| Support Staff | 3 | ? | 2 | ? | 6 | ? |
| Assume all all stores are similar in terms of needed resources and resources skills and that moving staff from store to store is easily done. | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
5
| Store Location | Orange County | Pasadena | Malibu | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $500,000 | ? | $1,600,000 | ? | $5,200,000 | ? |
| Growth % | 500% | -55% | -5% | |||
| Sales Staff | 2 | ? | 9 | ? | 12 | ? |
| Support Staff | 1 | ? | 5 | ? | 15 | ? |
| Assume all all stores are similar in terms of needed resources and resources skills and that moving staff from store to store is easily done. | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
6
| Product Line | A | B | C | |||
| Year | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Revenue | $500,000 | ? | $1,600,000 | ? | $5,200,000 | ? |
| Growth % | 500% | -50% | -5% | |||
| Sales Staff | 3 | ? | 8 | ? | 12 | ? |
| Support Staff | 0 | ? | 4 | ? | 15 | ? |
| Assume all product lines are similar in terms of needed resources and resources skills are the same for each product line | ||||||
| How many total sales staff do you need? | ||||||
| How many total support staff do you need? | ||||||
| What will your action plan be? |
