Create a chart from provided data.
$250-750 USD
Pagado a la entrega
I need a formula that prompts for data and presents the data as described. You will be asked detailed questions about the project, so please understand the requirements before applying.
variables:
e= number of employees
DRIVER AVERAGES
a= road warrior
b= everyday
c= frequent
d= occasional
TYPES OF REPORTING
f= spreadsheet
g= reporting tool
h= mileage app
i= paper log
OTHER
r= mileage rate
ROI= return on investment per month per employee
s= salary of employee
v = total savings as a result of less miles being logged
m= money saved from absence of w
DETERMINED VALUES
w=
2 if f selected
1.5 if (g)
1.25 if (h)
2.5 if (i)
q=
a & f = 1140
a & g = 750
a & h = 630
a & i = 1607
b & f = 760
b & g = 500
b & h = 420
b & i = 880
c & f = 380
c & g = 250
c & h = 210
c & i = 440
d & f = 190
d & g = 125
d & h = 105
d & i = 220
Questionnaire:
Prompt for (e): How many employees do you have? [enter value]
Prompt for (f, g, h, i): How do you currently track mileage? [menu: spreadsheet, reporting tool, mileage app, paper log]
Prompt for (a, b, c, d): What is the estimated average monthly miles traveled for each employee?
[menu: road warrior, everyday, frequent, occasional]
Prompt for (r): What is your current mileage reimbursement? [choose (0.56) or enter [value]]
Prompt for (s): What is the average annual salary for employees?
Step 1: Calculate (v) and (m)
v= (q)(r) m= (s/2080)(w)
Step 2: Calculate (t)
t= v + m
Step 3: Calculate (ROI)
ROI= ((100(t))/20)(100)
Display:
(t), (t)(e) and (t)(12), (t)(e)(12)
ROI, ROI(e) and ROI(12), ROI(e)(12)
Nº del proyecto: #5575330
Sobre el proyecto
13 freelancers están ofertando un promedio de $401 por este trabajo
Hello Sir, I am ready to start the job. I have some project like this just the data calculation differ. Please find my profile to know about me in details. Thanks & Regards, Pankaj
Hi, my name is Alex and I would like to do this project for you. From the requirements I understand you want a questionnaire that determines the amount of savings based on the miles logged (per employee/per all employe Más
hi there, i have done similar projects recently and i would like to help you with your project. please contact me so we could continue with discussion regarding project details.
Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. Más
Hi, I'm a very experienced java programmer and I understand the requirements. I can complete the project in 2-3 days. If you have any questions, feel free to contact me.
SUMMARY Sun Certified Programmer for Java 6.0 Platform. with 93%. Over 2+years of I.T. Experience. Excellent Development Skills : J2SE, HTML,JSP,SERVLET,J.D.B.C.,XML,STRUTS,HIBERNATE,SOAP,MYSQL,SQL SERVER. EXPERIE Más