Inventory Summary Window

This window can be used to look at an inventory snapshot or to see how inventory has changed during a period of time. It can also be used for inventory related reporting. To understand how inventory works in Fusion, see the Inventory section of Core Concepts.

Determining What Inventory To Look At

Fusion will show inventory information for the date (or date range), locations, and items you select.

Date. To look at inventory information for one day, just enter the one date here. If you want to look at information over a period of days, enter the begin and end dates.
Included Locations…. Click this button to manage which locations are included in the displayed information. You can view one location at a time or combine any combination of locations by checking the appropriate checkboxes in the Include column.
Item Tabs. Click on the Commodities, Drugs, Inputs, or Cattle tab, depending on which kind of inventory you want to see.

Each time you make a change to any of the above, you will need to click the Refresh Tab's Information button to have Fusion update the displayed information.

Commodities, Drugs, and Inputs

Commodities, drugs, and inputs all work in similar way. When you select an item in the list on the left, the information on the right will show the inventory information for that item. If you select multiple items, Fusion will combine the inventory information for all the items selected. See the next section to learn how each value on the right is calculated depending on whether one or multiple items is selected.

The major difference between the Commodities tab from the Drugs and Inputs tab is the Show Extra Precision checkbox. When this option is turned on, Fusion will show 6 decimal places for the quantity related figures. If the option is left off, Fusion will only show 3 decimal places. The only time it would make sense to turn this on is if you are looking at ingredients that have their Track with extra precision option turned on (see Commodity/Ingredient Edit Window).

Calculations

The following table shows how the Fusion calculates the values in the Inventory Summary window for commodities, drugs, and inputs.

	One Item Selected	Multiple Items Selected
A	The beginning balance for the first day in the period. If multiple locations are selected, this is the sum of the appropriate first day for each item.	The sum of A for each selected item.
B	The sum of the New and the Offset In values for the period.	The sum of B for each selected item.
C	The sum of the Used and the Offset Out values for the period.	The sum of C for each selected item.
D	The ending balance for the last day in the period. If multiple locations are selected, this is the sum of the appropriate last day for each item.	The sum of D for each selected item.
E	B divided by days in period.	The above B divided by days in period.
F	C divided by days in period.	The above C divided by days in period.
G	A multiplied by K	The sum of G for each selected item.
H	Sum the New and Offset In values and multiply by the Avg Unit Cost for each day in the period. Then sum these values together.	The sum of H for each selected item.
I	Sum the Used and Offset Out values and multiply by the Avg Unit Cost for each day in the period. Then sum these values together.	The sum of I for each selected item.
J	D multiplied by N	The sum of J for each selected item.
K	The Avg Unit Cost for the first day in the period. If multiple locations are selected, this will be a weighted average based on begin balance.	The above G divided by the above A.
L	H divided by B	The above H divided by the above B.
M	I divided by C	The above I divided by the above C.
N	The Avg Unit Cost for the last day in the period. If multiple locations are selected, this will be a weighted average based on end balance.	The above J divided by the above D.

(The Market Value and Bill At sections follow the same logic as the Cost section but use Avg Unit Market Value and Avg Unit Bill At values respectively.)

The Avg Unit pricing is stored with each day’s record and is recalculated automatically when pricing, equivalency (for inputs), or amounts change. It is based on the current (for that day) pricing (Cost/Market Value/Bill At attributes) applied to all in and out movement for the item. If any relevant inventory offsets had any pricing overridden, this will be taken into account for the amount of the offset.

Cattle Tab

The first principle to understand when using the cattle portion of this window is that Fusion figures out cattle inventory solely based on in and out cohorts. If you override in or out values on a lot level, or if you have extra in and out cohorts associated with a lot to cancel out mistakes that have been made, the inventory levels shown here will not be correct. For this reason we recommend not overriding in or out values and editing or deleting in and out cohorts when mistakes have been made.

When you first use this tab, Fusion will show just the total values for the time period and location(s) chosen. You can break the totals down in several ways using the options above the inventory list. You don't have to refresh the list each time you make one of these changes, so it is easy to quickly experiment with how they work.

Cattle Type. Breaks the figures down by the cattle types you have defined.
Sex. Breaks the figures down by sex as defined in each lot (Mixed, Female, Male).
Weight Class. Breaks the figures down by weight class. You must choose which weight (Begin Weight, In Weight, Out Weight, or End Weight) to use for the breaks.
Lot. If you break by lots, there will be a row for each individual lot shown.
Show Subtotals. If this option is turned on, Fusion will add a subtotal row for each level of the left-most break column.
Hide Repeated Values. When this option is turned on, Fusion will hide repeating values in each break column so that it is easier to read.
Reflect Ownership Percentage. If you turn this option on, Fusion will adjust all the figures to reflect the ownership of a someone based on the following choices:
- For. Fusion will show the inventory levels for just the entered contact.
- For All Except. Fusion will show the inventory levels for everyone except the entered contact. For example, you could enter the name of your entity here and choose this option to see the inventory levels of all custom fed cattle (everything except your own cattle).

The columns in the inventory list are calculated as follows:

Begin Count. The total count of animals on this day. Since Fusion only keeps track of the count of animals for the end of the day for each day, this will be the count as it was at the end of the first day of the date range.
In Count. The total count of animals that entered the feedlot during the date range (including the first and last day in the range). This comes from the in cohort count field
Death Count. The total of animals that died during the date range. This comes from death out cohorts.
Out Count. The total of animals that left the feedlot during the date range. This comes from non-death out cohorts.
Begin Weight. The total weight of all the cattle on the first day in the date range. This weight comes from the weight Fusion automatically assigns a lot each day based on the weight gain method you set up in each lot.
In Weight. The total weight of animals that entered the feedlot during the date range. This is based on the in cohort pay weight.
Out Weight. The total weight of animals that left the feedlot. This does not include death weight and it based on the out cohort pay weight.
End Weight. The total weight of all the cattle on the last day in the date range. This weight comes from the weight Fusion automatically assigns a lot each day based on the weight gain method you set up in each lot.
Begin Value. Fusion looks at the begin count and begin weight and the current market value for the weight class each lot falls into and figures out the total value. Market value is based on the weight class pricing attributes you have set up.
In Dollars. The total dollar value of in cohorts within the period.
Out Dollars. The total dollar value of non-death related out cohorts within the period.
End Value. Works the same as Begin Value, except it uses end count and end weight.

Copying To Clipboard

You can click the Copy To Clipboard button to copy the values in whichever tab you are looking at to the clipboard. You could then paste it into a spreadsheet for further analysis. When you copy from the Cattle tab, it copies it just as you see it. When you copy from the other tabs, Fusion actually copies the values for every item in the list whether it is selected or not.

Note that the Show Extra Precision setting in the Commodities tab affects the values copied into the clipboard.

Printing Reports

To print an inventory report, click the Print button. From there you can create new reports or select existing reports to print from. See Inventory Summary Print Window for more information.

Note that the Show Extra Precision setting in the Commodities tab affects the values in the report.

Getting Here

You can open this window by going to Fusion Core → Lots → Lot Center.