Average Use and Cost by Origin Report

The Average Use and Cost by Origin report can be useful when creating a coffee buying plan. When purchase data is entered in Typica, one of the required fields is the Origin field. For every distinct origin specified, there will be a row in this report. Also note that decaffeinated coffees are listed separately.

Options

Date Range

While it is possible to look at this data over the full range of dates that data exists for, over time it may be more useful to restrict this report to a more recent date range. Several options exist in a convenient drop down menu or a custom range can be selected.

Sort Order

Regular and decaffeinated coffees are always displayed in separate sections, but within these sections, it is possible to sort the coffee alphabetically by origin, by average rate of use, or by average cost. Each of these can be in ascending or descending order.

Weight Unit

Weight measurements can be displayed in either pounds or kilograms.

Displayed Data

Origin

Whatever is put in the Origin field when entering green coffee purchases is put in this column. This is a link that can be clicked to expand the row to include information about the purchases.

When the row is expanded, there's a new row for every purchase represented. This consists of the green coffee ID for that item, the name of the green coffee, the rate that particular coffee was used at, the cost per pound or kilogram for that coffee, the current remaining inventory of that coffee, the date that coffee was first used, and the date the coffee was last used.

The green coffee ID is a link which can be clicked to bring up the Item Transactions report for that coffee.

Avg. Rate

Daily use of the coffee in pounds or kilograms.

Avg. Cost

Average cost of purchases.

Last Cost

The most recent purchase cost.

Last Purchase Date

The most recent purchase date of a coffee from the given origin.

Bag Size (min)

The minimum bag weight purchased.

Bag Size (max)

The maximum bag weight purchased.

Bean Size (mean)

The average bag weight.

Purchases

The number of purchases represented by the row.