Controllable Cost of Goods

The Cost of Goods report allows you to generate a listing of the theoretical cost of one or more inventory items that were sold (as part of a menu item or as part of a prep item included in a sold menu item) during the specified time period compared to the actual usage of the inventory item.  The theoretical and actual usage dollars are divided by specified sales figures to calculate a Cost of Goods percentage. Sales figures used in this report are based on posted and unposted transactions posted to the general ledger accounts specified in GL Account Filters. Once GL account filters have been created, they must be applied to Inventory Level 1 Sales Account Filter. GL Account Filters must be used to effectively run this report.

The cost is "theoretical" because of assumptions in sales quantities from the sales mix and variances in recipe portions. Compeat takes each inventory item and determines which menu items or prep items (recipes) it is used in. The theoretical usage in dollars is calculated by taking a weighted average of the actual dollars per unit (i.e., the sum of dollars divided by the sum of units) during the specified time period, and then multiplying the weighted average dollars per unit time the number of theoretical usage units.  If the start date of the time period (i.e. 1/1) is immediately following an inventory count date (i.e. 12/31), the inventory quantity and unit cost of that date will be included in the calculation.

Note: If an item has never been purchased (entered on an invoice or manual check within Compeat), Compeat will use the Inv. Unit Cost defined on the Restaurant Inventory screen.

The report should be run for an inventory period, so Compeat can give an accurate picture of the theoretical usage (based on recipes and POS sales) and the actual usage (based on a physical inventory count).

This report pulls actual and theoretical costs from inventory product usage and counts not from your P&L. Only items that have been deemed as controllable inventory items will be included. Unchecking the 'Controllable Cost' checkbox on the restaurant inventory item record will filter items off of this report.

Report Options

baby_down.jpg Click to view/hide picture.

 

The following options are available to customize your report:

Report Data

A sample Cost of Goods report is shown below.

image71.jpg

Description of report columns

Each item is identified by its Item # and Description at the beginning of the row.

 

 

Note: Actual usage of transferred product will be shown only on the receiving store. This prevents duplication of usage that could result from counting usage at both the sending and receiving stores. This is allowed in the calculations because the cost has been transferred from the sending store to another entity.

 

Note: Items that do not have the 'Controllable Cost' checkbox checked will not be included in either actual or theoretical usage on this report.  

 

Note: Drill-down capabilities are available on the Level 1, 2, and 3 groupings.  The report should be run without including detail, rather, you may drill into a particular level to see item detail.