Formulate an lp model for the staffing problem

Assignment Help Supply Chain Management

Reference no: EM133526082

To process income tax forms, the Internal Revenue Service (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 numbers of forms will arrive: week 1, 40,000; week 2, 30,000; 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 all employees are capable of performing data preparation or data entry, but must be assigned to one task for an entire week at a time.

Question:

Formulate an LP model for the staffing problem. Use the spreadsheet provided to execute the model in Excel.
The solution obtained in part a) may suggest imbalanced workload over time. That is, a lot of forms are done in some week, while many fewer are done in others. Such a schedule is not practically appealing. To make sure a more balanced load over time, we impose a constraint that the forms processed at each step in each month should not exceed 30% of the total number of forms to be processed. Modify the model (in a separate workbook) to find the new schedule.

Reference no: EM133526082

Questions Cloud

What are the benifits gained from the implementation : What are the benifits gained from the implementation of the Internet of Things would be the usage of smart meters by utility companies like water, electricity

How would you implement your plan : How would you implement your plan? How would you track progress of your plans' execution? Who does what, where, how, when, etc. Your RACI chart would fit here

How often does health care organization assess its strengths : How often does health care organizations assess its strengths, weaknesses, opportunities, and threats in order to understand the current business climate?

What challenges does walmart currently face : What are the global challenges that Walmart faces in its supply chain and what are the best solutions? Explain in details.

Formulate an lp model for the staffing problem : Formulate an LP model for the staffing problem. Use the spreadsheet provided to execute the model in Excel.

Identify topic in maternal and child health or mental health : Identify one topic in maternal and child health or mental health. Describe the topic and give one example of the work done in public health to improve health.

What is the single most important thing you would do : What is the single most important thing you would do to reduce monopoly power? What would be the benefit?

Provide a brief perspective of the role : Reflect on the point of view of whether "all supply chains are global" or not. Provide a brief perspective of the role of the customs process in supply chains.

Crafting a compelling brand statement : Crafting a compelling brand statement is important in your career journey. It highlights your talents, skills, and expertise; and shows how you can provide

User Account

All Pages