Optimizing PURCHASING and INVENTORY Using MS Excel

Optimizing PURCHASING and INVENTORY Using MS Excel 150 150 GCSS Inc.

Introduction

Participants who have existing needs of “optimizing” or “maximizing” current procurement process optimization, including the capability of “optimizing” schedules of current procurements, subject to “defined” constraints, and other constraints that maybe applied, based on prevailing company/organization policies.

Scenario models will be taken up for this paid webinar gives practical and industry-practiced examples for users within organizations tasked to manage its procurement activities, alongside inventory control and management.

Learning Objectives

Logistics analytics is a concept used by companies to define analytical processes to evaluate and organize the logistical role and supply chain to ensure timely and cost-effective, smooth running of operations.  Participants are encouraged to maximize these Excel functionalities which are normally applied for logistics-related concerns.

The objective of this webinar is to enable small to medium size organizations to optimize their procurement and inventory control processes using the latest features of the standard Excel Optimization add-ins.

Who Should Attend

Those who are involved with logistics and purchasing operation and function.

Program Duration

3 days, 3 hours per day.

Scenarios to be Covered

Scenario 01 — Award contracts for providers which have bids to supply goods to facilities in many locations/destinations provisioning for bids to be made for the minimum size of each location.

Scenario 02 – Perform Inventory Stocking / Reordering process with intent to optimally achieve or equate existing inventory stocking and reordering guidelines to the company defined EOQ (Economic Order Quantity) model.

Scenario 03 – Total Advertising Cost Model. Ascertain the level of advertising which needs to be contracted in different media to minimize and reduce total costs based on the defined degree of reach or frequency.

Scenario 04 – Transport Model. Decide how much amount is required to be paid to Various suppliers for shipment of items from various locations/warehouses to be delivered to different plants/warehouses with the final objective of reducing total costs all shipping and procurement costs.

For a complete course outline, email trainings@gcssinc.com. 

Download Sustainability Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Resiliency Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Productivity Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Sociability Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.