<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="budgets-responsibility" name="Budgets and reporting responsibility">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Budgets and reporting responsibility">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="How do detailed budget drivers differ from a cost-center summary?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter" label="CostCenter" tableName="CostCenter" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter__grain" label="One organizational reporting cost&#10;center" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="CostCenter">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter__CostCenterID" label="CostCenterID (PK)" fieldName="CostCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="CostCenter">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter__CostCenterName" label="CostCenterName" fieldName="CostCenterName">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="CostCenter">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter__ParentCostCenterID" label="ParentCostCenterID (FK)" fieldName="ParentCostCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="CostCenter">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="CostCenter__ManagerID" label="ManagerID (FK)" fieldName="ManagerID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="CostCenter">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget" label="Budget" tableName="Budget" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="244.0" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__grain" label="One monthly cost-center/account&#10;budget summary" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__BudgetID" label="BudgetID (PK)" fieldName="BudgetID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__CostCenterID" label="CostCenterID (FK)" fieldName="CostCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__AccountID" label="AccountID (FK)" fieldName="AccountID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__FiscalYear" label="FiscalYear" fieldName="FiscalYear">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Budget__Month" label="Month" fieldName="Month">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Budget">
            <mxGeometry x="0" y="214.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine" label="BudgetLine" tableName="BudgetLine" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="170" width="330" height="244.0" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__grain" label="One monthly budget driver or&#10;statement-planning detail" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__BudgetLineID" label="BudgetLineID (PK)" fieldName="BudgetLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__CostCenterID" label="CostCenterID (FK)" fieldName="CostCenterID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__AccountID" label="AccountID (FK)" fieldName="AccountID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__FiscalYear" label="FiscalYear" fieldName="FiscalYear">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="BudgetLine__Month" label="Month" fieldName="Month">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="BudgetLine">
            <mxGeometry x="0" y="214.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Account" label="Account&#10;Shared reference" tableName="Account" primaryHome="false">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=65;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#f0f1f3;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="610" width="330" height="207.0" as="geometry" />
          </mxCell>
        </object>
        <object id="Account__grain" label="One chart-of-accounts account" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Account">
            <mxGeometry x="0" y="65.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="Account__AccountID" label="AccountID (PK)" fieldName="AccountID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Account">
            <mxGeometry x="0" y="117.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Account__AccountNumber" label="AccountNumber" fieldName="AccountNumber">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Account">
            <mxGeometry x="0" y="147.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="Account__AccountType" label="AccountType" fieldName="AccountType">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="Account">
            <mxGeometry x="0" y="177.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="r1" label="r1" relationKind="reference" childTable="Budget" childFields="CostCenterID" parentTable="CostCenter" parentFields="CostCenterID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="CostCenter__CostCenterID" target="Budget__CostCenterID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="279.0" />
                <mxPoint x="379.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r2" label="r2" relationKind="reference" childTable="Budget" childFields="AccountID" parentTable="Account" parentFields="AccountID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="Account__AccountID" target="Budget__AccountID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="742.0" />
                <mxPoint x="379.0" y="339.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r3" label="r3" relationKind="reference" childTable="BudgetLine" childFields="CostCenterID" parentTable="CostCenter" parentFields="CostCenterID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERzeroToOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="CostCenter__CostCenterID" target="BudgetLine__CostCenterID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1.0" y="279.0" />
                <mxPoint x="1.0" y="162.0" />
                <mxPoint x="771.0" y="162.0" />
                <mxPoint x="771.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r4" label="r4" relationKind="reference" childTable="BudgetLine" childFields="AccountID" parentTable="Account" parentFields="AccountID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="Account__AccountID" target="BudgetLine__AccountID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1.0" y="742.0" />
                <mxPoint x="1.0" y="841.0" />
                <mxPoint x="771.0" y="841.0" />
                <mxPoint x="771.0" y="339.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="footer" label="(PK) = primary key. (FK) = foreign key.&#10;Solid crow’s-foot lines show foreign-key relationships; dashed labeled lines show conditional traces or analytical matches. See r1, r2… in the relationship table.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="873.0" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
