Microsoft Excel Help. Costing??

Question

I need to develop a Cost Evaluation sheet, in which there are various sheets of products, with a list of their respective components, materials, and manufacturing charges etc...

charges as per the product manufacturing process.

now, im new to excel, and since this needs to be pretty confidential, i cant share the files with anyon. Can anyone please Help.

i need to mentain 3-4 coloumns.

Component

Material

weight

Mfg Charges (stage wise)

Rate of material

Amount

where the wieght X Rate = Amount

and mfg = amount

and then total is under the coloumn of amount. (last coloumn last row)

Since most of these have similar, or same material. i need ot automate this somehow.

Variable- rates, and some are fixed rates..

Please can someone Help me how to go about this?

I need to make a Master sheet, from where the Rate Coloumn Picks up all the Rates accroding to the Material.

so that, if these rates ever change (maket fluctuations), my cost changes automatically.

Please help, as this is Urgent

Answer 1

Hello,

Put reuqired fields vertically column-wise in excel sheet as below

    A           B          C         D                   E                      F

    Comp  Matl.      Wet    Mfg.Chrg    Rate of Matl.   Cost

1.    ---           ---        ---         ----              ----              C1 x E1

        

You have to put the formula in furmula bar which is in the top of the sheet. To get a cost of respective item you have to multiply respective column x respective row. Here for multiply you have to use * sign. To get a total you have to go to the bottom of the respecetive column and row & click on the autosum botton.

If it is not helpful to you then you can send me mail.