Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers...

 

Transcribed Image Text:

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. Note: you must follow the information given in this TMA case and ignore other rules and regulations concerning property sales and bank loans. (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) Selling Price per square meter 10,000 15,000 $14,000 S11,000 6,000 S7,200 4,000 $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. Bishan Tuas Mall Mall Traffic (visitors per day) Selling price per square meter City Point 12,000 Centre 9,000 Square 6,000 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). 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. Note: you must follow the information given in this TMA case and ignore other rules and regulations concerning property sales and bank loans. (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) Selling Price per square meter 10,000 15,000 $14,000 S11,000 6,000 S7,200 4,000 $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. Bishan Tuas Mall Mall Traffic (visitors per day) Selling price per square meter City Point 12,000 Centre 9,000 Square 6,000 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).

Answer rating: 100% (QA)

mall traffic visitors per day selling price ... View the full answer