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
what are the essentials of a good steam generator?

Q. Inlet channel of the exchanger? The inlet channel of the exchanger shall be designed to minimize flow turbulence and erosion of the refractory liner and the tube inlet area.

You need to sketch shear force and bending moment diagrams and estimate maximum bending and shear stresses acting on the beam using your knowledge in beam analysis.  Please note

dynamic analysis of four bar linkage by kelin''s construction.

A hollow mild steel tube 6 m long 4 cm internal diameter and 6 mm thick is used as a strut with both ends hinged. Determine the crippling load and safe load taking factor of safety

Calculate strength coefficient: A copper specimen of 64 mm gauge length and 12.80 mm dia. was tested in tension. Following two diameters were recorded in the plastic range of

Discover modulus of elasticity of the composite: A composite of glass fibres and epoxy contain all fibres laid along the length and is needed to carry a stress of 1200 MPa. Th

The major assignment for the unit is to design the final drive for the F-SAE race car. This is a group project to be completed with groups of up to 5 people. The design should be r

causes and remedy of coldshut,misruns,shirnkage cavity,microporosity,metal penetration,mismatch

Grinding & Brushing: Grinding is process there has an abrasive wheel that rotating at certain speed to smooth a surface or to give an even finish on material. In this Blade pr