| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Worker Salary | 4,500.00 | ||||||||||||||||||
2 | Worker cost / hour | 6.25 | ||||||||||||||||||
3 | ||||||||||||||||||||
4 | Sample of 2.5 Dev Production / Sell Math | |||||||||||||||||||
5 | Production Costs | |||||||||||||||||||
6 | Production Time | Cost per Item | Man Power | Total Cost | Buy Price | Sell Price (Buy-10%) | Profit / Item | Profit / Hour | Profit % | |||||||||||
7 | Medikit | 600 | 80.00 | 3,750.00 | 3,830.00 | 80.00 | 72.00 | -3,758.00 | -6.26 | -4697.50% | ||||||||||
8 | IR Googles | 800 | 100.00 | 5,000.00 | 5,100.00 | 100.00 | 90.00 | -5,010.00 | -6.26 | -5010.00% | ||||||||||
9 | Frag Grenade | 120 | 35.00 | 750.00 | 785.00 | 35.00 | 31.50 | -753.50 | -6.28 | -2152.86% | ||||||||||
10 | Flashbang | 120 | 70.00 | 750.00 | 820.00 | 70.00 | 63.00 | -757.00 | -6.31 | -1081.43% | ||||||||||
11 | Smoke grenade | 200 | 25.00 | 1,250.00 | 1,275.00 | 25.00 | 22.50 | -1,252.50 | -6.26 | -5010.00% | ||||||||||
12 | Incendiary Grenade | 200 | 150.00 | 1,250.00 | 1,400.00 | 150.00 | 135.00 | -1,265.00 | -6.33 | -843.33% | ||||||||||
13 | ||||||||||||||||||||
14 | Assault Rifle | 900 | 1,000.00 | 5,625.00 | 6,625.00 | 1,000.00 | 900.00 | -5,725.00 | -6.36 | -572.50% | ||||||||||
15 | Assault Rifle Magazine | 120 | 70.00 | 750.00 | 820.00 | 70.00 | 63.00 | -757.00 | -6.31 | -1081.43% | ||||||||||
16 | Sniper rifle | 1200 | 1,300.00 | 7,500.00 | 8,800.00 | 1,300.00 | 1,170.00 | -7,630.00 | -6.36 | -586.92% | ||||||||||
17 | Sniper Rifle Magazine | 120 | 85.00 | 750.00 | 835.00 | 85.00 | 76.50 | -758.50 | -6.32 | -892.35% | ||||||||||
18 | Riot Shotgun | 1400 | 1,500.00 | 8,750.00 | 10,250.00 | 1,500.00 | 1,350.00 | -8,900.00 | -6.36 | -593.33% | ||||||||||
19 | Saboted Slugs | 180 | 35.00 | 1,125.00 | 1,160.00 | 35.00 | 31.50 | -1,128.50 | -6.27 | -3224.29% | ||||||||||
20 | Flechette Shells | 120 | 35.00 | 750.00 | 785.00 | 35.00 | 31.50 | -753.50 | -6.28 | -2152.86% | ||||||||||
21 | ||||||||||||||||||||
22 | ||||||||||||||||||||
23 | ||||||||||||||||||||
24 | Balance Production / Sell Proposal | |||||||||||||||||||
25 | Worker Salary | 500.00 | ||||||||||||||||||
26 | Worker cost / hour | 0.69 | ||||||||||||||||||
27 | Cost per Item % | 40% | ||||||||||||||||||
28 | Production Costs | Market | ||||||||||||||||||
29 | Production Time | Cost per Item | Man Power | Total Cost | Buy Price | Sell Price (Buy-10%) | Profit / Item | Profit / Hour | Profit of 30 Workers/Month | Monthly Production of 30 workers | Best option | |||||||||
30 | Primary | |||||||||||||||||||
31 | Assault Rifle | 360 | 400.00 | 250.00 | 650.00 | 1,000.00 | 900.00 | 250.00 | 0.69 | 15,000.00 | 60 | Sell | ||||||||
32 | Assault Rifle Magazine | 50 | 36.00 | 34.72 | 70.72 | 90.00 | 81.00 | 10.28 | 0.21 | 4,440.00 | 432 | Sell | ||||||||
33 | Sniper rifle | 360 | 480.00 | 250.00 | 730.00 | 1,200.00 | 1,080.00 | 350.00 | 0.97 | 21,000.00 | 60 | Sell | ||||||||
34 | Sniper Rifle Magazine | 50 | 48.00 | 34.72 | 82.72 | 120.00 | 108.00 | 25.28 | 0.51 | 10,920.00 | 432 | Sell | ||||||||
35 | Riot Shotgun | 360 | 600.00 | 250.00 | 850.00 | 1,500.00 | 1,350.00 | 500.00 | 1.39 | 30,000.00 | 60 | Sell | ||||||||
36 | Saboted Slugs | 10 | 18.00 | 6.94 | 24.94 | 45.00 | 40.50 | 15.56 | 1.56 | 33,600.00 | 2,160 | Sell | ||||||||
37 | Flechette Shells | 10 | 18.00 | 6.94 | 24.94 | 45.00 | 40.50 | 15.56 | 1.56 | 33,600.00 | 2,160 | Sell | ||||||||
38 | Plasma Rifle | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
39 | Plasma Rifle Mag. | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
40 | Laser Rifle | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
41 | D-F Cartridge | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
42 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
43 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
44 | Secondary | |||||||||||||||||||
45 | 7.62mm Pistol | 180 | 360.00 | 125.00 | 485.00 | 900.00 | 810.00 | 325.00 | 1.81 | 39,000.00 | 120 | Sell | ||||||||
46 | 7.62mm Pistol Mag. | 10 | 16.00 | 6.94 | 22.94 | 40.00 | 36.00 | 13.06 | 1.31 | 28,200.00 | 2,160 | Sell | ||||||||
47 | Machine Pistol | 220 | 400.00 | 152.78 | 552.78 | 1,000.00 | 900.00 | 347.22 | 1.58 | 34,090.91 | 98 | Sell | ||||||||
48 | 4.2mm MP Mag. | 10 | 16.00 | 6.94 | 22.94 | 40.00 | 36.00 | 13.06 | 1.31 | 28,200.00 | 2,160 | Sell | ||||||||
49 | SubMachine Gun | 360 | 540.00 | 250.00 | 790.00 | 1,350.00 | 1,215.00 | 425.00 | 1.18 | 25,500.00 | 60 | Sell | ||||||||
50 | SMG Mag. | 20 | 32.00 | 13.89 | 45.89 | 80.00 | 72.00 | 26.11 | 1.31 | 28,200.00 | 1,080 | Sell | ||||||||
51 | Micro Shotgun | 360 | 540.00 | 250.00 | 790.00 | 1,350.00 | 1,215.00 | 425.00 | 1.18 | 25,500.00 | 60 | Sell | ||||||||
52 | Flechette Shells | 10 | 14.00 | 6.94 | 20.94 | 35.00 | 31.50 | 10.56 | 1.06 | 22,800.00 | 2,160 | Sell | ||||||||
53 | Combat Knife | 20 | 22.00 | 13.89 | 35.89 | 55.00 | 49.50 | 13.61 | 0.68 | 14,700.00 | 1,080 | Sell | ||||||||
54 | Plasma Pistol | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||||||
55 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
56 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
57 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
58 | Heavy | |||||||||||||||||||
59 | Machine Gun | 300 | 480.00 | 208.33 | 688.33 | 1,200.00 | 1,080.00 | 391.67 | 1.31 | 28,200.00 | 72 | Sell | ||||||||
60 | Machine Gun Mag. | 30 | 40.00 | 20.83 | 60.83 | 100.00 | 90.00 | 29.17 | 0.97 | 21,000.00 | 720 | Sell | ||||||||
61 | Flamethrower | 345 | 600.00 | 239.58 | 839.58 | 1,500.00 | 1,350.00 | 510.42 | 1.48 | 31,956.52 | 63 | Sell | ||||||||
62 | C90 Canister | 40 | 68.00 | 27.78 | 95.78 | 170.00 | 153.00 | 57.22 | 1.43 | 30,900.00 | 540 | Sell | ||||||||
63 | Rocket Launcher | 1000 | 1,600.00 | 694.44 | 2,294.44 | 4,000.00 | 3,600.00 | 1,305.56 | 1.31 | 28,200.00 | 22 | Sell | ||||||||
64 | HE Rocket | 90 | 172.00 | 62.50 | 234.50 | 430.00 | 387.00 | 152.50 | 1.69 | 36,600.00 | 240 | Sell | ||||||||
65 | IC Rocket | 150 | 252.00 | 104.17 | 356.17 | 630.00 | 567.00 | 210.83 | 1.41 | 30,360.00 | 144 | Sell | ||||||||
66 | Grenade Launcher | 600 | 1,000.00 | 416.67 | 1,416.67 | 2,500.00 | 2,250.00 | 833.33 | 1.39 | 30,000.00 | 36 | Sell | ||||||||
67 | 25mm HIT Grenades | 30 | 54.00 | 20.83 | 74.83 | 135.00 | 121.50 | 46.67 | 1.56 | 33,600.00 | 720 | Sell | ||||||||
68 | 25mm IC Grenades | 30 | 54.00 | 20.83 | 74.83 | 135.00 | 121.50 | 46.67 | 1.56 | 33,600.00 | 720 | Sell | ||||||||
69 | 25mm Flechette Grenades | 30 | 54.00 | 20.83 | 74.83 | 135.00 | 121.50 | 46.67 | 1.56 | 33,600.00 | 720 | Sell | ||||||||
70 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
71 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
72 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
73 | Misc | |||||||||||||||||||
74 | Medikit | 80 | 160.00 | 55.56 | 215.56 | 400.00 | 360.00 | 144.44 | 1.81 | 39,000.00 | 270 | Sell | ||||||||
75 | IR Googles | 200 | 320.00 | 138.89 | 458.89 | 800.00 | 720.00 | 261.11 | 1.31 | 28,200.00 | 108 | Sell | ||||||||
76 | Frag Grenade | 20 | 30.00 | 13.89 | 43.89 | 75.00 | 67.50 | 23.61 | 1.18 | 25,500.00 | 1,080 | Sell | ||||||||
77 | Flashbang | 20 | 34.00 | 13.89 | 47.89 | 85.00 | 76.50 | 28.61 | 1.43 | 30,900.00 | 1,080 | Sell | ||||||||
78 | Smoke grenade | 20 | 30.00 | 13.89 | 43.89 | 75.00 | 67.50 | 23.61 | 1.18 | 25,500.00 | 1,080 | Sell | ||||||||
79 | Incendiary Grenade | 40 | 60.00 | 27.78 | 87.78 | 150.00 | 135.00 | 47.22 | 1.18 | 25,500.00 | 540 | Sell | ||||||||
80 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
81 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
82 | Armour | |||||||||||||||||||
83 | Combat Armor | 480 | 560.00 | 333.33 | 893.33 | 1,400.00 | 1,260.00 | 366.67 | 0.76 | 16,500.00 | 45 | Sell | ||||||||
84 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
85 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
86 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
87 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||
88 | Craft Items | |||||||||||||||||||
89 | Shiva Rotary Cannon | 1000 | 2,000.00 | 694.44 | 2,694.44 | 5,000.00 | 4,500.00 | 1,805.56 | 1.81 | 39,000.00 | 22 | Sell | ||||||||
90 | SHIVA 20mm API Rounds | 150 | 240.00 | 104.17 | 344.17 | 600.00 | 540.00 | 195.83 | 1.31 | 28,200.00 | 144 | Sell | ||||||||
91 | SHIVA 20mm HEI Rounds | 150 | 240.00 | 104.17 | 344.17 | 600.00 | 540.00 | 195.83 | 1.31 | 28,200.00 | 144 | Sell | ||||||||
92 | Raven ECM Unit | 1000 | 3,200.00 | 694.44 | 3,894.44 | 8,000.00 | 7,200.00 | 3,305.56 | 3.31 | 71,400.00 | 22 | Sell | ||||||||
93 | Sparrowhawk AA Missile Rack | 1000 | 2,800.00 | 694.44 | 3,494.44 | 7,000.00 | 6,300.00 | 2,805.56 | 2.81 | 60,600.00 | 22 | Sell | ||||||||
94 | Sparrowhawk Missile | 240 | 400.00 | 166.67 | 566.67 | 1,000.00 | 900.00 | 333.33 | 1.39 | 30,000.00 | 90 | Sell | ||||||||
95 | TR-20 Rocket Pod | 1200 | 2,400.00 | 833.33 | 3,233.33 | 6,000.00 | 5,400.00 | 2,166.67 | 1.81 | 39,000.00 | 18 | Sell | ||||||||
96 | TR-20 Rocket | 240 | 336.00 | 166.67 | 502.67 | 840.00 | 756.00 | 253.33 | 1.06 | 22,800.00 | 90 | Sell | ||||||||
97 | Targeting Computer | 1800 | 4,000.00 | 1,250.00 | 5,250.00 | 10,000.00 | 9,000.00 | 3,750.00 | 2.08 | 45,000.00 | 12 | Sell | ||||||||
98 | Fuel Pod | 800 | 1,200.00 | 555.56 | 1,755.56 | 3,000.00 | 2,700.00 | 944.44 | 1.18 | 25,500.00 | 27 | Sell | ||||||||
99 | Polymer Aircraft Armour | 900 | 1,600.00 | 625.00 | 2,225.00 | 4,000.00 | 3,600.00 | 1,375.00 | 1.53 | 33,000.00 | 24 | Sell | ||||||||
100 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||