﻿<?xml version="1.0" encoding="utf-8"?>
<CrossTab xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AppVersion="3.2.5.36101" xmlns="http://www.ajbsystems.net">
  <UserIDLastEdited>AJBSystems</UserIDLastEdited>Requires one sales file and corresponding Cost of Sales file. 
Shows annual Sales, COGS, Gross Margin, Gross Margin %, Units, ASP, Standard Cost and Gross Margin per Unit.

For further details and sample output, search the IFP Help Centre for 'Cost of Sales Analysis'.
<ClassificationVariables /><Columns><CrossTabColumn><OutputColIndex>1</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>F1~|Sales</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>F1~|COGS</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0102</ColumnCode><ColumnHeaders>F1~|GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0301#0.0</ColumnCode><ColumnHeaders>F1~|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>F1~|Units</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>0</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0105#0.00</ColumnCode><ColumnHeaders>F1~|ASP</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0205#0.00</ColumnCode><ColumnHeaders>F1~|Std Cost</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0607#0.00</ColumnCode><ColumnHeaders>F1~|GM/unit</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>