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
sensitivity of governors

In a nuclear power plant saturated steam at 30 bar enters a h.p. turbine and expands isentrophically to a pressure at which its quality is 0.841. At this pressure the steam is pass

Thermal Conductivity The amount of heat passing throughout unit cross-section of a solid material in unit time for unit thermal gradient is termed as thermal conductivity. The


Describe the following key terms: (i) Stream Line (ii) Path Line (iii) Streak Line (iv) Stream Function (v) Potential flow function (vi) Flow net

MANDATORY CHECKS DURING THE FIRST SIX SERVICES Various steps in servicing of motorcycle are given below in a tabular form. 2.3.1 First Service and Second Ser

Management of Financial Requirements:  To start an own workshop or any business you need monetary support. You need to ensure availability of the required money including working

steam boilar

1 Prepare an updated sketch of the electro-hydraulic system shown in Figure showing the actuators in their start position appropriate to your allocated actuator sequence. 2 By u

Low Hydrogen Electrodes Low hydrogen electrodes are so called because their covering is low in hydrogen bearing compounds and only traces of hydrogen or moisture are present in t