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
Various Properties of Lubricant Viscosity: The property of lubricant which is a measurement of the internal friction of lubricating oil is called its viscosity. The vi

Find out the axial moment of inertia: Find out the axial moment of inertia of a rectangular area of base b and height d around centroidal axis GX and the base B 1 B 2 . So

Screw Conveyors: Screw conveyors are used principally for transmitting materials in the form of powder or paste with the application of rotating screw. For example feedin

Prlblems 1 & 3 can you provide accurate and clear solved out solutions not done by computer either.

Standard for External Representation of Product Data (STEP)  The furthest developed standard is by ISO 10303, or STEP, Standard for the Exchange of Product model data. One of t

CLASSIFICATION OF POWER SOURCES ACCORDING TO CONSTRUCTION & DESIGN To give the desired output a power source may be constructed with different components. Therefore, a classifi

Defects Involving Inadequate Bonding Lack of fusion Involves lack of complete melting and fusion of some portion of the weld metal in a joint. It may occur either bet


There is risk of wet H 2 S corrosion in all emulsion and gas lines from the Inlet Separator up to and including the Treater. Full compliance to NACE is highly recommended to contro

PLASMA WELDING This is an extension of TIG welding. In plasma welding torch, plasma energy is constricated and ensures its most efficient utilisation for welding cutting and s