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
Constant Mesh Type Gear Box : Most of the gearboxes on motorcycles are "constant mesh". That means all the gears are constantly meshed with one another and are always spinning. T

case study of thermal stresses and composite bar

proof of work being a path function

Develop a computer program that can be used for internal flow analysis in SI units. The program should be able to: ? Get the required input data from the user ? Decide the flow ty

What us the duff between direct stress and bending stress

(a) Derive the mathematical expression for Steady Flow Energy Equation. State the assumption made before the derivation. (b) The internal energy of a substance is provided by th

Question 1 A metal rod has a diameter of 8.74 mm and supports a load of 24.6 kN. Calculate the value of true stress on the rod. The diameter was measured with the load already a


With the help of diagram , depict the evaluation of Machine Design. Discuss in detail Technical feasibility, finanacial and economic feasibility, social and environmental feasib

Atmospheri c Pressure (P atm ): It is pressure exerted by atmospheric air on any surface. It can be measured by a barometer. The standard values of it are; 1 P atm = 760