Note that Table $4\mathrm{.}1$ is for the Commercial case study and provides a preconstruction budget. Prepare a similar preconstruction budget for the Brewpub case study. $(8$ pts$).$ You have general information about both projects and some cost information. Make assumptions. $\backslash$table$[[,\backslash$table$[[$Base$],[$wage$/$hour$]],\backslash$table$[[$Labor$],[$burden$]],\backslash$table$[[$HOOH$],[$& Fee$]],\backslash$table$[[$Precon$],[$wage$/$hour$]],\backslash$table$[[$Duration$],[($weeks$)]],\backslash$table$[[$Hours$],[$per week$]],\backslash$table$[[$Total$],[$hours$]],\backslash$table$[[$Total$],[($estimate$)]]],[$Project Executive,$$90,40\%,15\%,$$$145,12,4,48,$$$6,955],[$Senior PM$,$$$80,40\%,15\%,$$$129,4,8,32,$$$4,122],[$Project Manager,$$60,40\%,15\%,$$$97,12,20,240,$$$23,184],[$Superintendent$,$$$60,55\%,15\%,$$$107,12,12,144,$$$15,401],[$Chief Estimator,$$70,40\%,15\%,$$$113,4,20,80,$$$9,016],[$Staff Estimator,$$45,40\%,15\%,$$$72,4,40,160,$$$11,592],[$Scheduler$,$$$50,40\%,15\%,$$$81,3,20,60,$$$4,830],[$QC Officer,$$50,40\%,15\%,$$$81,2,16,32,$$$2,576],[$Safety Officer,$$50,40\%,15\%,$$$81,2,16,32,$$$2,576],[$Project Engineer,$$40,40\%,15\%,$$$64,12,10,120,$$$7,728],[$BIM Detailer,$$35,40\%,15\%,$$$56,6,4,24,$$$1,352],[$Total Wages:,,,,,,$972,$$$89,332,],[$Materials including printing, phones, parking, and mileage to be invoiced at cost plus,$15\%$:$,$$$30,668,,,,,,],[$Total Preconstruction Budget:,,,,,,$$120,000,,]]$