Data and tasks - rough-cut capacity planning, Mechanical Engineering

Expected quarterly sales in Year 1 (vehicles)

The work content of a single unit of each product in each process has been estimated at:

Using MS-Excel, calculate the workloads on each workcentre, expressed in actual quarterly, total annual and average quarterly terms.

Using a stacked vertical barchart in MS-Excel, display the total workload on the workshop for each quarter, broken down further to each workcentre.

The ideal quarterly capacity of a single unit of each resource in each workcentre, assuming full efficiency is:

In other installations, the actual, historically observed efficiency of these resources has been:

Taking into account the probable efficiencies of the resources, calculate and display in a table the effective quarterly capacity of a single unit of each resource.

Based on your answer to Task 3, calculate the "ideal" number of units of resource each quarter (i.e. the number of units of resources in each workcentre that would just meet the workload).

What would be a practical number of units of resource in each workcentre that would allow capacity to go all through the year unchanged? (Assume that demand timing is flexible [i.e. demand can be levelled between quarters] and that capacity can be rounded up to the average quarterly level.)

What would be the resulting quarterly and annual utilisations in each workcentre?

Posted Date: 3/12/2013 1:08:20 AM | Location : United States







Related Discussions:- Data and tasks - rough-cut capacity planning, Assignment Help, Ask Question on Data and tasks - rough-cut capacity planning, Get Answer, Expert's Help, Data and tasks - rough-cut capacity planning Discussions

Write discussion on Data and tasks - rough-cut capacity planning
Your posts are moderated
Related Questions
How is local shear mode characterized in bearing capacity? Local Shear Failure The local shear mode of failure is characterized by slip zones, small surface heave and a poor

This section shall apply to the general requirements for design, fabrication, erection, and testing of structural steels for supports, stairways, ladders and platforms. All stru

Differences between torque and torsion: Give differences between torque and torsion. List a few examples of torsion in the engineering practice. Sol.: When structural or

Q. Source of Materials? The user may restrict sources of fabrication materials. If there is a restriction, the prospective manufacturers must be informed at the time of biddin

Impulse, Momentum, Work and Energy: As a part of summary, you can remember various important principles in terms of following equations.  (i)        Impulse-Momentum equati

Q. What is Squeeze time? It is the time between the initial application of the electrode pressure on the work and the initial application of current to make the weld. During th

Determine the parameter - Larson-Miller parameters: Larson-Miller parameters for an alloy at tests levels 10 MP a and 30 MP a are determined respectively as 18 × 10 4 and 1

STEA M ENGINE TERMINOLOGY: 1 .     Cylinder Bore: Inside diameter of cylinder. 2 .     Cover End and Crank End of cylinder: In the horizontal cylinders the end that

What is Drilling It is an operation by which holes are produced in solid metal by means of revolving tool known as „Drill?. The various operations on drilling machine.

A tank has two identical orifices in one of its vertical sides. The upper orifice is 3m below the water surface and lower one is 5m below the water surface. If the value of Cv for