Multiproduct cost-volume-profit model with product limits

A multiproduct cost-volume-profit model is extended to incorporate sales or product capacity limits for each product, required rate of return on sales, and the tax rate depending on profit levels as determined by the government. The model also deals with overhead costs that are traceable to a group of products but which cannot be allocated to individual products within the group to any reasonable accuracy. To solve the model, an algorithm is constructed to determine the required volume for each product that will achieve the best possible rate of return on sales revenue. Based upon the dBase Database Management System and the CVP model, a user-friendly menu-driven interactive decision support system is developed. The model algorithm and decision support system is illustrated with an example consisting of five products. Various reports generated by the interactive decision support system are also presented.