You are to design/build a spreadsheet model to help you create a bid to build a wall. You will offer two options:1)Lava Rock, or 2) Brick. Both walls will be built by crews of two. Crews will work three eight-hour days to build either type of wall.
The wall will be 20 feet long, 6 feet tall and 2 feet thick. Wages will be $10 per hour per person. You will have to add %20 to wages to cover fringe benefits. Lava Rock will cost $3 per cubic foot. Brick will cost $2 per cubic foot. Your bid must add a profit margin of 30% to your expected cost.