Summary: 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.