﻿<?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 two sales files and corresponding Cost of Sales files. 
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>Sales|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>Sales|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011203</ColumnCode><ColumnHeaders>COGS|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011204</ColumnCode><ColumnHeaders>COGS|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0103</ColumnCode><ColumnHeaders>GM|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0204</ColumnCode><ColumnHeaders>GM|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0501#0.0</ColumnCode><ColumnHeaders>% GM|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0602#0.0</ColumnCode><ColumnHeaders>% GM|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>Units|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>0</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>Units|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>0</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>11</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0109#0.00</ColumnCode><ColumnHeaders>ASP|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>12</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0210#0.00</ColumnCode><ColumnHeaders>ASP|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0309#0.00</ColumnCode><ColumnHeaders>Std Cost|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0410#0.00</ColumnCode><ColumnHeaders>Std Cost|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1113#0.00</ColumnCode><ColumnHeaders>GM/Unit|F1~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>16</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1214#0.00</ColumnCode><ColumnHeaders>GM/Unit|F2~</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>