{"id":5278,"date":"2024-12-10T10:46:32","date_gmt":"2024-12-10T10:46:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tu-tao-cong-thuc-tinh-gia-xuat-kho-theo-phuong-phap-fifo-phan-3\/"},"modified":"2024-12-10T10:46:32","modified_gmt":"2024-12-10T10:46:32","slug":"tu-tao-cong-thuc-tinh-gia-xuat-kho-theo-phuong-phap-fifo-phan-3","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tu-tao-cong-thuc-tinh-gia-xuat-kho-theo-phuong-phap-fifo-phan-3\/","title":{"rendered":"T\u1ef1 t\u1ea1o c\u00f4ng th\u1ee9c t\u00ednh gi\u00e1 xu\u1ea5t kho theo ph\u01b0\u01a1ng ph\u00e1p FIFO \u2013 Ph\u1ea7n 3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Sau khi ch\u00fang ta\u00a0\u0111\u00e3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c quy tr\u00ecnh t\u00ednh to\u00e1n theo ph\u01b0\u01a1ng ph\u00e1p FIFO, ch\u00fang ta c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng nh\u1eefng n\u1ed9i dung\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 x\u00e2y d\u1ef1ng th\u00e0nh c\u00e2u l\u1ec7nh VBA gi\u00fap t\u00ednh gi\u00e1 xu\u1ea5t kho theo ph\u01b0\u01a1ng ph\u00e1p n\u00e0y.<\/p>\n<h2>Vi\u1ebft Macro t\u00ednh gi\u00e1 xu\u1ea5t kho theo ph\u01b0\u01a1ng ph\u00e1p FIFO<\/h2>\n<p>Ch\u00fang ta\u00a0\u00e1p d\u1ee5ng v\u00e0o b\u1ea3ng t\u00ednh m\u1eabu nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14682\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-fifo-05.png\" width=\"1066\" height=\"335\" title=\"heo-fifo-05\"><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 nhi\u1ec1u l\u1ea7n nh\u1eadp theo c\u00e1c ng\u00e0y\u00a0kh\u00e1c nhau trong b\u1ea3ng k\u00ea nh\u1eadp kho<\/p>\n<p>Trong B\u1ea3ng k\u00ea xu\u1ea5t kho, c\u00f3 5 l\u1ea7n xu\u1ea5t. T\u00ednh gi\u00e1 tr\u1ecb xu\u1ea5t kho cho t\u1eebng l\u1ea7n xu\u1ea5t<\/p>\n<p><strong>C\u00e1ch l\u00e0m<\/strong>:<\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u00f3 c\u00e1c c\u1ed9t:<\/p>\n<ul>\n<li>C\u1ed9t S\u1ed1 l\u01b0\u1ee3ng nh\u1eadp = c\u1ed9t C<\/li>\n<li>C\u1ed9t\u00a0\u0110\u01a1n gi\u00e1 nh\u1eadp = c\u1ed9t D<\/li>\n<li>C\u1ed9t S\u1ed1 l\u01b0\u1ee3ng xu\u1ea5t kho = c\u1ed9t H<\/li>\n<li>C\u1ed9t Gi\u00e1 tr\u1ecb xu\u1ea5t kho = th\u00e0nh ti\u1ec1n = c\u1ed9t I<\/li>\n<\/ul>\n<p>D\u1ef1a theo quy tr\u00ecnh\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u\u00a0\u1edf b\u00e0i tr\u01b0\u1edbc, ch\u00fang ta x\u00e2y d\u1ef1ng c\u00e2u l\u1ec7nh VBA c\u0103n c\u1ee9 theo c\u00e1c d\u1eef li\u1ec7u\u00a0\u1edf tr\u00ean nh\u01b0 sau:<\/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-452.gif\" title=\"ex101_92019-nho-452\"><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-180.gif\" title=\"vba101_92019-nho-180\"><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-452.gif\" title=\"ex101_92019-nho-452\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/9a8d1e6c1c4263c3f7c2d1b728edf03f\">Gist<\/a>.<\/div>\n<p>Ch\u1ea1y th\u1eed c\u00e2u l\u1ec7nh tr\u00ean, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14683\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-fifo-06.png\" width=\"1064\" height=\"344\" title=\"heo-fifo-06\"><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra l\u1ea1i nh\u01b0 sau:<\/p>\n<p><strong>L\u1ea7n 1<\/strong>: Xu\u1ea5t 50 c\u00e1i, theo l\u1ea7n nh\u1eadp\u00a0\u0111\u1ea7u ti\u00ean,\u00a0\u0111\u01a1n gi\u00e1 100 =&gt; Th\u00e0nh ti\u1ec1n 50 * 100 = 5.000 <strong>K\u1ebft qu\u1ea3\u00a0\u0111\u00fang<\/strong><\/p>\n<p><strong>L\u1ea7n 2<\/strong>: Xu\u1ea5t 200 c\u00e1i<\/p>\n<ul>\n<li>Theo l\u1ea7n nh\u1eadp\u00a0\u0111\u1ea7u ti\u00ean c\u00f2n 50 c\u00e1i,\u00a0\u0111\u01a1n gi\u00e1 100 = 50 * 100 = 5.000<\/li>\n<li>Theo l\u1ea7n nh\u1eadp th\u1ee9 hai s\u1ebd xu\u1ea5t 200-50 = 150 c\u00e1i (c\u00f2n d\u01b0 50 c\u00e1i),\u00a0\u0111\u01a1n gi\u00e1 120 = 150 * 120 = 18.000<\/li>\n<li>T\u1ed5ng c\u1ed9ng l\u00e0 18.000 + 5.000 = 23.000 <strong>K\u1ebft qu\u1ea3\u00a0\u0111\u00fang<\/strong><\/li>\n<\/ul>\n<p><strong>L\u1ea7n 3<\/strong>: Xu\u1ea5t 100 c\u00e1i<\/p>\n<ul>\n<li>Theo l\u1ea7n nh\u1eadp th\u1ee9 hai c\u00f2n 50 c\u00e1i,\u00a0\u0111\u01a1n gi\u00e1 120 = 50 * 120 = 6.000<\/li>\n<li>Theo l\u1ea7n nh\u1eadp th\u1ee9 ba s\u1ebd xu\u1ea5t 100 \u2013 50 = 50 c\u00e1i (c\u00f2n d\u01b0 70 c\u00e1i),\u00a0\u0111\u01a1n gi\u00e1 110 = 50 * 110 = 5.500<\/li>\n<li>T\u1ed5ng c\u1ed9ng l\u00e0 6.000 + 5.500 = 11.500\u00a0<strong>K\u1ebft qu\u1ea3\u00a0\u0111\u00fang<\/strong><\/li>\n<\/ul>\n<p>T\u01b0\u01a1ng t\u1ef1 ch\u00fang ta x\u00e9t c\u00e1c l\u1ea7n nh\u1eadp sau.<\/p>\n<p>Nh\u01b0 v\u1eady b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng VBA ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 vi\u1ebft\u00a0\u0111\u01b0\u1ee3c c\u00e2u l\u1ec7nh Macro gi\u00fap t\u1ef1\u00a0\u0111\u1ed9ng t\u00ednh gi\u00e1 tr\u1ecb xu\u1ea5t\u00a0kho theo ph\u01b0\u01a1ng ph\u00e1p FIFO\u00a0\u0111\u01b0\u1ee3c r\u1ed3i.<\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu:\u00a0<a href=\"https:\/\/drive.google.com\/open?id=1AKoTj6NVlks1vXkMfOOgRLjcY4K_U-X9\">https:\/\/drive.google.com\/open?id=1AKoTj6NVlks1vXkMfOOgRLjcY4K_U-X9<\/a><\/p>\n<p style=\"text-align: left\">C\u00f3 n\u1ec1n t\u1ea3ng v\u1ec1 Excel ch\u1eafc ch\u1eafn t\u1ea1o n\u00ean s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n. V\u00ec v\u1eady, \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u k\u1ebf to\u00e1n nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 chuy\u00ean nghi\u1ec7p, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel.<\/p>\n<p style=\"text-align: left\">Hi\u1ec7n t\u1ea1i, Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c k\u1ebf to\u00e1n c\u1ee7a b\u1ea1n. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: left\">\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-452.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5279,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5278","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\/5278","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=5278"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5278\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5279"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}