A Company Has Daily Staffing Requirements for Two Types of Jobs,cleaning

question 39

Essay

A company has daily staffing requirements for two types of jobs,cleaning and customer service persons.The minimum numbers of workers required each day for each type of job are shown in the table below.To meet these requirements,the company can employ three types of workers: those who clean only,those who can perform customer service only,and those who are able to do both.In each of these three categories,the company wants to meet its daily requirements using only full-time workers.A full-time worker must work five consecutive days with two days off.Workers who are able to perform only one type of work (cleaning or customer service)earn $50 per day.Those who are able to perform both types of work earn $60 per day.As a matter of policy,the company wants to ensure that at least 20% of its total hours are staffed by "swing workers"; those who can do both types of jobs.The company wants to find a staffing policy that covers the daily worker requirements at minimum total costs per week.Use solver to formulate and solve the company's problem.

---

Definitions:

Peak Periods

Peak periods refer to times of heightened demand or activity within a business or market, often leading to increased sales, higher operational intensity, and the need for strategic planning to meet consumer needs.

Off-Peak Periods

Times outside of peak demand or usage intervals, often characterized by lower costs or lesser activity levels.

Capacity Shortage

A situation where the demand for a company's output exceeds its production capacity.

Margin Reduction

The decrease in the difference between the selling price of a product and its cost, often due to increased costs or reduced selling prices.