I need the formulas to type in the cell

CSE 2111 In Lab 5 Directions Master Microsoft Word Review View Paragraph Styles YOU MUST DOWNLOAD YOUR STARTING FILES F ROM YOURSMNET SESSON AND SUBMIT Yous TING FILES TO YOUR SIMNET SESSION OR SIMNET WILL BLOCK YOUR SUBMISSION. PART 1: BUCKEYE BUILDERS In the followingproblem, you will be analyzing the day to day operations of a new home building company named Buckeye Builders. One of your primary tasks will be to design an Excel workbook detaling the different modelhomes theyoffer, the various locations available in your new development, and the customer accounts you are currently handling. Development Specifications Your development area excludes the areas for roads and a lake. You will divide the land up into as many 1/4 acre plots as possible and build one of the model home types you offer on each plot. You may assume the deve sufficiently continuous such that all of the development area wilcontain plots:; you do not need to deduct any areaforstreets and roads, etc consists of 750,000 square meters of developable land. This development area already 1 plots% 000 sqvare Pricing Specifications Each model home has a specific base price which is determined by the number of leves in the home and the the plot location, and the options included. The workbook, CE 2111 in Lab 5 Buckeye Builders Master.xisx contains four worksheets as follows: Models: This worksheet outines the specifications for the base modelhomes offered by the bullder. it includes all the standard features for each given model Base: This worksheet outlines the price in S/square foot by cate gory for each home based on the variables just described. Homes with less than 1,500 square feet and 1 levelare priced at $85 per square foot, and $105 per square foot for 2 levels. Homes with at least 1,500 square feet but less than 2.000 square feet are priced at 583 per square foot for 1 level and $102 persquare foot for 2 levels