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

ablain

New Member
Joined
Aug 7, 2019
Messages
3
[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]
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

joeu2004

Well-known Member
Joined
Mar 2, 2014
Messages
2,811
Office Version
  1. 2010
Platform
  1. Windows
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.
 
Last edited:

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,049
Office Version
  1. 2016
Platform
  1. Windows
Assuming that you wanted to round up part of a day to a whole number :

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

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,313
Office Version
  1. 2010
Platform
  1. Windows
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.
 
Last edited:

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,049
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,313
Office Version
  1. 2010
Platform
  1. Windows
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

Well-known Member
Joined
Sep 21, 2016
Messages
3,049
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Code:
[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

New Member
Joined
Aug 7, 2019
Messages
3
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

New Member
Joined
Aug 7, 2019
Messages
3
Thank you. This does help me understand how to use fonction to solve this type of problem. Really appreciate it!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,007
Messages
5,526,248
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top