PRAC #1

 

Developing complete spreadsheet applications.

 

1.      Define the problem

 

2.      Analyse the problem and determine the steps.

 

3.      Design & test a model.

 

4.      Create & save a template.

 

5.      Test the spreadsheet model.

 

 

1.                  A spreadsheet template is needed to calculate labour cost for a project.

 

2.                  Inputs are      

·        Total number of worker hours for a project

·        Maximum number of workers

·        Work hours per day for project

·        Hourly rate of pay

 

            Outputs are

·        Full days to complete project for all number of workers

·        Total wages bill for all number of workers

 

3.                  Draw up table

 

WORKERS	DAYS	WAGE
6
5
4

 

                                    1 worker takes 100 hours

                                    2 workers take 50 hours

                                    4 workers take 25 hours

 

            7 hour working day                100 hours = 100/7 ~ 14.3 days ~ 15 days

                                                              50 hours =   50/7 ~   7.1 days ~   8 days

 

Cost per hour is $20. Cost per worker day is 7 x $20 = $140