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

Hodgkin-huxley fast subsystem, Hodgkin-Huxley Fast Subsystem 1. Explai...

Hodgkin-Huxley Fast Subsystem 1. Explain why replacing the extracellular Na + with choline has little effect on the resting potential of an axon. Calculate the new resting po

Concept of continum, in concept of continum what is the meaning of upper cu...

in concept of continum what is the meaning of upper cure

Working stress and factor for safety working stress, W orking stress and F...

W orking stress and Factor for Safety Working Stress: Working stress is safe stress taken within elastic range of material. For the brittle materials, it is taken equal to

Production, what is tooling economics, machine economics and optimization

what is tooling economics, machine economics and optimization

Explain about vertical vessels, Q. Explain about Vertical Vessels? Vert...

Q. Explain about Vertical Vessels? Vertical vessels shall normally be designed as self-supporting units, and shall resist overturn based upon wind or earthquake considerations.

Space for coil removal, Q. Space for coil removal? Locations, of all co...

Q. Space for coil removal? Locations, of all coils clearly indicated on the drawings. Provide adequate space for coil removal, and access doors on both sides. Flexible connecti

Biaxial tension-compression state, Given:  A brittle material has an ulti...

Given:  A brittle material has an ultimate tensile strength of 300 MPa and an ultimate compressive strength of  -1000MPa.  Assume that failure can be represented by the Modified

Four-stroke - single cylinder gasoline engine, A four-stroke, single cylind...

A four-stroke, single cylinder gasoline engine having a bore of 90 mm and stroke of 100 mm has a compression ratio 7. The relative efficiency is 55% when the shown specific fuel co

Working principle of the petrol engine, W orking Principle of the Petrol E...

W orking Principle of the Petrol Engine: OTTO CYCLE     5-1 Suction Stroke 1-2 Adiabatic Compression Stroke 2-3 Heat Addition at the constant Volume.

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