| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||
2 | RAW MATERIAL SITE | |||||||||||
3 | ||||||||||||
4 | Raw Material Site Size | Extraction Rate | Extraction Cost Per Unit | Extraction Tool Cost Per Unit | Per Unit Wholesale Price (IMU) | Net Revenue Per Site | Cost Of Raw Material Site | Net Income Per Land Slot | USER INPUTS | |||
5 | 100 | 500 | $15.11 | $17.00 | $5.00 | ($13,555) | $0 | ($13,555) | Extraction Tool Price | $8,500.00 | ||
6 | 100 | 1,250 | $23.65 | $6.80 | $5.00 | ($31,813) | $0 | ($31,813) | Raw Material Wholesale Price(IMU) | $5.00 | ||
7 | Size A (smaller) Raw Site | 2,483,581 | ||||||||||
8 | Size B (larger) Raw Site | 100 | ||||||||||
9 | FACTORY | Cost of Size A Raw Site | $4,516,092,578 | |||||||||
10 | Cost of Size B Raw Site | $2,483,581 | ||||||||||
11 | Production Output | Production Cost Per Unit | Per Unit Wholesale Price (IMU) | Net Revenue Per Factory | Extraction Cost Per Unit of A | $23.65 | ||||||
12 | 50,000 | $5.00 | $5.00 | $0 | Extraction Cost Per Unit of B | $23.65 | ||||||
13 | Size A site extraction rate | |||||||||||
14 | Size B site extraction rate | 1,250 | ||||||||||
15 | Number of supply days | |||||||||||
16 | ||||||||||||
17 | Product Cost | $5.00 | ||||||||||
18 | Number of sites of Size A to equal output of Size B: | 3 | Factory Product Price (IMU) | $5.00 | ||||||||
19 | Production Output | 5 | ||||||||||
20 | Net Income of one size B site: | ($31,813) | ||||||||||
21 | Net Income of Factory Slots in lieu of Size A Raw Sites: | $0 | ||||||||||
22 | Net Income of one size B site plus Factories: | ($31,813) | ||||||||||
23 | Net Income of equivalent size A sites: | ($40,664) | ||||||||||
24 | ||||||||||||
25 | Total Net Income difference of one size B site plus Factories vs. equivalent size A sites: | $8,851 | ||||||||||
26 | ||||||||||||