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
-
Twenty lab rats are taught to push a lever in their cage to drop a food pellet. For 10 days, the rats learn to push the lever and, each time, a food pellet drops. On the 11th day, the researchers...
-
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...
-
In Problem 19, suppose that the woman uses a motorboat that goes 20 miles per hour. Then where should she land?
-
The total number of plates purchased from subcontractors should not exceed the number of plates manufactured. Given the long relationship between Larkin and subcontractor "Harjis", the total number...
-
Which manager uses a transformational leadership style to motivate employees? A. Dick, who works daily to get the task done and gives to do lists to employees. B. Martin, who is known for seeing that...
-
How much would you have to invest today to receive: a. $15,000 in 8 years at 10 percent? b. $20,000 in 12 years at 13 percent? c. $6,000 each year for 10 years at 9 percent? d. $50,000 each year for...
-
Given the Following. 172.20.0.0 /19 For /19, how many borrowed bits? (1pt) ??? What is the equation to determine total number of subnets (1pt) ??? For /19, how many total subnets? (1pt) ??? For /19,...
-
Palmer, a U.S. company, acquired 90% of Scalas voting stock for $32,600 in cash on January 1, 2019, when Scalas book value was $5,000. The fair value of the noncontrolling interest at the date of...
-
What are the prevailing security models employed in the context of risk management within organizational frameworks? Please elucidate on the intricacies of these models, detailing their...
-
Strong Corporation had consistently used the cash method of accounting even though inventories were a material income-producing factor to its business and average annual gross receipts in the prior...
-
Given that there are 5 2 8 0 feet in a mile and 3 6 0 0 seconds in an hour, what is 2 5 miles per hour in feet per second?
-
If Colorado Springs, Colorado, has 1.2 times as many days of sunshine as Boston, Massachusetts, how many days of sunshine does each city have if there are a total of 464 days of sunshine between the...
-
The board have assessed that they require funding of 5 0 , 0 0 0 , 0 0 0 to invest in future projects. Discuss the factors the company would have to take into account when choosing between debt or...
-
At General Electric, shift 1 produced 4 times as much as shift 2. General Electric's total production for July was 5,500 jet engines. What was the output for each shift?
-
Truffles, Inc. is a chocolate store. This year, it sells a chocolate tempering machine that qualifies as a 1231 asset for $60,000. Truffles purchased the machine two years ago for $50,000, has taken...
-
Identify the Critical Infrastructure Physical Protection System Plan.
-
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...
-
In what terms are standard variable overhead application rates (SR) usually stated? a. Per dollar b. Per direct labor hour c. Per unit of product d. Per month
-
The gross profit on the interim income statement of a firm using standard costs is computed as: a. Sales less cost of goods sold at standard b. Sales less cost of goods sold at standard plus net...
-
The formula [(Actual Price Standard Price) X Actual Quantity] can be used to calculate which cost variance? a. Variable overhead volume b. Labor efficiency c. Materials efficiency d. Materials price
Study smarter with the SolutionInn App