Business
Business, 06.10.2019 05:30, Timsters333

Quicklube is in the quick oil and lube business. although customers bring in their cars for service described as quick oil changes, quicklube also replaces windshield wipers, oil filters, and air filters, subject to customer approval. the customer invoice lists the charges for the oil used, all parts used, and a standard labor charge. when quicklube presents the invoice, customers pay cash, use a credit card, or write a check. quicklube does not extend credit. quicklube needs a database designed to keep track of all components in all transactions. given the high parts usage of the business operations, quicklube must maintain careful control of its parts (oil, wipers, oil filters, air filters) inventory. therefore, if parts reach their minimum on hand quantity, they must reorder the part in question from an appropriate vendor. quicklube maintains a vendor list that contains both the vendors, actually used as well as potential vendors. quicklube also tracks each customer’s car mileage. periodically, quicklube mails updates/reminders to customers, based on the date of the car’s service and the mileage. based on the information provided: 1) draw the erd (entity relationship diagram) for quicklube: draw the erd using crow's feet notation. use ms visio and save your final drawing as a pdf. 2) on a separate page(s): clearly list all the entities with a list of the attributes below each entity. 3) make sure you clearly mark/label the primary/identifier key attribute(s) (pk) for each entity. 4) also, make sure you clearly mark/label any foreign key attributes (fk) for each entity. 5) provide a list of any business assumptions that you made while developing your erd.

answer
Answers: 3

Other questions on the subject: Business

image
Business, 22.06.2019 11:30, Svetakotok
Margaret company reported the following information for the current year: net sales $3,000,000 purchases $1,957,000 beginning inventory $245,000 ending inventory $115,000 cost of goods sold 65% of sales industry averages available are: inventory turnover 5.29 gross profit percentage 28% how do the inventory turnover and gross profit percentage for margaret company compare to the industry averages for the same ratios? (round inventory turnover to two decimal places. round gross profit percentage to the nearest percent.)
Answers: 2
image
Business, 22.06.2019 22:00, vanessacasillas452
What resourse is both renewable and inexpensive? gold coal lumber mineral
Answers: 1
image
Business, 23.06.2019 02:40, laura1649
P8-4b dropping unfavorable division based on the following analysis of last year's operations of groves, inc., a financial vice president of the company believes that the firm's total net income could be increased by $160,000 if its design division were discontinued. (amounts are given in the thousands of dollars.) required provide answers for each of the following independent situations: a. assuming that total fixed costs and expenses would not be affected by discontinuing the design division, prepare an analysis showing why you agree or disagree with the vice president. b. assume that the discontinuance of the design division will enable the company to avoid 30% of the fixed portion of cost of services and 40% of the fixed operating expenses allocated to the design division. calculate the resulting effect on net income. c. assume that in addition to the cost avoidance in requirement (b), the capacity released by discontinuance of the design division can be used to provide 6,000 new services that would have a variable cost per service of $60 and would require additional fixed costs totaling $68,000. at what unit price must the new service be sold if groves is to increase its total net income by $180,000?
Answers: 2
image
Business, 23.06.2019 03:00, drainy0uandthefish
Why is the type of product sold in an industry an important characteristic? a firm that can differentiate its product from that of rivals may be able to charge a higher price for a superior product. a firm that sells intangible goods is usually considered a monopoly. service industries cannot differentiate their products, which makes it easy for new firms to enter the industry. expensive products are usually sold by perfectly competitive firms.
Answers: 2
Do you know the correct answer?
Quicklube is in the quick oil and lube business. although customers bring in their cars for service...

Questions in other subjects:

Konu
Mathematics, 30.03.2021 05:10