Sumproduct

[dammyshaggs]

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!!



[TABLE="width: 949"]
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]Weighting[/TD]
[TD]0.01[/TD]
[TD]0.04[/TD]
[TD]0.1[/TD]
[TD]0.25[/TD]
[TD]0.6[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]High Level Tasks[/TD]
[TD]Natural Disaster[/TD]
[TD]Stormy Weather[/TD]
[TD]Bad Weather[/TD]
[TD]Good Weather[/TD]
[TD]Great Weather[/TD]
[TD]Estimated Hours[/TD]
[/TR]
[TR]
[TD]Driveway[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Backyard[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Front yard[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Back veranda[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Front porch[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TOTAL HOURS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0.0[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Sounds like homework, not landscape work...

 

[dammyshaggs]

Sounds like homework, not landscape work...

Yes home work.Been solving it but wrong .

I have to fill the table before using the SUMPRODUCT function.

Then used that to find my estimated hours.
Lemme explain better what i did which i believe is giving me wrong answers.I used fill handle to do the increasing factor for each column.Then use the all data to perform SUMPRODUCT for the estimated hours.
But that approached fails!

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-fo...5835-help-solve-this-sumproduct-question.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[joeu2004]

See my response to your posting in excelforum.com.

Please note, I wrote there: ``Since this is homework or an exam question about SUMPRODUCT, it would be inappropriate to provide a turnkey solution using SUMPRODUCT.
But let's be sure you understand the mathematical principle (probability theory), which might be your stumbling block.``

 

[dammyshaggs]

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!!



[TABLE="width: 949"]
<tbody>[TR]
[TD]Weighting[/TD]
[TD]0.01[/TD]
[TD]0.04[/TD]
[TD]0.1[/TD]
[TD]0.25[/TD]
[TD]0.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]High Level Tasks[/TD]
[TD]Natural Disaster[/TD]
[TD]Stormy Weather[/TD]
[TD]Bad Weather[/TD]
[TD]Good Weather[/TD]
[TD]Great Weather[/TD]
[TD]Estimated Hours[/TD]
[/TR]
[TR]
[TD]Driveway[/TD]
[TD]40[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]22[/TD]
[TD]20[/TD]
[TD]21.6[/TD]
[/TR]
[TR]
[TD]Backyard[/TD]
[TD]60[/TD]
[TD]45[/TD]
[TD]37.5[/TD]
[TD]33[/TD]
[TD]30[/TD]
[TD]32.4[/TD]
[/TR]
[TR]
[TD]Front yard[/TD]
[TD]50[/TD]
[TD]37.5[/TD]
[TD]31.25[/TD]
[TD]27.5[/TD]
[TD]25[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]Back veranda[/TD]
[TD]50[/TD]
[TD]37.5[/TD]
[TD]21.25[/TD]
[TD]27.5[/TD]
[TD]25[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]Front porch[/TD]
[TD]40[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]22[/TD]
[TD]20[/TD]
[TD]21.6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TOTAL HOURS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]129.6[/TD]
[/TR]
</tbody>[/TABLE]

Have solved it yesterday night.Thank you very much...

Moreover am new here and am not sure if have done something wrong.This forum seems not friendly.Can anybody tell me how i can delete my account here!!!

 

[dammyshaggs]

I will like to say thank you to everybody who had dedicated their precious time trying to solve this question for me.Am really grateful for your kind gesture.!!!

 

[dammyshaggs]

I did not cross post.I don't even have the time of looking for irrelevant question from one forum to another(My too busy for that).
I was taking an excel course and the exercise looks complicated.So i googled best forum in order to just meet people that will just explain better for me not solve it.But finally did it by myself.
I think am done here!!!

Can you just tell me how to deactivate my account!!!

Best Regards
Dammy Shaggs

 

[LFKim2018]

Have solved it yesterday night.Thank you very much...

Moreover am new here and am not sure if have done something wrong.This forum seems not friendly.Can anybody tell me how i can delete my account here!!!

Every Forum have its own policy. The only problem I can see (as I also was warned of cross posting some time ago)
is how the way it was said. THERE IS ALWAYS A BETTER WAY OF SAYING THINGS. specially to the new comers.. a little TACT will go a long way....
thank you

 

[Macropod]

I did not cross post.

That's a flat-out lie. Same username, same question and posted only minutes apart.

I think am done here!!!

Fine, with your attitude you won't be missed.

Can you just tell me how to deactivate my account!!!

You can't. Thread closed.