NZCBAT403 Financial and Data Management-Quality Control Management
Answer the following questions based on the data in your spreadsheet. Record your answers on a new sheet called Data Analysis.
1. How many staff started with the company in 1998?
2. Of the staff from 1998, how many were in the IT department?
3. How many staff are in the IT department today?
4. Which Division has the largest number of IT staff today?
5. Who is the lowest paid staff member?
6. Who is the highest paid staff member?
1. How many staff started with the company in 1998?
2. Of the staff from 1998, how many were in the IT department?
3. How many staff are in the IT department today?
4. Which Division has the largest number of IT staff today?
5. Who is the lowest paid staff member?
6. Who is the highest paid staff member?
Answer:
| Employee | Division | Department | Status | Start Date | Salary | New Salary | % of tax |
| Alexander, Charles | West | Manufacturing Admin | Contract | 27-Aug-00 | $74,500.00 | $76,288.00 | 12% |
| Allen, Thomas | Main | Manufacturing | Full Time | 31-Mar-06 | $79,730.00 | $81,643.52 | 12% |
| Allen, Thomas | Watson | Quality Control | Part Time | 20-Aug-10 | $38,105.00 | $39,019.52 | 7% |
| Alvarado, Sonia | Main | IT | Part Time | 21-Sep-11 | $35,045.00 | $35,886.08 | 7% |
| Alvarado, Sonia | Main | Quality Assurance | Full Time | 18-Oct-10 | $63,030.00 | $64,542.72 | 10% |
| Anthony, Robert | Watson | IT | Part Time | 3-Aug-10 | $16,925.00 | $17,331.20 | 5% |
| Anthony, Robert | Watson | Quality Assurance | Hourly | 1-Dec-07 | $23,692.00 | $24,260.61 | 5% |
| Atkins, Kevin | North | Manufacturing | Hourly | 6-Jul-08 | $8,904.00 | $9,117.70 | 5% |
| Atkins, Kevin | Watson | Quality Control | Hourly | 25-Oct-99 | $32,536.00 | $33,316.86 | 6% |
| Ayers, Douglas | Main | Manufacturing | Contract | 11-Oct-10 | $52,940.00 | $54,210.56 | 8% |
| Ayers, Douglas | North | Training | Full Time | 10-Apr-09 | $75,150.00 | $76,953.60 | 12% |
| Ballard, Martin | South | IT | Full Time | 3-Jan-07 | $87,030.00 | $89,118.72 | 13% |
| Ballard, Martin | North | Quality Assurance | Contract | 17-Mar-06 | $85,930.00 | $87,992.32 | 13% |
| Banks, Ryan | Main | IT | Hourly | 31-Mar-03 | $21,648.00 | $22,167.55 | 5% |
| Banks, Ryan | South | Quality Assurance | Part Time | 13-Jul-03 | $48,740.00 | $49,909.76 | 8% |
| Barber, Robbie | North | Manufacturing | Full Time | 21-Jun-99 | $37,760.00 | $38,666.24 | 7% |
| Barber, Robbie | West | Quality Control | Full Time | 26-Dec-04 | $81,340.00 | $83,292.16 | 12% |
| Barnett, Brenda | North | Human Resources | Full Time | 23-Aug-08 | $47,350.00 | $48,486.40 | 8% |
| Barnett, Brenda | North | Quality Assurance | Contract | 15-Nov-99 | $54,840.00 | $56,156.16 | 10% |
| Barr, Jennifer | North | Marketing | Full Time | 17-Nov-08 | $49,770.00 | $50,964.48 | 8% |
| Barron, Michael | West | Manufacturing | Full Time | 26-Jul-08 | $34,480.00 | $35,307.52 | 7% |
| Barron, Michael | North | Sales | Contract | 1-Jul-03 | $78,100.00 | $79,974.40 | 12% |
| Bates, Verna | North | Manufacturing | Full Time | 26-Jun-01 | $66,010.00 | $67,594.24 | 11% |
| Bates, Verna | North | Quality Control | Full Time | 20-Jul-07 | $24,980.00 | $25,579.52 | 6% |
| Bauer, Chris | West | IT | Part Time | 2-Aug-02 | $33,810.00 | $34,621.44 | 6% |
| Bauer, Chris | South | Quality Assurance | Full Time | 21-Jun-03 | $29,210.00 | $29,911.04 | 6% |
| Baxter, Teresa | Taft | Manufacturing | Part Time | 12-Jan-98 | $48,835.00 | $50,007.04 | 8% |
| Baxter, Teresa | North | Quality Control | Full Time | 18-Aug-98 | $64,470.00 | $66,017.28 | 11% |
| Beck, Craig | North | Environmental Compliance | Full Time | 19-Apr-12 | $46,220.00 | $47,329.28 | 8% |
| Beck, Craig | Main | Marketing | Part Time | 22-Mar-11 | $13,090.00 | $13,404.16 | 5% |
| Bell, David | South | Manufacturing | Contract | 23-Oct-07 | $35,460.00 | $36,311.04 | 7% |
| Bell, David | Main | Research Center | Contract | 25-Jun-11 | $66,132.00 | $67,719.17 | 11% |
| Bennett, Chris | Taft | IT | Full Time | 11-Jul-10 | $66,840.00 | $68,444.16 | 11% |
| Bennett, Chris | Main | Quality Assurance | Full Time | 12-Nov-07 | $48,490.00 | $49,653.76 | 8% |
| Benson, Troy | Watson | Manufacturing | Contract | 22-Oct-10 | $28,260.00 | $28,938.24 | 6% |
| Benson, Troy | Main | Training | Part Time | 24-Aug-11 | $30,445.00 | $31,175.68 | 6% |
| Berry, Jacklyn | Taft | Manufacturing | Contract | 3-Mar-07 | $64,430.00 | $65,976.32 | 11% |
| Berry, Jacklyn | North | Quality Control | Contract | 14-Sep-11 | $62,480.00 | $63,979.52 | 10% |
| Best, Lara | Main | IT | Full Time | 28-Aug-04 | $86,200.00 | $88,268.80 | 13% |
| Best, Lara | West | Quality Assurance | Full Time | 7-Sep-04 | $31,910.00 | $32,675.84 | 6% |
| Blackburn, Kathryn | West | Manufacturing | Contract | 31-Mar-08 | $62,780.00 | $64,286.72 | 10% |
| Blackburn, Kathryn | Main | Sales | Hourly | 16-Oct-08 | $21,668.00 | $22,188.03 | 5% |
| Blair, Sperry | West | Environmental Compliance | Full Time | 20-Oct-09 | $51,180.00 | $52,408.32 | 8% |
| Blair, Sperry | Taft | Marketing | Full Time | 5-Aug-10 | $57,560.00 | $58,941.44 | 10% |
| Bond, John | North | Environmental Compliance | Part Time | 1-Dec-07 | $46,095.00 | $47,201.28 | 8% |
| Bond, John | West | Marketing | Full Time | 8-Jul-10 | $48,800.00 | $49,971.20 | 8% |
| Boone, Eric | Taft | Major Mfg Projects | Contract | 26-Mar-10 | $71,190.00 | $72,898.56 | 11% |
| Boone, Eric | Watson | Quality Assurance | Part Time | 13-Oct-12 | $25,885.00 | $26,506.24 | 6% |
| Boyd, Debra | North | Manufacturing | Part Time | 19-Mar-00 | $46,710.00 | $47,831.04 | 8% |
| Boyd, Debra | Main | Quality Control | Part Time | 14-Mar-07 | $27,710.00 | $28,375.04 | 6% |
| Boyer, John | West | Manufacturing | Full Time | 22-Mar-06 | $73,144.00 | $74,899.46 | 11% |
| Boyer, John | South | Quality Control | Contract | 3-Aug-10 | $41,770.00 | $42,772.48 | 7% |
| Bradford, Raymond | North | Manufacturing | Contract | 26-Jun-98 | $71,710.00 | $73,431.04 | 11% |
| Bradford, Raymond | Taft | Quality Control | Part Time | 24-Jul-99 | $19,825.00 | $20,300.80 | 5% |
| Bradley, David | Main | Manufacturing | Full Time | 5-Sep-08 | $69,320.00 | $70,983.68 | 11% |
| Bradley, David | Watson | Sales | Hourly | 25-Jul-03 | $11,044.00 | $11,309.06 | 5% |
| Brady, Traci | Main | Manufacturing | Full Time | 1-Apr-11 | $47,440.00 | $48,578.56 | 8% |
| Brady, Traci | South | Training | Hourly | 1-Sep-16 | $29,070.00 | $29,767.68 | 6% |
| Bridges, Jeff | West | Manufacturing | Full Time | 4-Feb-11 | $43,820.00 | $44,871.68 | 7% |
| Bridges, Jeff | East | Training | Part Time | 26-Feb-16 | $15,240.00 | $15,605.76 | 5% |
| Briggs, Bryan | Main | Facilities/Engineering | Contract | 22-Feb-08 | $85,480.00 | $87,531.52 | 13% |
| Briggs, Bryan | Taft | Product Development | Full Time | 13-Jul-08 | $71,010.00 | $72,714.24 | 11% |
| Brock, Ensley | Taft | Manufacturing | Full Time | 3-Sep-10 | $39,520.00 | $40,468.48 | 7% |
| Brock, Ensley | West | Training | Part Time | 14-May-06 | $11,025.00 | $11,289.60 | 5% |
| Brooks, Richard | West | Marketing | Part Time | 16-Jan-07 | $47,705.00 | $48,849.92 | 8% |
| Browning, Kathleen | South | Manufacturing | Contract | 27-Jun-00 | $57,760.00 | $59,146.24 | 10% |
| Browning, Kathleen | North | Quality Control | Contract | 6-Jun-07 | $75,550.00 | $77,363.20 | 12% |
| Bryant, Douglas | North | Marketing | Full Time | 30-Oct-99 | $44,220.00 | $45,281.28 | 8% |
| Bullock, Greg | North | Facilities/Engineering | Hourly | 17-Jan-12 | $14,568.00 | $14,917.63 | 5% |
| Bullock, Greg | Main | Professional Training Group | Full Time | 21-Jul-11 | $69,400.00 | $71,065.60 | 11% |
| Burgess, Cherie | North | Manufacturing | Full Time | 17-May-08 | $89,740.00 | $91,893.76 | 13% |
| Burgess, Cherie | South | Quality Control | Full Time | 24-Mar-99 | $77,680.00 | $79,544.32 | 12% |
| Burns, Fiona | Main | Manufacturing | Hourly | 31-Jan-11 | $28,424.00 | $29,106.18 | 6% |
| Burns, Fiona | Main | Training | Full Time | 4-Jun-14 | $49,350.00 | $50,534.40 | 8% |
| Bush, Rena | South | Marketing | Contract | 5-Sep-07 | $81,930.00 | $83,896.32 | 12% |
| Butler, Roy | Taft | Manufacturing | Full Time | 7-Feb-99 | $81,400.00 | $83,353.60 | 12% |
| Butler, Roy | Main | Quality Control | Contract | 27-Jul-01 | $28,270.00 | $28,948.48 | 6% |
| Caldwell, Pete | Main | Marketing | Full Time | 23-Oct-99 | $43,460.00 | $44,503.04 | 7% |
| Callahan, Marilyn | South | Manufacturing | Full Time | 9-Apr-07 | $23,330.00 | $23,889.92 | 5% |
| Callahan, Marilyn | North | Quality Control | Full Time | 18-Mar-12 | $46,550.00 | $47,667.20 | 8% |
| Camacho, Stephanie | Watson | Manufacturing | Contract | 3-Dec-08 | $80,690.00 | $82,626.56 | 12% |
| Camacho, Stephanie | South | Sales | Part Time | 26-Mar-10 | $49,405.00 | $50,590.72 | 8% |
| Campbell, Michael | West | Marketing | Full Time | 16-May-00 | $52,490.00 | $53,749.76 | 8% |
| Campos, Richard | Main | Major Mfg Projects | Hourly | 25-Dec-99 | $61,860.00 | $63,344.64 | 10% |
| Campos, Richard | Taft | Quality Assurance | Full Time | 4-Aug-11 | $67,920.00 | $69,550.08 | 11% |
| Carr, Susan | South | Manufacturing Admin | Full Time | 16-Aug-12 | $39,160.00 | $40,099.84 | 7% |
| Carrillo, Robert | North | Manufacturing | Contract | 27-Feb-04 | $57,410.00 | $58,787.84 | 10% |
| Carrillo, Robert | West | Quality Control | Hourly | 21-Oct-08 | $37,344.00 | $38,240.26 | 7% |
| Carroll, Lesa | West | Environmental Compliance | Full Time | 3-Apr-17 | $56,440.00 | $57,794.56 | 10% |
| Carroll, Lesa | West | Marketing | Full Time | 8-Apr-12 | $37,020.00 | $37,908.48 | 7% |
| Carson, Anthony | West | Manufacturing | Full Time | 23-Nov-08 | $22,660.00 | $23,203.84 | 5% |
| Carson, Anthony | Taft | Quality Control | Full Time | 28-Apr-01 | $78,710.00 | $80,599.04 | 12% |
| Castro, Christopher | Main | Manufacturing | Full Time | 28-Jan-12 | $52,940.00 | $54,210.56 | 8% |
| Castro, Christopher | Watson | Training | Full Time | 18-Dec-16 | $37,670.00 | $38,574.08 | 7% |
| Chambers, Richard | Main | Manufacturing | Contract | 16-Jul-98 | $68,260.00 | $69,898.24 | 11% |
| Chambers, Richard | North | Quality Control | Part Time | 29-Oct-99 | $26,185.00 | $26,813.44 | 6% |
| Chandler, Diane | Main | IT | Hourly | 18-Jun-99 | $39,764.00 | $40,718.34 | 7% |
| Chandler, Diane | Taft | Quality Assurance | Contract | 10-Jul-01 | $46,780.00 | $47,902.72 | 8% |
| Chang, Gabriel | Main | Environmental Compliance | Part Time | 5-Dec-09 | $28,680.00 | $29,368.32 | 6% |
| Chang, Gabriel | Main | Marketing | Full Time | 26-Sep-10 | $33,970.00 | $34,785.28 | 6% |
| Chavez, Thomas | Main | Marketing | Full Time | 3-Mar-08 | $82,110.00 | $84,080.64 | 12% |
| Clay, William | Watson | Manufacturing | Contract | 18-Jul-03 | $75,420.00 | $77,230.08 | 12% |
Buy NZCBAT403 Financial and Data Management-Quality Control Management Answers Online
Talk to our expert to get the help with NZCBAT403 Financial and Data Management-Quality Control Management Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
Get Online Support for NZCBAT403 Financial and Data Management-Quality Control Management Assignment Help Online
Resources
- 24 x 7 Availability.
- Trained and Certified Experts.
- Deadline Guaranteed.
- Plagiarism Free.
- Privacy Guaranteed.
- Free download.
- Online help for all project.
- Homework Help Services
Resources
- 24 x 7 Availability.
- Trained and Certified Experts.
- Deadline Guaranteed.
- Plagiarism Free.
- Privacy Guaranteed.
- Free download.
- Online help for all project.
- Homework Help Services
