Data and tasks - rough-cut capacity planning, Mechanical Engineering

Assignment Help:

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?


Related Discussions:- Data and tasks - rough-cut capacity planning

Horizontal deflection , A  truss  is  shown  in  the  given figure. Compute...

A  truss  is  shown  in  the  given figure. Compute  the horizontal deflection of  joint D formed by  both  the  load  and  fabrication  error  (bar  AE  is  30mm  too  long).  For

Determine the machining time in milling operation, Determine the Machining ...

Determine the Machining Time in Milling Operation An HSS slab mill of 100 mm diameter and 150 mm width is used on a Horizontal milling machine to mill C50 steel. The milling c

How long does it take a plane, How long does it take a plane, traveling at ...

How long does it take a plane, traveling at a constant speed of 190 m/s, to fly once around a circle whose radius is 2950 m?

Illustrate the euler-poincare formula, The Euler-Poincare Formula  The ...

The Euler-Poincare Formula  The Euler-Poincaré formula describes the relationship of the number of vertices, the number of edges and the number of faces of a manifold. It has b

Determine the heat transfer coefficient, The average heat transfer co effic...

The average heat transfer co efficient for flow of 100 o C air over a flat plate is calculated by observing the temperature time history of a 3mm thick copper slab exposed 100 o

Calculate change in internal energy of the gas, (a) Illustrate First Law of...

(a) Illustrate First Law of Thermodynamics for a Closed System undergoing a change of state and show that ‘Energy' is a property of the system. (b) A cylinder contains 1 m 3 of

Process of corrosion in bfw tank, Q. Process of Corrosion in BFW Tank? ...

Q. Process of Corrosion in BFW Tank? The feed to the BFW Tank is hot and will be flashing when it enters the tank. The vapours will be corrosive when the tank is open to atmosp

Air standard cycles - thermodynamics, AIR STANDARD CYCLES - thermodynamics:...

AIR STANDARD CYCLES - thermodynamics: Most of the power plant operates in the thermodynamic cycle that is the working fluid undergoes a series of processes and returns to its

Displacement or swept volume, Displacement or Swept Volume ( V s ) : The ...

Displacement or Swept Volume ( V s ) : The nominal volume swept by the working piston when travelling from one dead centre to the other is called the displacement volume. It is e

Two wheeler industry growth, TWO WHEELER INDUSTRY GROWTH:  In world repres...

TWO WHEELER INDUSTRY GROWTH:  In world represents one of the largest two wheeler markets in the world with an estimated size of 5.4 million units a year. Two wheelers are used ext

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd