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
INTREPRETATION OF DEFECTS Intrepretation is an important factor is controlling the quality of the product on economic levels. Sometimes for want of proper decision, proj

how to understand what is carnot vapour cycle???please understand me..??

Heat Dissipation : During clutch application, large amount of heat is generated. The rubbing surfaces should have sufficient area and mass to absorb the generated heat. The proper

Write an essay on air, water and soil-based heat pumps. Discuss the advantages and the disadvantages of each system. For each system identify the conditions under which that system

Brake Wear Inspection and Free Play Adjustment: Brake wear inspection is very important because worn out brake shoe does not provide good braking. At some point of time they need

#q(b) Illustrate governing mechanism of Kaplan turbine.uestion..

Q. Automation Material Specifications? Automation Material Specifications include the development and / or review of material specifications, and the review of data sheets, mat

If Brakes Drag Causes of Problem Remedy   Insufficient pedal free play Recommended brake fluid not used

Determine the reaction: The cantilever is shown in the figure given below; determine the reaction when it is loaded.   In cantilever at fixed end ( A ) there is three reac

(a) Can you explain the limitations of 1 s t law of thermodynamics ? Describe thermal energy Reservoir, heat sink and heat source. (b) Give the basic concept of Heat Engine, Ref