Question

In: Accounting

Davis Instruments has two manufacturing plants located in Atlanta, Georgia. Product demand varies considerably from month...

Davis Instruments has two manufacturing plants located in Atlanta, Georgia. Product demand varies considerably from month to month, causing Davis extreme difficulty in workforce scheduling. Recently Davis started hiring temporary workers supplied by WorkForce Unlimited, a company that specializes in providing temporary employees for firms in the greater Atlanta area. WorkForce Unlimited offered to provide temporary employees under three contract options that differ in terms of the length of employment and the cost. The three options are summarized:

Option

Length of Employment

Cost

1

One month

$2000

2

Two months

$4800

3

Three months

$7500

The longer contract periods are more expensive because WorkForce Unlimited experiences greater difficulty finding temporary workers who are willing to commit to longer work assignments.

Over the next six months, Davis projects the following needs for additional employees:

Month  
January

February

March

April

May

June

Employees Needed  
10

23

19

26

20

14

Each month, Davis can hire as many temporary employees as needed under each of the three options. For instance, if Davis hires five employees in January under Option 2, WorkForce Unlimited will supply Davis with five temporary workers who will work for two months: January and February. For these workers, Davis will have to pay 5($4800)=$24,000 . Because of some merger negotiations under way, Davis does not want to commit to any contractual obligations for temporary employees that extend beyond June.

Davis’s quality control program requires each temporary employee to receive training at the time of hire. The training program is required even if the person worked for Davis Instruments in the past. Davis estimates that the cost of training is $875 each time a temporary employee is hired. Thus, if a temporary employee is hired for one month, Davis will incur a training cost of $875, but will incur no additional training cost if the employee is on a two- or three-month contract.

Problem 4   Workforce Scheduling

  1. Define the decision variables, objective function, and constraints.

Optimal Solution: Total Cost =

Jan.

Feb.

Mar.

Apr.

May

June

Option 1

Option 2

Option 3

2.

Option

Number Hired

Contract Cost

Training Cost

Total Cost

1

2

3

Total:

  1. With the lower training costs, the costs per employee for each option are as follows:

Option

Cost

Training Cost

Total Cost

1

2

3

4.        

Jan.

Feb.

Mar.

Apr.

May

June

Option 1

Option 2

Option 3

Option

Number Hired

Contract Cost

Training Cost

Total Cost

1

2

3

Total:

           

Solutions

Expert Solution


Related Solutions

The demand for a product of Carolina Industries varies greatly from month to month. Based on...
The demand for a product of Carolina Industries varies greatly from month to month. Based on the past two years of data, the following shows the monthly demand at Carolina Industries.     Unit Demand               # Months 300                              4 400                              6 500                              9 600                              5 If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? What are the variance and the standard deviation for the...
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia....
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia. In business for ten (10) years, it has become one of the area’s largest producers of Widgets. James Henderson and three (3) associates founded the company, which has slowly grown to employ 500 employees, primarily production workers, in its three (3) existing facilities. Henderson is the President and CEO of the corporation, and Mike Johnson is the newly appointed Manager of Human Resources. Wentworth...
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia....
The Wentworth Corporation is a mid-sized manufacturing company located in the metropolitan area of Atlanta, Georgia. In business for ten (10) years, it has become one of the area’s largest producers of Widgets. James Henderson and three (3) associates founded the company, which has slowly grown to employ 500 employees, primarily production workers, in its three (3) existing facilities. Henderson is the President and CEO of the corporation, and Mike Johnson is the newly appointed Manager of Human Resources. Wentworth...
A corporation has 35 manufacturing plants. Of​ these, 28 are domestic and 7 are located outside...
A corporation has 35 manufacturing plants. Of​ these, 28 are domestic and 7 are located outside of the country. Each year a performance evaluation is conducted for 6 randomly selected plants. a. What is the probability that the evaluation will include no plants outside the​ country? b. What is the probability that the evaluation will include at least 1 plant outside the​ country? c. What is the probability that the evaluation will include no more than 1 plant outside the​...
You are located downwind from two oil-burning power plants. One is located 0.3 km NE of...
You are located downwind from two oil-burning power plants. One is located 0.3 km NE of your location and burns 1400 kg of 0.5% sulfur oil per hour. Its effective height is 60 m. The second plant is located 0.5 km NNW of you and burns 1600 kg/hr of fuel oil containing 0.75% sulfur. The effective height is 40 m. The wind is blowing from NNE at 3.3 m/s (measured at the standard height of 10 m). For a class...
Rexburg Technologies operates two plants. The demand equation for Rexburg's product is P = 38 –...
Rexburg Technologies operates two plants. The demand equation for Rexburg's product is P = 38 – 2.5Q, where Q is in thousands of units. The marginal cost of production in the two plants are MC1 = 2Q1 and MC2 = 4Q2, respectively. To maximize profits, Rexburg should charge a price of: A. $32.50 B. $23 C. $8 D. $10.75 E. None of the options
Samsung manufactures flash devices for use in products. Samsung has two fabrication plants. The plant located...
Samsung manufactures flash devices for use in products. Samsung has two fabrication plants. The plant located in Texas is responsible for 3/5 of the units, and the rest of the flash devices are manufactured in South Korea. Due to some impurity in the silicon, some flash devices are slow. It has been reported that 1/3 of the flash devices produced in Texas are slow and hence considered defective. Furthermore, a study shows that a total of 3/10 of the units...
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg.
Problem 12-27 (Algorithmic)Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here.Aynor: Cost = 80Q1 + 5Q12 + 106Spartanburg: Cost = 28Q2 + 3Q22 + 158WhereQ1 = number of chairs produced at AynorQ2= number of chairs produced at SpartanburgAndalus needs to manufacture a total of 30 kitchen chairs to meet an order just received. How many chairs should...
A company has a star product whose estimated demand is in the attached table Month 1...
A company has a star product whose estimated demand is in the attached table Month 1 2 3 4 5 6 Demand 50 70 30 90 10 100 An order costs $ 150, the cost of the product is $ 75 and the cost to keep in inventory is 15%. For each period, determine the replenishment plan and the associated cost. Using the Minimum Unit Cost method, interpret the purchase order program.
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost...
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. Aynor: Cost = 66Q1 + 6Q12 + 105 Spartanburg: Cost = 20Q2 + 2.5Q22 + 156 Where Q1 = number of chairs produced at Aynor Q2= number of chairs produced at Spartanburg Andalus needs to manufacture a total of 50 kitchen chairs to meet an order just received....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT