Use Pivot Table and Become Smart in Report Making (Download Excel Template)

SHARE:

Making production reports is made easy with the use of Pivot Table. Sample report template for garment manufacturers are shared and can be downloaded.

Report making is one of the daily activities for most of the garment manufacturers in the garment industry. Most of the them use spread sheet (MS Excel or Open Office) for making daily production report and other reports.

I assume that you are one of them. You may know how to use spread sheet. The question is how are you utilizing excel tools to make your reports?

Take an example of making Daily production report (DPR). You make it daily, right? How do you do it? I hope you follow these step,

Existing Method of Report Making

  • You have DPR template with set formula 
  • You copy last day’s sheet and make new sheet. 
  • You delete previous day’s production quantity and add today’s production
  • Add new rows in the template if need to add more/new style in the report
  • You drag formula to new rows added in the new sheet
  • You calculate total production by adding today’s production
  • You cross check and tally production quantity with previous reports and actual report twice.

(If you already made 31 sheets date wise in a file you also need to similar activities)

Finally you get the DPR but this is only one report with lot of rows and column. You spend lot of time and energy but final outcome is a clumsy report. If one takes printout of the DPR having more than four sewing lines it is really a torture to the report reader. Are you happy with such report format? (See Figure 1)

Figure -1: Daily Production Report

If you are asked to make summarized report (e.g. style wise summary report, day-wise production day of a style, or monthly report) or report in a different format, it would be a tough job (time consuming job). In case management asks for report I know this job is more than a mental torture.

Other disadvantages are
  • You need enter same data in multiple sheets/multiple reports
  • You need to make separate file for each month.
  • You need make multiple reports as requested by management 
  • Limited form of reporting

How can you improve your reporting making process?


Use pivot table. All you need to enter data in one sheet and view report as you want. Make one sheet for data entry. Design your data entry sheet with maximum data field required to make all of your desired reports. Design your reports (to be viewed) using pivot table. You will get Pivot table in Inset tab (See Figure 2) in the menu bar. 
Figure -2: Inserting Pivot table 

In this article I am not going to teach you how to use pivot table. You can learn it by reading online. I will show an example that I use making production report.

Making report using pivot table is not difficult. But most of us don’t know how to use Pivot table. I have learned this last year and prepared more than 100 reports for garment manufacturers using pivot table. I have shown here an example (with hypothetical data).

In this report you will get following report (See Figure 3)
  1. Daily production report
  2. WIP Report (Running styles)
  3. Monthly Report
  4. Style Summary Report
  5. Figure-3: List of Reports
  6. Style report (Date wise break-up)

Benefits of using Pivot table.

In this report you
  • Don’t need to make multiple files for making different reports using same data.
  • Don’t need to make day wise DPR (Daily Production Report). 
  • Don’t need to copy the file and edit data and enter new data on the current sheet
  • Don’t need to check your formula daily prior to taking the printout.
You just need to enter data in one sheet (See Figure 4). And all desired reports will be generated just by refreshing data. You can make numerous reports and check data using filter as much variation as you need provided that you have entered all related data in the entry sheet that you want to view in the report. By making multiple reports you can keep your DPR clean (See Figure 5, 6, 7). Data analysis become very easy when you keep all data in one table. 
Figure-4: Data Entry Sheet
Daily Production Report: To view the daily production you need to select date only from the drop down menu. For WIP report you need select running styles.
Figure-5: Daily Production Report (DPR)
Monthly Production Report: You will get monthly report by selecting Month and Year. In the sample report I have not shorted month wise.
Figure 5: Monthly Production Report
Style Report: You can check detailed report for styles date wise past data (See Figure 6).  Report can be viewed for single style and multiple styles.
Figure 6: Style Report
Style Summary Report: You can check production status of all styles for a duration (See Figure 7).
Figure -7: Style Summary Report

Click on the following download link to save the excel template to your computer.


P.S. You can make an advanced report using SQL query and pivot table in excel.

[post_ads_2]

COMMENTS

You may also like

Name

5S,3,Apparel ERP,1,apparel industry,56,apparel news,33,Apparel Production,30,Apparel Software,17,Bamboo Fabric,1,Bangladesh,1,Blogs,1,Books,30,Business Guides,9,Buyer,1,Buying House,4,CAD/CAM,1,Calculation & Formula,1,career,33,Change Management,1,Clothing,1,Clothing Brand,3,Compliance,3,Consumption,4,Costing,7,Cutting,17,Denim,3,Directory,3,Dyeing,1,eCommerce,2,Education,5,Event & Fair,14,Fabric,71,Fashion,5,Fashion Business,37,Fashion Design,3,Fashion Show,1,Fiber,1,Finishing,10,Garment Exporters,1,Garmenting,1,Gartex,1,GSM,1,Guest Post,8,Human Resource,2,Industrial Engineering,211,Infographic,5,Knitting,3,Kurti,1,Lean,27,Line layout,3,Machines,28,Manufacturing,51,Merchandising,101,MIS,23,MISC,20,Operation bulletin,14,Operator,1,Operator Training,1,Performance rating,1,PLM,3,Printing & Embroidery,11,Problem Solving,1,Production Planning,26,Project Report,1,QNA,121,Quality,61,Quality manual,2,Quality system,14,Resources,42,Retailing,4,Salary & Wages,7,Sampling,22,Scheduling,3,Sourcing,8,Spec Sheet,9,Sportswear,1,Stitching,3,Store,2,Stretch fabric,1,sustainable clothing,7,T-shirt,3,Tailor,1,Tailoring Shop,2,Technology,58,Texprocess,1,Textile processing,11,Textile testing,22,Textiles,41,Threads,1,Towel,1,Trims & Accessories,15,videos,11,Waste,1,Work Study,38,Yoga wear,1,
ltr
item
Online Clothing Study: Use Pivot Table and Become Smart in Report Making (Download Excel Template)
Use Pivot Table and Become Smart in Report Making (Download Excel Template)
Making production reports is made easy with the use of Pivot Table. Sample report template for garment manufacturers are shared and can be downloaded.
https://1.bp.blogspot.com/-Nl62PlDaAl8/UaB11A6nGtI/AAAAAAAAA3U/xw7emhDlkBM/s1600/daily_production_report.png
https://1.bp.blogspot.com/-Nl62PlDaAl8/UaB11A6nGtI/AAAAAAAAA3U/xw7emhDlkBM/s72-c/daily_production_report.png
Online Clothing Study
http://www.onlineclothingstudy.com/2015/04/use-pivot-table-and-become-smart-in.html
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/2015/04/use-pivot-table-and-become-smart-in.html
true
6551124471002606808
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy