{"id":7513,"date":"2024-12-21T17:52:16","date_gmt":"2024-12-21T17:52:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho\/"},"modified":"2024-12-21T17:52:16","modified_gmt":"2024-12-21T17:52:16","slug":"phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho\/","title":{"rendered":"Ph\u01b0\u01a1ng ph\u00e1p FIFO v\u1edbi Excel trong vi\u1ec7c qu\u1ea3n l\u00fd kho"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong nghi\u1ec7p v\u1ee5 kho, khi xu\u1ea5t kho ch\u00fang ta c\u00f3 v\u00e0i ph\u01b0\u01a1ng ph\u00e1p nh\u01b0 sau: FIFO, LIFO v\u00e0 AVCO, trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd \u0111i n\u00f3i v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p FIFO<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6767004fb42da\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho.html#FIFO_la_gi\" title=\"FIFO l\u00e0 g\u00ec\">FIFO l\u00e0 g\u00ec<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho.html#Van_de_voi_FIFO\" title=\"V\u1ea5n \u0111\u1ec1 v\u1edbi FIFO\">V\u1ea5n \u0111\u1ec1 v\u1edbi FIFO<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/phuong-phap-fifo-voi-excel-trong-viec-quan-ly-kho.html#Download_file_vi_du\" title=\"Download file v\u00ed d\u1ee5\">Download file v\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"FIFO_la_gi\"><\/span>FIFO l\u00e0 g\u00ec<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 nghe r\u1ea5t nhi\u1ec1u v\u1ec1 FIFO, th\u1eadm ch\u00ed bi\u1ebft FIFO c\u00f3 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o, nh\u01b0ng ngu\u1ed3n g\u1ed1c c\u1ee7a t\u1eeb nghe bu\u1ed3n c\u01b0\u1eddi n\u00e0y l\u00e0 t\u1eeb 4 ch\u1eef c\u00e1i vi\u1ebft t\u1eaft c\u1ee7a c\u1ee5m t\u1eeb ti\u1ebfng Anh: First In, First Out, ngh\u0129a l\u00e0 c\u00e1i g\u00ec v\u00e0o \u0111\u1ea7u ti\u00ean th\u00ec s\u1ebd ra \u0111\u1ea7u ti\u00ean. \u0110i\u1ec1u n\u00e0y r\u1ea5t ph\u00f9 h\u1ee3p v\u1edbi ho\u00e0n c\u1ea3nh khi ch\u00fang ta nh\u1eadp h\u00e0ng ho\u00e1 n\u00e0o tr\u01b0\u1edbc th\u00ec h\u00e0ng ho\u00e1 \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c xu\u1ea5t kh\u1ecfi kho tr\u01b0\u1edbc nh\u1ea5t l\u00e0 nh\u1eefng lo\u1ea1i h\u00e0ng ho\u00e1 c\u00f3 h\u1ea1n s\u1eed d\u1ee5ng nh\u01b0 thu\u1ed1c, th\u1ef1c ph\u1ea9m, \u2026. Tuy nhi\u00ean ph\u01b0\u01a1ng ph\u00e1p FIFO kh\u00f4ng ch\u1ec9 gi\u1edbi h\u1ea1n \u1edf vi\u1ec7c \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 t\u00ednh h\u1ea1n s\u1eed d\u1ee5ng m\u00e0 c\u00f2n \u00e1p d\u1ee5ng cho c\u00e1c s\u1ea3n ph\u1ea9m kh\u00e1c n\u1eefa.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Van_de_voi_FIFO\"><\/span>V\u1ea5n \u0111\u1ec1 v\u1edbi FIFO<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi FIFO, ch\u00fang ta c\u00f3 1 v\u1ea5n \u0111\u1ec1 nh\u1ecf nh\u01b0 sau: c\u00f9ng 1 m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u00e1c th\u1eddi \u0111i\u1ec3m kh\u00e1c nhau c\u00f3 th\u1ec3 c\u00f3 gi\u00e1 kh\u00e1c nhau, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00fang ta theo d\u00f5i \u0111\u01b0\u1ee3c s\u1ef1 thay \u0111\u1ed5i v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a 1 m\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3 trong kho, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00fang ta bi\u1ebft \u0111\u01b0\u1ee3c s\u1ebd l\u1ea5y h\u00e0ng \u1edf ng\u00e0y n\u00e0o tr\u01b0\u1edbc, ng\u00e0y n\u00e0o sau?\u00a0V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>Ng\u00e0y 1 ch\u00fang ta nh\u1eadp 10 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 1 \u0111\u1ed3ng<\/li>\n<li>Ng\u00e0y 2 ch\u00fang ta nh\u1eadp 5 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 2 \u0111\u1ed3ng<\/li>\n<li>Ng\u00e0y 3 ch\u00fang ta nh\u1eadp 10 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 1 \u0111\u1ed3ng<\/li>\n<\/ul>\n<p>V\u00e0 \u1edf ng\u00e0y 4 ch\u00fang ta mu\u1ed1n xu\u1ea5t kho \u0111\u1ec3 b\u00e1n h\u00e0ng 20 s\u1ea3n ph\u1ea9m X, v\u1eady th\u1ee9 t\u1ef1 \u0111\u1ec3 ch\u00fang ta l\u1ea5y h\u00e0ng cho \u0111\u01a1n h\u00e0ng 20 s\u1ea3n ph\u1ea9m X n\u00e0y s\u1ebd l\u00e0:<\/p>\n<ul>\n<li>10 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 1 \u0111\u1ed3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o ng\u00e0y 1, ti\u1ebfp \u0111\u1ebfn<\/li>\n<li>5 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 2 \u0111\u1ed3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o ng\u00e0y 2, ti\u1ebfp \u0111\u1ebfn<\/li>\n<li>5 s\u1ea3n ph\u1ea9m X v\u1edbi gi\u00e1 1 \u0111\u1ed3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o ng\u00e0y 3.<\/li>\n<\/ul>\n<p>S\u1ea3n ph\u1ea9m c\u1ee7a ch\u00fang ta sau b\u00e0i vi\u1ebft n\u00e0y l\u00e0:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/Excel-FIFO-Calculation-and-Report.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6498\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-fifo-calculation-and-report.gif\" alt=\"phuong-phap-fifo-trong-excel\" width=\"908\" height=\"604\" title=\"excel-fifo-calculation-and-report\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Download_file_vi_du\"><\/span>Download file v\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>[sociallocker id=2748]<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-673.gif\" title=\"ex101_92019-nho-673\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-302.gif\" title=\"vba101_92019-nho-302\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-673.gif\" title=\"ex101_92019-nho-673\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/FIFO-co-ban-trong-Excel.xlsx\">FIFO-co-ban-trong-Excel<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<p>C\u00e1c b\u1ea1n \u0111\u1eebng qu\u00ean tham gia 2 kho\u00e1 h\u1ecdc \u0111\u1eb7c bi\u1ec7t v\u1ec1 kho c\u1ee7a Blog H\u1ecdc Excel Online \u0111\u1ec3 n\u1eafm v\u1eefng nh\u1eefng nghi\u1ec7p v\u1ee5 kho v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng v\u00e0o trong th\u1ef1c t\u1ebf nh\u00e9:<\/p>\n<ul>\n<li><a href=\"https:\/\/hocexcel.online\/category\/3-excel-ke-toan\" target=\"_blank\">\u1ee8ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd kho<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Kho\u0301a h\u1ecdc excel k\u1ebf to\u00e1n online<\/a><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-673.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7514,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7513"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7513\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7514"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}