Create a chart from provided data.

Cerrado Publicado Mar 18, 2014 Pagado a la entrega
Cerrado 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)



Formularios electrónicos Matemáticas MySQL PHP Desarrollo de software

Nº del proyecto: #5575330

Sobre el proyecto

13 propuestas Proyecto remoto Activo Apr 24, 2014

13 freelancers están ofertando un promedio de $401 por este trabajo

samitXI

Hi Sir, I am ready to work for you.I am expert in statistics and mathematics. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please Más

$315 USD en 7 días
(138 comentarios)
7.2
canlan318

Hello, beauhr I am a full-time freelancer who has rich experience and high skills in PHP / MySQL / HTML5 / CSS3 / Javascript / jQuery programming. I understood your project requirements completely. I believe i can Más

$257 USD en 3 días
(70 comentarios)
6.8
idleswell

Hello, Your request is for an online questionnaire (form) with results to display based on your calculations using the formulas supplied. I presume also that data should be validated. Results will be displayed (unle Más

$317 USD en 10 días
(173 comentarios)
5.9
VolKa

HI. Sure can do this in Matlab or Mathematica. Can do this also as handrwitten solution with charts done in any other software. And - If you create the other project with reduced ranges of bid (30-250$) I will change Más

$250 USD en 3 días
(32 comentarios)
5.2
ognjen011

A proposal has not yet been provided

$515 USD en 10 días
(8 comentarios)
4.5
CakephpJobs1

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

$250 USD en 10 días
(9 comentarios)
3.5
AlexCiobanu

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

$450 USD en 4 días
(1 comentario)
2.4
milanrsbg

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.

$250 USD en 7 días
(4 comentarios)
2.3
rochakv

Hi Would like to help. Please contact me for discussions. Good Day

$250 USD en 7 días
(2 comentarios)
1.6
abhinovpankaj

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

$250 USD en 7 días
(0 comentarios)
0.0
endershadow

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.

$250 USD en 3 días
(0 comentarios)
0.0
soamvipinkumar

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

$666 USD en 2 días
(0 comentarios)
0.0