Find Jobs
Hire Freelancers

Do some Excel Work

$2-8 USD / hour

Завершено
Опублікований about 10 years ago

$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.
ID проекту: 5429333

Про проект

5 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
A proposal has not yet been provided
$2 USD за 1 день
4,8 (19 відгуки(-ів))
4,3
4,3
5 фрілансерів(-и) готові виконати цю роботу у середньому за $5 USD/год.
Аватарка користувача
A proposal has not yet been provided
$5 USD за 1 день
4,9 (29 відгуки(-ів))
5,1
5,1
Аватарка користувача
A proposal has not yet been provided
$5 USD за 1 день
5,0 (3 відгуки(-ів))
2,6
2,6
Аватарка користувача
A proposal has not yet been provided
$5 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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
Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.