Given Formula and Data

Can You Give me a calculation

You are required to complete the PCB assembly worksheet in Table below. Show all the calculations. Find the total cost of completing the assembly. Given: Operator rate, Wa=0.6cents/s Batch size, Bs=1000 No. of setups, Nset=10 No. of boards/panel=1 Total Description Name of part, sub- assembly operation or soldered component No. of pins or leads N1 No. of parts, ops, comps Rp 1 Total manual op. time (sec) Ta op. cost (cents) Ca Place in fixture Circuit board (size>15mm) (Thickness15mm) (thickness>2mm) Screw (sizes 15mm) (thickness>2mm) Washer (size 80 leads 10.0 i basic Posts, DIP/DIP Itine 6.0 sockets, pin-grid i insert arrays or odd-form component i additional components i tine per 0.5 lead or posti -------- SMDS add and solder using i special fixture or tool i 10.0 Other Manual Operations Part Operation iTime(s) Sleeve cut one sleeve and add to a lead i 15.0 Jumper wire cut, strip and tin ends, i (ECO) i insert and solder 60.0 Heat sink i add to transistor 25.0 | Lead or post hand-solder one lead or post 6.01 -1 -------- SOODS -DODO -------- PCB Assembly Database - Automatic Operations Insertion Costs per Component (cents) ---- Component Type Auto, cai i Robot, cri Axial (VCD) 1.2 5.0 Radial 1.2. 5.0 0.8 5.0 SIP/SIP socket | DIP/DIP socket / 0.8 5.0 1.0 5.0 Connector ------ i Small SMD (2 connections) 0.2 5.0 Large SMD (>2 connections) 1.0 5.0 * Note: includes cost of sequencing Manual: Cop = to Wa + RoCrwM, cents Auto insertion machine: Cap Cop = R, (Cai + en + Crow Ap ) + Net ) Cas Bs cents BS Robot insertion machine: Cop = Ry(Cri tentang Grow Rp) + Nser 2 + Ry = Cre BS Crs BS cents Where Ar = average number of faults requiring rework for each autoinsertion (0.002) Bs = total batch size Ca = cost of insertion (obtained from database) Cap = programming cost per component for autoinsertion machine (150 cents) Cas = setup cost per component type for autoinsertion machine (150 cents) Ce = cost of replacement component when rework is needed Cri = cost of robot insertion (obtained from database) Crp = programming cost per component for robot system (150 cents) Crs = setup cost per component type for robot system (150 cents) Cow = TN, W, + Ce and is the average rework cost per faulty component (cents) Me = average number of faults requiring rework for each manual insertion (0.005) N1 = number of leads or posts on one component Nget = estimated number of setups per batch R = average number of faults requiring rework for each robot insertion (0.002) Rp = number of components to = total time for all manual operations (calculated from database figures) T: = average estimated time to rework one component fault per lead or post (30s) Wa = rate for manual operations, cents/s You are required to complete the PCB assembly worksheet in Table below. Show all the calculations. Find the total cost of completing the assembly. Given: Operator rate, Wa=0.6cents/s Batch size, Bs=1000 No. of setups, Nset=10 No. of boards/panel=1 Total Description Name of part, sub- assembly operation or soldered component No. of pins or leads N1 No. of parts, ops, comps Rp 1 Total manual op. time (sec) Ta op. cost (cents) Ca Place in fixture Circuit board (size>15mm) (Thickness15mm) (thickness>2mm) Screw (sizes 15mm) (thickness>2mm) Washer (size 80 leads 10.0 i basic Posts, DIP/DIP Itine 6.0 sockets, pin-grid i insert arrays or odd-form component i additional components i tine per 0.5 lead or posti -------- SMDS add and solder using i special fixture or tool i 10.0 Other Manual Operations Part Operation iTime(s) Sleeve cut one sleeve and add to a lead i 15.0 Jumper wire cut, strip and tin ends, i (ECO) i insert and solder 60.0 Heat sink i add to transistor 25.0 | Lead or post hand-solder one lead or post 6.01 -1 -------- SOODS -DODO -------- PCB Assembly Database - Automatic Operations Insertion Costs per Component (cents) ---- Component Type Auto, cai i Robot, cri Axial (VCD) 1.2 5.0 Radial 1.2. 5.0 0.8 5.0 SIP/SIP socket | DIP/DIP socket / 0.8 5.0 1.0 5.0 Connector ------ i Small SMD (2 connections) 0.2 5.0 Large SMD (>2 connections) 1.0 5.0 * Note: includes cost of sequencing Manual: Cop = to Wa + RoCrwM, cents Auto insertion machine: Cap Cop = R, (Cai + en + Crow Ap ) + Net ) Cas Bs cents BS Robot insertion machine: Cop = Ry(Cri tentang Grow Rp) + Nser 2 + Ry = Cre BS Crs BS cents Where Ar = average number of faults requiring rework for each autoinsertion (0.002) Bs = total batch size Ca = cost of insertion (obtained from database) Cap = programming cost per component for autoinsertion machine (150 cents) Cas = setup cost per component type for autoinsertion machine (150 cents) Ce = cost of replacement component when rework is needed Cri = cost of robot insertion (obtained from database) Crp = programming cost per component for robot system (150 cents) Crs = setup cost per component type for robot system (150 cents) Cow = TN, W, + Ce and is the average rework cost per faulty component (cents) Me = average number of faults requiring rework for each manual insertion (0.005) N1 = number of leads or posts on one component Nget = estimated number of setups per batch R = average number of faults requiring rework for each robot insertion (0.002) Rp = number of components to = total time for all manual operations (calculated from database figures) T: = average estimated time to rework one component fault per lead or post (30s) Wa = rate for manual operations, cents/s