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
why we feel increase in weight when elevator goes up?

(a) What do you understand by steering gear ? Explain with a clean sketch the working of Davis steering gear process. Also show the required equation between wheel base and distanc

Foil Butt Seam Welding This is a modification of seam welding, in which thin narrow strips of metal arc introduced between one or both of the circular electrodes and the work p

Sign convention which is used for solving problems of beam: Although different sign conventions can be used, most of the engineers use following sign conventions for shear for


Explain the autoignition and detonation theory of detonation. What do you mean by preignition ? Describe octane Rating of a fuel. What are the different S.I. engine combustion cham

What is STEP The STEP (Standard for External Representation of Product Data) project is supported by the ISO workgroup TC 184/SC4. it is also sometimes called Standard for Exch

Ask question #Minimum 100 words awrite short note on the the hierarchical system structure involving various level

Define the term linear non-uniform soil pressure. See that the eccentric load on a column as in demonstrated figure also produces a similar effect. The linear non-uniform soil

connecting rod AB of length L support a variable compressiv force F .Drive an expression for the moment of F about the crank axis O in the term of F L r and angle