WHAT FORMULA DO I USE?

  • Thread starter Thread starter LYNABY
  • Start date Start date
L

LYNABY

DESCRIPTION PART # PART $ LABOUR
BDY R/I L PICKUP BED SIDE PANEL 25871809 $642.50 13.5 $921.65
REF REFINISH L BED OUTER SIDE PANEL 3.0 $204.81
REF REFINISH L ADD FOR EDGE 0.5 $34.14
BDY R/I FUEL TANK EXISTING 1.0 $68.27



PAINT MATERIALS
SHOP MATERIALS


I NEED TO ADD ALL THE LABOUR TIME FOR ROWS STARTING WITH BDY TOGETHER AND
MUTIPLY THEM BY 6.12 TO GET MY SHOP MATERIALS TOTAL, AND ADD ALL LABOUR TIME
FOR ROWS STARTING WITH REF TOGETHER AND MULTIPLY THEM BY 32.68 TO GET MY
PAINT MATERIALS TOTAL. WHAT KIND OF A FORMULA DO I USE AND HOW DO I SET IT
UP?
 
Lynaby,

Your spreadsheet is a little jumbled, so I'm going to assume that you have
13.5 hours for BDY job 1 and 1.0 hours for BDY job 2. Also, let us both
assume that 13.5 is in cell E1 and 1.0 is in cell E2.

To create the formula you need, click an empty cell and type =(E1+E2)*6.12
to calculate total Shop Materials labour cost.

For the total Paint Materials labour cost, use the same structure as above,
but E1 and E2 will change to whatever cells have 3.0 and 0.5 and 6.12 will
change to 32.68.

Good louck!
 
Back
Top