Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers to operate their businesses. Instead of renting the space to the customers, PLL sells the units to them under Strata Title. PLL needs to determine the right selling prices which allows it to maximise profit while attracting many buyers. This assignment requires you to practise principles of correct spreadsheet construction and design to help PLL to improve its decision making to meet its business challenges. (a) Mall Traffic, measured by the number of visitors-per-day, is often used as a variable to predict the occupants business viability. PLL has collected the following information on mall traffic and selling price per square meter of four existing malls. Data for Mall Traffic and Selling Price Mall Traffic (visitors per day) 15,000 10,000 6,000 4,000 Selling Price per square meter $14,000 $11,000 $7,200 $3,600 Note: The Selling Price is valid only for units with areas between 50 to 200 square meters. Record how Selling Price changes with Mall Traffic by creating a scatter plot with a Trend Line and equation shown, assuming a linear relationship between the variables. PLL has completed building three properties with estimated mall traffic as shown below. The selling price has yet to be decided. Mall City Point Bishan Centre Tuas Square Mall Traffic (visitors per day) 12,000 9,000 6,000 Selling price per square meter Using the TRENDLINE that you have computed above, compose a spreadsheet model that will allow PLL to determine the Selling Price for each of the three properties by using Excel function(s).