Question: Based on Lanzenauer et al. (1987). To process income tax forms, the IRS first sends each form through the data preparation (DP) department, where information

Based on Lanzenauer et al. (1987). To process income tax forms, the IRS first sends each form through the data preparation (DP) department, where information is coded for computer entry. Then the form is sent to data entry (DE), where it is entered into the computer. During the next 3 weeks, the following quantities of forms will arrive: week 1, 40,000; week 2, 30,000; and week 3, 60,000. All employees work 40 hours per week and are paid $500 per week. Data preparation of a form requires 15 minutes, and data entry of a form requires 10 minutes. Each week, an employee is assigned to either data entry or data preparation. The IRS must complete processing all forms by the end of week 5 and wants to minimize the cost of accomplishing this goal. Assume that all workers are full-time employees and that the IRS will have the same number of employees each week. Assume that all employees are capable of performing data preparation and data entry. Determine how many workers should be working and how the workers should allocate their hours during the next five weeks.

Step by Step Solution

3.22 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Model Processing income tax forms Range names used CommonTotal ModelB20F20 Inputs Minutes DEAvail Mo... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

1497_6040a2330bc22_694782.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!