Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Accounting Expert

An Introduction to Management Science 13th Edition (Chap 4 Case Problem 4 - "Workforce Scheduling")

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 Work Force Unlimited, a company that specializes in providing temporary employees for ?rms in the greater Atlanta area. Work Force 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 Work Force Unlimited experiences greater difficulty ending 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 ?ve employees in January under Option 2, WorkForce Unlimited will supply Davis with ?ve temporary workers who will work 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.

Develop a model that can be used to determine the number of temporary employees Davis should hire each month under each contract plan in order to meet the projected needs at a minimum total cost. Include the following items in your report:

1. A schedule that shows the number of temporary employees that Davis should hire each month for each contract option.

2. A summary table that shows the number of temporary employees that Davis should hire under each contract option the associated contract cost for each option, and the associated training cost for each option. Provide summary totals showing the total number of temporary employees hired, total contract costs and total training costs.

3. If the cost to train each temporary employee could be reduced to $700 per month, what effect would this change have on the hiring plan? Explain. Discuss the implications that this effect on the hiring plan has for identifying methods for reducing training costs. How much of a reduction in training costs would be required to change the hiring plan based on a training cost of $875 per temporary employee?

4. Suppose that Davis hired 10 full-time employees at the beginning of January in order to satisfy part of the labor requirements over the next six months. If Davis can hire full-time employees for $16.50 per hour, including fringe bene?ts, what effect would it have on total labor and training costs over the six-month period as compared to hiring only temporary employees? Assume that full-time and temporary employees both work approximately 160 hours per month. Provide a recommendation regarding the decision to hire additional full-time employees.

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91524341
  • Price:- $30

Guranteed 24 Hours Delivery, In Price:- $30

Have any Question?


Related Questions in Financial Accounting

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r-­-e". The revenue and expenses f ...

Assessment 1develop complex spreadsheetsthis is an

Assessment 1 Develop Complex Spreadsheets This is an assessment that may be worked on in study time and as homework. Assessment presentation should be completed in a manner that is appropriate to professional business re ...

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years?  b. What would the value ...

Excel quiz1 start excel 2016 and download and open the file

Excel Quiz 1. Start Excel 2016 and download and open the file Excel Quiz1F18. 2. Save the workbook as FirstName_LastName_Excel_Quiz1 where FirstName is your own First Name and LastName is your Surname (for example Roger_ ...

Assessment -part a -saturn petcare australia and new

Assessment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

Can you please help me with thishow do restrictions affect

Can you please help me with this. How do restrictions affect net assets in Not- For -Profit organization or health care?

Listed below are selected account balances for pinnacle

Listed below are selected account balances for Pinnacle Corporation at December 31, Year 1 and Year 2.  Also available for you is selected information from the income statement for Pinnacle for the year ended December 31 ...

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

Question 1 an organization owes pound300000 tax at 17x4 and

Question 1 . An organization owes £300,000 tax at 1.7.X4 and £450,000 at 30.6.X5. Its income statement for the year to 30.6.X5 includes a tax charge of £400,000. How much tax was actually paid in the year to 30.6.X5?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As