<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

As margins around the country continue to contract due to factors such as increases in freight costs, impact of natural disasters, regulatory costs, etc., recognition of the cost of landing raw materials earlier in the supply chain process is becoming increasingly critical.  

A tool like ColumbusFood's Extra Charges functionality is a great way to recognize those charges as early as possible in your business process flow.  By allowing landing costs to be assessed, allocated and recorded at the time of purchase and accrued with the item's expected cost, purchasing managers and cost accountants can assess the impact immediately and are able to react to these market shifts. 

With complete flexibility to assign costs to the entire order or just an individual line, to allocate those costs based on a variety of methods across a variety of cost centers or departments, a purchasing manager can detail all of the related charges and insure that these projected costs are recorded immediately as part of the item's expected inventory cost.

Let's look at an example:

A purchasing agent enters an order for apples and pears from Canada.expected item inventory cost columbus

The following charges will apply to all items delivered and will be allocated by the average weight of each case.Document Header Extra Charges Landed Costs

The apples will also need to be graded — that charge is per case, or quantity received. This item will receive an allocated portion of the import fees, the food safety testing and the inbound freight.Extra-charges-landed-costs

The full expected cost of each line is then shown on the order:Full-expected-cost-on-order

When received, the expected cost is recorded, including the extra charges.expected-cost-is-recorded-including-extra-charges

When the invoices for these costs are finally realized, costs are actualized and any variance recorded automatically.

Analytic reporting, using tools like Power BI, can now be performed to assess cost portions as well as the expected vs. actual cost.Murphy6

Murphy7

 

 

 

 

 

 

 

Trending these costs allows insight into changes in cost metrics, as well as how much of recorded costs is certain, and how much is predicted based on the remaining expected cost at each analytic point.Freight-costs

Now management is empowered with needed information to adjust pricing, projections and forecasts, and perhaps even look into alternatives for reducing the freight that's causing the pain. Further analytics can be performed to review freight on a regional or seasonal basis, for example, or look for an outlaying factor that's causing the increase in freight costs when bringing in less material than usual.

Get the best view of your costs as early in your business process as possible. No crystal ball needed actually. Check out ColumbusFood to learn how.

want to learn more about columbusfood erp solutions

 

Topics

Discuss this post

Recommended posts

Here's a common scenario for Dynamics 365 Finance users: "Company A" has a purchase order for $1,000 in January that will be a part of a fixed asset. There will be two additional PO’s that will be part of this fixed asset, but won’t be invoiced until February and March. The asset should not be placed in service until all three invoices have been posted.
I've worked with Microsoft Dynamics GP for over 20 years and one of the coolest features I've seen is the workflow functionality in version GP2013 R2 and after. With each version after GP2013 additional capability and modules have been added. However, there are two major questions that need to be answered before you begin:
Data has been a very hot topic among clients lately. Specifically, I keep getting asked: "How can I create a strategy and plan around my data?" Most people I talk to are working for companies that collect data at every turn of the supply chain. This data might come from heavy equipment machinery or e-commerce metrics or financial growth numbers—the point is, it's usually contextually diverse and there's a lot of it.
In 2018, Black Friday sales pulled in a record $6.22 billion in online sales and 2019 could very well beat that number. Regardless, between Black Friday and Cyber Monday, this year's post-Thanksgiving weekend will be one of the biggest days in American retail.
Most food manufacturers and distributors have invested substantially in plant and equipment. However, it's common that even companies who invest in high functioning, sophisticated ERP systems also have manual processes for handling equipment maintenance. 
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down