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?

Ferdigheter: Dataregistrering, Databehandling, Excel, Visual Basic, Nettsøk

Om arbeidsgiveren:
( 3 omtaler ) Grand Rapids, United States

Prosjekt-ID: #15853709

## Tildelt til:

JackieXu

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

\$111 USD på 3 dager
(34 omtaler)
4.8

## 6 frilansere byr i snitt \$161 for denne jobben

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 Mer

\$200 USD på 3 dager
(295 Omtaler)
7.7
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 på 3 dager
(283 Omtaler)
7.2
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 Mer

\$200 USD på 5 dager
(214 Omtaler)
6.8
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 Mer

\$155 USD på 1 dag
(85 Omtaler)
6.2
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 Mer

\$100 USD på 2 dager
(161 Omtaler)
6.0