Estimate the mortgage that you can afford based on income, debt-to-income ratio, down payment, and housing expenses. Simply fill out the form to receive your FREE resource. Step 1 – First, calculate the variance from method 3rd. LTIFR calculation = (Number of lost time injuries x 1,000,000) / Total hours worked. The DATEDIF function below calculates the age of a person. 2) and Mineral Resources (2. 000219178)1825 = $2,983. The formula for calculating lost time injury frequency rate is the number of lost time injuries multiplied by 1,000,000, divided by the employee total hours worked. The number 200,000 is used to represent 100 employees working 2,000 hours per year, as the rate that results from this formula is designed to represent the number of lost. The formula for calculating lost time injury frequency rate is the number of lost time injuries multiplied by 1,000,000, divided by the employee total hours. Formula: MH = N * W. Step Three: Find the Average. OSH Accident Cost Calculator (OSHACC) - V2. Here, the details are in order in the corresponding cells in the formula. Printing and scanning is no longer the best way to manage documents. For that use the following formula in cell D7. March 10, 2023. Let me quickly explain what happens here. Content. I havent done stats in 25 years. Therefore, each one produces different results. It is a payroll document in which you can record payroll data for multiple employees along with a Salary slip prepared according to Indian rules of Employment. To calculate the percent difference between two numbers correctly, carry out these steps. Rolling LTIFR Calculator. (N/EH) x 200,000 <class=bold>=. Using the example above, this would result in the following formula: 4 x 1,000,000/ 246,750. Manual: turns off auto-calculations in Excel so you'll have to calculate manually. As you can see, there are just three parts of the LTIFR formula, two of which need to be reconciled on your end, and then the 1,000,000 figure which. =. Open a new worksheet, the right-click cell A1 and choose Paste Options > Keep. So, if you have 8 lost time injuries and 3 million hours worked, your LTIFR is 2. 0), AGL Energy (2. 67 0. You can specify the start and end time, regular time hours, overtime charges, as well as weekends. Here are the steps to add a Pivot Table Calculated Field: Select any cell in the Pivot Table. I'm trying to adapt this to our department as best as I can but on a weekly basis. The DIFR or LTIFR is calculate over a period of 12 months and the fixed indicator of 200 000 is used. e. The LTIFR is the average number of lost-time injuries in each industry in Australia in. (Number of OSHA recordable cases x 200,000) / Total number of hours worked. There's no CAGR function in Excel. To get YOY figures for YTD and FYTD, the best way to go about this is to calculate the previous year’s YTD and FYTD figures as well so that we can employ the simple mathematical equation of dividing the difference between current and previous years’ figures by the previous year figure. Scribd is the world's largest social reading and publishing site. . The easy part of TRIFR calculations, like all safety KPIs ( see more here) is the measurement itself. The Lost Time Injury Fatality Rate calculator can now be seen on the Data website. Use the Excel Formula Coach to find the present value (loan amount) you can afford, based on a. The IF function can be combined with other calculations by nesting other formulas and functions inside IF. Create an amortization table and graphs for adjustable rate mortgage (ARM) loans. Loan Amortization Schedule. 2, and 1. First put a start date in a cell, and an end date in another. INTRODUCTION. Then your percent change formula takes this form: = (C2-B2)/B2. Lost Time Case Rate. Then, click the pop-out button next to the word "Number. It can arise from a small incident, like aLost Time Injury Frequency Rate (LTIFR): How to Calculate & Reduce It. R. LTIFR or the lost time injury frequency rate is a safety measure which refers to the number of lost time injuries occurring per 1 million hours worked. If we look at Team B and D's ratios, had there been only 1 decimal place to display, 1. This is a ready-to-use template that you can manage your timesheet. 24 would be rounded down to 1. PPF account in SBI, HDFC, PNB, BOB, ICICI or any other authorised bank. Your companys LTIFR is 2. In the screen below, C7 contains a number and the sum is displayed:Let's create the formula for straight-line depreciation in cell C8 (do this on the first tab in the Excel workbook if you are following along). This would be a pretty high TRIFR, as you can see some TRIFR averages here. Mutiply, divide etc. Obviously you need to use the above LTIFR calculation formula to calculate LTIFR properly, but the tool you use for calculating your lost time injury rate is up to you - and can have a big impact on the amount of time and effort required to get these safety metrics into a safety scorecard or other useful format. OSHA has a published formula for calculating workplace injuries as follows: (# of injuries x 200,000)/400,000. 1 in 2018, according to the Bureau of Labor Statistics. Multiplying the number makes it easier to interpret. Choose a blank cell, and type "=RATE (" into it. Download Salary Sheet Excel Template. First, select cell B2, and enter the formula =B3, i. Building on this standard, GHG Protocol has now released a companion guide that makes it even easier for businesses to complete their scope 3 inventories. This is the nominal interest rate your bank offers to you. - Implement Quality Tools using MINITAB for the root cause analysis of defects in packaging. balthasar gelt skill treeThe Lost time injury frequency rate (LTIFR) calculator is a data tool that helps you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. We are committed to publically reporting our carbon emissions and, more generally, informing stakeholders of our approach to the risks and opportunities arising from climate change. It’s calculated by dividing the number of recordable injuries by the total number of employees over one year. The formula in Excel will begin with the equal sign. 1. 3 NPS calculation methods. LTIFR will typically be calculated for a specific workplace or project, but it can also be expanded to measure safety in specific regions or industries as well. To make it easier to interpret and benchmark, multiply the (very tiny) number you get by. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula. Here is a list of all Recalculate keyboard shortcuts: Shortcut. To work out the LTIFR you multiply the number of lost time injuries by 1,000,000 then divide that number by the total number of hours worked in an organization. As you can see, there are just three parts of the LTIFR formula, two of which need to be reconciled on your end, and then the 1,000,000 figure which. Converting this to a million hour LTIFR involves multiplying the number of LTIs by 1 000 000 and diving the result by the number. Premium = insurable earnings x premium rate ÷ 100. What is now known is that for every 100 employees, 35. 3), Qantas (24. Alternatively, you can open a new workbook, making sure that the sheet containing your data remains open and minimized. Most companies choose to calculate LTIFR per 1 million man hours worked. Oct 10, 2013. Using who example above, this intend result in the following formula: 4 x 1,000,000/ 246,750. , the “ Sold Value”. In this example, a construction company is using their scorecard to track the number and type of risk assessments being performed. of Calculation Options in Excel. Both the person involved in accident and the employer may lose their income or profit due to extra costs incurred and increasing of various types of expenses in company operation. Then, the number is multiplied by 200,000 to make it easier to use and interpret. PMT(rate, nper, pv, [fv], [type])n = 5 years x 365 days (5*365 =1825) Supply the above numbers into the compound interest formula, and you will get the following result: =$2,000 * (1 + 0. Lost time injury frequency rates (LTIFR) Lost time injury frequency rates are one measure that can help you compare part of the work health and safety performance of our organisation again. 89; with a factor of 1,000, the LTIFR is. 1. Custom Lost Time Injury Calculator calculator, built using CALCONIC_. Select the cell where the weighted average should go (for us that's cell D15) and then type the following formula. Explain : Lost Time Injury Frequency Rate (LTIFR)When assessing safety performance, one of the most important KPIs to track is lost time injury frequency rat. Syntax. Effectively managing the staffing schedule and putting on casuals or part timers can help reduce workload and reduce your LTIFR. The number of work-related injuries per 100 full-time workers during a one year period. I. How much your accident insurance policy costs will depend on several things: the amount your business pays in wages. In the example shown, the formula in E5, copied down, is: =IF (C5>20, C5*D5*0. In the U. If the TRIR rate is high, it indicates that the company's work sites are dangerous. The most significant improvements in 2020 were at Nordgold (58% reduction in LTIFR), MMG (56%) and Kinross (45%). The Lost time injury frequency rate (LTIFR) calculator is a data tool maintained by Safe Work Australia that can help you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. 9, C5*D5) If more than 20 items were sold, the formula applies a 10% discount to the total price. . LTIFR = (14 / 800,000) x 200,000 = 3. LTIFR calculation formula. The LTIFR formula is: The LTIIR product is: As with other episode rates, a good Lost Time Failure Rate is one that is as vile because likely. Press the Enter key to complete your calculation. Simply copy the Table and remove the data. To modify Excel calculation options; On our worksheet ribbon, click on the “Formulas” tab and then. Figuring out the time period for your rolling average depends on your goal in calculating it. To calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000. SR is the total number of lost workdays per year × 200000 work hrs/number of workers in a job. 2. Total wattage of fixtures = 2 × 32 = 64 Watt. R. From this info, first, enter all these things into the Excel worksheet to conduct the ROI calculation. 00 2. 80 1. You'll see a tool tip in the top left corner of the sheet as well as when you select the cells containing the loan details at the top. I'm trying to adapt this to our department as best as I can but on a weekly basis. These steps help you figure out which numbers to include in the formula, then how to solve the equation: 1. Step 3 – To get the percentage of the entire data variance, we have to drag the formula applied to cell D2. Enter N = Number of Recordable Injuries and/or Illnesses in One Year EH = Total Number of Hours Worked by all Employees in One Year 200,000 = Equivalent of 100 Full-Time Employees Working 40 Hour Weeks. The estimated number of people with an over-3-day absence injury at any time. Summary. Then, the number is multiplied by 200,000 to make it easier to use and interpret. The Lost Time Injury Frequency Rate (LTIFR), then, refers to the number of Lost Time Injuries that occurred within a given accounting period, relative to the total. With the last argument set to TRUE, vlookup will find the closest match to the lookup value that is less than or equal to the lookup amount. Then, click the pop-out button next to the word "Number. 00 5. Total recordable injury frequency rate should not be confused with the similarly named lost time injury frequency rate (LTIFR). SOLUTIONS MANAGEMENT INSIGHTS(+591) (2) 2792420; Av. Project management KPI templates can be helpful, but it’s most important for KPIs to be S. The Lost time injury frequency rate ( LTIFR) calculator is a data tool that helps you compare one aspect of the work health and safety performance of your. The generic formula for calculating EAR (in Excel formula syntax) is: =(1+i/n)^n–1 where n stands for periods, and i is the stated interest rate. To do so, select the columns or cells where you intend to store time clock entries and click the "Home" tab on the Excel ribbon menu. Sebuah dialog window akan muncul dan memintamu untuk memilih data mana yang akan dijadikan tabel. 6. #How to #calculate #TRIR #LTIR #LTISR #SafeWorkingHours #TIR by #maaz / #askmaazThis short video will give you guidelines on calculation of safety incident r. LTIFR calculation formula. Your best option is to use MS Excel, and add the formulas to calculate it. Safety Solutions. Lost Time Injury rate follows a simple formula to indicate your performance. - Perform Calculation of Sigma Level (DMAIC Approach) & designed Six Sigma Calculator, Worked on Sigma Level Benchmarking according to the guidelines of ASQ. The tricky part lies in getting accurate. The easy part of TRIFR calculations, like all safety KPIs ( see more here) is the measurement itself. Key Success Factors (KSFs) only change if there is a fundamental shift in business objectives. Salary Sheet is a ready-to-use template in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps you easily calculate the salary. 2. Building on this standard, GHG Protocol has now released a companion guide that makes it even easier for businesses to complete their scope 3 inventories. The formula below calculates the number above the fraction line. 91 89 321 Jan to Jun 2014 1. S. We’re also adding a bonus method by showing you the math behind NPS and how you can calculate it with pen and paper… should you ever want to!In this tutorial, we will show you how to compare revenue figures for two different years using a line graph. 00 = (2 x 1,000,000)/100,000. Step 3: Now convert the result into percentages by changing the format of the cell in Excel from number to percentage. KPIs are utilised to track or measure actual performance against key success factors. In Excel 2003 and earlier, go to. To calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000 to get a LTIFR = 2. You would use this formula: =RATE (E2,E3,E4)*12. W - work. Number of people ( employees + contractors) on site in rolling 12 months = 40. In Excel 2007, click Office button > Excel options > Formulas > Iteration area. Phone: 1300 OHS RTW (647 789) Mail: PO Box. Let’s go with the example in the introduction. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format. F. Pros: Helps normalize for the actual hours worked and particularly helpful for larger organizations (calibrating to 1 million hours is approximately 500 full time persons over a year). Excel Formulas & Functions. This number tells you the number of lost time injuries per 100 worker years (equivalent to 2000 hours. accident frequency rate calculation excel accident frequency rate calculation excel Your culture should focus on employee education and company-wide safety awareness, to truly cultivate a dedication and commitment to safety. LTIFR = 2. LTIFR will typically be calculated for a specific workplace or project, but. It is a payroll document in which you can record payroll data for multiple employees along with a Salary slip prepared according to Indian rules of Employment. LTIFR = # LTIs in accounting period / # hours worked in accounting period. Just click on the arrow for Insert > Insert Table Columns to the Left. Automatic: the default option that tells Excel to refresh the calculation any time information in the formula's data range is edited. LTIFR: Lost Time Injury Frequency Rate: the number of lost time injuries that occurred during the reporting period. 22 40 246 Jan to Jun 2016 1. Note: If the function returns a #NUM! error,. First, we have IncidentReports, which contains the incidents. Standar perhitungan statistik versi OSHA (Occupational Safety Health Administration) dengan angka 200. The 200,000 is the benchmark established by OSHA because it represents the total number of hours 100 employees would log in 50 weeks based on a 40-hour work week. 4 lost time trauma for every one mill man hours worked. Optional extra payments. 4, which means there were 2. Begin by choosing a spreadsheet software program such as Google Sheets, Microsoft Excel, LibreOffice Calc, or Open Office Calc. Type an equal sign = and then type a function. LTIFR will typically be calculated for a specific workplace or project, but it can also be expanded to measure safety in specific regions or industries as well. OSHA defines a lost time case as a recordable incident where an. 06,5,200,4000) . accident frequency rate calculation excel. gov. Safety-Rate-Calculation-Sheet. On the Excel Options dialog box, click Formulas in the menu on the left. This formula is used to check the results from EFFECT. We have used the NPV formula and we have ignored the value in cell C2, as this is the initial outflow. Categories of individuals that are included in the reported number of. Excel does it for me. Here is the TRIR calculation formula set forth by OSHA: TRIR = Number of Incidents x 200,000 / total number of hours worked in a year. Then press ENTER. The LTIFR is the average number of. 2. 52. Calculation in 8 steps. Lumen per fixtures = 85 x 64 = 5440 Lumen. The tricky part lies in getting accurate. To calculate the 12-month rolling sum for January 2020, add the 4 tons emitted in January 2020 and subtract the 2 tons emitted a year ago in January 2019. OSHA calculates this number as a rough measure of a company’s safety performance. We’re going to take you through 3 main methods for calculating your NPS, using: A spreadsheet/Excel, or. Resources. 000 = ( 50 minggu / tahun ) x ( 40jam / minggu) x 100 pekerja. You need to understand how to calculate Mean Time Between Failure and Mean Time To Repair before you apply it in to your excel data. In this example, a construction company is using their scorecard to track the number and type of risk assessments being performed. 20 de abril de 2023. WebAccident Incidence Rate Formula. 4. Send us mail mukwonago humane society. 00 9. 한국어. Fixed Yearly and Fixed Monthly modes of investments. If you have more than one NAICS code (NC), you will need to calculate each NC separately. Step Three: Combine the SUMPRODUCT and SUM to Calculate the Weighted Average. Experiment with growth rate scenarios and project outcomes in real time. Occupational Safety and Health Administration defines incidence rate as the number of injuries/illnesses × 200000/employee-hours worked, where 200000 represents the equivalent of 100 employees working for 40 hrs per week, 50 weeks per year. 4, which resources there were 2. Lost time incidents are accidents that occur when a worker sustains a lost time injury (LTI) that results in time off from work, or loss of productive work (absenteeism or delays). Please note that in addition to incident. You can see some LTIFR industry averages here. 1 safety departments Please try again. The assessment of the LTI has been used as an indicator for the Health and Safety performance, and the subset of the lost time injury which are the LTIFR and LTISR helps in proper assessment of. Type (, enter or select a range of cells to include in your calculations, then type ). LTIFR is considered a lagging indicator, as the results are more meaningful when measured across a large group of workers. This would be a pretty high TRIFR, as you can see some TRIFR averages here. LTIFR: Lost Time Injury Frequency Rate: the number of lost time injuries that occurred during the reporting period. Lost Time Injury Frequency Rate (LTIFR) 0. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. 3. jamie macdougall son of nanette fabray. T = Taxes. At first glance, it may seem all bricks and beams, concrete and chaos. 2 as well. The formula for calculating lost time injury frequency rate is the number of lost time injuries multiplied by 1,000,000, divided by the employee total hours worked. The table below shows how the calculations work each compound period. A survey tool with NPS feature. 00 0. 2. Knowing this, you can simply subtract the start time (“Clock In”) from the end time (“Clock Out”) to find the time worked. LTIFR calculation formula. As you can see, there are just three parts of the LTIFR formula, two of which need to be reconciled on your end, and then the 1,000,000 figure which. Explore our current key statistics on work health and safety and workers' compensation. 3 days were lost. Click anywhere in chart area, in Chart Tools, go to Layout tab, click on the drop-down button of Trendline button in Analysis section and then click on More Trendline Options. 12 in 2019, and the LTIR was 1. Automatic Except for Data Tables: also tells Excel to recalculate any formulas if the data in the formula's cells changes. Type an opening parenthesis (. Lost time injury frequency rates’ (LTIFR) are used to calculate how a company health and safety system is performing, by calculating the number of LTIs multiplied by 1 million, divided by the number of person-hours worked in the period. If we subtract this value 10 times, the asset depreciates from 10,000 to 1000 in 10 years (see first picture, bottom. N = Installment Numbers (Months). Now, select the investment value cell B2. of LTI ÷ Manhour (Within the period in assessment) × 1000000 . There's no CAGR function in Excel. Go digital and save time with signNow, the best solution for electronic signatures. Type =SUMPRODUCT (. 22%, which is the IRR of the cash flow after six years. As the hours worked are the denominator when calculating LTIFR and other health and safety indicators you want them to be as large as possible. Lost time injury frequency rates (LTIFR) Link to engage. High TRIR shows poor safety performance; it is important to keep your organization’s TRIR as low as. PMT(rate, nper, pv, [fv], [type])n = 5 years x 365 days (5*365 =1825) Supply the above numbers into the compound interest formula, and you will get the following result: =$2,000 * (1 + 0. 00 5. What is now known is that for every 100 employees, 35. Median. 3) Metcash, Woolworths, Qantas Airways and Wesfarmers have consistently recorded some of the highest LTIFR rates over the past few years, while Wesfarmers has consistently recorded the. So, putting these two data in the above formula, we would get -. Pilih range/area datamu. XIRR – finds IRR for a series of cash flows that occur at irregular intervals. The median divides a distribution in half, which means 50% of. “Automatic” is the default option. An LTIFR of 7, for example, shows that 7 lost time injuries occur on a jobsite every 1 million hours worked. What is Lost time injury (LTI) : LTI is said to occur when a worker’s injury prevents him/her from returning to work within 24hours after an accident. Download the Tripartite Oversight Committee Report 2017 – 2020. The Lost time injury frequency rate ( LTIFR) calculator is a data tool that helps you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. Enter the date of birth into cell A2. LTIFR calculation formula. Step 1: To calculate the CAGR, we add the following formula in Cell C2, Step 2: Press Enter. Multiple the LTIs, four, by the standardizing number, 1 million, and divide by the number of hours worked. This formula is used to calculate an organization's TRIFR:How to Calculate: OSHA Recordable Incident Rate. “Automatic” is the default option. The software and spreadsheets below will make your job much easier, allowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size, and so on. Tag by Topic. M. Result:The number of hours worked (Manhour) = 100,000. Meanwhile, the lost-time injury frequency rate (LTIFR) fell on average for the 41 miners reporting this figure to 1. Calculation Method of Lost Time Injury Frequency Rate, LTIFR, Total Injury Frequency Rate, TIFR, Lost Time Injury Severity Rate (LTISR), First Aid, Medical T. 4, which means there were 2. Type an opening parenthesis (. This is called the net income. DCF Formula in Excel. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. In this case, we’ll say every employee worked 64 eight-hour days. One went to hospital for one week and the other was away for one full day. Man-hour is the average amount of work that one person can do in an hour. 290 0% Risk Management Maturity Model (RM3) 60% 80% 100% 99% 97% Top 10 Milestones to Reduce Level Crossing Risk 6 8 10 8 50% Train Accident Risk Reduction (TARR) 60% 80% 100% 96% 89% How we performed in 2019/2020 Local Measures KPI Worse Target Better Actual. Step 2: Appying Excel Formula inside a cell. 89 2. Where the TRIR considers all injuries and illnesses, the LTC Rate represents solely the number of cases that resulted in lost workdays. If you have more than one NAICS code (NC), you will need to calculate each NC separately. Automatic: the default option that tells Excel to refresh the calculation any time information in the formula's data range is edited. Loan Amortization Schedule. ÈE>% hn„ÔË‚ü}ø5ùN2 ˜ L Ù‚'×ó f [ >Ãhí R†` Pêy ó¹± ñθŠ üé–Ô2¾bK —Óé åF Ða j 2ŸÝ‚=© ýÜàß;% R“ìf÷MU f’œ J×Z LÌb!9 ß*„νuÀ„/ B¥rë$2º{ ó„ åt |?Ò&« #£0_Jë?aê' ê;§³: ·> ×î. Calculate Hours with a Simple Formula. But first, we will calculate the ROI value. The formula for how to calculate TRIR is simple: the number of incidents, multiplied by 200,000, then divided by the total number of hours worked in a year. Recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation. That is the start of last uptime to start of follow up failure. Simply enter the number of days lost to injury or illness and plug in the total number of hours worked by all employees to find your facility’s Lost Workday Rate – the rate of days lost on average for every 100 employees. The calculation for death or permanent total disability is based on a theoretical average remaining working life of 20 years, working 300 days per year. We will apply the formula mentioned above to calculate investment return in Excel. The definition of L. Excel has a built-in formula but it's far from ideal. Helps normalize for the actual hours worked and particularly helpful for larger. R. 3. 5. I am very sorry to say, I. MTBF Formula in Excel (With Excel Template) MTBF Formula Calculator; MTBF Formula. Two things to remember when totaling your annual. 4 And voila! Your company’s LTIFR is 2. 279 0. Call Us +971 (0) 4 299 9373 . For example, let’s say one of the strategic objectives of a local government is to provide. Click a cell outside the ranges you are evaluating. Most companies and projects differentiate and measure MTI's and FAI's or first aid injuries one another, as the difference in severity warrants a different lens. Enter this formula: =NETWORKDAYS(A2,B2) * 8 into a blank cell where you want to put the result, and then press Enter key, and you will get a date format cell as following screenshot shown: In case there will always be minimum 12 months data then below will work: =SUM (OFFSET (B6,,MATCH (TRUE,INDEX (ISBLANK (B6:W6),),0)-2,,-12)) In case data could be less than 12 months, say only 5 months (and other cells are blank), then below formula will account for this and return SUM of only 5 months: The resulting calculation would be: (5 recorded 'injuries' x 1,000,000) / 200,000 hours = 25 injuries per million hours worked. A lost time injury is something that results time lost from work. With a simple calculation, LTIFR is 3. 000, menggambarkan untuk 100 pekerja yang bekerja selama 2000 jam kerja. With their LTIFR calculated, this company can compare it to the rate for the construction industry as a whole. 89 2. Type. Lost time incidents are accidents that occur when a worker sustains a lost time injury (LTI) that results in time off from work, or loss of productive work (absenteeism or delays). Then, the number is multiplied by 200,000 to make it easier to use and interpret. 0000175. Refer your client Contact us. Learn how to total Year to Date values for either calendar year (Jan to Dec) or financial year (any. of Calculation Options in Excel. From the drop-down, select Calculated Field. Easy, quick and smart YTD calculation with Excel formulas. The law of small numbers does of course apply here, where the difference between 0, 1 and 2 incidents is tiny - but the derived calculation result difference is huge. Every product has a Wholesale Cost.