dammyshaggs
New Member
- Joined
- Sep 17, 2018
- Messages
- 5
Been having hard time solving this question.I got it wrong and i believe the workings used is the cause of it.
Question 1
The following file describes the situation faced by a landscaping company, 'Landscaping Solutions'.
If there is great weather, the company takes the following hours to complete a driveway, backyard, front yard, back verandah, and front porch: 20, 30, 25, 25, and 20 hours respectively.
Good weather increases all times by a factor of 1.1.
Bad weather increases all times by a factor of 1.25.
Stormy weather increases all times by a factor of 1.5.
A natural disaster increases all times by a factor of 2.0
Great weather, good weather, bad weather, stormy weather, and a natural disaster have the following probabilities of occurrence: 0.6, 0.25, 0.1, 0.04, and 0.01 respectively.
All these probabilities (weightings) sum to 1.
Use SUMPRODUCT to calculate the estimated hours of work to complete the landscaping.
Please answer using the format ###.##
Thanks!!
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
Question 1
The following file describes the situation faced by a landscaping company, 'Landscaping Solutions'.
If there is great weather, the company takes the following hours to complete a driveway, backyard, front yard, back verandah, and front porch: 20, 30, 25, 25, and 20 hours respectively.
Good weather increases all times by a factor of 1.1.
Bad weather increases all times by a factor of 1.25.
Stormy weather increases all times by a factor of 1.5.
A natural disaster increases all times by a factor of 2.0
Great weather, good weather, bad weather, stormy weather, and a natural disaster have the following probabilities of occurrence: 0.6, 0.25, 0.1, 0.04, and 0.01 respectively.
All these probabilities (weightings) sum to 1.
Use SUMPRODUCT to calculate the estimated hours of work to complete the landscaping.
Please answer using the format ###.##
Thanks!!
Weighting | 0.01 | 0.04 | 0.1 | 0.25 | 0.6 | |
High Level Tasks | Natural Disaster | Stormy Weather | Bad Weather | Good Weather | Great Weather | Estimated Hours |
Driveway | 20 | |||||
Backyard | 30 | |||||
Front yard | 25 | |||||
Back veranda | 25 | |||||
Front porch | 20 | |||||
TOTAL HOURS | 0.0 |
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>