In the current competitive landscape, the ability to preserve the grain’s identity as it moves through the supply chain, commonly referred to “Identity Preserved” or “IP”, is quickly moving from “handy to know” to “absolutely essential.”  Tracking the origins and the quality of the grain throughout the value chain enables you to maximize both margins and customer satisfaction.

Why is food traceability essential? 

• Identity Preserved Differentiates Commodities, and Your Business  The ability to track a product from farm to fork allows you to assure your customers that the food they are eating is of the highest quality and was produced in an ethical and sustainable way.  In an increasingly competitive global market, customers will pay a premium price for premium food. 
• Identity Preserved Food Can Be Traced:  The ability to trace grain from destination to source is essential for recalls, but forward tracing can also be used not only for cases of bin contamination, but to denote the final processing yields of grains purchased from different suppliers. 
• Identity Preserved Maintains Compliance:  Canada and European Union have already begun instituting rules surrounding Deforestation and Clean Fuel Regulations.  These regulations have been incorporated into Agrosoft, our CTRM agribusiness accounting software, to ensure regulatory compliance.  

Identity Preserved - A Packaged Solution

When the product is packaged, identity preservation becomes much simpler.  In Agrosoft grain accounting software, packaged products can be assigned a lot number, either at manufacturing time (for internally produced products) or at receipt time.  

From that moment on, every transfer, shipment, sale, return, or movement of the product should require the lot number, so you always trace where a lot is in your organization.  In Agrosoft, we support the ability to track lots throughout the system, as well as the ability to quarantine or hold lots using user defined status codes.  This would enable you to mark a lot as “testing required” or “test results pending” or “rejected”, with the ability to document the stages that are relevant to your organization.  

The main challenge with lot tracking isn’t the tracing, it’s making sure the lot numbers are properly  recorded when the inventory is received, moved, or shipped out.  With this in mind, Agrosoft provides bar code scanning for handling lot tracked products. 

Identity Preserved - Bulk Challenges

With bulk, unpackaged grain, the challenges are numerous.  The fun begins when grain from an individual shipment is mixed in with grain from other shipments.  Unless every load is stored separately, tracking the grain is as much an exercise in tracking where the grain has been as tracking the grain itself. 

In Agrosoft, we maintain an inventory transaction log that allows you to track which user-defined storage location any shipment has been placed in.  Agrosoft’s identity preserved tracing functionality enables you to track any loads that went into a particular bin, and any movements out of the bin.  Our bin management solution can also trace the last time the bin was empty, and record all bin cleanings.  

If a bulk load is contaminated, any bins that load touched, or any loads that touched the contaminated grain, may need to be recalled.  Agrosoft’s robust food traceability allows the operator to trace which bin grain was placed in, then see all movements of grain in-and-out of the bin.  If grain was moved to another bin, you can then trace that bin as well.  

This information will only exist if it is properly recorded.  Agrosoft’s grain elevator software solutions provide interfaces with the electronic scales that facilitates inventory tracking, on both inbound and outbound movements of the grain. 

This inventory management data could, if desired, also be integrated into a client’s block chain traceability as well. 

Identity Preserved - Quality Averaging

In addition to bin management tracing, we also allow you to track the grain quality in a bin.  Agrosoft will maintain a running weighted average summary of the grain quality of the grain that went into the bin, based on the loads received.  This average can be manually overridden by an operator with proper security, with Agrosoft recording who overrode the averages and when.  This allows you to maintain track of a certain quality factor, such as damage, while also giving you the option of overriding the average if an actual testing of the grain’s quality proves more accurate.  

As with the traceability, we allow you to record when a bin is emptied and/or cleaned, so that the factor averages can be reset to zero.  Knowing this is critical for food traceability / block chain traceability as well.

Identity Preserved - Conclusion 

While the challenges of tracing grain identity and grain quality through the supply chain are numerous, the rewards are enormous.  When done properly, the ability to certify your product's origins moves beyond mere compliance, and becomes a true competitive advantage that gives you pricing power.  Once a question of food safety, Identity Preserved products are now a central part of sustainability and customer satisfaction, and provide the sort of results and profits that every agribusiness will want to preserve. 

We hope to see you at booth #111 at the NGFA in California next week, where we will be raffling off a set of GSS golf balls, AI powered to guarantee a hole-in one every time, in a way that won't look at all suspicious.

Mary Marquardt, Mike McGeever, and Kurt Triebe will be brokenhearted to leave the subzero February temperatures in Chicago to celebrate the coming of spring at the March NGFA in California. Please stop by Booth #111 for a look at our Agrosoft customer Portal, free M&Ms, and tips about how to use your computer monitor to give yourself a fabulous January tan.

What is Costing Costing You?

The answer is everything.  Agricultural accounting software that will allow you to understand the true costs of your sales is the key to developing strategies for growing your business in a profitable, sustainable way.  While this may sound easy, it’s not, particularly in the agriculture industry, which presents a unique set of challenges.  How do you develop an accurate margin when the costs of your ingredients are fluctuating or are fundamentally unknowable, sometimes even after you’ve manufactured and sold the product?

My Accounting Professor Made It Sound Easy

In principle, it sounds easy.  You purchase inventory as an asset, and when you sell it you move the cost of the asset to the cost of goods sold.  The difference between your sales price and your purchase price is your gross sales margin.  Adding in your other costs (salaries, facility costs, overhead) enables you to compute the profitability of each sale, and manage your business. 

This approach works well for products with a readily known purchase cost, such as buying and selling a rake through your farm supply division.  But grain accounting is far more complex, as you are also managing merchandising contracts, risk hedging, and terminal storage. Grain can be bought using unpriced contracts, where the final futures or basis price may not be known for weeks or even months after the purchase has occurred.  Accounting rules also allow you to revalue products that are bought and sold in commodity markets, so the corn you bought last month can (and should) be revalued in you inventory at your current market price.  Indeed, accounting for commodity inventory is much more analogous to accounting for negotiable securities like stocks, which are revalued with an unrecognized gain or loss every month.

If you are buying and selling commodities such as corn or wheat, it is valid to price them after the purchase and revalue them as market conditions change, typically at the end of a financial period.  However, the problem becomes more complex when you use the product internally to manufacture other products.  What is the value of the corn that you have purchased but which you haven’t paid for (and for which you don’t have a price) when that corn has been used to manufacture cornflakes?).  Revaluing it (and possibly recognizing a gain in the value) doesn’t seem like a viable solution, as if you are doing feed blending sucking corn out of cornflakes and putting it back on the cob is a process beyond the scope of most grain processing facilities. 

OPTION ONE:  WHAT’S MINE IS MINE

One solution is to separate the risk of fluctuating commodity pricing from the manufacturing of your product.  This can be accomplished by running the commodity procurement traders and the feed/manufacturing facilities as separate cost centers.  Unpriced (or priced) grain can be transferred from the grain elevator to the feed/manufacturing division at the current standard cost, typically derived from the current market price.  The advantage of this approach is that you segregate out the gains/losses due to good (or bad) commodity trade risk management in the grain division, without passing the gains or losses onto the feed division.  So if you managed to purchase corn at $3 a bushel, and when the corn was actually transferred to the feed manufacturing division it was worth $7 a bushel, then that gain would be recognized by the traders rather than the feed division, with the grain elevator software tracking the difference.  

Note that some companies allow the feed division to buy grain externally if they can find another price, or allow the grain division to sell their grain to a competitor if they can get a better price.  Although this might seem non-intuitive, the goal of this approach is to create market efficiencies that drive better purchase decisions. 

OPTION TWO:  MARKET  TILL YOU MAKE IT

Segregating purchasing and manufacturing works for businesses that run their purchasing and processing functions as separate divisions, however, there are times when it makes more sense to have a single bottom line.  For example, if you are running a livestock company, or a feed manufacturing company, and purchasing grain is merely an adjunct to your core business, then your goal may be to reflect all costs in your finished product as accurately as possible, rather than to create a separate cost center for grain.

We recently completed a new module that allows us to accumulate costs – including the costs for unpriced grain – into your final inventory cost, even if the product used for manufacturing is still unpriced.  This enables you to seamlessly accumulate your commodity purchase costs into the finished products costs for your feed blending or fertilizer blending.  The procedure works as follows:

1)  You run your grain purchasing system as a periodic inventory system.  You record inventory purchase costs only when the grain is priced.

2)  At the end of the period (weekly, or monthly) you bring the unpriced inventory to market.  If the inventory has been used in manufacturing, then you move that cost into your finished goods inventory or cost of goods sold.  Otherwise, you keep the cost as part of your raw materials inventory. 

3)  You would reverse out the “to market” entries, and repriced any unpriced grain at the end of the next period, until the grain is actually priced.

4)  You also have the option of folding other expenses (such as your risk hedging or other commodity risk management costs) into your market price.

CONCLUSION

Computing margins for finished products that use unpriced inventory creates a unique set of challenges.  Agrosoft agtech software allows you to transfer unpriced costs using a fixed market price or standard cost, or adjust the unknown cost until the purchase is complete and the price can be fixed.  There is no right answer, and the choice may well depend on whether you are a grain business with a feed blending division or a livestock/feed manufacturing company with a grain division.  Whatever your situation, our dedicated team of professionals is here to develop the perfect solution for you.

When he isn't delivering presents to good boys and girls around the world, Santa works as a software developer and business analyst at Grossman Software Solutions. Santa and his hard-working elves make sure that the world is fed by providing the ERP software companies need to run their grain elevators, feed mills, crop inputs businesses, country stores, and terminals. 

A MERRY CHRISTMAS to all!

(Note: If you want to learn more, please call us after December 25th, as Santa is quite busy until then.)

Thank you, Kansas City, for your fabulous hospitality at the National Grain & Feed Association Country Elevator Conference.  The convention was a great opportunity for us to show off new features in Agrosoft's grain accounting software, including soybean crush and canola crush, our customer grain portal, and our tracking module for grouping and computing the profitability of shipping trains, trucks, and vessels.  

When merchandising grain, it is not uncommon to set up a purchase and sale where you ship directly from the buyer to the seller without ever taking physical possession of the grain.  Sometimes called a direct order, or a back-to-back, or a scalp transaction, these transactions allow traders to earn money by facilitating the transfer of grain and by arranging the freight. 

Most systems accomplish directs by creating a separate purchase and sale transaction, and then linking them together.  This requires the same information to be stored on two sets of transactions and can lead to headaches when the data isn’t kept in synchronization.  As the old data processing  joke goes:

Parallel files, aren’t.

In Agrosoft, we avoid this problem by recording the purchase and sale as a single transaction, thus eliminating the need for dual data entry and the possibility of parallel transactions getting out of synchronization. 

This is our screen for entering director orders.  In this example, we are purchasing/selling a truck of grain.  Note that we record both the origin (shipment) of the grain, as well as the destination (receipt) of the grain on the same screen.   Since this information is recorded in one place, recording the receipt of the grain on this screen marks the transactions as received on both the purchase and sales sides.

In the example above, we only record one truck's shipment.  But the grid structure allows us to set up many loads on a single order if we dare to. 

We have separate tabs that allow you to record the sales pricing:

As well as the purchase pricing:

One key advantage of this approach is you are not setting up separate transactions with duplicate information, and when you record the shipment (or receipt) of the grain you record it in only one place.  Similarly, you can record your freight information in a single place, and not waste time rekeying the freight across two transactions.

Although the direct is a separate transaction the sale can be invoiced before the purchase is recorded as complete, or visa-versa.   So you can invoice grain even though the purchase is still unpriced.

Yet another advantage of this is inventory management.  Systems that require you to set up separate purchases and sales will typically require you to set up a dummy “direct” location, to avoid recording the physical receipt of inventory that you never have.   In Agrosoft, you can record the direct at the location responsible for establishing the direct, without ever impacting physical inventory.

Setting up a dummy “direct” location can also create costing problems.  If you have several directs being shipped & received at the same time, the costs of the inventory can become intermingled,  which distorts the margin on each individual sale.  With Agrosoft, there is no dummy location, and you can easily compare the purchase price to the sales price on every transaction. 

Conclusion

Why do transactions twice when you can do them once, correctly, without errors, and without kludges or workarounds for “hiding” the fact that you aren’t receiving physical inventory?  Agrosoft allows you to record directs as directs, once, and with the correct margins and inventory.