Banner Image

All Services

Business & Finance

MS Excel based Optimization techniques

Optimization techniques are deployed using Microsoft Excel functionality and/or formulas, based on mathematical logic to arrive at the required Planned quantities for: * Production at Manufacturing facilities * Distribution / dispatch to Warehouses * Retail Sales to End Customers. Each of the techniques are used to derive the value of the Decision parameter based on the following set of premises: - Objective e.g. Inventory Cost reduction - Constraints (may be single or multiple) which have a measured impact on the Objective. These techniques come in handy for Sales & Operations Planning for: * Constrained / Unconstrained Planning * Forward / Backward Planning * Stock level based Planning (safety stock planning / reorder level planning / min-max planning etc.)

About

$30/hr Ongoing

Download Resume

Optimization techniques are deployed using Microsoft Excel functionality and/or formulas, based on mathematical logic to arrive at the required Planned quantities for: * Production at Manufacturing facilities * Distribution / dispatch to Warehouses * Retail Sales to End Customers. Each of the techniques are used to derive the value of the Decision parameter based on the following set of premises: - Objective e.g. Inventory Cost reduction - Constraints (may be single or multiple) which have a measured impact on the Objective. These techniques come in handy for Sales & Operations Planning for: * Constrained / Unconstrained Planning * Forward / Backward Planning * Stock level based Planning (safety stock planning / reorder level planning / min-max planning etc.)

Skills & Expertise

Cost ReductionFormulaInventory ManagementMathematicsMicrosoft ExcelObjective-COperations ManagementProduction ManagementProduction PlanningRetail SalesStatistics

6 Reviews