{"id":96114,"date":"2026-10-04T04:30:32","date_gmt":"2026-10-04T04:30:32","guid":{"rendered":"https:\/\/skyplanner.ai\/?p=96114"},"modified":"2026-10-04T12:09:34","modified_gmt":"2026-10-04T12:09:34","slug":"model-plan-de-productie","status":"publish","type":"post","link":"https:\/\/skyplanner.ai\/ro\/resurse\/model-plan-de-productie\/","title":{"rendered":"Model de programare a produc\u021biei pentru fabrica\u021bie"},"content":{"rendered":"
\n\n

Model de programare a produc\u021biei pentru fabrica\u021bie<\/h1>\n\n
\n\n

Acas\u0103<\/a> » Resurse<\/a> » Model de programare a produc\u021biei pentru fabrica\u021bie<\/p>\n\n\n

<\/path><\/svg><\/span><\/span>Timp estimat de citire: <\/span>5<\/span> minute<\/span><\/p>\n\n<\/div>\n

\n\n

Copia\u021bi acest model de programare a produc\u021biei \u00een Excel \u0219i \u00eenlocui\u021bi A \u0219i B cu opera\u021biile dvs. Fiecare r\u00e2nd este o opera\u021bie. Exemplul fictiv arat\u0103 dou\u0103 opera\u021bii care folosesc aceea\u0219i ma\u0219in\u0103 M1 \u0219i acela\u0219i operator O1: B \u00eencepe c\u00e2nd se termin\u0103 A.<\/p>\n\n\n

Comand\u0103 \/ opera\u021bie<\/th>Ma\u0219in\u0103 \/ operator<\/th>Preg\u0103tire min<\/th>Execu\u021bie min<\/th>\u00cenceput<\/th>Sf\u00e2r\u0219it<\/th>Termen<\/th>Stare<\/th><\/tr><\/thead>
A \/ A-10<\/td>M1 \/ O1<\/td>30<\/td>120<\/td>08:00<\/td>10:30<\/td>12:00<\/td>Planificat<\/td><\/tr>
B \/ B-10<\/td>M1 \/ O1<\/td>15<\/td>180<\/td>10:30<\/td>13:45<\/td>16:00<\/td>Planificat<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n

A ocup\u0103 M1 timp de 150 de minute; B are nevoie de 195 de minute. \u00cencap \u00eentr-un schimb ne\u00eentrerupt de la 08:00 la 16:00, cu ambele materiale preg\u0103tite \u0219i cu O1 disponibil pe tot parcursul. Niciuna nu se suprapune cu cealalt\u0103 \u0219i niciuna nu dep\u0103\u0219e\u0219te termenul.<\/p>\n\n\n

Adapta\u021bi foaia la nevoile dvs.<\/h2>\n\n\n

Selecta\u021bi tabelul, copia\u021bi-l \u0219i lipi\u021bi-l \u00een celula A1 dintr-o foaie Excel goal\u0103. Dac\u0103 tot con\u021binutul ajunge \u00eentr-o singur\u0103 coloan\u0103, folosi\u021bi Date > Text \u00een coloane \u0219i alege\u021bi separatorul vizibil \u00een textul lipit. Verifica\u021bi c\u0103 fiecare antet are propria coloan\u0103 \u00eenainte de a continua.<\/p>\n\n\n

P\u0103stra\u021bi antetele \u0219i \u00eenlocui\u021bi A \u0219i B. Folosi\u021bi un ID de comand\u0103 \u0219i un ID unic de opera\u021bie, astfel \u00eenc\u00e2t s\u0103 pute\u021bi ad\u0103uga un alt r\u00e2nd pentru pasul urm\u0103tor al comenzii respective. Execu\u021bie min este durata total\u0103 de procesare a lotului, nu timpul pe bucat\u0103. Preg\u0103tire min este timpul suplimentar petrecut pe ma\u0219in\u0103.<\/p>\n\n\n

Pentru opera\u021biile dvs. reale, introduce\u021bi \u00cenceput \u0219i Termen ca date \u0219i ore complete, nu ca text. Formata\u021bi \u00cenceput, Sf\u00e2r\u0219it \u0219i Termen ca dat\u0103 \u0219i or\u0103, astfel \u00eenc\u00e2t munca de m\u00e2ine s\u0103 nu poat\u0103 p\u0103rea munca de azi. Cu coloanele de mai sus, introduce\u021bi urm\u0103toarea formul\u0103 \u00een F2 \u0219i copia\u021bi-o \u00een jos.<\/p>\n\n\n

=E2+(C2+D2)\/1440<\/code><\/p>\n\n\n

Excel stocheaz\u0103 timpul ca frac\u021biuni dintr-o zi; aceast\u0103 formul\u0103 adaug\u0103 la \u00eenceput minutele de preg\u0103tire \u0219i de execu\u021bie.<\/p>\n\n\n

Formula calculeaz\u0103 ora de sf\u00e2r\u0219it pentru o activitate care se desf\u0103\u0219oar\u0103 f\u0103r\u0103 \u00eentrerupere. Nu g\u0103se\u0219te o ma\u0219in\u0103 liber\u0103 \u0219i nu sare peste o pauz\u0103. Alege\u021bi \u00eenceputul abia dup\u0103 ce verifica\u021bi ma\u0219ina, operatorul, materialele \u0219i opera\u021bia precedent\u0103.<\/p>\n\n\n

P\u0103stra\u021bi perioadele de lucru pe o a doua foaie. Pentru exemplu, tabelul de disponibilitate este:<\/p>\n\n\n

Resurs\u0103<\/th>Disponibil de la<\/th>Disponibil p\u00e2n\u0103 la<\/th><\/tr><\/thead>
M1<\/td>08:00<\/td>16:00<\/td><\/tr>
O1<\/td>08:00<\/td>16:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n

\u00cenlocui\u021bi aceste valori cu perioadele dvs. de lucru reale, \u00eenso\u021bite de dat\u0103. Dac\u0103 exist\u0103 o pauz\u0103, folosi\u021bi perioade disponibile separate \u00eenainte \u0219i dup\u0103 ea. O opera\u021bie care nu poate fi \u00eentrerupt\u0103 are nevoie de un interval continuu suficient de lung pentru timpul de preg\u0103tire \u0219i cel de execu\u021bie.<\/p>\n\n\n

Pentru comenzile cu mai mul\u021bi pa\u0219i, ad\u0103uga\u021bi o coloan\u0103 Predecesor care con\u021bine ID-ul opera\u021biei anterioare. Ad\u0103uga\u021bi o coloan\u0103 Material preg\u0103tit atunci c\u00e2nd sosirea materialelor influen\u021beaz\u0103 \u00eenceputul. P\u0103stra\u021bi Ma\u0219ina \u0219i Operatorul \u00een coloane separate dac\u0103 trebuie s\u0103 sorta\u021bi sau s\u0103 filtra\u021bi aloc\u0103rile independent. O ma\u0219in\u0103 liber\u0103 nu este suficient\u0103 dac\u0103 operatorul ei este ocupat \u00een alt\u0103 parte.<\/p>\n\n\n

Ce se schimb\u0103 c\u00e2nd M1 se opre\u0219te?<\/h2>\n\n\n

Presupunem c\u0103 A se termin\u0103 la 10:30, dar M1 se opre\u0219te apoi p\u00e2n\u0103 la 13:00. B nu a \u00eenceput. P\u0103stra\u021bi sf\u00e2r\u0219itul real al lui A, actualiza\u021bi disponibilitatea lui M1 \u0219i testa\u021bi B de la 13:00.<\/p>\n\n\n

B are \u00een continuare nevoie de 195 de minute, deci sf\u00e2r\u0219itul s\u0103u continuu ar fi la 16:15. Acesta este dup\u0103 termenul de 16:00 \u0219i dup\u0103 sf\u00e2r\u0219itul schimbului. Marca\u021bi B ca av\u00e2nd nevoie de o decizie de planificare; nu emite\u021bi 16:15 ca sf\u00e2r\u0219it aprobat.<\/p>\n\n\n

C\u0103uta\u021bi o alt\u0103 ma\u0219in\u0103 eligibil\u0103, cu un operator disponibil, sau o perioad\u0103 de lucru ulterioar\u0103 aprobat\u0103. \u00cemp\u0103r\u021bi\u021bi opera\u021bia doar dac\u0103 procesul poate fi \u00eentrerupt \u0219i reluat \u00een siguran\u021b\u0103. Dac\u0103 niciun interval fezabil nu respect\u0103 termenul, conveni\u021bi asupra unui angajament de livrare revizuit. Schimbarea culorii de stare a lui B nu creeaz\u0103 timpul de ma\u0219in\u0103 lips\u0103.<\/p>\n\n\n

Verific\u0103ri \u00eenainte de a trimite programul \u00een sec\u021bie<\/h2>\n\n\n