Find Jobs
Hire Freelancers

Do some Excel Work

$2-8 USD / hour

Ολοκληρώθηκε
Αναρτήθηκε περίπου 10 χρόνια πριν

$2-8 USD / hour

Despite the advent of technology, many processes in business are still manual. The Order Conformation form (Example 1) is an example. In spite of the fact that most of the data for this form is in another file called Tractor Status, and the rest of the data can be assembled into small tables, the input for this is still a manual operation. Historically, it has taken several WEEKS to process all incoming orders at the beginning of the model year. However, this has been for 200 orders; the company has grown and now has 400+ orders in-house. Clearly, this needs to be automated in some way. Tractor Status is the Master Schedule for the organization. While most organizations may have this in some database, the advantage of using Excel is the flexibility in adjusting weekly and monthly builds, as well as accessibility and ease of use. The Serial Number field is the Primary Key. Each row is a specific record, and contains the necessary information to build each tractor to a specific configuration. It also contains order information: Who (Dealer), Series or Model, Date Ordered, Month to be Built, Requested Month to be Built and PO number. Much of this information can be used to populate the Order Confirmation form. In addition, there are tables provided in the Conformation Model Template, which includes Option Pricing, Dealer names and addresses, Standard configurations and base price for each model and a table for Terms by Date. The logic for the terms is as follows. An MSRP is calculated by adding the base price and option prices for each order. Each dealer receives a discount of 20%. In addition for US dealers, an additional discount is earned depending upon the quantity ordered; a number is set as a dealer goal at the beginning of each model year. There are three levels: Platinum, Gold and Silver. Depending upon the level for which a dealer has currently qualified, several options are listed on the form, as well as a box for selecting which discount percentage. For Canadian Dealer, the discount depends upon the model ordered and which calendar year (2013 or 2014) payment is received. For both using the 20% and additional discount, a wholesale price is calculated. The Goal: automate this form by linking into Tractor Status and using Data Retrieval functions. Use the 2014 data in Tractor Status; all Serial Numbers begin with 914. Insure that your model is dynamically linked to Tractor Status; change some data and see if those changes are reflected in your model. Deliverables: Study the data and business rules. Develop a plan to complete this analysis. Detail what need to be done on a high level, what specifically need to be done with the data, and what formulas/functions could be useful in the process. Update the plan as you proceed if there are issues that force you to change the plan. Do this in a Word document. Implement the plan in Excel. Make it as dynamic as possible to minimize the number of formulas and functions you need to write/update. Note: PDF files are provides as templates, but your work may not match the numbers on those files.
Ταυτότητα εργασίας: 5429333

Σχετικά με την εργασία

5 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
A proposal has not yet been provided
$2 USD σε 1 ημέρα
4,8 (19 αξιολογήσεις)
4,3
4,3
5 freelancers δίνουν μια μέση προσφορά $5 USD/ώρα για αυτή τη δουλειά
Avatar Χρήστη
A proposal has not yet been provided
$5 USD σε 1 ημέρα
4,9 (29 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
A proposal has not yet been provided
$5 USD σε 1 ημέρα
5,0 (3 αξιολογήσεις)
2,6
2,6
Avatar Χρήστη
A proposal has not yet been provided
$5 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$7 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
yorktown, United States
5,0
4
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Φεβ 13, 2014

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

Excel Work
$50 USD
Excel Spreasheet
$30 USD
Tractor Status
$10-30 USD
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.