The management wants to know the total value of purchases made by each agent in the last
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case Scenario You, as a group, have been contracted by a national real estate agency ABC Real Estate - to develop the backend database for a property management system (the System). The System shall allow the owners of the agency to track their sales performance, to calculate commissions for their sales agents and to extrapolate business insights from their property sales history. The party who sells a property is normally called 'the vendor'. They are normally but not always the owners of the property. A property may be owned jointly by multiple people. Thus, there may be more than one vendor for a property. For the purpose of this assessment, please assume that each of the vendors would have the attributes of an individual person. For example: name, gender and age. A vendor will normally engage a sales agent and authorise the agent to run a marketing campaign to sell the property. In return, the sales agent will take a proportion from the sales proceeds as a commission. The commission is calculated at 6% of the property sale price if the property is sold through auction, or 4% of the property sale price if it is sold through other means, for example a private sale. For the purpose of this assessment, please assume that a property can be sold by only one agent. Once the vendor contacts the agent and authorises them to market the property, the agent will then advertise the property on popular websites such as Domain or Realestate.com.au. At this stage, the property will be labelled as 'listed'. If the property is auctioned, the highest bidder and the vendor will enter into an unconditional Contract of Sale ('COS') on the auction day and the status of the property will be changed to 'under contract'. In this assessment, you do not need to consider any other possibilities at auction, e.g., the property is withdrawn or passed in. If the property is not to be auctioned, interested purchasers may approach the agent and make offers on the property. If the vendor accepts the offer, both parties will normally proceed to a conditional CoS, which is subject to conditions, for example, securing a home loan from the bank. At this stage, the status of the property will be changed to 'under offer'. Once the conditions in the Cos are satisfied and the CoS becomes unconditional, the status of the property will be changed to 'under contract'. There is normally a one to six-month gap between the date when a contract, conditional or otherwise, is entered into and the date that the ownership of the property is transferred from the vendor to the purchaser. The time duration allows the vendor to move out of the house and the purchaser to prepare finances and other paperwork required for the conveyancing of the property. The date on which the ownership is transferred is called the settlement date. Once the property is settled, its status will be changed to 'settled'. This is when the commission becomes payable to the agent. Case Scenario You, as a group, have been contracted by a national real estate agency ABC Real Estate - to develop the backend database for a property management system (the System). The System shall allow the owners of the agency to track their sales performance, to calculate commissions for their sales agents and to extrapolate business insights from their property sales history. The party who sells a property is normally called 'the vendor'. They are normally but not always the owners of the property. A property may be owned jointly by multiple people. Thus, there may be more than one vendor for a property. For the purpose of this assessment, please assume that each of the vendors would have the attributes of an individual person. For example: name, gender and age. A vendor will normally engage a sales agent and authorise the agent to run a marketing campaign to sell the property. In return, the sales agent will take a proportion from the sales proceeds as a commission. The commission is calculated at 6% of the property sale price if the property is sold through auction, or 4% of the property sale price if it is sold through other means, for example a private sale. For the purpose of this assessment, please assume that a property can be sold by only one agent. Once the vendor contacts the agent and authorises them to market the property, the agent will then advertise the property on popular websites such as Domain or Realestate.com.au. At this stage, the property will be labelled as 'listed'. If the property is auctioned, the highest bidder and the vendor will enter into an unconditional Contract of Sale ('COS') on the auction day and the status of the property will be changed to 'under contract'. In this assessment, you do not need to consider any other possibilities at auction, e.g., the property is withdrawn or passed in. If the property is not to be auctioned, interested purchasers may approach the agent and make offers on the property. If the vendor accepts the offer, both parties will normally proceed to a conditional CoS, which is subject to conditions, for example, securing a home loan from the bank. At this stage, the status of the property will be changed to 'under offer'. Once the conditions in the Cos are satisfied and the CoS becomes unconditional, the status of the property will be changed to 'under contract'. There is normally a one to six-month gap between the date when a contract, conditional or otherwise, is entered into and the date that the ownership of the property is transferred from the vendor to the purchaser. The time duration allows the vendor to move out of the house and the purchaser to prepare finances and other paperwork required for the conveyancing of the property. The date on which the ownership is transferred is called the settlement date. Once the property is settled, its status will be changed to 'settled'. This is when the commission becomes payable to the agent.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Compensation System Change Introduction As Melanie Griffith gazed through the window of her office, she could see some employees walking to the parking lot to get to their cars; others were on their...
-
A company has 10,000 employees. Each employee is entitled to twenty days of paid holiday per calendar year. Up to five days of this entitlement may be carried forward and taken in the following year...
-
On January 1, 2014, Pat Company purchased 90% of the outstanding common stock of Solo Company for $236,000 cash. The balance sheet for Pat Company just before the acquisition of Solo Company stock,...
-
5- Write a C++ program (a Main function) to merge two dynamic array of characters. The user should enter the array of characters as one string. Then, the program should generate the reverse of it and...
-
The journal of Bell Technology Solutions, Inc., includes the following entries for August, 2010: Requirements 1. Describe each transaction. 2. Set up T-accounts using the following account numbers:...
-
a. Calculate and display the first 50 autocorrelations for the four data series in the accompanying table, labeled A, B, C, and D; consider each of the four data series to be a quarterly time series....
-
Dr. Jennings sent the following memo to Dr. Wilson, the Nalukai School District superintendent, regarding their analysis of current budgeting practices in the school district. Dr. Jennings...
-
The following adjusted revenue and expense accounts appeared in the accounting records of Pashi, Inc., an accrual basis taxpayer, for the year ended December 31, Year 2. Revenues Net sales $3,000,000...
-
Based on the synopsis of the LeadClick case. Who has or should have primary responsibility for managing fake news and its consequences (i.e., social media companies, advertising companies,...
-
44x If a basketball player shoots a foul shot, releasing the ball at a 45-degree angle from a position 6 feet above the floor, then the path of the ball can be modeled by the quadratic function, h(x)...
-
Explain the mechanisms of action of monoclonal antibodies in therapeutic applications, and discuss their use in targeting specific immune pathways in the treatment of autoimmune diseases and cancers .
-
1. Grab Holdings Inc. commonly known as Grab, is a Southeast Asian technology company headquartered in Singapore. In addition to transportation, the company offers food delivery and digital payments...
-
1. What is symbolic speech? a. Speech which promotes at least some type of commerce b. Privately expressing ideological beliefs c. Speech that promotes at least some type of symbolism d. Expressive...
-
How do you account under ASPE for a lease which has a fair value purchase option, and does not meet the other criteria for capitalization. However, the equipment is specialized for the lessee, and...
-
Consider the following schedule for transactions T1, T2 and T3: S1: r1(Y); r3(Y); r1(X); r2(X); w2(X); r3(Z); w3(Z); w1(Y); r2(Z) Which one of the schedules below is the correct serialization of the...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Why do you think Google was adamant about not wanting to supply information requested by the government concerning the Child...
-
An extract from the consolidated statement of Triangle Holdings Inc. and its subsidiary, Trico Ltd., as at December 31, 2013, is shown below. Triangle Holdings acquired all the share capital (cum...
-
Endeavour Films is a production company that produces movies and television shows. It also owns cable television systems that broadcast its movies and television shows. Endeavour transferred to Barco...
-
GOW Inc. purchases used mining equipment, refurbishes it, and sells it to mining companies around the world. On October 31, 2013, GOW ordered some used mining equipment from a company in a foreign...
-
What is a best practice in general? Give examples of best practices in an area unrelated to project management, such as nutrition, exercise, or child rearing.
-
What are some unique features of project management software in general?
-
Why should organizations identify and use best practices? What are the main categories of best practices developed as part of OPM3?
Study smarter with the SolutionInn App