Inch 5a7cb844-808d-4210-afab-dc2d76bbdecf 0 Integrated ENTERDATA true cb5455a2-1c29-4654-a9eb-501cd2d71718 EnterData 9 2 OrganizationKey OrganizationName 13 Australia 8 Canadian Division 5 Central Division 11 France 12 Germany 3 Northeast Division 4 Northwest Division 6 Southeast Division 7 Southwest Division <Query> <XmlData> <Data> <Row> <OrganizationKey>13</OrganizationKey> <OrganizationName>Australia</OrganizationName> </Row> <Row> <OrganizationKey>8</OrganizationKey> <OrganizationName>Canadian Division</OrganizationName> </Row> <Row> <OrganizationKey>5</OrganizationKey> <OrganizationName>Central Division</OrganizationName> </Row> <Row> <OrganizationKey>11</OrganizationKey> <OrganizationName>France</OrganizationName> </Row> <Row> <OrganizationKey>12</OrganizationKey> <OrganizationName>Germany</OrganizationName> </Row> <Row> <OrganizationKey>3</OrganizationKey> <OrganizationName>Northeast Division</OrganizationName> </Row> <Row> <OrganizationKey>4</OrganizationKey> <OrganizationName>Northwest Division</OrganizationName> </Row> <Row> <OrganizationKey>6</OrganizationKey> <OrganizationName>Southeast Division</OrganizationName> </Row> <Row> <OrganizationKey>7</OrganizationKey> <OrganizationName>Southwest Division</OrganizationName> </Row> </Data> </XmlData> <ElementPath>Data{}/Row{OrganizationKey(String),OrganizationName(String)}</ElementPath> </Query> System.String OrganizationKey System.String OrganizationName EnterData 8 2 DepartmentGroupKey DepartmentGroupName -1 [All Department Groups] 1 Corporate 2 Executive General and Administration 3 Inventory Management 4 Manufacturing 5 Quality Assurance 6 Research and Development 7 Sales and Marketing <Query> <XmlData> <Data> <Row> <DepartmentGroupKey>-1</DepartmentGroupKey> <DepartmentGroupName>[All Department Groups]</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>1</DepartmentGroupKey> <DepartmentGroupName>Corporate</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>2</DepartmentGroupKey> <DepartmentGroupName>Executive General and Administration</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>3</DepartmentGroupKey> <DepartmentGroupName>Inventory Management</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>4</DepartmentGroupKey> <DepartmentGroupName>Manufacturing</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>5</DepartmentGroupKey> <DepartmentGroupName>Quality Assurance</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>6</DepartmentGroupKey> <DepartmentGroupName>Research and Development</DepartmentGroupName> </Row> <Row> <DepartmentGroupKey>7</DepartmentGroupKey> <DepartmentGroupName>Sales and Marketing</DepartmentGroupName> </Row> </Data> </XmlData> <ElementPath>Data{}/Row{DepartmentGroupKey(String),DepartmentGroupName(String)}</ElementPath> </Query> System.String DepartmentGroupKey System.String DepartmentGroupName EnterData true =Parameters!OrganizationKey.Value true =Parameters!DepartmentGroupKey.Value 37 7 Level_01 Level_02 Level_03 Amount OrganizationKey Date DepartmentGroupKey Discounts 227.0700 13 5/1/2020 -1 Interest Expense 2345.2342 13 5/2/2020 -1 Operating Expenses Commissions 38048.7800 13 5/3/2020 -1 Operating Expenses Depreciation Amortization of Goodwill 2345.2342 13 5/4/2020 -1 Operating Expenses Depreciation Building Leasehold 345234.3456 13 5/5/2020 -1 Operating Expenses Depreciation Equipment 4647.2345 13 5/6/2020 -1 Operating Expenses Depreciation Furniture and Fixtures 2345.2342 13 5/7/2020 -1 Operating Expenses Depreciation Other Assets 38048.7800 13 5/8/2020 -1 Operating Expenses Depreciation Vehicles 2345.2342 13 5/9/2020 -1 Operating Expenses Depreciation Employee Benefits 345234.3456 13 5/10/2020 -1 Operating Expenses Depreciation Payroll Taxes 4647.2345 13 5/11/2020 -1 Operating Expenses Depreciation Salaries 2345.2342 13 5/12/2020 -1 Operating Expenses Labor Expenses Conferences 38048.7800 13 5/13/2020 -1 Operating Expenses Labor Expenses Marketing Collateral 2345.2342 13 5/14/2020 -1 Operating Expenses Labor Expenses 345234.3456 13 5/15/2020 -1 Operating Expenses Marketing 4647.2345 13 5/16/2020 -1 Operating Expenses Marketing 2345.2342 13 5/17/2020 -1 Operating Expenses Office Supplies 38048.7800 13 5/18/2020 -1 Operating Expenses Other Expenses 2345.2342 13 5/19/2020 -1 Operating Expenses Professional Services 345234.3456 13 5/20/2020 -1 Operating Expenses Rent 4647.2345 13 5/21/2020 -1 Operating Expenses Telephone and Utilities Telephone 2345.2342 13 5/22/2020 -1 Operating Expenses Telephone and Utilities Utilities 38048.7800 13 5/23/2020 -1 Operating Expenses Depreciation Entertainment 2345.2342 13 5/24/2020 -1 Operating Expenses Travel Expenses Meals 345234.3456 13 5/25/2020 -1 Operating Expenses Travel Expenses Other Travel Related 4647.2345 13 5/26/2020 -1 Operating Expenses Travel Expenses Travel Lodging 2345.2342 13 5/27/2020 -1 Operating Expenses Travel Expenses Travel Transportation 38048.7800 13 5/28/2020 -1 Operating Expenses Travel Expenses 2345.2342 13 5/29/2020 -1 Operating Expenses Travel Expenses 345234.3456 13 5/30/2020 -1 Operating Expenses Travel Expenses 4647.2345 13 5/31/2020 -1 Operating Expenses Travel Expenses 2345.2342 13 6/1/2020 -1 Operating Expenses Travel Expenses 38048.7800 13 6/2/2020 -1 Operating Expenses Travel Expenses 2345.2342 13 6/3/2020 -1 Returns and Adjustments 345234.3456 13 6/4/2020 -1 Total Cost of Sales Standard Cost of Sales 4647.2345 13 6/5/2020 -1 Total Cost of Sales Variances 2344.2345 13 6/6/2020 -1 <Query> <XmlData> <Data> <Row> <Level_01>Discounts</Level_01> <Level_02></Level_02> <Level_03></Level_03> <Amount>227.0700</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/1/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Interest Expense</Level_01> <Level_02></Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/2/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Commissions</Level_02> <Level_03></Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/3/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Amortization of Goodwill</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/4/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Building Leasehold</Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/5/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Equipment</Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/6/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Furniture and Fixtures</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/7/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Other Assets</Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/8/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Vehicles</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/9/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Employee Benefits</Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/10/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Payroll Taxes</Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/11/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Salaries</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/12/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Labor Expenses</Level_02> <Level_03>Conferences</Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/13/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Labor Expenses</Level_02> <Level_03>Marketing Collateral</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/14/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Labor Expenses</Level_02> <Level_03></Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/15/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Marketing</Level_02> <Level_03></Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/16/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Marketing</Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/17/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Office Supplies</Level_02> <Level_03></Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/18/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Other Expenses</Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/19/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Professional Services</Level_02> <Level_03></Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/20/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Rent</Level_02> <Level_03></Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/21/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Telephone and Utilities</Level_02> <Level_03>Telephone</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/22/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Telephone and Utilities</Level_02> <Level_03>Utilities</Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/23/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Depreciation</Level_02> <Level_03>Entertainment</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/24/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03>Meals</Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/25/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03>Other Travel Related</Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/26/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03>Travel Lodging</Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/27/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03>Travel Transportation</Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/28/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/29/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/30/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>5/31/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/1/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>38048.7800</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/2/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Operating Expenses</Level_01> <Level_02>Travel Expenses</Level_02> <Level_03></Level_03> <Amount>2345.2342</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/3/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Returns and Adjustments</Level_01> <Level_02></Level_02> <Level_03></Level_03> <Amount>345234.3456</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/4/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Total Cost of Sales</Level_01> <Level_02>Standard Cost of Sales</Level_02> <Level_03></Level_03> <Amount>4647.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/5/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> <Row> <Level_01>Total Cost of Sales</Level_01> <Level_02>Variances</Level_02> <Level_03></Level_03> <Amount>2344.2345</Amount> <OrganizationKey>13</OrganizationKey> <Date>6/6/2020</Date> <DepartmentGroupKey>-1</DepartmentGroupKey> </Row> </Data> </XmlData> <ElementPath>Data{}/Row{Level_01(String),Level_02(String),Level_03(String),Amount(Float),OrganizationKey(String),Date(String),DepartmentGroupKey(String)}</ElementPath> </Query> System.String Level_01 System.String Level_02 System.String Level_03 System.Double Amount System.String OrganizationKey System.String Date System.String DepartmentGroupKey =Fields!Level_01.Value =Fields!Level_01.Value =Fields!Level_01.Value =Fields!Level_01.Value =Sum(Fields!Amount.Value) true true =Fields!Level_01.Value & vbCrLf & FormatCurrency(Sum(Fields!Amount.Value)) & " (" & FormatPercent(Sum(Fields!Amount.Value) / Sum(Fields!Amount.Value, "dsMain")) & ")" 8pt #5c5c5c False 0.5 NaN NaN NaN 8pt #5c5c5c False 0.5 NaN Opposite NaN NaN 8pt #5c5c5c 0.5 NaN NaN NaN 8pt #5c5c5c 0.5 NaN Opposite NaN NaN TopLeft Black Black LEVEL 01 EXPENDITURES ACCOUNTS ('000) TopLeft EarthTones No Data Available dsMain 1.5in 6in 4.8in White None =Fields!Level_01.Value =Fields!Level_01.Value =Fields!Level_02.Value =Fields!Level_02.Value =Fields!Level_03.Value =Fields!Level_03.Value =Fields!Level_01.Value =Fields!Level_01.Value =Sum(Fields!Amount.Value) true true 8pt #5c5c5c False 0.5 NaN NaN NaN 8pt #5c5c5c False 0.5 NaN Opposite NaN NaN 8pt #5c5c5c 0.5 NaN NaN NaN 8pt #5c5c5c 0.5 NaN Opposite NaN NaN EXPENDITURES ACCOUNTS HIERARCHY ('000) TopLeft EarthTones No Data Available dsMain 1.5in 5.2in 6in 4.8in 1 White None Embedded Contoso_LogoSmall FitProportional 0.29167in 0.90833in 1.35833in 2 true Organization Expenditures Black 1pt Bottom 2pt 2pt 2pt 2pt true Organization: =Parameters!OrganizationKey.Label | Period: =Format(Parameters!DateFrom.Value, "d") & " to " & Format(Parameters!DateTo.Value, "d") | Department: =Parameters!DepartmentGroupKey.Label Top 2pt 2pt 6pt 2pt true 1.4in 1.2in 8.6in 3 #0d7b3d 7.5in 10in 0.6in true true true true Run at =Globals!ExecutionTime 0.2in 0.4in 5in Black 1pt #0d7b3d Middle 8pt 4pt 4pt 4pt true true Page =Globals!PageNumber of =Globals!TotalPages 0.2in 5in 0.4in 5in 1 Black 1pt #0d7b3d Middle 4pt 8pt 4pt 4pt 8.5in 11in 0.2in 0.2in 0.2in 0.2in