{"id":198,"date":"2022-05-02T14:19:32","date_gmt":"2022-05-02T12:19:32","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=198"},"modified":"2023-11-01T10:45:28","modified_gmt":"2023-11-01T09:45:28","slug":"kalkulacija-prodajne-cene-robe-u-excel-u","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/","title":{"rendered":"Cost calculation form in Excel &#8211; CoGS"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Kalkulacija_prodajne_cene_robe_izradom_KL_obrasca\" >Kalkulacija prodajne cene robe izradom KL obrasca<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Evidentiranje_podataka_u_KL_obrascu\" >Evidentiranje podataka u KL obrascu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Kakulacija_%E2%80%93_obracun\" >Kakulacija &#8211; obra\u010dun<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#lzracunavanje_razlike_u_ceni\" >lzra\u010dunavanje razlike u ceni\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Kriterijumi_za_izracunavanje_razlike_u_ceni\" >Kriterijumi za izra\u010dunavanje razlike u ceni<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Zastita_od_izmene_zakljucavanjem_polja_sa_formulama\" >Za\u0161tita od izmene zaklju\u010davanjem polja sa formulama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Preuzimanje_podataka_iz_drugog_dokumenta_i_validacija_podataka\" >Preuzimanje podataka iz drugog dokumenta i validacija podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Stampanje_ili_izrada_PDF_dokumenta\" >\u0160tampanje ili izrada PDF dokumenta<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Preuzimanje_excel_datoteke\" >Preuzimanje excel datoteke<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Cost_calculation_form\" >Cost calculation form<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Recording_data_in_the_KL_form\" >Recording data in the KL form<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Caculation_%E2%80%93_calculation\" >Caculation &#8211; calculation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Calculating_the_difference_in_price\" >Calculating the difference in price<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Criteria_for_calculating_the_price_difference\" >Criteria for calculating the price difference<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Protection_against_modification_by_locking_the_formula_field\" >Protection against modification by locking the formula field<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Download_data_from_another_document_and_validate_data\" >Download data from another document and validate data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Print_or_create_a_PDF_document\" >Print or create a PDF document<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/kalkulacija-prodajne-cene-robe-u-excel-u\/#Download_excel_file\" >Download excel file<\/a><\/li><\/ul><\/nav><\/div>\nHere you will learn how to make a usable table in Excel from one formally outdated form. Many Excel users often wonder if what they know is enough to get started and be successful in jobs where good knowledge is expected. The aim of this article is to guide you through a typical process of creating records, processing and analyzing this data, and finally printing or creating PDF files in the standard format as provided by our regulations.<\/p>\n<p>For this purpose, we have chosen a standard form known as KL-form for Sales Price Calculation in Excel.<\/p>\n<p>It enables small companies to simplify the calculation of sales prices for goods or services and to prepare the necessary documents on the prescribed form KL, which also forms the basis for calculating tax liabilities and filling in the prescribed number PK-1 &#8211; Business Book of Income and Expenditure. Don&#8217;t be alarmed by the sign PK &#8211; Tax credit for investments in fixed assets intended for companies.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cost_calculation_form\"><\/span>Cost calculation form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The prescribed layout of the form meant that all data was collected from paper documents. The documents from which the data for the production of sales prices are taken are the invoices\/invoices and delivery notes of the supplier.<\/p>\n<figure id=\"attachment_374\" aria-describedby=\"caption-attachment-374\" style=\"width: 721px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"Kalkulacija - obra\u010dun wp-image-374 size-full\" title=\"Kalkulacija - obra\u010dun\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija.jpg\" alt=\"Kalkulacija prodajne cene robe izradom KL obrasca u Excel-u\" width=\"721\" height=\"441\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija.jpg 721w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-350x214.jpg 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-300x183.jpg 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><figcaption id=\"caption-attachment-374\" class=\"wp-caption-text\">Form KL Calculation &#8211; calculation of selling prices of goods<\/figcaption><\/figure>\n<p>Incoming documents contain information such as Name of goods, unit of measure, quantity, price per unit of measure, the value of goods, approved individual or total rebate, tax rate, amount of VAT, code, and other data related to goods.<\/p>\n<p>Goods for resale are received in the warehouse and on that occasion, an Invoice or Receipt of goods is made in the warehouse. Differences in quantity and value may exist as a result of damage to the goods.<\/p>\n<ul>\n<li>\n<h2><span class=\"ez-toc-section\" id=\"Recording_data_in_the_KL_form\"><\/span><span class=\"\">Recording data in the KL form<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the records of the form KL &#8211; Calculation of the selling price, goods (products) are entered chronologically at the same VAT rates for each invoice of the supplier.\u00a0The data is entered as follows:<\/p>\n<ul>\n<li><strong>1 column<\/strong>\u00a0&#8211; ordinal number of goods (products), where for each price calculation the ordinal number is entered starting from number one;<\/li>\n<li><strong>2 column<\/strong>\u00a0&#8211; the name of the goods from the invoice, delivery note, receipt, or other document on the procurement of goods, where the goods are grouped according to the same VAT rates;<\/li>\n<li><strong>3 column<\/strong>\u00a0&#8211; unit of measure of purchased goods (kilogram, liter, meter, piece, etc.);<\/li>\n<li><strong>4 column<\/strong>\u00a0&#8211; purchased quantities of goods;<\/li>\n<li><strong>5 column<\/strong>\u00a0&#8211; the price of purchased goods per unit of measure, whereby, if the goods were received with a rebate, the price is reduced by the amount of the approved rebate;<\/li>\n<li><strong>6 column<\/strong>\u00a0&#8211; the value of purchased goods, as a product of the amount from col.\u00a04 and 5;<\/li>\n<li><strong>7 column<\/strong>\u00a0&#8211; the amount of dependent costs (costs of transport, loading, unloading, storage, storage, etc.);\u00a0sum of amounts from col.\u00a06 and 7 are entered in column 12 of the business book PK-1;<\/li>\n<li><strong>8 column<\/strong>\u00a0&#8211; the amount of the difference in price obtained when the appropriate value of the margin, ie the amount of the rebate approved by the supplier, is applied to the purchase value of goods (value of goods from column 6 increased by dependent costs from column 7);\u00a0the total amount from column 8 is entered in column 14 of the business book PK-1;<\/li>\n<li><strong>9 column<\/strong>\u00a0&#8211; sales value of goods without VAT, as the sum of the amount from col.\u00a06 &#8211; 8 (basis for VAT calculation);<\/li>\n<li><strong>10 column<\/strong>\u00a0&#8211; prescribed VAT rate;<\/li>\n<li><strong>11 column<\/strong>\u00a0&#8211; the amount of calculated VAT obtained by multiplying the rate from column 10 with the sales value of goods from column 9;\u00a0the total amount from column 11 is entered in column 15 of the business book PK-1;<\/li>\n<li><strong>12 column<\/strong>\u00a0&#8211; sales value of goods with VAT, as the sum of the amount from col.\u00a09 and 11, where the sales value of goods at the same VAT rates is expressed in special amounts &#8211; subtotals;\u00a0the total amount from column 12 is entered in column 16 of the business book PK-1;<\/li>\n<li><strong>13 column<\/strong>\u00a0&#8211; selling price of goods per unit of measure obtained when the selling value of goods with VAT from column 12 is divided by the purchased quantity of goods from column 4;\u00a0Entrepreneurs who are not VAT payers enter the gross value of the invoice (purchase statement with VAT included) in the purchase price calculation, whereby the dependent costs are also entered as the gross value stated in the invoice.<\/li>\n<\/ul>\n<p>Form KL is an accompanying document of the invoice of the procured goods or other document on the basis of which the procurement of goods was made (receipt, delivery note, etc.);\u00a0in the upper right corner of the KL records, enter the ordinal number under which the entry was made in the business book\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/excel-poslovna-knjiga-prihoda-i-rashoda\/\">PK-1 Business Book of Revenues and Expenditures<\/a>\u00a0.<\/li>\n<\/ul>\n<figure id=\"attachment_3049\" aria-describedby=\"caption-attachment-3049\" style=\"width: 1372px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3049 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Excel-KL-obrazac-1.png\" alt=\"EXCEL Obrazac KL Kalkulacija - obra\u010dun prodajnih cena robe\" width=\"1372\" height=\"635\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Excel-KL-obrazac-1.png 1372w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Excel-KL-obrazac-1-300x139.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Excel-KL-obrazac-1-1024x474.png 1024w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Excel-KL-obrazac-1-768x355.png 768w\" sizes=\"auto, (max-width: 1372px) 100vw, 1372px\" \/><figcaption id=\"caption-attachment-3049\" class=\"wp-caption-text\">EXCEL Form KL Calculation &#8211; calculation of selling prices of goods<\/figcaption><\/figure>\n<p>This is not the only task of making a calculation.\u00a0<span class=\"\">Namely, business accounting should, in cooperation with operational accounting, statistics and analysis, diagnose and clarify various phenomena, forms of work and functions in the organization.\u00a0<\/span>They provide reliable information for making business decisions and taking planned or corrective actions, which will contribute to better business and the future.<\/p>\n<p>The calculation serves as a basis for:<\/p>\n<ul>\n<li>determining the selling price of products and services,<\/li>\n<li>observing and analyzing structural changes in business.<\/li>\n<\/ul>\n<p>The calculation that serves as a basis for calculating the selling price of products and services breaks down costs into proportional and fixed.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Caculation_%E2%80%93_calculation\"><\/span><span id=\"Kakulacija_-_obracun\" class=\"ez-toc-section\"><\/span>Caculation &#8211; calculation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The goal of making a calculation &#8211; calculation is to determine the cost of production of a particular product or service.\u00a0It\u00a0\u00a0forms the basis for calculating the selling prices of goods or services of each organization.<\/p>\n<p>In the standard form of the first 7 columns are data that are mainly taken from the\u00a0<strong>Receipt<\/strong>\u00a0of goods to the warehouse, which is done on the basis of the\u00a0<strong>Delivery<\/strong>\u00a0or\u00a0<strong>Delivery<\/strong>\u00a0of goods.<\/p>\n<div class=\"google-auto-placed ap_container\"><ins class=\"adsbygoogle adsbygoogle-noablate\" data-ad-format=\"auto\" data-ad-client=\"ca-pub-5501613786001986\" data-adsbygoogle-status=\"done\" data-ad-status=\"filled\"><ins id=\"aswift_2_expand\" tabindex=\"0\" title=\"Advertisement\" aria-label=\"Advertisement\"><ins id=\"aswift_2_anchor\"><iframe loading=\"lazy\" id=\"aswift_2\" src=\"https:\/\/googleads.g.doubleclick.net\/pagead\/ads?gdpr=0&amp;client=ca-pub-5501613786001986&amp;output=html&amp;h=280&amp;adk=1683199643&amp;adf=550650105&amp;pi=t.aa~a.2430093988~i.41~rp.4&amp;w=834&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1652872691&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=3566677754&amp;psa=1&amp;ad_type=text_image&amp;format=834x280&amp;url=https%3A%2F%2Fkalkulacija.com%2Fwordpress%2Fen%2Fkalkulacija-prodajne-cene-robe-u-excel-u%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=833&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;adsid=ChAI8LKSlAYQ8uzN26eT_agyEj0ARuk_6SVcfb9w1o4kcew8Ed0TwZC0OpMQKsgeMKtBOHkhM9vH29nq2GVqdWkxGMtVrYvcUPbiAHjtQyGR&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTAwLjAuNDg5Ni4xMjciLFtdLG51bGwsbnVsbCwiNjQiLFtbIiBOb3QgQTtCcmFuZCIsIjk5LjAuMC4wIl0sWyJDaHJvbWl1bSIsIjEwMC4wLjQ4OTYuMTI3Il0sWyJHb29nbGUgQ2hyb21lIiwiMTAwLjAuNDg5Ni4xMjciXV0sZmFsc2Vd&amp;dt=1652872679176&amp;bpp=3&amp;bdt=604&amp;idt=3&amp;shv=r20220511&amp;mjsv=m202205170101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D307f2a1d10ecf64d-220fd7b276cd0000%3AT%3D1650013396%3ART%3D1650013396%3AS%3DALNI_MafllsGJaGaMBIjE6N4SxuvSpTPaw&amp;gpic=UID%3D000006617e1b2d04%3AT%3D1652789863%3ART%3D1652851758%3AS%3DALNI_MZgDSBbmIO_Nv9utiFB04z3xdSgFg&amp;prev_fmts=0x0%2C834x280%2C339x280%2C339x280%2C339x280%2C339x280&amp;nras=7&amp;correlator=1343143469871&amp;frm=20&amp;pv=1&amp;ga_vid=1775674432.1652872679&amp;ga_sid=1652872679&amp;ga_hid=2028483587&amp;ga_fc=1&amp;u_tz=120&amp;u_his=6&amp;u_h=900&amp;u_w=1440&amp;u_ah=870&amp;u_aw=1440&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=109&amp;ady=4661&amp;biw=1423&amp;bih=767&amp;scr_x=0&amp;scr_y=1725&amp;eid=44759875%2C44759926%2C44759837%2C31067656%2C31062931&amp;oid=2&amp;psts=AGkb-H8EwV55mhuH0iKhNZVElzxtA-tAJ3KF3gVDIp6YZDpJI6d908BMnu7r1HwG-zGJaHGyBebByqusA7FwdWboNA%2CAGkb-H_yeCslXxESlcfiWejsa29J1u0Jq81Ze5pGG-uO5Q7LnZfnUrVSTkQqSOSDiZ_S5rQbfwf6TfujfLd1OjECbQ%2CAGkb-H9p5kF2BzxLmOgb3bcOwTEl27UPED_f62LkugEvfv4zmh5rp5l4ld0w5gH2bXfaavFj3D2SxfEL3zp9yQnyuA%2CAGkb-H-vE3XQbMOTfWh9F1alfeWJd6l7bjAfk3EWRUC9XJgcz4A9YCkHDVTjauMLCR3HqIlegnOb2CR5GElyef6B%2CAGkb-H8hkQOoDBw2TbCYeAmm1PO27UD9XURaHXqhJoLq8hXVtZ9r5LlBL5kXG_eqP2y3uO4oxf4SZg5mGfAf3nqGjg&amp;pvsid=3401177030333925&amp;pem=369&amp;tmod=45593056&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fkalkulacija.com%2Fwordpress%2Fkalkulacija-prodajne-cene-robe-u-excel-u%2F&amp;eae=0&amp;fc=1408&amp;brdim=1920%2C0%2C1920%2C0%2C1440%2C0%2C1440%2C870%2C1440%2C767&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;cms=2&amp;fu=128&amp;bc=31&amp;jar=2022-05-18-10&amp;ifi=3&amp;uci=a!3&amp;btvi=4&amp;fsb=1&amp;xpc=ilBVO7ng6Z&amp;p=https%3A\/\/kalkulacija.com&amp;dtd=12387\" name=\"aswift_2\" width=\"834\" height=\"280\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" sandbox=\"allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation\" data-google-container-id=\"a!3\" data-google-query-id=\"CMGBl8326PcCFa3qKAUdaecFjQ\" data-load-complete=\"true\" data-mce-fragment=\"1\"><\/iframe><\/ins><\/ins><\/ins><\/div>\n<p>The main question is how do we arrive at the amount in column 8, The amount of the price difference.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Calculating_the_difference_in_price\"><\/span><span id=\"lzracunavanje_razlike_u_ceni\" class=\"ez-toc-section\"><\/span>Calculating the difference in price<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The difference in price is obtained when the\u00a0<strong>purchase value of<\/strong>\u00a0goods (value of goods from\u00a0<strong>column 6<\/strong>\u00a0increased by\u00a0<strong>dependent costs<\/strong>\u00a0from\u00a0<strong>column 7<\/strong>\u00a0) is applied to the appropriate percentage of margin, ie the amount of rebate approved by the supplier.<\/p>\n<p>So, getting the final selling price can be achieved in two ways:<\/p>\n<ol>\n<li>By increasing the purchase price by the percentage of sales margin (5%, 10%, 15%, 30%, 50%\u2026) which we calculate by percentage calculation;<br \/>\nFormula:\u00a0<strong>Price difference = Purchase price x Margin [%] &#8211; 100<br \/>\nSales price = Purchase price + Price difference<\/strong><\/li>\n<li>By selling at the purchase price where the amount of the rebate approved by the supplier or manufacturer, is based on our business relationship. It can be any amount from 0 to a theoretical amount of 99%;<br \/>\nFormula:\u00a0<strong>Price difference = Sales price x Discount [%] &#8211; 100<br \/>\nSales price = Purchase price<br \/>\n<\/strong><\/li>\n<li>By determining the final selling price that a product should have in a competitive market.\u00a0This is the situation when we want to determine the exact nominal amount of the selling price.<br \/>\nFormula:\u00a0<strong>Price difference = Sales price &#8211; Purchase price<\/strong><\/li>\n<\/ol>\n<p>The total amount from column 8 is entered in column 14 of the\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/excel-poslovna-knjiga-prihoda-i-rashoda\/\">business book PK-1<\/a>\u00a0.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Criteria_for_calculating_the_price_difference\"><\/span><span id=\"Kriterijumi_za_izracunavanje_razlike_u_ceni\" class=\"ez-toc-section\"><\/span>Criteria for calculating the price difference<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Since we basically have three ways of calculating, it is necessary to determine the criteria for determining the formula by which we calculate the difference in price.\u00a0The choice of the formula to be applied can be based on a combination of input data.\u00a0Eg\u00a0if our Margin is higher than zero, it means the first calculation, If our rebate is higher than zero, the second calculation and if the margin and rebate are equal to zero, and the selling price is higher than the purchase price, then it is the third calculation.<\/p>\n<p>We can also create a new column that should not be printed on the document, but which should allow the user to choose the type of calculation.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Protection_against_modification_by_locking_the_formula_field\"><\/span><span>Protection against modification by locking the formula field<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>There are columns that are populated or whose content is taken from other tables.\u00a0There are also columns that are calculated as e.g.\u00a0column no.\u00a06\u00a0<\/span><strong><span>The value of the goods<\/span><\/strong><span>\u00a0is calculated by multiplying the values \u200b\u200bfrom column 4.\u00a0<\/span><strong><span>quantity<\/span><\/strong><span>\u00a0and column 5.\u00a0<\/span><strong><span>price per unit of measure<\/span><\/strong><span>.\u00a0Not to skip, but in the 1st column of the\u00a0<\/span><strong><span>ordinal number<\/span><\/strong><span>, the formula is inserted which reads:\u00a0<\/span><strong><span>= IF (IFNA (C8; 1) = 0; \u201d\u201d; B7)<\/span><\/strong><span>\u00a0.\u00a0Its work is based on testing whether there is a value in column 2.\u00a0<\/span><strong><span>The name of the goods<\/span><\/strong><span>\u00a0exists, if there is no IFNA function it will return the value 1. This value is tested by the\u00a0<\/span><strong><span>IF<\/span><\/strong> function and<span>\u00a0if it is different from zero, the ordinal number 1 is printed for the first line, and the previous number is increased by 1 for all other lines. As we can see in the following figure.<\/span><\/p>\n<figure id=\"attachment_3094\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3094\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3094\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal01.png\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal01.png 377w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal01-300x154.png 300w\" alt=\"Increasing the ordinal number\" width=\"377\" height=\"194\" \/><figcaption id=\"caption-attachment-3094\" class=\"wp-caption-text\"><span>Increasing the ordinal number<\/span><\/figcaption><\/figure>\n<p><span>This can be solved in several ways, here is another one\u00a0<\/span><strong><span>= IFNA (IFNA (C8; 1) = 0; \u201d\u201d; ROW () &#8211; 7)<\/span><\/strong><span>\u00a0where the\u00a0<\/span><strong><span>ROW ()<\/span><\/strong><span>\u00a0function of the workspace table number is used.<\/span><\/p>\n<p><span>Now select all the cells that need to be unlocked after locking the worksheet, in this case all the orange columns, and press\u00a0<\/span><strong><span>Ctrl + 1<\/span><\/strong><span>\u00a0.\u00a0You will receive the following content.<\/span><\/p>\n<figure id=\"attachment_3095\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3095\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3095\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal02.png\" sizes=\"auto, (max-width: 890px) 100vw, 890px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal02.png 890w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal02-300x194.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal02-768x498.png 768w\" alt=\"Cell format\" width=\"890\" height=\"577\" \/><figcaption id=\"caption-attachment-3095\" class=\"wp-caption-text\"><span>Cell format<\/span><\/figcaption><\/figure>\n<p><span>Now select the Protection tab and remove the heel from the\u00a0<\/span><strong><span>Locked<\/span><\/strong><span>\u00a0option .<\/span><\/p>\n<figure id=\"attachment_3096\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3096\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3096\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal03.png\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal03.png 492w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/kal03-300x100.png 300w\" alt=\"Unlock the cell\" width=\"492\" height=\"164\" \/><figcaption id=\"caption-attachment-3096\" class=\"wp-caption-text\"><span>Unlock the cell<\/span><\/figcaption><\/figure>\n<p><span>After this action, locking the entire\u00a0<\/span><strong><span>sheets<\/span><\/strong><span>\u00a0will leave these cells unlocked for input.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Download_data_from_another_document_and_validate_data\"><\/span><span id=\"Preuzimanje_podataka_iz_drugog_dokumenta_i_validacija_podataka\" class=\"ez-toc-section\"><\/span><span>Download data from another document and validate data<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>As the document, in addition to the main table, also has fields with the data of the business entity in which we use this document, it is necessary to fill in the header, double-clicking on the header element that will take us directly to the page to fill.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3082\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL.png\" sizes=\"auto, (max-width: 565px) 100vw, 565px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL.png 565w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL-300x151.png 300w\" alt=\"\" width=\"565\" height=\"284\" \/><\/p>\n<p><span>Page to populate the header.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3083\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL-za-popunjavanje.png\" sizes=\"auto, (max-width: 565px) 100vw, 565px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL-za-popunjavanje.png 585w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Zaglavlje-KL-za-popunjavanje-268x300.png 268w\" alt=\"\" width=\"565\" height=\"632\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Print_or_create_a_PDF_document\"><\/span><span id=\"Stampanje_ili_izrada_PDF_dokumenta\" class=\"ez-toc-section\"><\/span><span>Print or create a PDF document<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Finally, now you need to print the document and sign it.\u00a0We can do this in two ways, in electronic form, and in physical or paper form.<\/span><\/p>\n<p><span>If we do everything electronically, we first perform the electronic signing and save it in the appropriate folder in the original Excel format.\u00a0Of course, electronic signatures are revoked at any time when some data in the excel file itself changes.\u00a0Another way can be to first save it in PDF format in the\u00a0<\/span><strong><span>File \/ Save<\/span><\/strong><span>\u00a0as option and then electronically sign the PDF file itself.<\/span><\/p>\n<p><span>On the other hand, if we do everything in physical form or want to keep the documents on paper, we will first print the document and then physically sign the documents.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Download_excel_file\"><\/span><span id=\"Preuzimanje_excel_datoteke\" class=\"ez-toc-section\"><\/span>Download excel file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #c4dfe6; text-align: center;\">You can download the initial version here. \t\t<script src=\"https:\/\/www.google.com\/recaptcha\/api.js\" async defer><\/script>\t\t<div class=\"email_download_link\">\r\n\t\t\t\t\t\t<form action=\"#\" method=\"post\" class=\"ed_form\" id=\"ed_form_1778556954\">\r\n\t\t\t\t<p><span class=\"name\">Name *<\/span><br><input type=\"text\" name=\"name\" id=\"name\" placeholder=\"Name\" value=\"\" maxlength=\"50\" required\/><\/p>\t\t\t\t<p><span class=\"email\">Email *<\/span><br><input class=\"\" type=\"email\" id=\"email\" name=\"email\" value=\"\" placeholder=\"Email *\"  maxlength=\"225\" required\/><\/p>\t\t\t\t\t\t\t\t\t\t\t\t<p><input type=\"checkbox\" name=\"gdpr\" id=\"gdpr\" value=\"YES\"> <a href=\"https:\/\/kalkulacija.com\/wordpress\/politika-privatnosti\/\" target=\"_blank\">GDPR saglasnost za \u010duvanje emaila \/ GDPR consent to save email<\/a><\/p>\t\t\t\t<p><div class=\"g-recaptcha\" data-sitekey=\"6LfKPA4UAAAAADCRvP7_0Rmx03ygOZOhfsLi0Lnl\"><\/div><\/p>\t\t\t\t<br \/>\r\n\t\t\t\t<input name=\"submit\" class=\"submit\" id=\"ed_form_submit_1778556954\" value=\"Send Download Link\" type=\"submit\" \/>\r\n\t\t\t\t<span class=\"ed_form_spinner\" id=\"loading-image\" style=\"display:none;\">\r\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/plugins\/email-download-link\/images\/ajax-loader.gif\" \/>\r\n\t\t\t\t<\/span>\r\n\t\t\t\t<input name=\"guid\" id=\"guid\" value=\"apygmc-jokieb-webqag-udxqeh-erxfpb\" type=\"hidden\"\/>\r\n\t\t\t\t<input type=\"text\" style=\"display:none;\" id=\"email_name\" name=\"email_name\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"form_nonce\" id=\"form_nonce\" value=\"beb21ae5f4\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"name_mand\" id=\"name_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"gdpr_mand\" id=\"gdpr_mand\" value=\"YES\" type=\"hidden\"\/>\r\n\t\t\t\t<input name=\"phone_mand\" id=\"phone_mand\" value=\"\" type=\"hidden\"\/>\r\n\t\t\t<\/form>\t\r\n\t\t\t<span class=\"ed_form_message\" id=\"ed_form_message_1778556954\"><\/span>\r\n\t\t<\/div>\r\n\t<\/div>\n<div><\/div>\n<p><strong>CONTINUED TO FOLLOW!<\/strong>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;198&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;10&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.7&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.7\\\/5 - (10 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Cost calculation form in Excel - CoGS&quot;,&quot;width&quot;:&quot;133.8&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 133.8px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.7\/5 - (10 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Here you will learn how to make a usable table in Excel from one formally outdated form. Many Excel users<\/p>\n","protected":false},"author":1,"featured_media":2793,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-198","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kalkulacija"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Kalkulacija prodajne cene robe u Excel-u<\/title>\n<meta name=\"description\" content=\"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kalkulacija prodajne cene robe u Excel-u\" \/>\n<meta property=\"og:description\" content=\"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-02T12:19:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-01T09:45:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1675\" \/>\n\t<meta property=\"og:image:height\" content=\"770\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Cost calculation form in Excel &#8211; CoGS\",\"datePublished\":\"2022-05-02T12:19:32+00:00\",\"dateModified\":\"2023-11-01T09:45:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/\"},\"wordCount\":3448,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/kalkulacija-1.png\",\"articleSection\":[\"Calculation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/\",\"name\":\"Kalkulacija prodajne cene robe u Excel-u\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/kalkulacija-1.png\",\"datePublished\":\"2022-05-02T12:19:32+00:00\",\"dateModified\":\"2023-11-01T09:45:28+00:00\",\"description\":\"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/kalkulacija-1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/kalkulacija-1.png\",\"width\":1675,\"height\":770,\"caption\":\"Kalkulacija prodajne cene robe u Excel-u\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/kalkulacija-prodajne-cene-robe-u-excel-u\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kalkulacija prodajne cene robe u Excel-u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kalkulacija prodajne cene robe u Excel-u","description":"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.","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:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/","og_locale":"en_US","og_type":"article","og_title":"Kalkulacija prodajne cene robe u Excel-u","og_description":"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.","og_url":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2022-05-02T12:19:32+00:00","article_modified_time":"2023-11-01T09:45:28+00:00","og_image":[{"width":1675,"height":770,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Cost calculation form in Excel &#8211; CoGS","datePublished":"2022-05-02T12:19:32+00:00","dateModified":"2023-11-01T09:45:28+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/"},"wordCount":3448,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png","articleSection":["Calculation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/","url":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/","name":"Kalkulacija prodajne cene robe u Excel-u","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png","datePublished":"2022-05-02T12:19:32+00:00","dateModified":"2023-11-01T09:45:28+00:00","description":"Kalkulacija prodajne cene robe u Excel-u utvrdjuje cenu ko\u0161tanja proizvoda ili usluge, koja \u010dini osnovu za izra\u010dunavanje.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/01\/kalkulacija-1.png","width":1675,"height":770,"caption":"Kalkulacija prodajne cene robe u Excel-u"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/kalkulacija-prodajne-cene-robe-u-excel-u\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Kalkulacija prodajne cene robe u Excel-u"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=198"}],"version-history":[{"count":54,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/198\/revisions"}],"predecessor-version":[{"id":3098,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/198\/revisions\/3098"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/2793"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}