ROI Calculation Excel for a Standard LIMS in Brewari

« Back to Previous Page
0
0

Please to read the entire article.

Marked as spam
Posted by Debasish Mukherjee (Discussions: 1, Comments: 1)
Replied on August 16, 2018 1:16 pm
29 views
0
Private comment

Hi Debasish, nice to hear from you and thanks for posting this. I will share this discussion with Joe Liscouski who has done some work in the area of at least framing the costs to consider in determining LIMS ROI. I am not sure how Breweries are particularly special. Can you outline some of the pain points that breweries have with respect to quality control? One question is… why do brewers have laboratory testing in the first place. If it is a critical function, then we can start to build out ROI models from there.

Marked as spam
Posted by John Jones (Discussions: 368, Comments: 3039)
Replied on August 16, 2018 1:11 pm

Here is link to a previous discussion that has an excel sheet you can use as a starting point: https://www.limsforum.com/forum/lims-roi/

(John Jones at August 16, 2018 1:14 pm)
0
Private comment

Thanks for your response. As Usual before going CFO wants to understand ROI which could have been more elaborate after the URS and whole study. Many of us face the same issue when CFO wants to see the ROI calculation much before the expectation is set and before giving a green signal to move ahead. Here is the same issue.

Now to be specific to your question what the objective here:

1. This is a Replacement of Excel to System for Lab. Hence Greenfield. Error or Clerical work for Analyst is high and No Re usability of Data and time consuming etc etc which are quite natural for a green field project.
2. ERP is there however duplicate entry is high.
3. Batch system. Batch waits for report. Only EMail Communication or wait till the data is manually entered.
4. In ANy Bewary there are lot of 3rd party in Supply chain.However their quality is Beyond the Main system till it is entered. Hence they want to start journey to single point of truth.
5. Regulatory Requirement.

Hope this Answer your Question.

Marked as spam
Posted by Debasish Mukherjee (Discussions: 1, Comments: 1)
Replied on August 16, 2018 10:55 pm

As with any manufacturer, the purpose is not process but end product. Anything that adds to a process is cost and anything that reduces process is profit. The lab is needed to assure quality. If the company is committed to quality, then that is half the battle for building a value proposition. To prove roi you have to count up man-hours of labor spent on double entry, redoing of work, etc. If you reduce man-hours per day/week through automation and data management, it does not take long to justify a lims depending on the price of the lims and cost of implementation. If you are trying to justify labware, starlims or some other overpriced solution, you best stick with spreadsheets and cheap labor. You will never get your money back with those systems in a small mfg case like a brewery. Not knowing much more about your use case such as number of lab users, interface requirements, etc. I can only guess given it is a brewery that the most you should pay for a fully implemented LIMS is around $40K. If it is more than that, you will find it harder and harder to justify.

(John Jones at August 17, 2018 8:21 am)
« Back to Previous Page