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
Q. High temperature materials in Boilers? A thin refractory layer between the shield and boiler tube is recommended in areas subject to moderate temperatures and levels of corr

MIG / CO 2 WELDING In MIG / CO 2 welding the feeding of filler wire is machanised. If the welder moves the MIG / CO 2 torch the process is called semi automatic MIG / CO 2

Bore - Thermodynamics: The inner diameter of engine cylinder is called as bore. It can be measured by a vernier calliper or bore gauge. As engine cylinder wears out with the p

A nozzle of 50 mm. dia. delivers a stream of water that strikes a flat plate which is held normal to the axis of stream. If the issuing jet has a velocity of 15 m/sec., Determin

A pelton wheel works at the foot of a dam because of which the head available at the nozzle is 400m. The nozzle diameter is 160mm and the coefficient of velocity is 0.98. The diame


Proof that energy is a property of system

types of compressor used in super chasrger

Find Cutting Speed for Prolonging Tool Life A form tool machining at 24 m/minute requires re-sharpening after 30 minutes. What should be the cutting speed for prolonging tool