Đã hoàn thành

Build a capacity spreadsheet

At the company there's a safelaunch location where there are 4 inspectors who inspect parts before they are shipped to the customer. I have included the part numbers on the left side of the spreadsheet.

I have a column for number of inspectors, and the quantities that they have to inspect. For example, the third part number 2151173, there are 60 parts in a tray, and there are 8 trays per bundle, and each box contains 2 bundles. Therefore there are 960 trays pieces per box.

I made a time study for the inspection for each of the part numbers, for example, how long will it take a certain number of inspectors to inspect the 960 pieces that we talked about. It will take them 110 minutes to fully inspect a box.

In column N, that is the quantity of pieces that we have to ship. I have converted the quantity from pieces to boxes in column O.

Column P is based on the total available inspection time that we have, for example, how many inspectors do we have? What's the volume (quantity) that we have to ship? Will we be able to make the shipment in time if we have 3 inspectors? Will we be able to make the shipment in time if we have 2 inspectors?

If we have too few inspectors, meaning we don't have enough inspectors, then a cell would turn RED because we will not be able to make the shipment. If we have too few inspectors, meaning we don't have enough inspectors, then a cell would turn RED because we will not be able to make the shipment.

If we have enough inspectors, the cell would turn GREEN because we have enough inspectors.

However, the volumes change from day to day. I want to be able to view it from a different angle, I want to have weekdays in the spreadsheet. Say for example, Monday we will ship 15 boxes, tuesday we will ship 8 boxes, etc. I want to be able to see and make sure that we have enough inspectors for each day.

If you have other ideas to improve this spreadsheet let me know please.

So one of the cell's color would depend on the quantity that needs to be inspected and how many inspectors we have based on a timeline that we have. For example, we need to ship 15 boxes in 24 hours, how many inspectors will it take to get this accomplished?

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Tìm kiếm web

Xem thêm: Build a spreadsheet, build excel spreadsheet with forms, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256did_dest, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256, a fantastic opportunity is available for a bookkeeper who can touch type 40wpm+ ie without looking at the keyboard the job invol, in view of the diversity of context in which translation research is conducted can never be fully comprehensive look at the diff, build list spreadsheet, build integration spreadsheet, build excel spreadsheet, Build spreadsheet, build data entry spreadsheet, available cakephp capacity, address change spreadsheet, change address spreadsheet, javascript selection value dropdown box change available values, can build front end excel spreadsheet

Về Bên Thuê:
( 0 nhận xét ) United States

Mã Dự Án: #15853709

Đã trao cho:

JackieXu

. Relevant Skills and Experience . Proposed Milestones $111 USD - .

$111 USD trong 3 ngày
(8 Đánh Giá)
2.7

8 freelancer đang chào giá trung bình $169 cho công việc này

schoudhary1553

Greetings, I can help you in Build a capacity spreadsheet . Please ping me for more discussion. Please see my profile i have deliver almost 280 projects with 100% client satisfaction. Relevant Skills and Experienc Thêm

$200 USD trong 3 ngày
(220 Đánh Giá)
7.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

$200 USD trong 3 ngày
(215 Đánh Giá)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia Thêm

$200 USD trong 5 ngày
(182 Đánh Giá)
6.7
rengrish

Hi I went through the requirement. Need to discuss more on that, I have 10+ years of experience in Excel/VBA. Please ping back .Kindy check my reviews Relevant Skills and Experience Excel/VBA/Macros Proposed Milesto Thêm

$100 USD trong 2 ngày
(154 Đánh Giá)
6.0
onlinejob247

Hi there, I have read the details and lots of experience Build a capacity spreadsheet and different types of projects. I am waiting for your quick positive reply. Feel free ask me question if any. I Look forward to Thêm

$155 USD trong 1 ngày
(48 Đánh Giá)
5.6
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic, Web Search Proposed Milestones $222 USD - D Thêm

$222 USD trong 5 ngày
(38 Đánh Giá)
5.1
c4cuteconain

We are a team of professionals and can help you with any official project including excel, oracle, VBA bookkeeping finance Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic, Web Search P Thêm

$161 USD trong 3 ngày
(20 Đánh Giá)
4.4