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
Dynamic Magnifier: This is function of frequency ratio. Forced Vibration: While the system is continuously excited by an external force or internally produced force, the v

What will be the criteria to be looked into get the pulley rpm increase

Q. What do you mean by Dilution method? Dilution methods are more suited especially in hilly streams and torrents where current meter measurements are not feasible on account o

INTRODUCTION TO WELDING PROCESSES Welding is a material joining process used in making welds and a weld is a localised coalescence of metals or non metals produced either by he

Define the process of Otto cycle The Otto cycle is the ideal air standard cycle for petrol and gas engine. It having of four processes. Process 1 to 2 is isentropic comp

what is the advantage of fan

Spar k Ignition Engines (or S.I. Engine): It works on otto cycle. In Otto cycle, energy supply and rejection occur at the constant volume process and compression and expansio

Is bleed necessary in condensing and back pressure both the turbine? What is the use of bleed in steam turbine? What is the basic difference in condensing and backpressure turb

for a circle,is the net work necessarily zero? for what kind of system will this be the case?

Railway Station: Types of Stations There are the following types of stations: (a) Terminal stations, Howrah station in Kolkata and Mumbai Central being good exampl