Find Jobs
Hire Freelancers

decision support system(repost)

$5-10 USD

En curso
Publicado hace más de 12 años

$5-10 USD

Pagado a la entrega
ase Study: Infoligent Education Limited Case Scenario Kevin is a regional sales manager for the Infoligent Education Limited. The company's sales force is responsible for promoting books to higher learning institutions around the globe. Kevin is one of Infoligent's many regional sales managers and has many responsibilities which include visiting with current and potential customers, supervising a growing sales staff, preparing numerous reports and tracking his sales region's expenses. Each week, members of Kevin's sales staff submit weekly expense claim forms. Currently, he scans through the expense forms, checks for anything out of the ordinary and then authorizes reimbursement cheques. He needs to become more organized about tracking his sales staff's expenses and asks you to design an expense worksheet for him. By using a spreadsheet application to analyze his sales force's expenses, he feels that he will save time and make better decisions. You and your team members will be provided with the Expense worksheet (in [login to view URL]) to start off and are required to perform the following tasks: BDS3014 Decision Support Systems for Knowledge Management Assignment 2 Excel functions and Nesting functions Task 1: Create a separate worksheet named "mileage lookup table" to store the mileage lookup table as shown below: Infoligent Education Limited Position Allowable Miles Rate MN SU S2 S1 700 600 550 500 0.20 0.22 0.25 0.32 When a sales representative is hired, he is issued a company car. Each week, the sales representative reports the number of miles that he has driven that week. For any miles over mileage limit, the employee is charged an overage fee. The allowable mileage and charge rate vary by sales position (MN=Manager, SU=Supervisor, S2= Sales representative2, S1=Sales representative1) within the company. Task 2: Based on the given worksheet (i.e. Expense), you need to further improve the worksheet to make it appear more consistent, professional and well-organized. For example, apply proper formatting to the cells like Ringgit Malaysia sign with two decimal places.
ID del proyecto: 2666370

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$10 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
2 freelancers están ofertando un promedio de $8 USD por este trabajo
Avatar del usuario
See private message.
$5 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de MALAYSIA
Malaysia
0,0
0
Miembro desde nov 17, 2011

Verificación del cliente

Otros trabajos de este cliente

decision support system
$10-15 USD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.