Could you please ensure the data entered is correct? Thank you
Orginal Question:
Q * (Fields)
Price Per Ton
TR
MR Per Ton
FC
VC
TC
Profit or loss
AFC Per Ton
AVC Per Ton
ATC Per Ton
MC Per Ton
0
$40.00
$ 0
1
$40.00
24,000
$59,000
2
$40.00
40,000
3
$40.00
60,000
4
$40.00
85,000
5
$40.00
$156,000
6
$40.00
169,000
7
$40.00
221,000
8
$40.00
286,000
Filled in table, that I am requesting to be double checked:
Q * (Fields)
Price Per Ton
TR
MR Per Ton
FC
VC
TC
Profit or loss
AFC Per Ton
AVC Per Ton
ATC Per Ton
MC Per Ton
Q
P
P ⢠Q
ÎTR/ÎQ
FC+VC
TR-TC
FC/Q
TVC/Q
TC/Q
ÎTC/ÎQ
0
$40.00
$0
-
$0
$0
$0
$0
$0
$0
$0
$0
1
$40.00
40,000
$40
35,000
24,000
$59,000
-19,000 (Loss)
35,000
24,000
59,000
59,000
2
$40.00
80,000
40
35,000
40,000
75,000
5,000 (Profit)
17,500
20,000
37,500
16,000
3
$40.00
120,000
40
35,000
60,000
95,000
25,000 (Profit)
11,667
20,000
31,667
20,000
4
$40.00
160,000
40
35,000
85,000
120,000
40,000 (Profit)
8,750
21,250
30,000
25,000
5
$40.00
200,000
40
35,000
121,000
$156,000
44,000 (Profit)
7,000
24,200
31,200
36,000
6
$40.00
240,000
40
35,000
169,000
204,000
36,000 (Profit)
5,833
28,167
34,000
48,000
7
$40.00
280,000
40
35,000
221,000
256,000
24,000 (Profit)
5,000
31,571
36,571
52,000
8
$40.00
320,000
40
35,000
286,000
321,000
-1,000 (Profit)
4,375
35,750
40,125
65,000
Could you please ensure the data entered is correct? Thank you
Orginal Question:
Q * (Fields) | Price Per Ton | TR | MR Per Ton | FC | VC
| TC | Profit or loss | AFC Per Ton | AVC Per Ton | ATC Per Ton | MC Per Ton |
0 | $40.00 | $ 0 | |||||||||
1 | $40.00 | 24,000 | $59,000 | ||||||||
2 | $40.00 | 40,000 | |||||||||
3 | $40.00 | 60,000 | |||||||||
4 | $40.00 | 85,000 | |||||||||
5 | $40.00 | $156,000 | |||||||||
6 | $40.00 | 169,000 | |||||||||
7 | $40.00 | 221,000 | |||||||||
8 | $40.00 | 286,000 |
Filled in table, that I am requesting to be double checked:
Q * (Fields) | Price Per Ton | TR | MR Per Ton | FC | VC
| TC | Profit or loss | AFC Per Ton | AVC Per Ton | ATC Per Ton | MC Per Ton |
Q | P | P ⢠Q | ÎTR/ÎQ | FC+VC | TR-TC | FC/Q | TVC/Q | TC/Q | ÎTC/ÎQ | ||
0 | $40.00 | $0 | - | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
1 | $40.00 | 40,000 | $40 | 35,000 | 24,000 | $59,000 | -19,000 (Loss) | 35,000 | 24,000 | 59,000 | 59,000 |
2 | $40.00 | 80,000 | 40 | 35,000 | 40,000 | 75,000 | 5,000 (Profit) | 17,500 | 20,000 | 37,500 | 16,000 |
3 | $40.00 | 120,000 | 40 | 35,000 | 60,000 | 95,000 | 25,000 (Profit) | 11,667 | 20,000 | 31,667 | 20,000 |
4 | $40.00 | 160,000 | 40 | 35,000 | 85,000 | 120,000 | 40,000 (Profit) | 8,750 | 21,250 | 30,000 | 25,000 |
5 | $40.00 | 200,000 | 40 | 35,000 | 121,000 | $156,000 | 44,000 (Profit) | 7,000 | 24,200 | 31,200 | 36,000 |
6 | $40.00 | 240,000 | 40 | 35,000 | 169,000 | 204,000 | 36,000 (Profit) | 5,833 | 28,167 | 34,000 | 48,000 |
7 | $40.00 | 280,000 | 40 | 35,000 | 221,000 | 256,000 | 24,000 (Profit) | 5,000 | 31,571 | 36,571 | 52,000 |
8 | $40.00 | 320,000 | 40 | 35,000 | 286,000 | 321,000 | -1,000 (Profit) | 4,375 | 35,750 | 40,125 | 65,000 |