Question;1. Davis InstrumentsDavis 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:OptionLength of EmploymentCost1One month$2,0002Two months$4,8003Three$7,500The 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, David projects the following needs for additional employees:MonthJanuaryFebruaryMarchAprilMayJuneEmployees Needed102319262014Each 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 Option2, WorkForce Unlimited will supply Davis with five 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.Managerial ReportDevelop 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:a) A schedule that shows the number of temporary employees that Davis should hire each month for each contract option.b) If the cost to train each temporary employee could be reduce 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?2. Carlson Department Store (Forecasting)The Carlson Department Store suffered heavy damage when a hurricane struck on August 31. The store was closed for four months (September through December), and Carson is now involved in a dispute with its insurance company about the amount of lost sales during the time the store was closed. Two key issues must be resolved: (1) the amount of sales Carlson would have made if the hurricane had not struck, and (2) whether Carlson is entitled to any compensation for excess sales due to increased business activity after the storm. More than $8 billion in federal disaster relief and insurance money came into the county, resulting in increased sales at department stores and numerous other businesses.The attached excel file give Carlson?s sales data for the 48 months preceding the storm. Tale 15.20 reports total sales for the 48 months preceding the storm for all department stores in the county, as well as the total sales in the county for the four months the Carlson Department Store was closed. Carlson?s managers asked you to analyze these data and develop estimates of the lost sales at the Carlson Department Store for the months of September through December. They also asked you to determine whether a case can be made, Carlson is entitled to compensation for excess sales it would have earned in addition to ordinary sales.Carlson Department StoreCounty SalesMonthYear 1Year 2Year 3Year 4Year 5January46.846.843.858February4848.645.651.6March6059.457.657.6April57.658.253.458.2May61.860.656.460June18.104.22.1687July56.4515457.6August6358.860.661.8September55.857.649.847.469October56.453.454.654.675November71.471.465.467.885.2December117.6114102100.2121.8Managerial ReportPrepare a report for the managers of the Carlson Department Store that summarizes your findings, forecast, and recommendations. Include the following:a) An estimate of sales for Carlson Department Store had there been no hurricaneb) An estimate of countywide department store sales had there been no hurricanec) An estimate of lost sales for the Carlson Department Store for September through Decemberd) In addition, use the countywide actual department stores sales for September through December and the estimate in part (2) to make a case for or against excess storm-related sales.e) How accurate are the above models?
Paper#45737 | Written in 18-Jul-2015Price : $32