Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers to operate their businesses. Instead of renting the

 

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).

Step by Step Solution

3.46 Rating (169 Votes )

There are 3 Steps involved in it

Step: 1

mall traffic visitors per day selling price ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Tax Research

Authors: Barbara H. Karlin

4th Edition

013601531X, 978-0136015314

More Books

Students also viewed these Programming questions

Question

Was the Hawthorne effect operating?

Answered: 1 week ago