Excelgoodies +1 650 491 3131

WarehouseOps Optimization

4.67 Hours

Before Automation

40 Minutes

After VBA Automation

4 Hours

Time Saved per month

  • Industry:
  • Commercial printing, Logistics and Supply Chain, Digital Marketing

Company Profile: A Fortune 500 integrated communications company, headquartered in Chicago, provides marketing and business communications, commercial printing, and related services.

  • Department:
  • Customer Support
  • Tool(s) Used:
  • Microsoft Excel VB Programming (Macro)

Need for Automation:

In my role within the Customer Support department, I consistently find myself managing a diverse range of Stock Status information for Sales Reps, encompassing critical details such as backorders, available quantities, order quantities, and other relevant metrics across various warehouse/plants. This multifaceted task consumes approximately 2 hours of man-hour weekly. Recognizing the pressing need for efficiency, my goal is to automate this comprehensive process, optimizing not only my time but also ensuring that Sales Reps receive a swift and accurate overview of the stock situation.

Additionally, I am entrusted with the responsibility of consolidating extensive data from multiple files, each containing a wealth of post-production details. Currently occupying an extra hour each week, the automation of this data consolidation process would liberate valuable time, enabling me to focus more effectively on other critical aspects of my responsibilities.

Cost-Benefit Analysis (Post Macro Implementation)

Activity # Frequency Manual Effort Production Time
1 Status Stock Report 4 week
Before Automation
70 Minutes 56 Hours
After Automation
10 Minutes 8 Hours

The Manual effort time for this project will acquire 1 hour 10 minutes and its weekly-based report. Annual Production Time for this job is 56 hours.

Now this job has been automated and effort time would be 10 minutes and APT for this job is 8 hours.

This project reduced of effort time on this job.

Join our 10-day online session and learn how to automate your Excel Reports and Processes using VBA Programming. No prior programming experience needed!.

Upcoming Schedule:

  • Date:
  • Sunday, July 11
  • Time:
  • 10:00 AM - 12:30 PM (ET)

Proficiency with Excel formulas is a prerequisite. Not sure about your skills? Schedule a pre-assessment at 650-491-3131 to evaluate your Excel proficiency.

Explore 90+ practical scenarios, delve into 7 case studies, and complete a live VBA project.

Ready to learn Excel VBA Macro?