Create a spreadsheet tool to derive the estimates

Assignment Help Business Management

Reference no: EM131225008

General Electric manufactures and refurbishes GE diesel locomotives at a facility in Erie Pennsylvania. The facility remanufactures machines that have reached a point in their service life such that they are beyond the point of applying ordinary maintenance procedures. A model that entered service 10 years ago has begun to show up at the facility. A crew of 15 mechanics recently required 3.4 weeks to refurbish the first machine that came to facility. Due to a backlog of other repair and refurbishing work, crews will not refurbish any other units until 2016.

Based on experience with other models, the company anticipates a 93% learning curve (with each doubling of the number of units repaired) with regard to man-hours required to refurbish a locomotive. The company expects to refurbish 16 locomotives in the coming year (2016); that number is expected to grow by 20 percent per year for the next four years.

Compensation to mechanics, including wages, benefits, insurances, etc. is currently $43 per hour, a figure that is expected to grow by 4% per year. You may assume that mechanics work 40 hours per week and 48 weeks per year (net of vacations and sick days).

As a company analyst, you have been asked to do the following:

Estimate refurbishing labor hours required for this particular model in each year, 2016-2019
Estimate refurbishing labor costs in each year, 2016-2019
An estimate of refurbishing manpower headcount required in each year, 2016-2019

Create a spreadsheet tool to derive the estimates above. Use excel to emulate the exhibit on the following page. Print the corresponding exhibit in excel, and staple it on top of the remainder your printed spreadsheet. Structure your spreadsheet as per directives given earlier in the semester.

Analyst:___________________________________________________________________

	2016	2017	2018	2019
Locomotives refurbished
Labor hours required
Labor costs
Required Headcount

Hours required for locomotive number 18:_______________________

Hours required for locomotive 48:________________________

Average hours required, first 50 locomotives: _____________________

Reference no: EM131225008

Questions Cloud

Compute how much money will tom and tricia have : How much money will Tom and Tricia have in 45 years if they donothing for the next 10 years, then put $2400 per year away for the remaining 35 years?

Current hydrocarbon propellants in aerosol products : Review of current hydrocarbon propellants in aerosol products and consider a minimum of five propellants or combinations

Facility and company that is approved is pizza hut : The facility and company that is approved is Pizza Hut. Research the growth of a faculty-approved e-business in Supply Chain Management.

What is morris tie ratio : If the company does not maintain a TIE ratio of at least 6 to 1, its bank will refuse to renew the loan and bankruptcy will result. - What is Morris's TIE ratio?

Create a spreadsheet tool to derive the estimates : Learning Curve Project - BUS461 Create a spreadsheet tool to derive the estimates above. Use excel to emulate the exhibit on the following page. Print the corresponding exhibit in excel, and staple it on top of the remainder your printed spreadshe..

Who decides on behalf of the patient : How can a healthcare administrator ensure that the patient's autonomy is ensured and competency is established?

Potential ethical and conflict of interest issues : What are the potential ethical and conflict of interest issues arising from CEO involvement in the selection of board members? How can these issues be addressed?

How can the company pay its canadian employees : How can company pay its Canadian employees, who presumably want Canadian dollars, when its U.S. customers are paying in U.S. dollars? Furthermore, how can it calculate its profit if revenue is in U.S. currency and most of its costs are in Canadian..

Create domestic flight itineraries and source airfares : SITTTSL309 & SITTTSL310 Source airfares for domestic flights & Construct normal international airfares. Interpret domestic airfare information, Create domestic flight itineraries and source airfares and Document and maintain records of calculations

User Account

All Pages