Salary Lab: How To Write A Time Card Professionally

Salary Labin This Lab You Are Going To Write A Time Card Processor Pro

In this lab, you are required to develop a time card processor program that reads data from a file called salary.txt. The file will contain multiple departments, each starting with a department name that includes the word “Department.” Following the department name, a list of employees will be provided, with their respective hours and pay grades. The file concludes with the line “EOF.”

The data for each employee includes their name, a set of hours, and their pay grade (F1, F2, F3, F4). The number of hours recorded depends on the pay grade; for example, F1 and F2 employees will have five hours values, F3 employees will have sales amount and commission percentage, and F4 employees will have seven hours values associated with on-call work. The pay calculations differ by pay grade:

• F1: Total hours multiplied by $10.25
• F2: (Total hours – 35) * $18.95 + $400
• F3: Total sales amount * commission rate; assume 30 hours if commission ≤10%, 40 hours if >10%
• F4: Sum of first 5 hours $22.55 + remaining hours $48.75

The program output should include, for each department, the department name, the total salary paid to all employees, total hours worked, and total number of employees. Additionally, for each department, it should provide breakdowns per employee category (F1, F2, F3, F4), including total salary and total hours.

Sample output structure:

Department of Bees
Total Salary: $XXXX.XX
Total Hours: XXX
Total Employees: XX
F1: Total Salary: $XXXX.XX, Total Hours: XXX
F2: Total Salary: $XXXX.XX, Total Hours: XXX
F3: Total Salary: $XXXX.XX, Total Hours: XXX
F4: Total Salary: $XXXX.XX, Total Hours: XXX
Department of Sales
Total Salary: $XXXX.XX
Total Hours: XXX
Total Employees: XX
F1: Total Salary: $XXXX.XX, Total Hours: XXX
F2: Total Salary: $XXXX.XX, Total Hours: XXX
F3: Total Salary: $XXXX.XX, Total Hours: XXX
F4: Total Salary: $XXXX.XX, Total Hours: XXX

Before implementation, plan your approach by considering what actions are needed—reading from the file, parsing data, performing calculations, and outputting results. Decide whether you will modularize your code with functions for reading data, processing each employee, calculating salaries, and generating reports. Think about how functions will communicate and how data flows through your program.

Flowchart outline (conceptual):

• Start
• Open 'salary.txt' for reading
• Initialize department data structures
• Read line; if line contains "Department", store department name
• Read next employee line
• Parse employee data (name, hours, pay grade, sales/commission if applicable)
• Calculate individual salary based on pay grade
• Accumulate totals per category
• Repeat for all employees until EOF
• Compute department totals
• Output department summaries
• Repeat for next department until EOF
• End

Designing such a program requires anticipating variations and ensuring robustness, such as handling missing data or incorrect formats. Proper modularization will improve readability and maintainability, separating file I/O, data parsing, calculations, and output formatting.

References

• Coyle, J. J., Langley, C. J., Novack, R. A., & Gibson, B. (2016). Supply chain management: a logistics perspective. Nelson Education.
• ISO/IEC. (2020). ISO/IEC 9075:2020 Information technology — Database languages — SQL.
• Anderson, J. E. (2018). Operations management. McGraw-Hill Education.
• Levy, D., & Weitz, B. (2012). Retailing management. McGraw-Hill/Irwin.
• Bartholomew, D. J., Knott, M., & Moustaki, I. (2011). Latent variable models and factor analysis. John Wiley & Sons.
• Harrison, A., & Van Hoek, R. (2011). Logistics management and strategy. Pearson Education.
• Slack, N., Christopher, J. E., & Johnston, R. (2010). Operations management. Pearson Education.
• Heizer, J., Render, B., & Munson, C. (2016). Operations management. Pearson.
• Stevenson, W. J. (2018). Operations management. McGraw-Hill Education.
• Christopher, M. (2016). Logistics & supply chain management. Pearson UK.