Need to solve a mathematical problem and I must use two fonctions to do it.

[ablain]

[FONT=&quot]Hi,[/FONT]
[FONT=&quot]I need to solve this using 2 fonctions (not 1, not 3).[/FONT]
[FONT=&quot]You hire an employee to pick up tomatos.If he picks up 8 cases an hour, 8 hours a day, 6 days a week, but you guarantee him a minimum of 4 weeks, how many days do you hire him for 1000 cases?[/FONT]
[FONT=&quot]I'm really stuck with this one and I cant seem to find any helping document online.[/FONT]
[FONT=&quot]PLEASE HELP!!![/FONT]

 

[joeu2004]

I dislike teachers that specify how a problem should be solved. But in this case, the "optimum" solution does indeed use two Excel functions.

If you guarantee at least 4 weeks of 6 days each, how many days is that? I'll call that "x".

If the employee can pick 8 cases per hour and 8 hours per day, how many cases can she pick in a day? Then, how many days will it take for her to pick up 1000 cases?

The teacher probably wants you to round up to a whole number of days. I'll call that "y".

Then, you must hire the employee for the larger of "x" or "y".

If you do not know what functions to use for rounding up a value and finding the larger of two values, enter "math functions" and "statistical functions" into Excel Help ("?" icon), and scroll through each list.

PS.... Test your formula with 2000 cases as well as 1000 cases.

 

[footoo]

Assuming that you wanted to round up part of a day to a whole number :

=MAX(24, ROUNDUP(1000/64,0))

 

[Rick Rothstein]

Assuming that you wanted to round up part of a day to a whole number :

=MAX(24, ROUNDUP(1000/64,0))

Very good... you just did ablain's homework for him/her. I am pretty sure Joe was trying to lead him/her to that solution.

 

[footoo]

Very good... you just did ablain's homework for him/her. I am pretty sure Joe was trying to lead him/her to that solution.

Thanks. I'm flattered.
Based on your premise, answers should not be included in replies to many posts to this forum since many of them can be easily found with a simple search of the internet.

 

[Rick Rothstein]

Thanks. I'm flattered.
Based on your premise, answers should not be included in replies to many posts to this forum since many of them can be easily found with a simple search of the internet.

I think you may have missed my point. It seemed to me (and Joe) that this was clearly a homework problem (the "I need to solve this using 2 fonctions (not 1, not 3)." sort of says so)... we should not be providing solutions to homework problems when they can clearly be identified as homework problems. It is better to lead the OP to the solution than just give it to them... that way they learn something and what they turn into their teacher is their work not someone else's.

 

[footoo]

[COLOR=#333333]I think you may have missed my point. [/COLOR]

No I didn't. My response was a feeble attempt at irony - obviously failed since you appear to have missed my point.
It is unnecessary for you to explain your position. You are entitled to work to whatever criteria you prefer but I am not obliged to follow them.

 

[ablain]

This was indeed part of a homework. But my goal here was not to gather plain answers but just to understant how one's would approach a problem like this. Our teacher in this case is not really good and many students tried to get some clarification from him without success. So yes @footoo gave me an answer to one of MANY similar problem but he gave me a new understanding on how to approach such a problem.

...sorry for my english btw

 

[ablain]

Thank you. This does help me understand how to use fonction to solve this type of problem. Really appreciate it!