+1 650 491 3131

Macro on auto preparation of Remittance Advice

20 Hours

Before Automation

2.9 Hours

After VBA Automation

17.1 Hours

Time Saved per month

  • Industry:
  • Electronics Manufacturing Services and ODM

Company Profile: It is an American multinational technological manufacturer, with corporate headquarters in Singapore and administrative in Silicon Valley, California. It is the third largest global EMS, ODM Company by revenue.

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

Need for Automation:

Conducting Intra-branch contests for staff on key business parameters is one of the motivational measures used at our bank. Such contests are conducted at frequent intervals and the performance of each staff has to be recorded and updated on a daily basis consuming 10 man-hours monthly. Thereby, a simple automation would allow me to focus on other importance aspects of the business.

Cost-Benefit Analysis (Post Macro Implementation)

Activity # Description Frequency Time Consumed - Manually Time Consumed - After Automation Time Saved Time Saved Per Month
1 Filling RA Template 132 times/1056 Minutes 8 Minutes 1 Minutes 7 Minutes 924 Minutes/ 15 Hours & 24 Minutes
2 Updating AR Aging 132 times/66 Minutes 30 Seconds 10 Seconds 20 Seconds 53 Minutes
3 Actual Payment Received 4 times/20 Minutes 5 Minutes 0 5 Minues 20 Minutes
Total 8.75 Hours 1 Minute 8.75 Hours

Cost-Benefit Analysis (Post Macro Implementation)

Description

Filling RA Template

Frequency (Monthly)

132 Times

Time consumed manually

8 Minutes

Time Consumed for automated activity

1 Minutes

Total time savings per activity

7 Minutes

Total time saved Per month

924 Minutes/ 15 Hours & 24 Minutes

Description

Updating AR Aging

Frequency (Monthly)

132 Times

Time consumed manually

30 Seconds

Time Consumed for automated activity

10 Seconds

Total time savings per activity

20 Seconds

Total time saved Per month

53 Minutes

Description

Actual Payment Received

Frequency (Monthly)

4 Times

Time consumed manually

5 Minutes

Time Consumed for automated activity

0

Total time savings per activity

5 Minutes

Total time saved Per month

20 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?