+1 650 491 3131

Mobile Service Report Automation

50 Hours

Before Automation

11.67 Hours

After VBA Automation

38.33 Hours

Time Saved Per Month

  • Industry:
  • Retail & Telecommunication

Company Profile: Headquartered in India, it is a leading multi-brand retail chain that deals in mobile phones and connections, accessories, recharges and Internet data cards.

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

Need for Automation:

I am in to MIS team for Service Mobiles. One of my tasks is to generate report for service handsets (thrice in a week) – total quantity of products available in each outlet, total quantity available with supplies, Total stock available at warehouse for each product, period-wise quantity analysis, supplier-wise pendency, legal reports etc., received across 350+ branches.

This report is to understand the status on the defective handsets and resolved customer grievances. As the whole process is tedious and consumes more time, thus a need for automation to reduce the workload.

Cost-Benefit Analysis

Activity # Description Frequency (Monthly) Time Consumed - Manually Time Consumed - After Automation Total Time Savings Per Activity (per day) Total Time Saved Per month
1 Stock Report Generation 20 Days 30 Minutes 5 Minutes 25 Minutes 500 Minutes
2 SDC Report Generation 20 Days 30 Minutes 5 Minutes 25 Minutes 500 Minutes
3 Branch Report Generation 20 Days 30 Minutes 5 Minutes 25 Minutes 500 Minutes
4 Brand Report Generation 20 Days 30 Minutes 10 Minutes 20 Minutes 400 Minutes
5 Legal Report Generation 20 Days 30 Minutes 10 Minutes 20 Minutes 400 Minutes

Cost-Benefit Analysis (Post Macro Implementation)

Description

Stock Report Generation

Frequency

20 Days

Time consumed manually

30 Minutes

Time Consumed for automated activity

5 Minutes

Total time savings per activity

25 Minutes

Total time saved Per month

500 Minutes

Description

SDC Report Generation

Frequency

20 Days

Time consumed manually

30 Minutes

Time Consumed for automated activity

5 Minutes

Total time savings per activity

25 Minutes

Total time saved Per month

500 Minutes

Description

Branch Report Generation

Frequency

20 Days

Time consumed manually

30 Minutes

Time Consumed for automated activity

5 Minutes

Total time savings per activity

25 Minutes

Total time saved Per month

500 Minutes

Description

Brand Report Generation

Frequency

20 Days

Time consumed manually

30 Minutes

Time Consumed for automated activity

10 Minutes

Total time savings per activity

20 Minutes

Total time saved Per month

400 Minutes

Description

Legal Report Generation

Frequency

20 Days

Time consumed manually

30 Minutes

Time Consumed for automated activity

10 Minutes

Total time savings per activity

20 Minutes

Total time saved Per month

400 Minutes

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?