Purchase Solution

Bell-curve: Model Labour Hours

Not what you're looking for?

Ask Custom Question

Create a bell curve chart that shows the number of men needed per day for a 10,000 man hour job. The start date is 1/1/2008 and the end date is 6/1/2008. The job will run for a total of 21.71 weeks and there will be 108.57 work days. The estimated man hours is 10,000 and each worker will work an 8 hour shift 5 days out of the week. With this data can you help me create a bell curve that shows how many men would be needed each day to get the job done?

Purchase this Solution
Solution Summary

This tutorial provides guidelines on how to create a bell curve chart that shows the number of men needed per day to finish a 10,000 man hour job.

Solution Preview

Dear Student,

To create a sample bell curve for a problem, follow these steps:
1. Start Excel.
2. Enter the following column headings in a new worksheet:

A1:Original B1:Average C1:Bin D1:Random E1:Histogram G1:Histogram

3. Enter the following data in the same worksheet:

A2: 23 B2:
A3: 25 B3: STDEV
A4: 12 B4:
A5: 24
A6: 27
A7: 57
A8: 45
A9: 19

4. Enter the following formulas in the same worksheet:

B2: =AVERAGE(A2:A9)
B3:
B4: =STDEV(A2:A9)

These formulas will generate the average (mean) and standard deviation of the original data, respectively.

5. Enter the following formulas to generate the bin range for the histogram:

C2: =$B$2-3*$B4

This generates the lower limit of the bin range. This number represents three standard deviations less than the average.

C3: =C2+$B$4

This formula adds one standard deviation to the number calculated in the cell above.
6. Select Cell C3, grab the fill handle, and then fill the formula down from cell C3 to cell ...

Solution provided by:
Champake Mendis, MEngSc, PhD
Education
  • BSc (Hons), University of Colombo - Sri Lanka
  • MEngSc, University of Melbourne
  • Certificate IV in Training & Assessment , Australian Business Council
Recent Feedback
  • "Thank you!"
  • "Thank you."
  • "Thanks a lot for you help and support"
  • "Sorry about the late payment but the assignment was sufficient and appreciated. Good work"
  • "Great description! Thank you for your quick response."
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Probability at a Fast Food Restaurant

    If a group of 64 children is selected at random, what is probability that the average time these children watch television is more than 4.3 hours? Include an appropriate diagram of the bell shaped curve with the important values identified.

  • supply of labour and increasing retirement age

    She then has to adjust the utility curve downwards from U1 to U0. At the new tangent point A, her leisure is less than total hours (Lhours become positive. In other words, she becomes a labour force participant.

  • Methods of Overheads Allocation

    How many direct labour hours will be required to produce this batch of the mobile telephones? 4.

  • Productivity and Cost

    The MC curve will cut the average cost curve (AC) at its lowest point.

  • Wooden Toys

    407791 Wooden Toys This solution explains how this should be done to capture the necessary information in the LP model. First, I claim that it is alway better for the firm to use all of its labour units (i.e. labour always = 350).

  • linear programming model to compute an optimal production policy

    Month 1 Month 2 Month 3 Shoes Produced 360 390 120 Normal Labour Hours 1440 1440 480 Overtime Labor Hours 0 120 0 Raw Material Costs 1800 1950 600 Number of Workers 9 9 3 Beginning Inventory 50 110 0 Add Prod'n 360 390 120

  • Market Supply

    Does the market supply curve bend backward in the wage range shown in the table?

  • Quantitative Methods Optimal Solution a-j

    Only 2080 units of the 2400 available labour hours is used. So labour is not completedly consumed. 7) If fan motor increases to 225, now we are able to produce E = 130, S = 95 and D = 0.

  • Defining Economic Terms

    of labour, VMPK= value of marginal product of capital, L = amount of labour utilized, K = amount of capital utilized, w = wage rate, and PL=price of labour per unit of output.

View More Related Solutions