didijaba
Well-known Member
- Joined
- Nov 26, 2006
- Messages
- 511
Hi,
I have repair shop that buys large amounts of used bikes and then repairs them, and after repair is done sales repaired ones to buyers. I know how repair success is distributed over months, and I know how sales of repaired bike since it is placed into store is distributed. I would like to calculate my IRR but I do not know how to apply distribution of sales to calculated measure of repaired bikes coming to the store.
Here are my two tables
<table><tr><td><b>MONTHS</b></td><td><b>RepairSuccess</b></td><td><b></b></td><td><b>MONTHS</b></td><td><b>SaleSuccess</b></td></tr>
<tr><td>1</td><td>50%</td><td></td><td>1</td><td>0%</td></tr>
<tr><td>2</td><td>10%</td><td></td><td>2</td><td>5%</td></tr>
<tr><td>3</td><td>9%</td><td></td><td>3</td><td>15%</td></tr>
<tr><td>4</td><td>7%</td><td></td><td>4</td><td>25%</td></tr>
<tr><td>5</td><td>7%</td><td></td><td>5</td><td>30%</td></tr>
<tr><td>6</td><td>2%</td><td></td><td>6</td><td>20%</td></tr>
<tr><td>7</td><td>2%</td><td></td><td>7</td><td>5%</td></tr>
<tr><td>8</td><td>2%</td><td></td><td>8</td><td></td></tr>
<tr><td>9</td><td>2%</td><td></td><td>9</td><td></td></tr>
<tr><td>10</td><td>2%</td><td></td><td>10</td><td></td></tr>
<tr><td>11</td><td>2%</td><td></td><td>11</td><td></td></tr>
<tr><td>12</td><td>5%</td><td></td><td>12</td><td></td></tr>
<tr><td>13</td><td></td><td></td><td>13</td><td></td></tr>
<tr><td>14</td><td></td><td></td><td>14</td><td></td></tr>
<tr><td>15</td><td></td><td></td><td>15</td><td></td></tr>
<tr><td>16</td><td></td><td></td><td>16</td><td></td></tr>
<tr><td>17</td><td></td><td></td><td>17</td><td></td></tr>
<tr><td>18</td><td></td><td></td><td>18</td></tr></table>
And here is my measure for repair succes and placing repaired bikes to store
I have repair shop that buys large amounts of used bikes and then repairs them, and after repair is done sales repaired ones to buyers. I know how repair success is distributed over months, and I know how sales of repaired bike since it is placed into store is distributed. I would like to calculate my IRR but I do not know how to apply distribution of sales to calculated measure of repaired bikes coming to the store.
Here are my two tables
<table><tr><td><b>MONTHS</b></td><td><b>RepairSuccess</b></td><td><b></b></td><td><b>MONTHS</b></td><td><b>SaleSuccess</b></td></tr>
<tr><td>1</td><td>50%</td><td></td><td>1</td><td>0%</td></tr>
<tr><td>2</td><td>10%</td><td></td><td>2</td><td>5%</td></tr>
<tr><td>3</td><td>9%</td><td></td><td>3</td><td>15%</td></tr>
<tr><td>4</td><td>7%</td><td></td><td>4</td><td>25%</td></tr>
<tr><td>5</td><td>7%</td><td></td><td>5</td><td>30%</td></tr>
<tr><td>6</td><td>2%</td><td></td><td>6</td><td>20%</td></tr>
<tr><td>7</td><td>2%</td><td></td><td>7</td><td>5%</td></tr>
<tr><td>8</td><td>2%</td><td></td><td>8</td><td></td></tr>
<tr><td>9</td><td>2%</td><td></td><td>9</td><td></td></tr>
<tr><td>10</td><td>2%</td><td></td><td>10</td><td></td></tr>
<tr><td>11</td><td>2%</td><td></td><td>11</td><td></td></tr>
<tr><td>12</td><td>5%</td><td></td><td>12</td><td></td></tr>
<tr><td>13</td><td></td><td></td><td>13</td><td></td></tr>
<tr><td>14</td><td></td><td></td><td>14</td><td></td></tr>
<tr><td>15</td><td></td><td></td><td>15</td><td></td></tr>
<tr><td>16</td><td></td><td></td><td>16</td><td></td></tr>
<tr><td>17</td><td></td><td></td><td>17</td><td></td></tr>
<tr><td>18</td><td></td><td></td><td>18</td></tr></table>
And here is my measure for repair succes and placing repaired bikes to store
Code:
RepairSuccesBikesInStore :=
CALCULATE (
SUMX (
tblRepairSuccess,
[Count of Bikes] * tblRepairSuccess[RepairSuccess]
)
)
Last edited: