2021207 Sherwin Williams

Back to the Intranet

Project List RMA List Equipment List Representative List Parts Cost Analysis Service Cost Analysis Sherwin Williams 2021207.xlsm Workorders Folder

Project#:

Rev:

Traveler Status: Schedule Status:

Prepared By:

Date Rel:

Date Equip. Received:

Date Quoted:

E. Ship Date:

PO#:

PO Date:

Dates Shipped:

Active:

cust id:

Identifier (30 chars):

Category:

*REP/OEM/VAR:

*Market Segment:

BILL TO

*Attn:

*Company:

Address:

City:

State:

Zip:

Country:

*Phone:

Fax:

*Email:

Rev1:

Rev2:

Rev3:

SHIP TO

Attn:

Company:

Address:

City:

State:

Zip:

Country:

Phone:

Fax:

Email:

FAT Type:

FAT Date:

Lease/Sale:

Crate/Box:

Quote#:

Quote Date:

Video#:

Ship Via:

ME Review:

EE Review:

Build By:

Pymt Recvd:

NDA:

Order Rev.:

Requested Ship:

Prod. Hrs Left:

Prod. Hrs Total:

Prod. Pct Done:

Non Prod. Hrs Left:

Non Prod. Hrs Total:

Non Prod. Pct Done:

Billed Pct Done:

Price (Gross):

Project Docs:

Open in Explorer

Discount:

Quote Docs:

Open in Explorer
Copy Path

Quantity Discount:

Commission:

Price (Net):

Customer Price:

Down Payment:
Prior to Ship Payment:
Final Payment:

Down Pay Email
Ship Pay Email
Final Pay Email

✓ Wrike Down Pay
✓ Wrike Ship Pay
✓ Wrike Final Pay
★ Wrike Accounting Complete

Priority:

Override

Pay Comments:

Update Comments

Red Flag:

Don't Start Until:

Demo Equipment

R&D Project

Include in A3 Report

Project Scope: The revised proposed system consists of a Multifeeder Technology feeding and verification system (with vision camera) to feed and bar code verify paint label sheets at a rate of up to 275 sheets per minute. A Multifeeder Technology MFT 350 feeder will gently separate your paint label sheets from a vertical stack of the in feed hopper of the feeder and will transport them individually onto the 600mm (23.64") long discharge of the feeder. A Heavy Duty Rear Support Assembly with support plate will be utilized to support the stack from the back as they are fed. A Pneumatic Shaker will be mounted onto the rear support assembly of the feeder to assist with product flow. A Vacuum Track Assembly consisting of a vacuum chamber and a feed belt with holes that travels over the chamber will be used to best grip the products as they are fed (house vacuum Supply). A vision system will be mounted over the discharge of feeder to scan the bar codes on products as they travel on the feeder discharge. The vision system will also perform OCR on a couple of words near the bar code. If a "No Read" or a "Bad Read" occurs the feeder inspection logic will reject the product below (reject on error). If a settable number of consecutive rejects occur the system will be signaled to stop and will declare a fault. The feeder will feed the verified paint label sheets into a Catch Tray Pan with Magnetic Side Guides where they will be stacked and accumulated. A Static Reduction Bar will be mounted over the tray to reduce static on the sheets as they are stack and accumulated. An operator can remove the stack from the tray (up to 250 sheets) and a Photo Optic Start Sensor will signal the feeder to replenish the tray once a stack is removed. The MFT 350 will be mounted onto a HDSR 1000-350 Heavy Duty Stand on Rollers for height adjustment and mobility. An APL 2000-290 Automatic Product Loader (2000mm x 290mm) will be utilized to allow for an optimum stack height in the feed magazine of the feeder and for increased in feed magazine capacity. A Photo Optic Sensor will be mounted in the feed magazine of the feeder and will signal the loader to replenish the stack once it drops below a pre-set level. An E-stop is included at the end of the APL conveyor, at the Catch Tray, and on the feeder. In addition, system guarding is included. Multifeeder's Engineering team will create a system drawing for customer approval. System Integration includes a Factory Acceptance Test to verify system performance before shipment. System Integration and testing includes testing of all individual pieces to perform as one complete system. Integration also includes testing of the feeding performance of each product size at the rate specified. Options Available: Other options include a spare parts kit and standard feeder installation.
Notes: Sherwin Williams 2021207: 5/10: Project Cancelled - SW forfeiting down payment, MFT retains equipment. Document is in the Project Docs. 5/4: Still waiting on what they want to do with their cancellation. 4/27: They have communicated they want to cancel the order. Sent email with options (pay in full and get machine or we keep and keep down payment) 4/20: No change. Still waiting on information. Last communication 4/3 with Vinny. 4/13: No change 4/6: No change 3/30: Waiting on samples. Haven't heard anything. 3/23: Mark N. will reach out for update on the sample status. 3/16: Move out to end of April. Haven't head back on samples. 3/2: Still waiting on samples. Should be here soon. Mike will check on tracking. 2/23: Still waiting on samples. Mark had call with them yesterday. They are sending more samples. (shipped in the next day or so?) One sample is a different size. Mark notified them that it would be a change order for another size. 2/16: Waiting on new samples to run and test. Working with their vendor to eliminate static. 2/9: Turning right direction with exaggerated vertical. 2/2: Jack working on creating videos. Working on 2-4th. Running into static issues yesterday. Mike working through FAT document. 1/26: Camera guy in today looking at vision systems. All products running at rate. Starting to shoot validation video after camera guy gets everything squared away. 1/19: Back and forth with EE and Integration. Verifying we are running at rate. Mark to follow up with customer on signed documents needed. 1/12: issues with product feeding squarely. away from funnels. verifying feeding. may need to push back to customer to supply Matt finish on product. 1/5: Just went live in Integration yesterday. Jack working on it. Trying to validate 3-4 products. 2/15 tight but no better estimate at this time. 12/8: Going on hold today. Update ship to address to Fernley, NV. Change to in person FAT. 12/1: In Integration. Waiting on EE. Waiting for lights. Software issue with noises. 11/17 Added photos of samples to work order. 11/17: In Integration. Good amount of modifications needed. Waiting for bandwidth. Need to define what we are running on the system. Need to update documentation. 11/10: In production. 11/3: Next in queue in production. 10/27: Try to do Sherwin ahead of Verla and Precision. 10/20: parts due next week. only APL out in November. suggest building, integrating, and adding APL late in process. 10/14: Just got EE release. 10/6: No change 9/29: EE has everything on order. Received quite a bit of the items. 9/22: Got camera and components on order 9/7. Already received some parts. 9/15: In electrical 9/8: Everything approved - waiting to move to next step. 9/1: Received signed layout. Still waiting for a few other items we have asked for. 8/25: Got them layout. Waiting for them to confirm a few things (layout, field of view for vision system, etc.) 8/18: Waiting for them to approve layout. They asked for a 3D model of layout. Signed our NDA. 8/11: No change 8/4: On hold. Sent them some confirmation on samples, field of view on vision system, etc. Waiting for confirmation. 7/28: Waiting on sales and confirmation of what we are proposing. 7/21: waiting on sales to resolve order and get back on track. waiting for new samples, waiting for follow-up on details from Mark N. need signoff on vision system. Need to supply field of view, resolution, letting them know the 3 items we are inspecting. need signoff on these so we can issue purchase order for vision. 7/21 Held Zoom meeting with new stakeholders. Move to work order review for next steps. 7/14: Confirmation on new ship to location and new stakeholders. Per Kimberly project is back live. Mark working on scheduling a meeting with new stakeholders. 7/7: No change 6/30: No change 6/23: Suspended 6/20: SW is changing the plant they want to put the machine in and are delaying the project until they decide which location. Suspending the project until that is resolved. 6/16: Have not heard back from Kimberly. Mark will reach out again today. 6/9: Should have had decision. Mike will follow up. 6/2: Kimberly has meeting today with boss to get final approval. 5/26: Really close. Waiting for final approval on one more detail. 5/19: No update. Note on Tuesday that they were hoping on a decision early next week. 5/12: Kimberly has not made a decision. Mark N. will bug her again. 5/5: Ball in Kimberly's court. Working through samples to see if it's going to work for them. 4/28: Mark will reach out to Kimberly today for update. 4/21: Call yesterday to talk through vision system. Taking information back to their team. Will have an answer in a week. 4/14: No change. Positive feedback from vision system company. Meeting next week. 4/7: No change. Working through electrical hook 3/31: Still going back and forth with customer. Met with Cognex yesterday. They felt they could address the concern. Will report back next week. 3/24: Sent clarifying questions around vision system. Waiting to hear back. 3/17: Still trying to define camera system. Mechanical parts on order. 3/9: meeting Friday 3-11 to discuss barcode verse OCR. got grading back on barcodes which graded B-D which was lower than expected. 3/3: Conference call to sort through barcode vs. OCR. 2/24: Conference call this morning trying to sort out vision portion. All mechanical parts are on order. Customer wants more follow up. A couple more parts to get on order. 2/17: Need to determine from customer what they are trying to accomplish. Vision system still not defined. Waiting for response from customer. 2/10: ME sent updated top level to procurement today. 2/3: Kick off to procurement 2/3/2022. Reached out to customer on samples 2/3/2022. 1/27: Still waiting no samples. Mark N visiting them today. Want to add a few people to update meeting. 1/20: No additional updates on samples. In engineering 1/14: Samples requested, no samples received. 1/13: Started in ME. Need to verify if we received samples. Mark will follow up again with customer 1/6:Mark got an email from Kimberly Taylor saying she is elevating samples. Gabe will move to Sherwin after Tru Earth. 12/30: On hold waiting for samples. 12/9: Waiting on samples. Mark has a conference call to them tomorrow. Waiting in queue in ME. 12/2: Received down payment. 2 weeks minimum delay in engineering. 11/18: Looks like down payment may have been approved. 11/11: Waiting for down payment 11/4: Invoiced them yesterday. Waiting for payment. 10/28: Getting close on working through terms and getting signed proposal. 10/21: In T&C limbo. Mike has call with customer today to discuss.:
Work Done:

Representative:
Rep Commission(%):
Tax Exempt(Y/N):
If exempt attach certificate of exemption:
Tax ID:
Custom Brokers Name:
Custom Brokers Phone:
Std Terms (55%,35%,10%):
Non Std Terms:

Section Refreshing.....

* To Refresh Totals - Click Save at Top *

Edit	XID	Part Number	Serial Number	Part Name	Complete	Total Hours	Hours Remaining	Qty	Cost	Price	Discount	Cal Price	On Hand
Edit	54899	4300026		SIKO FEEDER ADJ	Set Complete	1 Standard Production Build	1 hrs	1		$838.00			5
Edit	54900	7005190		STACKLIGHT TL50 GRY M12 CBL	Set Complete	1 Standard Production Build	1 hrs	1		$439.00			17
Edit	54901	4291800		VACUUM CHAMBER 30 MM	Set Complete		0 hrs	1		$978.00			8
Edit	54902	4650160		PRODUCT SUPPORT PNEUMATIC SHAKER	Set Complete	1 Integration and Testing	1 hrs	1		$697.00			4
Edit	54903	8320000		HIGH PERFORMANCE PACKAGE	Set Complete	1 Standard Production Build	1 hrs	1		$2,140.00			0
Edit	54906			VISION SYSTEM WITH HMI	Set Complete		0 hrs	1		$19,630.00
Edit	54907	7034150		I/O BOARD KIT GEN3	Set Complete	2 Standard Production Build	2 hrs	1		$2,242.00			1
Edit	54910	7013200		LOW PROD SENS DIST LO-DO M12M	Set Complete	1 Standard Production Build	1 hrs	1		$608.00			0
Edit	54911	8130490		STATIC BAR W MOUNT HCP 350	Set Complete	1 Standard Production Build	1 hrs	1		$2,997.00			0
Edit	54913	7160000		SENS BGS MLV12 PNP 250MM ADJ	Set Complete	1 Standard Production Build	1 hrs	1		$405.00			0
Edit	54914			SYSTEM DRAWING, FAT, AND INTEGRATION	Set Complete		0 hrs	1		$4,224.00
Edit	54915			REJECT ON ERROR GATE WITH CONTROLS	Set Complete		0 hrs	1		$7,997.00
Edit	54916			LOW PRODUCT DETECT SENSOR ASSEMBLY	Set Complete		0 hrs	1		$398.00
Edit	54917			SYSTEM GUARDING	Set Complete		0 hrs	1		$7,630.00
Edit	54918			E-STOP PB DUAL NC 22MM	Set Complete	0 Electrical Technician	0 hrs	2		$359.00	0.00	$718.00
Edit	57123	9776063		2021207 SHERWIN WILLIAMS	Set Complete	60 Standard Production Build	60 hrs	1		$34,761.00	0.00	$34,761.00	0

+ denotes that software settings are available for this piece of equipment.

Labor Hours
* To Refresh Totals - Click Save at Top *

	Department	Quoted Hours	Est. Hours	Hours Remaining	Billed Hours	xid	Resource(s) Assigned	Assignment	History
Edit	Mechanical Eng.	60	60	-110	170	8851
Edit	Electrical Eng.	60	60	-86	146	8852
Edit	Software Eng.	0	0	0	0	8853
Edit	Integration	73	73	-219.75	292.75	8854
Edit	Machine Shop	0	0	0	0	8855
Edit	Management	0	0	0	0	8856
Edit	Production	43	54	-16.75	70.75	8857	Penny Miller	Sequential	Est Hrs does not include picking or shipping (54 hrs)-MFT\PennyMiller
Edit	EE Technician	12	12	-3.5	15.5	8858

Purchase orders for this Work Order

Edit	XID	Description	PO	Partial	Cost
Edit	5968	ECO FINISHING COMPANY - CLEAR ANODIZE 0.1-0.2/1000"	41240	yes	($25.00)
Edit	6029	ECO FINISHING COMPANY - CLEAR ANODIZE 0.1-0.2/1000"	41601	yes	($20.00)
Edit	6357	AUTOMATION INC - 12MP IRIS GTX SMART CAMERA, 16MM 1.1" LENS, 3.45IM, MIDWEST OPTICS LT RED LENS FILTER, 3M PWR I/O CBL FOR IRIS, 1M VGA/USB CBL FOR IRIS, 300MM LINEAR LIGHT 625NM RED, 5 PIN	43336	yes	($12,686.50)
Edit	6362	AMAZON.COM - MK270 KEYBD & MOUSE	43363		($27.99)
Edit	6414	AMAZON.COM - USB 3, KEYBD & MOUSE	43693	yes	($61.09)
Edit	6413	BEETRONICS, INC. - 22" MONITOR 192-X1080, VGA CABLE 6FT	43694		($584.00)
Edit	6474	AUTOMATION INC - SMARTVISION LIGHT, RED 300MM	44121		($1,516.00)
Edit	6559	AUTOMATION INC - LC 55MM DIA 90MM LONG	44567		($176.58)
Edit	6580	INFINITE ELECTRONICS INTERNATIONAL, INC. - STD SVGA CBL HD15 M/M 10FT	44810		($50.99)


Charge ID:
Charge postfix (3 chars):
Manager:
Cost Center:
Description:
Begin Date:
End Date:
Budget (hours):
	Active R & D


Serial Number:
Quantity:	Price: % Discount:
	Special cost * financial summary does multiply by quantity * (do not use for purchase orders):
	Set to Zero Production Item: Used Equipment: RMA Main Product: Cost credit
Part Number:	Multifeeder Part: Lead Time (days):
Part Name:
Flag Item:
Date Started:	Date Required: Date Shipped:
Build Pulled:	Build Mechanical: Build Electrical:
Overall Status:	Check Out #1: Check Out #2:
Notes:
Don't Start Until:
Returned
	Add/View/Edit Resource Hours


Vendor:
Description:
Purchase Order:
Total Cost:
Partial Cost:	use this if only part of the purchase order was applied to this work order


			*PRODUCT STACK SHELVES ARE NOT INCLUDED WITH BASE-PICK WHAT IS NEEDED*


			**ALL ITEMS BELOW ARE INCLUDED IN COSTING & PRICING PN 9740001**