Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel Vehicles from the manufacturer, a new vehicle record is created. Included in the new vehicle record is the following information: vehicle identification number (VIN), name, model, year, name of manufacturer, and cost or amount paid to the manufacturer. When a customer arrives at Gofar Travel Vehicles, he/she works with a salesperson to discuss a vehicle purchase. The customer can purchase a new or used vehicle. On the new vehicle the customer can add options like a microwave, special lighting, fridge, stove, better seats etc. When the purchase has been agreed to, a sales invoice is completed by the salesperson. The invoice summarizes the details of the purchase. It will include all customer information, information on the vehicle being purchased and any options (if any), information on the trade-in vehicle and the trade-in dollar amount allowed (if a trade in exists). If the customer requests dealer-installed options, they will be listed on the invoice as well as the price. The invoice also summarizes the final price, plus any applicable taxes (7%) and license fees. The transaction concludes with a customer signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from Gofar Travel Vehicles. Name, address, and phone number are recorded for the customer. If there is a trade- in vehide it is described by a serial number, make, model, and year. Dealer installed options are described by an option code, description, cost from the manufacturer and selling price. Each invoice will list just one customer and one vehicle sold. It is rare but if a customer wants 2 vehicles then it requires two invoices be prepared. A person does not become a customer until they purchase a vehicle. Over time, a customer may purchase a number of vehicles from Gofar Travel Vehicles. Every invoice must be filled out by only one salesperson. A new salesperson may not have sold any vehicles, but experienced salespeople have sold many vehicles. A customer may decide to have no options added to the vehicle, or may choose to add many options. The optional equipment (stove, fridge, fire extinguisher) is stored in the warehouse. An option like a fire extinguisher can be installed on different types of vehicles. A customer may trade in only one vehicle toward the purchase of a new vehicle. The trade in vehicle may be sold later to another customer, who later trades it in on another Gofar. Travel Vehicle. The same vehicle over time can be sold several times. 1) Design the database to handle the above. There are assumptions to be made. For this case the selling price is the price the product sells for. There is no negotiating a lower price. This applies to options and the vehicle. 2) What changes to the design would you make if the price shown was a suggested price, but the webicle.could be sald for somother geootinted.pric MacBook Air Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel Vehicles from the manufacturer, a new vehicle record is created. Included in the new vehicle record is the following information: vehicle identification number (VIN), name, model, year, name of manufacturer, and cost or amount paid to the manufacturer. When a customer arrives at Gofar Travel Vehicles, he/she works with a salesperson to discuss a vehicle purchase. The customer can purchase a new or used vehicle. On the new vehicle the customer can add options like a microwave, special lighting, fridge, stove, better seats etc. When the purchase has been agreed to, a sales invoice is completed by the salesperson. The invoice summarizes the details of the purchase. It will include all customer information, information on the vehicle being purchased and any options (if any), information on the trade-in vehicle and the trade-in dollar amount allowed (if a trade in exists). If the customer requests dealer-installed options, they will be listed on the invoice as well as the price. The invoice also summarizes the final price, plus any applicable taxes (7%) and license fees. The transaction concludes with a customer signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from Gofar Travel Vehicles. Name, address, and phone number are recorded for the customer. If there is a trade- in vehide it is described by a serial number, make, model, and year. Dealer installed options are described by an option code, description, cost from the manufacturer and selling price. Each invoice will list just one customer and one vehicle sold. It is rare but if a customer wants 2 vehicles then it requires two invoices be prepared. A person does not become a customer until they purchase a vehicle. Over time, a customer may purchase a number of vehicles from Gofar Travel Vehicles. Every invoice must be filled out by only one salesperson. A new salesperson may not have sold any vehicles, but experienced salespeople have sold many vehicles. A customer may decide to have no options added to the vehicle, or may choose to add many options. The optional equipment (stove, fridge, fire extinguisher) is stored in the warehouse. An option like a fire extinguisher can be installed on different types of vehicles. A customer may trade in only one vehicle toward the purchase of a new vehicle. The trade in vehicle may be sold later to another customer, who later trades it in on another Gofar. Travel Vehicle. The same vehicle over time can be sold several times. 1) Design the database to handle the above. There are assumptions to be made. For this case the selling price is the price the product sells for. There is no negotiating a lower price. This applies to options and the vehicle. 2) What changes to the design would you make if the price shown was a suggested price, but the webicle.could be sald for somother geootinted.pric MacBook Air
Expert Answer:
Answer rating: 100% (QA)
CUSTOMER Company PK CustomerID make OH PK Company D Name phone a... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following are the assumptions for the projected cash flow and profit or loss statements for 20X3 for Zinc Mining Inc.: Zinc will sell 176,900 metric tons of zinc at an average price of $2,180...
-
A mechanical engineering contractor has been using a large and complex C software system for over 12 years. There is no documentation for the system and the maintenance programmers have moved to a...
-
Fill in the blanks with the right option: The children, Select one: O a. studyed - stopped b. studied - stoped c. studyed-stoped Od studied stopped for a long time. They at midnight.
-
Two thousand kg of water, initially a saturated liquid at 150C, is heated in a closed, rigid tank to a final state where the pressure is 2.5 MPa. Determine the final temperature, in C. the volume of...
-
As Ms. Chen's top aide, you are assigned the task of providing an analysis of the situation and recommending a solution. This is your opportunity to serve your company and community as well as to...
-
a) Check that the Black-Scholes formula for European call options \[ g_{\mathrm{c}}(t, x)=x \Phi\left(d_{+}(T-t)ight)-K \mathrm{e}^{-(T-t) r} \Phi\left(d_{-}(T-t)ight), \] satisfies the following...
-
Both Netcap and Jmart have the same retum standard deviation of 20 percent, and Netcap and Jmart returns have a correlation of +1. You invest half your funds in Netcap and the other half in Jmart....
-
Refer to the financial statements of Quaker Oats Company in Problem. Prepare a forecasted income statement for Year 12 using the following assumptions ($ millions): 1. Revenues are forecast to equal...
-
Great Migration refers to a the movement of thousands of African Americans north in search of employme the movement of troops across France Ob c the movement of troops across the Atlantic as the...
-
Aardvark, Inc., began 20X1 with the following receivables-related account balances: Accounts receivable ...................... $575,000 Allowance for credit losses .............. 43,250 Aardvarks...
-
1 10 5 2 2 3 4 6 2 7 3 5 6 Provide a trace Dijkstra's algorithm on the above graph with the start node 1.
-
Suppose that A is a small open economy that takes world prices as given. What would be the effect on wages and rents in A if it were to experience an outflow of foreign capital? Use a diagram to...
-
Suppose Switzerland is on the gold standard and it maintains a strict ratio of gold in its vaults to money (Swiss francs) in circulation. Suppose that it runs a balance of payments deficit. What will...
-
Suppose that we are in the early days of the Bretton Woods system, and France has declared a par value for the French franc at FF6 per dollar. The allowable fluctuation band is 1 percent on either...
-
Over the past two centuries, there have been two extended periods of worldwide fixed exchange rates, the international gold standard and the Bretton Woods system. Compare and contrast these two...
-
If two countries had identical term structures of interest rates, how would you expect the forward premium or discount to change over time?
-
PT Amanah merupakan perusahaan swasta yang menyediakan jasa switching. Saat audit interim berjalan, auditor mengevaluationbali faktor industri, regulasi, dan faktoreksternal lainnya yang mempengaruhi...
-
A survey of 70 college freshmen asked whether students planned to take biology, chemistry, or physics during their first year. Use the diagram to answer each question. How many of the surveyed...
-
What is the importance of the declaration date, record date, and payment date in conjunction with corporate dividends?
-
Carters Produce has applied for a loan and has agreed to use its inventory to collateralize the loan. The company currently has an inventory balance of $289,000. The cost of goods sold for the past...
-
During 2011, Lang Merchandising Company purchased $20,000 of inventory on account. The company sold inventory on account that cost $15,000 for $22,500. Cash payments on accounts payable were $12,500....
-
The Van Division of Travel Vans Corporation has offered to purchase 180,000 wheels from the Wheel Division for \($76\) per wheel. At a normal volume of 500,000 wheels per year, production costs per...
-
Francisco Consulting Firm provides three types of client services in three health-care-related industries. The income statement for July is as follows: The sales, contribution margin ratios, and...
-
Karakomi Cameras Inc. has a Disposables Division that produces a camera that sells for \($13.00\) per unit in the open market. The cost of the product is \($9.50\) (variable manufacturing of...
Study smarter with the SolutionInn App