Question: Given data fence building estimation Fence height =3ft,6ft,8ft, materials cedar= 10 redwood=20 timbertekk=30 Job expedition with 50% of labour chargers Price =lenght*height can you put

Given data fence building estimation

Fence height =3ft,6ft,8ft, materials

cedar= 10 redwood=20

timbertekk=30

Job expedition with 50% of labour chargers


Price =lenght*height

can you put a spreadsheet on excel


Fence Building Estimation

Fence Height (Feet)

3.00 (Dropdown for selecting 3,6,8)

Fence Material

Redwood (Dropdown for selecting Cedar, Redwood or Timbertek)

Fence Length (Feet)

50.00

Number of gates

3

Job Expedition required

No (dropdown for selecting yes/no)

Fence Area (Sq. Feet)

150.00

Material Cost (Sq. Feet)

$ 20.00

Gate Cost

$ 750.00

Expedition cost

$ -

Labor Cost

$ 500.00

Time (Hours)

0.2

Total Price

$ 4,250.00

3. Spreadsheet with Formulaes:

Fence Building Estimation

Fence Height (Feet)

3

Fence Material

Redwood

Fence Length (Feet)

50

Number of gates

3

Job Expedition required

No

Fence Area (Sq. Feet)

=B5*B3

Material Cost (Sq. Feet)

=IF(B4="Cedar",10,IF(B4="Redwood",20,IF(B4="Timbertek",30)))

Gate Cost

=B6*250

Expedition cost

=IF(B7="Yes",B14*0.5,0)

Labor Cost

=IF(B15*90>500,B15*90,500)

Time (Hours)

=IF(B3=3,0.2,IF(B3=6,0.25,IF(B3=8,0.3)))

Total Price

=B9*B11+B12+B13+B14



Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!