﻿<?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 YTD and remaining months Sales, Cost of Sales, Gross Margin, Gross Margin %, Units and ASP.

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>01CM01</ColumnCode><ColumnHeaders>Sales|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>RM1201</ColumnCode><ColumnHeaders>Sales|Fcst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>01CM02</ColumnCode><ColumnHeaders>COGS|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>RM1202</ColumnCode><ColumnHeaders>COGS|Fcst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0103</ColumnCode><ColumnHeaders>GM|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0204</ColumnCode><ColumnHeaders>GM|Fcst</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|YTD</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|Fcst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>01CM01</ColumnCode><ColumnHeaders>Units|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>0</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>RM1201</ColumnCode><ColumnHeaders>Units|Fcst</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|YTD</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|FCst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1211#0.0</ColumnCode><ColumnHeaders>ASP|% Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0309#0.00</ColumnCode><ColumnHeaders>Std Cost|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0410#0.00</ColumnCode><ColumnHeaders>Std Cost|Fcst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>16</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1514#0.0</ColumnCode><ColumnHeaders>Std.Cost|% Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>17</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0509#0.00</ColumnCode><ColumnHeaders>GM/Unit|YTD</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>18</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXDividedByColumnY</ColumnType><ColumnCode>0610#0.00</ColumnCode><ColumnHeaders>GM/Unit|Fcst</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>19</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>PercentageVarianceColumnXvsColumnY</ColumnType><ColumnCode>1817#0.0</ColumnCode><ColumnHeaders>GM/Unit|% Var</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>