Production Sechedule

[Fla Web Wiz]

Hi!

I am looking for an Excel file that I can modify for our business.

It would be a daily production log of each item, It would sum up the
total of each week's production for each item, and carry through for
5 years to chart production in past and future years.

We produce precast concrete items (steps, vaults, septic tanks, etc.)
I need to make a spreadsheet that lists about 15 of our items, with
cells to figure the square yards of concrete each piece uses, steel
rebar used, man hours it takes to make each peice and maximum daily
production possible. I would like data cellsthat I could change when
the cost of concrete or steel goes up that would reflect back to the
value of products on hand.

I am somewhat knew to Excel and could use some advice.

Anyone know where I can get something like this??

Thanks in advance!

 

[BrianB]

IMHO you are in danger of going wrong from the start. Forums like thi
are flooded with queries from people who are trying to collate dat
from numerous separate workbooks and worksheets.

I have had a lot of experience in the analysis & reporting on data an
come to the conclusion that the best method is to start with a simpl
table with field headings in row 1 and data underneath. I call this th
"database approach". The same sort of approach used by large companie
requiring millions of records. If the number of rows is likely t
exceed the 65,536 Excel limit then use an Access table.

For example, a column called "Week Number" might save you a lot o
unnecessary calculation.

As new data arrives it is just added to the bottom of the table. Ther
is no need for any special formatting.

This means that you can then use the more powerful (and simple
features of Excel such as pivot tables and filters to analyse data
again with no real need to format. You can then link this to separat
worksheets set out in the reporting format you require. i.e. a 3 stag
process DATA to PIVOT TABLE to REPORT.

There are 2 additional advantages from this approach. Firstly you
method will produce something that will be exactly what you need
Secondly, when changes are required all you need to do is change th
data in your table and a pivot table refresh will immediatel
re-organise the analysis.

In your case it looks like you will need a basic table to record you
daily production and a separate lookup table "price list" that carrie
information about your 15 products. You could then have columns in you
production table for materials and manhours etc. which look up uni
prices in your list and calculate the values. [Look in Excel Help fo
the VLOOKUP() function]. These would automatically change whenever yo
change the price list. Pivot tables using this table would als
automatically add up the values for you by product or date o
whatever.

Hope this helps.


PS. I guess you mean cubic yards of concrete rather than square yards