Apples and Oranges = Time and Production

**ComcoDG** · 08-05-2008, 03:52 PM

I am trying to Calculate how much time I need to complete a task at a given rate of production. The calculation is an easy one, but the function and format required to accomplish this on a spreadsheet is turning out to be a little more difficult.

If you are up to it, see the attached. The questions I’m trying to answer are: 1) How can I calculate my average production rate? 2) How can I use this average rate to calculate how many hours will it take to finish 3) What time should I start?

The cells in red represent cells which I believe I am having a problem with formatting. The production schedule contains two shifts which can work any time between 1:00 AM and 11:00 PM. These time are listed on the spreadsheet. A gantt chart has been created to show same.

Any takers? Thanks in advance for the help!

Example:
I must produce 50 boxes
I can produce and average of 9.5 per hour
I must finish the boxes by 9/15/2008 at 11:00 AM

**protonLeah** · 08-05-2008, 11:19 PM

1. You don't need the SUM() fn:

=SUM(F15/$H$11) ===> =F15/$h$11(

2. If the lunch break is always 1/2 hour, then the hours worked is simplified to:

Please Login or Register  to view this content.

with the cells formatted as number with 1 decimal place. Then boxes per hour is:

Please Login or Register  to view this content.

and the average is

Please Login or Register  to view this content.

**ComcoDG** · 08-06-2008, 06:00 PM

Perfect, and very simple! I actually changed my approach, but the info you provide was the key I needed to do so. Thanks so much for the tips.

Apples and Oranges = Time and Production

LinkBack

Thread Tools

Rate This Thread

Display

Apples and Oranges = Time and Production

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions