Need help filling in these answers. GLO-BUS 2020 Edition.

AC CAMERA WORKFORCE COMPENSATION UAV DRONE WORKFORCE COMPENSATION Compensation Decisions Company Ind. Avg. (Year 6) (last year) Base Wage (per PAT member) +1% - change $20,604 $20,400 Assembly Quality Incentive $ 2.50 per unit 1,875 1,800 Attendance Bonus $ 900 per worker 900 800 Fringe Benefit Package $ 2000 per worker 2,000 2,000 Total Compensation ($ per worker per year) $25,379 $25,000 Best Practices / Productivity Improvement Training (S/PAT) $ 2000- Projected PAT Productivity (AC Camera units per PAT per year) 3,215 AC CAMERA ASSEMBLY FACILITY Company Ind. Avg. Compensation Decisions (Year 6) (last year) Base Wage (per PAT member) +1% change $20,604 $20,400 Assembly Quality Incentive $ 4.80 - per unit 1,800 1,800 Attendance Bonus $ 800 - per worker 800 800 Fringe Benefit Package $ 2000 - per worker 2,000 2,000 Total Compensation (Sper worker per year) $25,204 $25,000 Best Practices / Productivity Improvement Training (S/PAT) $( 2000 - Projected PAT Productivity (UAV Drone units per PAT per year) 1,555 UAV DRONE ASSEMBLY FACILITY Workstation Spaces Installed Workstations At the End of Year 5 At the End of Year 5 100 worksins Expansion (new spaces) 0- $400k ea Installed for Y6 0 $325k ea Available for Year 6 Available for Year 6 100 workstns Additional Workstations Needed to Avoid Overtime Assembly 11 Assembly Capability (000s of units) 156.0 wlo OT 187.0 at maximum OT Projected Drone Demand (000s of units) 172.7 Expected UAV Unit Shortfall (unsatisfied demand) 0.0 (000s of units) 300 spaces 110 spaces 300 spaces 110 spaces Workstation Spaces Installed Workstations At the End of Year 5 At the End of Year 5 280 worksins Expansion (new spaces) 0 - $400k ea Installed for Y6 0 $125k ea Available for Year 6 Available for Year 6 280 worksins Additional Workstations Needed to Avoid Overtime Assembly 32 Assembly Capability (000s of units) 900.0 wlo OT 1,080.0 at maximum OT Projected Camera Demand (000s of units) 1,002.7 Expected ACC Unit Shortfall (unsatisfied demand) 0.0 (000s of units) Units (000s) Unit Assembly and Labor Costs ACC Assembly Regular-Time Overtime Training Total Labor Costs $000s $/unit 28,574 31.75 4,206 40.95 560 0.56 33,340 33.25 900.0 102.7 Units (000s) 156.0 16.7 Unit Assembly and Labor Costs UAV Assembly Regular-Time Overtime Training Total Labor Costs $000s $/unit 7,512 48.15 1,037 62.10 202 1.17 8,751 50.67 1,002.7 172.7 Robotics Upgrade for All ACC Workstations No Upgrade (to reduce the number of persons per PAT from 4 to 3) $000s Cost Impact of Depreciation (5% of $0k capital cost of upgrade) 0 Upgrade Labor (total savings in wages and incentive pay) 0 (5000s) Maintenance (additional cost of $9.0k per workstation) 0 Interest (if financed 25% with a 10-Year Loan 0 Net Annual Cost Impact of Robotics Upgrade 0 Robotics Upgrade for All UAV Workstations Initiate Upgrade (to reduce the number of persons per PAT from 4 to 3) $000s Cost Impact of Depreciation (5% of $15,000k capital cost of upgrade) +750 Upgrade Labor (total savings in wages and incentive pay) -2,364 (5000s) Maintenance (additional cost of $9.0k per workstation) +900 Interest (if financed 50% with a 10-Year Loan ) +488 Net Annual Cost Impact of Robotics Upgrade -226 Capital Expenditures New Facility Robotics Total New Capital Expenditures Facility Robotics Total PI ar Projected Y6 Performance Investor Scoring Measures Year 6 Expect. Earnings Per Share $1.57 $1.25 Return On Equity 24.1% 17.5% Credit Rating B+ B+ Image Rating 77 70 Change Other Measures Year 6 from Y5 Net Revenues (5000) 414,405 +24.0% Net Profit (9000) 31,354 +109.0 Ending Cash ($000s) 11,233 +6,233 AC CAMERA WORKFORCE COMPENSATION UAV DRONE WORKFORCE COMPENSATION Compensation Decisions Company Ind. Avg. (Year 6) (last year) Base Wage (per PAT member) +1% - change $20,604 $20,400 Assembly Quality Incentive $ 2.50 per unit 1,875 1,800 Attendance Bonus $ 900 per worker 900 800 Fringe Benefit Package $ 2000 per worker 2,000 2,000 Total Compensation ($ per worker per year) $25,379 $25,000 Best Practices / Productivity Improvement Training (S/PAT) $ 2000- Projected PAT Productivity (AC Camera units per PAT per year) 3,215 AC CAMERA ASSEMBLY FACILITY Company Ind. Avg. Compensation Decisions (Year 6) (last year) Base Wage (per PAT member) +1% change $20,604 $20,400 Assembly Quality Incentive $ 4.80 - per unit 1,800 1,800 Attendance Bonus $ 800 - per worker 800 800 Fringe Benefit Package $ 2000 - per worker 2,000 2,000 Total Compensation (Sper worker per year) $25,204 $25,000 Best Practices / Productivity Improvement Training (S/PAT) $( 2000 - Projected PAT Productivity (UAV Drone units per PAT per year) 1,555 UAV DRONE ASSEMBLY FACILITY Workstation Spaces Installed Workstations At the End of Year 5 At the End of Year 5 100 worksins Expansion (new spaces) 0- $400k ea Installed for Y6 0 $325k ea Available for Year 6 Available for Year 6 100 workstns Additional Workstations Needed to Avoid Overtime Assembly 11 Assembly Capability (000s of units) 156.0 wlo OT 187.0 at maximum OT Projected Drone Demand (000s of units) 172.7 Expected UAV Unit Shortfall (unsatisfied demand) 0.0 (000s of units) 300 spaces 110 spaces 300 spaces 110 spaces Workstation Spaces Installed Workstations At the End of Year 5 At the End of Year 5 280 worksins Expansion (new spaces) 0 - $400k ea Installed for Y6 0 $125k ea Available for Year 6 Available for Year 6 280 worksins Additional Workstations Needed to Avoid Overtime Assembly 32 Assembly Capability (000s of units) 900.0 wlo OT 1,080.0 at maximum OT Projected Camera Demand (000s of units) 1,002.7 Expected ACC Unit Shortfall (unsatisfied demand) 0.0 (000s of units) Units (000s) Unit Assembly and Labor Costs ACC Assembly Regular-Time Overtime Training Total Labor Costs $000s $/unit 28,574 31.75 4,206 40.95 560 0.56 33,340 33.25 900.0 102.7 Units (000s) 156.0 16.7 Unit Assembly and Labor Costs UAV Assembly Regular-Time Overtime Training Total Labor Costs $000s $/unit 7,512 48.15 1,037 62.10 202 1.17 8,751 50.67 1,002.7 172.7 Robotics Upgrade for All ACC Workstations No Upgrade (to reduce the number of persons per PAT from 4 to 3) $000s Cost Impact of Depreciation (5% of $0k capital cost of upgrade) 0 Upgrade Labor (total savings in wages and incentive pay) 0 (5000s) Maintenance (additional cost of $9.0k per workstation) 0 Interest (if financed 25% with a 10-Year Loan 0 Net Annual Cost Impact of Robotics Upgrade 0 Robotics Upgrade for All UAV Workstations Initiate Upgrade (to reduce the number of persons per PAT from 4 to 3) $000s Cost Impact of Depreciation (5% of $15,000k capital cost of upgrade) +750 Upgrade Labor (total savings in wages and incentive pay) -2,364 (5000s) Maintenance (additional cost of $9.0k per workstation) +900 Interest (if financed 50% with a 10-Year Loan ) +488 Net Annual Cost Impact of Robotics Upgrade -226 Capital Expenditures New Facility Robotics Total New Capital Expenditures Facility Robotics Total PI ar Projected Y6 Performance Investor Scoring Measures Year 6 Expect. Earnings Per Share $1.57 $1.25 Return On Equity 24.1% 17.5% Credit Rating B+ B+ Image Rating 77 70 Change Other Measures Year 6 from Y5 Net Revenues (5000) 414,405 +24.0% Net Profit (9000) 31,354 +109.0 Ending Cash ($000s) 11,233 +6,233