Excel template - Production report OEE calculation

In this video you will get know about how to prepare Production & OEE Report.
#production #oee #productioncompany
Click on below link to download excel file,
smartofficetem... india customer)
smart-office-t... (Out of india customer)
for GRAPHICAL Production report with OEE
• Excel template Product...
If you face any issue while downloading, please mail us on [e-mail]
View All our Templates Catalogue : tinyurl.com/ca...
Learn Excel from Basic formulas, visit below playlist link to watch short videos
• EXCEL FORMULAS BASIC T...
Follow our Linkedin Page
/ smart-office-templates
Like our facebook Page
/ sachinpawar.2022
Follow us on Instagram
/ pawar.sachin.125

[@smartofficetemplates]

Click on below link to download excel file, smartofficetemplates.myshopify.com/products/oee (within india customer) smart-office-templates.myshopify.com/products/oee (Out of india customer) for GRAPHICAL Production report with OEE kzbin.info/www/bejne/gpCmiZ-qhK6Whqs

[@rajanlohana9756]

Please can make one excel sheet of production planning sheet for extrusion moulding p

[@smartofficetemplates]

Ok I will prepare. Please email me on [e-mail]

[@shahbazvlog6074]

Zbrdast dear ❤

[@pravinkamble6621]

Have you tried to make a formulated sheet for time estimation for the product base on operation e.g turning, milling, drilling, grinding there are other operations also in machine shop

[@smartofficetemplates]

Sir, please email me on [e-mail] for your requirements

[@adrianocalderan3483]

How do I feed the worksheet with more than one break in the same machine and in the same shift.

[@smartofficetemplates]

Please use this Template, you can add more than one break on same machine kzbin.info/www/bejne/qpyloJd9gqaFgck

[@rajeshbhagwat4995]

Ek number explaining

[@smartofficetemplates]

thanks

[@ramjeeroy5704]

Awesome

[@jayarame4543]

thank you for excel spread sheet. can we get capacity spread sheets

[@smartofficetemplates]

Yes, when I get more such requirement I will make video for capacity sheet

[@smartofficetemplates]

For capacity sheet visit kzbin.info/www/bejne/gKi6m6qgjtmEoKM

[@nikhilmahangare6990]

👌👌 it's helpful

[@smartofficetemplates]

Glad to hear that

[@vishalingle4567]

Can you make one video on dashboard of vehicle order punching model wise, month wise, color code wise Also logistics report like dispatch data, invoice no, qty, color

[@smartofficetemplates]

Please mail your query on [e-mail]

[@NITINTHAKUR-eq3kr]

Nice

[@yusufrabiu2729]

Thank you.

[@rachaiahswamy236]

What is the meaning of bottle neck equipment in pharma industry

[@smartofficetemplates]

You will understand with below example "A" machine produces 1000nos/hr "B" machine produces 500nos/hr Material flow from machine A to B So while processing material gets dump at machine B causing production loss Here machine B is a Bottle neck.

[@mohammedbasheer8495]

Bro Is yield and quality are same ? Ex.. 100 kg produced . 2kg rework Final output 90 ( 8kg loss ) So Quality is calculated as 90/100 or 98/ 100 ??

[@smartofficetemplates]

90/100

[@mohammedbasheer8495]

@@smartofficetemplates if we took 90 / 100 , how quality can reach 100 % . Because in every production there will be loss due to wastage.

[@smartofficetemplates]

For OEE calculation, take first time right product only Yes there will be always loss, but our target must be to reduce it

[@mohammedbasheer8495]

We can reduce but we can't make it to zero wastage. So in TOTAL OEE CAN never be 100 % ??

[@smartofficetemplates]

Right

[@nityanand2011]

Sir...could you please clarify the std.cycle time.

[@smartofficetemplates]

Machine cycle time represents the actual time it takes for one machine to complete all of its operations on one piece, product etc. E.g. If A machine produces 50 nos. Per minute and 60 second in a minute It's cycle time will be as 60/50=1.2 So one product cycle time will be 1.2 second Or other method to calculate cycle time is 1. Start stopwatch 2.record time from picking product upto taking off it from machine after completing it's operation 3. This will be the time required a product to complete it's operation which will be the cycle time Note: Mention cycle time in second in Excel file

[@gopalwaghmare4483]

Sir mujhe 12 hours ka 1960 production & 16 manpower ka oee keshe nikale

[@smartofficetemplates]

Video achhese dekhiye,, availability nikalte samay 8 hrs ka time pakda hein, to aap vah 12 hrs ka time pakde (means 60x12 = 720 minutes)

[@rubiedayandayan1017]

How about incase of absent operator?.

[@smartofficetemplates]

You can mail your query on [e-mail]

[@digientrepreneur-paresh9299]

🙏🙏

[@ajinkyashinde9293]

Performance of machine and performance of operater should be saperate because due to machine brekdown operater also affected for his performance

[@smartofficetemplates]

Yes here, proformance means machine proformance

[@MrDiwakarbj]

Can you send me download link

[@smartofficetemplates]

Link available in video description to download the template

[@DevChaudhary-sv1lf]

Sorry there is many confusion you are not able to clear understanding

[@smartofficetemplates]

Please download template from link in description, practice it

[@sridharsai2700]

Bro...u r taking two much time to explain

[@smartofficetemplates]

Sorry for that, it's old video