{"id":46928,"date":"2025-02-17T01:54:13","date_gmt":"2025-02-16T18:54:13","guid":{"rendered":"https:\/\/zortout.com\/?post_type=docs&p=46928"},"modified":"2025-02-17T01:54:13","modified_gmt":"2025-02-16T18:54:13","password":"","slug":"profit-calculation-moving-average-and-fifo","status":"publish","type":"docs","link":"https:\/\/zortout.com\/en\/docs\/profit-calculation-moving-average-and-fifo","title":{"rendered":"Profit Calculation: Moving Average and FIFO"},"content":{"rendered":"

Did you know that calculating profit in a business isn’t as simple as you might think? If you buy a product for 100 baht and sell it for 200 baht, you would naturally make a profit of 100 baht. But what if you buy multiple lots of products at different costs and sell some of them? How do you calculate the profit then?<\/span><\/p>\n

Generally, we use one of two popular profit calculation methods: Moving Average and FIFO. These are fundamental techniques for proper inventory management.<\/span><\/p>\n

\n

1. Moving Average<\/strong><\/span><\/p>\n

Example Scenario:<\/span><\/p>\n

Purchase item P0001 (red shirts) in 2 lots:<\/span><\/p>\n

Lot 1: 10 units at 1,000 baht (100 baht each)<\/span><\/p>\n

Lot 2: 20 units at 1,400 baht (70 baht each)<\/span><\/p>\n

This gives you 30 units in stock with a total cost of 2,400 baht. The selling price to customers is 200 baht per unit.<\/span><\/p>\n

Using this method, you calculate the average cost per unit as:<\/span><\/p>\n

Average\u00a0Cost\u00a0per\u00a0Unit = (1000+1400)\/(10+20) = 80\u00a0baht\u00a0per\u00a0unit<\/span><\/p>\n

For example, when you sell a product for 200 baht each, you earn a profit of 200 – 80 = 120 baht per unit. Every time you sell, let’s assume you sold 20 units and have 10 units left. If you purchase additional units, you need to calculate the new average cost per unit. Suppose you buy a new batch of 50 units for 2800 baht (56 baht each). This changes the average cost per unit to ((10\u00d780) + 2800) \/ (10+50) = 60 baht per unit. After that, when you sell, you will earn a profit of 200 – 60 = 140 baht per unit. That’s it!<\/span><\/p>\n

\n

2. FIFO (First In, First Out)<\/strong><\/span><\/p>\n

Example Scenario:<\/span><\/p>\n

Purchase item G0001 (game consoles) in 3 Lots:<\/span><\/p>\n

Lot 1: 2 units at 2,000 baht (1,000 baht each)<\/span><\/p>\n

Lot 2: 1 unit at 1,200 baht (1,200 baht each)<\/span><\/p>\n

Lot 3: 3 units at 2,700 baht (900 baht each)<\/span><\/p>\n

This gives you 6 units in stock with a total cost of 5,900 baht. The selling price to customers is 1,500 baht per unit.<\/span><\/p>\n

Using FIFO, you calculate profits based on the actual cost of goods sold, starting with the oldest lots first. For example:<\/span><\/p>\n

Selling the first 2 units in Lot 1, you will get a profit of 1,500 – 1,000 = 500 baht per unit.<\/span><\/p>\n

Selling the next unit in Lot 2, you will get a profit of 1,500 – 1,200 = 300 baht per unit.<\/span><\/p>\n

Selling units 4 to 6 in Lot 3, you will get a profit of 1,500 – 900 = 600 baht per unit.<\/span><\/p>\n

If you purchase additional units (e.g., Lot 4) and they are sold later, they follow the FIFO principle, awaiting sale based on the original purchase order.<\/span><\/p>\n

\"\"<\/span><\/p>\n

 <\/p>\n

\n

Both methods involve complex calculations but with ZORT, whether for small or large businesses, you can calculate profits with just a few clicks!<\/span><\/p>\n

 <\/p>\n

1. Go to the “Settings” menu and select “Organisation.”<\/span><\/p>\n

2. Choose your preferred profit calculation method: Moving Average or FIFO.<\/span><\/p>\n

\"\"<\/span><\/p>\n

 <\/p>\n

3. View profit graphs on the report page.<\/span><\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

These methods ensure accurate tracking and profitability analysis in your business operations.<\/span><\/p>\n

 <\/p>\n

If you are interested in utilizing our comprehensive store management system,<\/span><\/p>\n

we encourage you to reach out for further information. <\/span><\/p>\n

Please do not hesitate to contact us at:<\/span><\/p>\n

\n

Phone: 02-026-6423<\/span><\/p>\n

Email: support@zortout.com<\/a><\/span><\/p>\n

LINE: @zort<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Did you know that calculating profit in a business isn’t as simple as you might think? If you buy a product for 100 baht and sell it for 200 baht, you would naturally make a profit of 100 baht. But what if you buy multiple lots of products at different costs and sell some of […]<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-46928","docs","type-docs","status-publish","hentry"],"acf":[],"year_month":"2026-04","word_count":481,"total_views":"431","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"author_nicename":"kritsanee","author_url":"https:\/\/zortout.com\/en\/blog\/author\/kritsanee"},"doc_category_info":[],"doc_tag_info":[],"author_list":[{"ID":"20","user_login":"Bell","display_name":"Bell","id":"20"},{"ID":"60","user_login":"Chaaim","display_name":"Chaaim","id":"60"},{"ID":"8","user_login":"deeboon","display_name":"deeboon","id":"8"},{"ID":"6","user_login":"Fluke","display_name":"Fluke","id":"6"},{"ID":"1","user_login":"gae","display_name":"gae","id":"1"},{"ID":"17","user_login":"Green","display_name":"Green","id":"17"},{"ID":"7","user_login":"kim","display_name":"kim","id":"7"},{"ID":"28","user_login":"Kritsanee","display_name":"kritsanee","id":"28"},{"ID":"2","user_login":"maad","display_name":"Maad","id":"2"},{"ID":"11","user_login":"Moo","display_name":"Moo","id":"11"},{"ID":"4","user_login":"nan","display_name":"Nan","id":"4"},{"ID":"61","user_login":"new","display_name":"new","id":"61"},{"ID":"27","user_login":"newwebsite","display_name":"top","id":"27"},{"ID":"26","user_login":"nine","display_name":"nine","id":"26"},{"ID":"10","user_login":"or","display_name":"or","id":"10"},{"ID":"25","user_login":"Pang","display_name":"Pang","id":"25"},{"ID":"62","user_login":"Ppraserts","display_name":"Ppraserts","id":"62"},{"ID":"5","user_login":"puk","display_name":"Puk","id":"5"},{"ID":"15","user_login":"Ruja","display_name":"Ruja","id":"15"},{"ID":"63","user_login":"Sahaphop","display_name":"Sahaphop","id":"63"},{"ID":"19","user_login":"Serbpong","display_name":"Serb Pong","id":"19"},{"ID":"9","user_login":"Top","display_name":"Top","id":"9"},{"ID":"58","user_login":"worawit","display_name":"worawit","id":"58"}],"knowledge_base_info":[],"knowledge_base_slug":[],"yoast_head":"\nProfit Calculation: Moving Average and FIFO - ZORT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Profit Calculation: Moving Average and FIFO\" \/>\n<meta property=\"og:description\" content=\"Did you know that calculating profit in a business isn’t as simple as you might think? If you buy a product for 100 baht and sell it for 200 baht, you would naturally make a profit of 100 baht. But what if you buy multiple lots of products at different costs and sell some of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation\" \/>\n<meta property=\"og:site_name\" content=\"ZORT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/zortcompany\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation\",\"url\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation\",\"name\":\"Profit Calculation: Moving Average and FIFO - ZORT\",\"isPartOf\":{\"@id\":\"https:\/\/zortout.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg\",\"datePublished\":\"2025-02-16T18:54:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage\",\"url\":\"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg\",\"contentUrl\":\"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zortout.com\/en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Profit Calculation: Moving Average and FIFO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zortout.com\/#website\",\"url\":\"https:\/\/zortout.com\/\",\"name\":\"ZORT\",\"description\":\"Integrated Inventory Management Platform\",\"publisher\":{\"@id\":\"https:\/\/zortout.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zortout.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/zortout.com\/#organization\",\"name\":\"ZORTOUT Co.,Ltd.\",\"url\":\"https:\/\/zortout.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zortout.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/zortout.com\/wp-content\/uploads\/2019\/06\/logo-header-01.png\",\"contentUrl\":\"https:\/\/zortout.com\/wp-content\/uploads\/2019\/06\/logo-header-01.png\",\"width\":123,\"height\":40,\"caption\":\"ZORTOUT Co.,Ltd.\"},\"image\":{\"@id\":\"https:\/\/zortout.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/zortcompany\/\",\"https:\/\/www.youtube.com\/channel\/UCXoWTNcz6LSppzGJx9K0nTw\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Profit Calculation: Moving Average and FIFO - ZORT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation","og_locale":"en_US","og_type":"article","og_title":"Profit Calculation: Moving Average and FIFO","og_description":"Did you know that calculating profit in a business isn’t as simple as you might think? If you buy a product for 100 baht and sell it for 200 baht, you would naturally make a profit of 100 baht. But what if you buy multiple lots of products at different costs and sell some of […]","og_url":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation","og_site_name":"ZORT","article_publisher":"https:\/\/www.facebook.com\/zortcompany\/","og_image":[{"url":"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation","url":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation","name":"Profit Calculation: Moving Average and FIFO - ZORT","isPartOf":{"@id":"https:\/\/zortout.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage"},"image":{"@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage"},"thumbnailUrl":"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg","datePublished":"2025-02-16T18:54:13+00:00","breadcrumb":{"@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#primaryimage","url":"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg","contentUrl":"https:\/\/zortout.com\/wp-content\/uploads\/2025\/02\/Setting-022-1024x576.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/zortout.com\/docs\/moving-average-and-fifo-calculation#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zortout.com\/en"},{"@type":"ListItem","position":2,"name":"Profit Calculation: Moving Average and FIFO"}]},{"@type":"WebSite","@id":"https:\/\/zortout.com\/#website","url":"https:\/\/zortout.com\/","name":"ZORT","description":"Integrated Inventory Management Platform","publisher":{"@id":"https:\/\/zortout.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zortout.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/zortout.com\/#organization","name":"ZORTOUT Co.,Ltd.","url":"https:\/\/zortout.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zortout.com\/#\/schema\/logo\/image\/","url":"https:\/\/zortout.com\/wp-content\/uploads\/2019\/06\/logo-header-01.png","contentUrl":"https:\/\/zortout.com\/wp-content\/uploads\/2019\/06\/logo-header-01.png","width":123,"height":40,"caption":"ZORTOUT Co.,Ltd."},"image":{"@id":"https:\/\/zortout.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/zortcompany\/","https:\/\/www.youtube.com\/channel\/UCXoWTNcz6LSppzGJx9K0nTw"]}]}},"_links":{"self":[{"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/docs\/46928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/comments?post=46928"}],"version-history":[{"count":1,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/docs\/46928\/revisions"}],"predecessor-version":[{"id":46935,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/docs\/46928\/revisions\/46935"}],"wp:attachment":[{"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/media?parent=46928"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/doc_category?post=46928"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/zortout.com\/en\/wp-json\/wp\/v2\/doc_tag?post=46928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}