About this document
Aggregate Planning for SureStep Company by Laís Contier is a document available to read on EtoBox.
This document describes a spreadsheet model for an aggregate production planning problem faced by SureStep Company. The model tracks production, labor, inventory, and costs over four months to determine the optimal production and labor hiring/firing decisions. Key aspects of the model include constraints on labor hours, production capacity, and meeting demand. The model is solved using linear programming in Excel Solver to minimize total costs. An extension allows for backlogging of demand by allowing negat
- Author
- Laís Contier
- Language
- EN