RED BRAND CANNERS REVISITED
Resource allocation report
Decision and Risk analysis
Contents
Executive Summary page 2
Introduction page 2
1 The basic model without the option of additional A tomatoes page 2
2 Additional supply of A tomatoes (AA) page 3
3 Advertising page 3
4 Additional supply of B tomatoes (BB) page 4
5 Closing down production lines? page 4
Appendix 1 - The Basic Model page 5
Appendix 2 ? Additional Supply of A tomatoes page 7
Appendix 3 ? Advertising page 8
Appendix 4 ? Additional supply of B tomatoes page 9
Appendix 5 ? Closing down production lines? Page 10
Executive Summary
By using resource allocation techniques with the support of Excel Solver, we were able to find an optimal solution that maximizes RBC's profit ($136,300) for this year's tomato crop, taking into consideration the known constrain ...