Could you help me to complete sheet I have missing health insurance and retirement I am sending my work for your view

Negotiation Plan As representatives of the Local H-56 of the International Union of Service Workers, the following are the bargaining subjects included in our negotiation: Length of Contract Wages Health Insurance: 92% of union workers have job-related health coverage versus 68% of non-union workers. Retirement: Union workers are more likely to have guaranteed pensions than non-union employees Vacations and Holidays Maternity leave Work schedules visibility These key points are important to discuss in order to attain a Labor Contract that will benefit both parties involved. Subcommittee Members Labor #2 Date: 9/15/2015 MEMBER CONTACT INFORMATION Bargaining Responsibility Vacations and Holidays, Maternity Leave Wages, Work schedule Health Insurance, Retirement INITIAL OFFERING+ (STARTING POINT) Item Year 1: 4% increase in wages (compounded annually) Wages* Year 2: 4% increase in wages (compounded annually) Year 3: 4% increase in wages (compounded annually) Wage Cost Vacation Cost of Wage Change $144,270.79 $7,708.33 Year 1: $151,979.12 Year 2: $151,979.12 * 4% = $158,058.28 Year 3: $158,058.28 * 4% = $164,380.61 Year 2: $3.75 $10,941.84 (Year 1) $11,723.4 (Year 2) $12,504.96 (Year 3) Year 3: $4.00 Total: $35,170.20 Year 1: $3.50 Health Insurance Cost Proposal Dependent coverage at no cost Retirement Increase to $0.50/hour paid to each employee for the life of the new contract. $19,883.52 (x3 years) 1-3 years of service: 2 weeks of paid vacation $109,147.87 (x3 years) 4 years of service: 3 weeks of paid vacation 5 years + of service: 4 weeks of paid vacation (vacation time capped at 4 weeks) Vacations and Holidays Maternity leave Work schedule Paid holidays: New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day and Christmas Day and two (2) floating holidays of the employee's choosing. Although Holiday Pay will not be considered \"hours worked\" for overtime purposes, employees will be paid time and a half for each holiday. $38,747.36 (Floating holidays x 3 years) We are proposing a paid maternity leave of three (3) months after one year of employment. Before one year of employment but after probationary period the employee will be eligible for an unpaid maternity leave of three (3) months. 40 hours X 4 weeks X 3 months All work schedules shall be posted seven (7) days prior to the first day of schedule to allow ample times for employees to make necessary arrangements. No costs applicable Attach additional sheets as needed with proposed language changes. Proposed Contract Duration: __3__ ESTIMATED ANNUAL COSTS (add or delete years as needed) years Year 1: $330,699.71 Year 2: $337,560.43 Year 3: $344,664.32 TOTAL LIFE OF CONTRACT COST: $ 1,012,924.46 Maximum Settlement Labor #2 Date: 9/15/2015 MAXIMUM SETTLEMENT (THREAT OR WALKAWAY POINT) Item Proposal Cost Wage Cost: $90,169.24 Vacation Cost of Wage Change: $4,817.71 Year 1: 2.5 % increase in wages (compounded annually) Year 1: 94,986.95 Wages Year 2: 2.5 % increase in wages (compounded annually) Year 2: $94,986.95 * 2.5%= $97,361.62 Year 3: 2.5 % increase in wages (compounded annually) Year 3: $97,361.62*2.5%= $99,795.66 Health Insurance Retirement Increase to $0.40/hour paid to each employee for the life of the new contract. $35,170.20 (x 3 years) Vacations We will settle for all employees to be hired at 2 weeks' $14,149.27 vacation minimum. and Holidays Paid holidays: New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day and Christmas Day and one (1) floating holiday of the employee's choosing. Although Holiday Pay will not be Floating holiday: $19,145.65 considered \"hours worked\" for overtime purposes, employees will be paid time and a half for each holiday. Maternity leave Will settle for 6 weeks' paid maternity leave after one year of employment. Work schedule All work schedules shall be posted seven (7) days prior to the first day of schedule to allow ample times for employees to make necessary arrangements. No costs applicable Attach additional sheets as needed with proposed language changes. ESTIMATED ANNUAL COSTS Proposed Contract Duration: 3 years (add or delete years as needed) Year 1: Year 2: Year 3: TOTAL LIFE OF CONTRACT COST: References Budd, J. W. (2015). The Zinnia and Service Workers Local H-56:A Collective Bargaining Simulation. Retrieved from www.thezinnia.com: http://www.thezinnia.com/ The Zinnia and Service Workers Local H-56 Contract Costing Spreadsheet John W. Budd, 2015 Instructions Calculate the cost of various contract proposals by specifying new values for the proposals in the Costs section below. For example, to calculate the cost of a 3% wage increase, change the Wage Change (percent) value from 0 to 3. The assumptions can be changed to analyze how costs differ with varying assumptions. All cells in blue can be changed. Note that wage changes can be estimated in two ways: i) entering values for the percent and/or cents changes in the Costs section (these are across the board changes) or ii) by directly entering new wage rates for each job class in the Wage Schedule section. Directly entering new wage rates deletes the percent/cent wage change formulas. To restore these formulas, re-load the spreadsheet. Note on Minimum Wage Occupations Five job classes are tipped occupations and are therefore paid relative to the minumum wage. This costing spreadsheet assumes that bargaining unit wage increases do not apply to these jobs. To estimate the cost of wage increases for these job classes, either change the value of the minimum wage in the asummptions below this note, or directly change the proposed wage for each desired job class in the Wage Schedule section found further down in the spreadsheet. Assumptions Reference Date: Mandated Benefits Costs (%) Regular Weekly Hours Worked Annual Weeks Worked Average Hours Per Day Annual Overtime Hours State Minimum Wage Employees 0 months after the start of the new contract 14.00 35 per employee, on average (excludes overtime) 52 per employee, including vacation 8 per employee (only used for cost of vacation & holiday replacement) 52 per employee per year, on average across all employees $9.00 (see note above) 167 Costs Proposal Wage Change (percent) Wage Change (cents) Wage Cost Vacation Cost of Wage Change Avg. Hrly. Earnings Amount 4 0 $144,270.79 (does not include vacation replacements) $11,315.46 12.72 Proposal Lump Sum Payment Cost 0 $0.00 New Overtime Premium (%) Cost 150 (existing is 150%) $0.00 Proposal Proposal Additional Benefits Contribution (cents) Cost 0.6 $1,875.74 Proposal Additional Benefits Contribution (percent) Cost 0 $0.00 Proposal Vacation Schedule (below) Cost $100,494.16 Proposal Additional Holidays/Sick Days (days) Cost Total Additional Proposed Costs: 1 $19,373.68 $277,329.83 Wage Schedule Job Class 110 210 310 320 410 420 430 440 510 Job Title Banquet Set-up Door Attendant Bell Captain Bellstand Service Bartender Bartender Bar Assistant Cocktail Waitperson Skilled Cook Existing Wage 13.11 9.00 10.85 9.00 14.65 12.99 11.24 9.00 17.74 Proposed Wage 13.63 9.00 10.85 9.00 15.24 13.51 11.69 9.00 18.45 Note Minimum wage classification Minimum wage + $1.85 Minimum wage classification Minimum wage classification 520 530 540 550 610 620 630 640 710 720 730 740 810 820 830 840 850 Cook Baker Utility Cook Counter Fry Combination Head Pantry Pantry Dishwasher Runner Host/Hostess Cashier Ala Carte Waitperson Busperson Housekeeping Storeroom Clerk Storeroom Helper Linen Room Linen Garmet Repair 17.03 16.94 13.64 13.59 12.94 12.79 12.73 12.48 14.08 12.45 9.00 11.87 13.15 13.00 12.87 12.73 12.93 17.71 17.62 14.19 14.13 13.46 13.30 13.24 12.98 14.64 12.95 9.00 12.34 13.68 13.52 13.38 13.24 13.45 Minimum wage classification Note: Different wage schedules can be costed by directly entering proposed wages in column D, but this deletes the percent/cent wage change formula. To restore these formulas, re-load the spreadsheet. Vacation Schedule Years of Service 0 1 2 5 10 15 20 Vacation Days Current 0 5 10 10 15 15 20 Vacation Days Proposed 0 10 10 20 20 20 20 Seniority Roster Employee YNT IKE QZP WXO ECI RVU UMR OLW PLQ AZQ SXW DCE FVR GBT JMU HKU KLO IPL ADW DGR FHT JLI KHO PIL OUK IYJ UTH YRG JFX SUR OPY TGE UTR UJI ARN STA TEF RWD EQS ZCS XVF CBG VNH BMJ MGD AFD GJT CKL Seniority (Months) 9 17 50 68 54 110 119 169 149 160 55 132 198 110 305 26 61 69 54 111 98 141 227 52 100 158 93 42 67 65 25 91 119 6 101 177 106 53 132 199 258 263 75 110 148 171 220 195 Job Class 110 110 110 110 110 110 110 110 110 110 210 210 210 310 310 320 320 320 320 320 320 320 410 410 420 420 430 430 440 440 440 440 440 440 440 440 510 510 510 510 510 510 520 520 520 520 520 530 Proposed Wages New Seniority (Years) ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### KDU ELV UYS ZHG DGT TWR IFY LAY GIE BKD PFR XUG JWG MSF TEM EUT KTS MTY CBT ETG GRJ ERH KTU SMT IDT MTD RIB JRD TFJ FRL MCA WYM IZH XUR LDF MEA GUK BRK SCJ JRX MDF JXV LSO ORI EUC PIE HGA WOA AOU HOW TWY OHW TAD GYT WIT HEY DUM ERN CTR NPV PVW MOY OBN NBE 0PE FEP BAR EUV JIY SRU UWH LUE SOU PUI SGR PEU DOE JHL GLK EKV EUI MUY GHK LHF GUO LHD SHT SKG KDJ SRH LGI YUF RTU WCT TOI DES 236 349 69 71 93 88 80 128 62 25 55 65 33 85 78 115 100 132 149 68 65 74 101 13 26 4 67 56 65 38 5 45 76 132 198 310 70 109 307 14 13 27 66 53 93 25 89 30 78 48 79 80 34 29 98 112 49 138 169 11 268 328 25 38 9 20 35 5 45 4 54 25 18 72 98 13 15 19 17 33 47 59 59 51 74 87 78 90 64 119 52 62 114 131 149 173 530 530 540 540 540 540 540 540 550 550 550 550 550 550 550 550 610 610 610 620 620 620 620 630 630 630 630 630 630 640 640 640 640 710 710 710 720 720 720 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 730 740 740 740 740 740 740 740 740 740 740 740 740 740 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 810 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### BAN PRI CIL ALE EIY COM PAH TRU KRE SUB JSR JSE KSI ODT LFH GYU TYS SMR MSI XYR SOR LKG SUT 58 61 218 221 191 58 200 285 339 316 250 100 138 62 75 88 57 87 53 118 99 74 96 810 810 810 810 810 810 810 810 810 810 810 820 820 830 830 830 840 840 840 840 840 850 850 ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###