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
A pressure transducer uses a probe to measure the deflection of a thin circular diaphragm, clamped at its periphery and having a rigid seat at its centre to eliminate curvature in

The rotor of a turbo charged having mass of 10 Kg is keyed to the centre of 25 mm diameter of steel shaft of 400 mm between bearings. Calculate : (i) Critical speed of shaft.

Seismometer : this is a transducer in which signal is proportional to the displacement. Accelerometer : This is a transducer in which signals is proportional to the a

Q. Describe the type of Facing and Backing sand? Facing sand. This sand is used directly next to the surface of the pattern and comes into contact with the molten metal when th

what is tool cost?

Determine the force: Determine the force P needed to start block B illustrated in Figure moving to the right if the coefficient of friction is 0.3 for all surfaces of contact.

Explain the Side Relief Angle It is angle made by flank of a tool and plane perpendicular to base just under the side cutting edge. if the side relief angle is very large the c

Design a shaft to transmit power from a motor to a lathe head stock through a pulley by means of a belt drive. The pulley weighs 200 N and is located at 300 mm from the centre of t

Gibson Ltd operates sportswear stores in Dublin and Cork and has set the following quarterly sales target for international and provlncial rugby shirts for 2013 per the attached sc

Every loaded blade rod is consists of 400 pieces of blades which around 25cm tall. The blasting nozzle vertical height different is just about 10 cm. The nozzle will blast the blad