Xanato Xan Kaso
Stalker
- Joined
- Oct 3, 2017
- Posts
- 1,635
- Location
- Florida
- Society
- The Frozen Flame
- Avatar Name
- Xanato Xan Kaso
Hi I am having difficulty determing whether or not I am making profit or if I am even calculating it correctly. Can someone take a look at my numbers and tell me if I am doing it right?
So in my spreadsheet i keep track of each run and then I tally all the results into a final figure.
Total Clicks
Total Qty Items Crafted.
Total Qty Material 1 Returned
Total Qty Material 2 Returned
"
Total Qty of Residue Returned.
After I have my totals I then do the following to determine % of TT returned.
Total TT Cost (TT cost per click x Total Clicks)
TT Returns of Item 1 (TT value of item x Total Return Qty)
TT Returns of Item 2
TT Returns of Item 3
"
TT value of Residue
------------------------
Total Value of TT returns
I then take Total TT Cost and subtract the Total TT Returns which then gives me my Total TT Profit/Loss and its % of Return.
Then to determine actual Profit/Loss
Total Cost = Total Clicks x Cost per Click with MU
Total Crafted Items Qty x TT x MU%
Total Return Qty of Item 1 x TT x MU%
Total Return Qty of Item 2 x TT x MU%
Total Return Qty of Item 3 x TT x MU%
"
Total Residue Returned x MU
-------------------------------------------
Total Value of Returned its with MU%
I then take the Total Cost w/ MU and subtract Total Returns w/ MU to get my Profit/Loss and %
Is this the correct way to do it? I have shown people my numbers and received conflicting answers as to whether or not I am calculating things correctly.
So in my spreadsheet i keep track of each run and then I tally all the results into a final figure.
Total Clicks
Total Qty Items Crafted.
Total Qty Material 1 Returned
Total Qty Material 2 Returned
"
Total Qty of Residue Returned.
After I have my totals I then do the following to determine % of TT returned.
Total TT Cost (TT cost per click x Total Clicks)
TT Returns of Item 1 (TT value of item x Total Return Qty)
TT Returns of Item 2
TT Returns of Item 3
"
TT value of Residue
------------------------
Total Value of TT returns
I then take Total TT Cost and subtract the Total TT Returns which then gives me my Total TT Profit/Loss and its % of Return.
Then to determine actual Profit/Loss
Total Cost = Total Clicks x Cost per Click with MU
Total Crafted Items Qty x TT x MU%
Total Return Qty of Item 1 x TT x MU%
Total Return Qty of Item 2 x TT x MU%
Total Return Qty of Item 3 x TT x MU%
"
Total Residue Returned x MU
-------------------------------------------
Total Value of Returned its with MU%
I then take the Total Cost w/ MU and subtract Total Returns w/ MU to get my Profit/Loss and %
Is this the correct way to do it? I have shown people my numbers and received conflicting answers as to whether or not I am calculating things correctly.