Excel Spreasheet

  • Tình trạng: Closed
  • Giải thưởng: $30
  • Các bài thi đã nhận: 2
  • Người chiến thắng: caabdul

Tóm tắt cuộc thi

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.

Các kĩ năng yêu cầu

Phản hồi của người thuê

“Oustanding Job! Project was delivered on time very happy with the results! Was very helpful throughtout the entire process would use him for everything!”

Hình ảnh hồ sơ cconte90, United States.

Những bài dự thi tốt nhất dự cuộc thi này

Xem thêm bài dự thi

Bảng thông báo công khai

  • designvin
    designvin
    • cách đây 4 năm

    Hi,
    I tried doing it but data seems to be incomplete. Have mentioned some example in my entry.
    Thanks

    • cách đây 4 năm
  • cconte90
    Chủ cuộc thi
    • cách đây 4 năm

    tractor status 1 is new project

    • cách đây 4 năm
  • cconte90
    Chủ cuộc thi
    • cách đây 4 năm

    tractor status one

    • cách đây 4 năm
  • psiva2009
    psiva2009
    • cách đây 4 năm

    What is the time line for this contest I ready to participate on this....

    • cách đây 4 năm
    1. cconte90
      Chủ cuộc thi
      • cách đây 4 năm

      4 days

      • cách đây 4 năm

Xem thêm bình luận

Làm thế nào để bắt đầu với cuộc thi

  • Đăng cuộc thi của bạn

    Đăng cuộc thi của bạn Nhanh chóng và dễ dàng

  • Nhận được vô số bài dự thi

    Nhận được vô số Bài dự thi Từ khắp nơi trên thế giới

  • Trao giải cho bài thi xuất sắc nhất

    Trao giải cho bài thi xuất sắc nhất Download File - Đơn giản!

Đăng cuộc thi ngay hoặc tham gia với chúng tôi ngay hôm nay!