The Charlotte Roadway Shop was approved Capital funding to build a new concept machine in the listed project years. Please review the attached data and present your findings addressing the cost per machine and how you, the Shop Supervisor of Cost & Quality would develop the strategy for the teams to identify inefficiencies and make recommendations to improve the quality of work and productivity of resources to continue producing the machines internally versus purchasing provided the most recent purchase price remains the same but overall materials to produce internally are expected to increase by 6%. The threshold for purchasing is 65%. Year Purchase Price Budget $2,860,000 Project '18 $475K ea. Status I Complete Complete Complete (5) Project '20 $2,970,000 $515K ea. Project '21 $2,640,000 $525K ea. For this exercise, distribute percentage of Wage Additives evenly on completed machines. *Additives are overhead charges added to Capital project wages and materials. **All Wages & Overtime Additives - 69% QTY to Complete 11 9 8 TUON 1 5 Period 1 1 31 91 10 11 1 12 1 13 1 14 1 15 1 16 1 17/1 18 1 19 1 201 21 1 22 1 8 Fiscal YeaPosting Date Document Date Document Object 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 PASA fx Fiscal Year SHEET 1 1/23/2018 1/23/2018 1/23/2018 1/24/2018 1/24/2018 1/24/2018 1/25/2018 1/25/2018 1/25/2018 1/29/2018 1/29/2018 1/29/2018 1/30/2018 1/30/2018 1/30/2018 1/31/2018 1/31/2018 1/31/2016 1/31/2018 1/31/2018 1/31/2018 type 1/23/2018 ZO 1/23/2018 ZQ 1/23/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/25/2018 ZQ 1/25/2018 20 1/25/2018 ZQ 1/29/2018 ZO 1/29/2018 20 1/29/2018 ZQ 1/30/2018 20 1/30/2018 20 1/30/2018 20 1/31/2018 20 1/31/2018 20 1/31/2018 ZQ 2/2/2018 20 2/2/2018 20 2/2/2018 20 Number Styles Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft ARRITAK Cells ValiCOArea Crcy CO area currency 1.176.73 USD 93.40 USD 143.19 USD 53.76 USD 677.17 USD 82.47 USD 54.81 USD 4.35 USD 6.67 USD 0.25 USD 0.03 USD 0.02 USD 32.74 USD 2.60 USD 3.98 USD 24.92 USD 1.98 USD 3.03 USD 37.04 USD 4.98 USD 169.56 USD 31 31 41 5 1 26 1 27 1 Period Fiscal Yea Posting Date Document Date Document Object tvoe 2/2/2018 ZQ 1/2/2019 WE 1/2/2019 20 1/2/2019 ZQ 1/2/2019 20 1/2/2019 ZQ 1/2/2019 ZQ 1/2/2019 ZQ 1/3/2019 ZQ 1/3/2019 20 1/3/2019 ZQ 1/9/2019 WA 1/14/2019 ZO 1/14/2019 ZQ 1/14/2019 ZQ 1/16/2019 20 1/17/2019 20 1/17/2019 20 1/17/2019 20 1/24/2019 ZQ 1/24/2019 ZQ 28 29 30 31 1 32 1 33 1 34 1 35 1 36 1 37 1 38 1 39 1 40 1 41 1 42 1 43 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 X 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 SHEET 1 fx Fiscal Year 1/31/2018 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/3/2019 1/3/2019 1/3/2019 1/9/2019 1/14/2019 1/14/2019 1/14/2019 1/16/2019 1/17/2019 1/17/2019 1/17/2019 1/24/2019 1/24/2019 G H Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Wages Shopcraft PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mater PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate Val/COArea Crcy CO area currency 0.70 USD 26,803.00 USD 506.58 USD 61.65 USD 40.20 USD 2.34 USD 29.53 USD 3.59 USD 123.76 USD 9.82 USD 15.06 USD -29,547.00 USD -1.78 USD -65.23 USD -3.86 USD 1.61 USD 53.01 USD 3,15 USD 2.48 USD 325.05 USD 15.19 USD