| Article ID: | iaor20032698 |
| Country: | Singapore |
| Volume: | 19 |
| Issue: | 1 |
| Start Page Number: | 63 |
| End Page Number: | 70 |
| Publication Date: | May 2002 |
| Journal: | Asia-Pacific Journal of Operational Research |
| Authors: | Leung Janny, Yu Alan |
| Keywords: | programming: linear, spreadsheets |
This paper illustrates how a frequently-encountered quota allocation problem in sales/production capacity allocation can be modeled as an aggregate planning problem. The corresponding linear program can be easily set up and solved using a spreadsheet with solver.