haegan2007 wrote:
I have been pulled off for several days to make a tool to help speed up the BTS! corporation expansion. Lots of math involved and the calculator is just too slow!
Due to personal reasons, and Haegan knows of them, I cannot concentrate on anything light, such as running turns or writing. The only thing I can get done productively is things involving heavy math requirements where I have to dedicate more of my organic computer's runtime to this.
Below is an example of the data I am putting together for the BTS! expansion CEO's, Inventors, and Potentates:
Code:
Product Base Market Price per Unit
Automobile, Standard .35 WU's per unit = $1,050,000,000 Revenue Per Month
Full Production per Month 3000 Units
Workers Needed for Full Production
Profession Needed
______________________________________
Unskilled Workers 82000 = $65,600,000 Payroll Per Month ($5 per hr)
Semi-Skilled Workers 58000 = $69,600,000 Payroll Per Month ($7.5 per hr)
Skilled Workers 23000 = $36,800,000 Payroll Per Month ($10 per hr)
Production Floor Managers 7000 = $14,000,000 Payroll Per Month ($24K per yr)
Administrative Managers 3800 = $15,200,000 Payroll Per Month ($48K per yr)
Corporate Managers 460 = $3,833,180 Payroll Per Month ($100K per yr)
Executives 46 = $958,318 Payroll Per Month ($250K per yr)
Production Floor Engineers 12000 = $24,000,000 Payroll Per Month ($24K per yr)
Senior Engineers 2400 = $9,600,000 Payroll Per Month ($48K per yr)
Executive Engineers 150 = $1,249,950 Payroll Per Month ($100K per yr)
_______________________________________________________________________________________
Total = $240,841,448 Payroll Per Month
Products Needed for Full Production
Product Monthly Use (in Units)
________________________________________________
Aluminum 50 = $1,145,000 Cost Per Month ($22,900 per Unit)
Automobile Body, Standard 3000 = $120,000,000 Cost Per Month ($4,000 per Unit)
Automobile Chassis, Standard 3000 = $105,000,000 Cost Per Month ($3,500 per Unit)
Automobile Interior, Standard 3000 = $165,000,000 Cost Per Month ($5,500 per Unit)
Chemicals 50 = $4,600,000 Cost Per Month ($92,000 per Unit)
Electrical Components 300 = $8,400,000 Cost Per Month ($28,000 per Unit)
Electronic Components 300 = $15,720,000 Cost Per Month ($52,400 per Unit)
Energy 30 million kwhs = $1,935,000 Cost Per Month ($64,500 per Unit)
Engine, ICE 3000 = $13,500,000 Cost Per Month ($4,500 per Unit)
High Tech Services 75 = $18,750,000 Cost Per Month ($250,000 per Unit)
Industrial Equipment 25 = $285,000 Cost Per Month ($11,400 per Unit)
Industrial Upkeep Units 2 = $6,040,000 Cost Per Month ($3,020,000 per Unit)
Plastic 30 = $102,600 Cost Per Month ($3,420 per Unit)
Services 125 = $335,000 Cost Per Month ($2,680 per Unit)
Steel 50 = $387,500 Cost Per Month ($7,750 per Unit)
Wheels 12,000 = $24,084,000 Cost Per Month ($2,007 per Unit)
________________________________________________________________________________________
Total Parts = $383,429,100 Cost Per Month
Total Labor = $240,841,448 Cost Per Month
________________________________________________________________________________________
Grand Total = $624,270,548 Cost Per Month
________________________________________________________________________________________
Profit = $425,729,452 Cost Per Month
Taxes = $127,718,836 Per Month
________________________________________________________________________________________
Income = $298,010,616 Per Month ($2,736,127,392 per year)
So I needed Haegan to come up with a small program to crunch the numbers for me since there are over 500 products scheduled to be introduced in this expansion.
Cheers, Thor