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
Resultant of Non-coplanar Force System: The resultant of a system of coplanar forces can be attained by adding up two forces through law of parallelogram at a time and after t

Gudgeon Pin: It forms the link between the small end of the connecting rod and the piston. It is a small pin as shown in Figure 2.13. Figure : Gudgeon Pin

Find the tangential and normal components of acceleration: A fly wheel along diameter 400 mm begins from rest with constant angular acceleration 2 rad/sec 2 . Find out the tan

Throttle Free Play Adjustmen: A smooth operation of the throttle ensures proper acceleration of the vehicle according to the requirement of the rider. If the throttle cable is kin

Evaluate the motion of the system: If in above Example, the block A is resting on an inclined plane at 45 o to horizontal as illustrative in Figure, find out the motion of th

What is the use of Spindle in Radial drilling machine    The spindle holds the drill or cutting tools and revolves in a fixed position in a sleeve.

Assume the production function is given by the following equation (where a and b are positive constants): Q = aL+bK. What is the marginal rate of technical substitution of labor fo

Kinetics of a Particle: We have seen the effect of forces on a particle. The laws of motion for a particle are extended to include a system of particles or a rigid body. It is

defect of casting

alternative theorems for lamis theorem