A PC‐based Spreadsheet Support System for the Newsboy Inventory Control Problem

In this article, a PC‐based spreadsheet support system (SSS) for controlling inventory and service level for the newsboy problem is developed utilising Lotus 1‐2‐3 spreadsheet capabilities. The technical aspects of the SSS are presented and discussed within the context of a numerical example. The developed SSS permits the decision maker to simulate and analyse the impact of parameter changes on the inventory system using a familiar PC spreadsheet package.