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

Stenght of Material, Give the assumption of pure torsion derivation of shea...

Give the assumption of pure torsion derivation of shear stress produced in circular shaft subjected to torsion

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

Illustrate the various functions of clutch, Illustrate the various Function...

Illustrate the various Functions of clutch and also explain the Principle of frictions Clutch ? What is the requirement of Transmission System & Explain the Arrangemnet for P

Calculate the motor efficiency, A 4- pole DC motor is known to have an arma...

A 4- pole DC motor is known to have an armature resistance of 0.5 Ω, and is operated as a separately excited motor. (a)  When the motor is connected to a 250V DC supply with no

Horizontal hinge, 2 x 2 m square gate opens clockwise on a horizontal hinge...

2 x 2 m square gate opens clockwise on a horizontal hinge located at point A, which is 100 mm below the centroid of the gate. The gate sits against solid rubber blocks which create

Piping, I have an assignment and i want you to do it for me

I have an assignment and i want you to do it for me

Diaphragm spring single plate, Give the working and consideration of a diap...

Give the working and consideration of a diaphragm spring single plate clutch in disengaged position. Discuss in detail the constructional features of a clutch plate. Explain the

Explain Functions of springs as on following points, 1. store energy 2. app...

1. store energy 2. apply force on a body 3. balance force between two bodies 4. absorb vibrations of body

Vectors, Following sets of the three forces act on a body,. In which case r...

Following sets of the three forces act on a body,. In which case resultant cannot be zero? 1) 10N, 10N, 10N 2)10N, 10N, 20N 3)10N, 20N, 20N 4010N, 20N, 40N Ans)      In 4th

Explain the homogeneous system - thermodynamic, Explain the Homogeneous Sys...

Explain the Homogeneous System - Thermodynamic Homogeneous System: A system, which contains a single phase, is known as homogeneous system. Such as, Mixture of water plus nitri

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