On Balboa Island near San Diego, in the shadow of the famous Hotel Del Coronado, where...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
On Balboa Island near San Diego, in the shadow of the famous Hotel Del Coronado, where Marilyn Monroe starred in one of her most famous roles in Some Like It Hot, lies a unique beauty salon called Marilyn Monroe Makeovers or MMM for short. MMM's founders, Lucy and Ethel, got the idea for their business from TV talk shows where they observed that ordinary people delighted in letting a team of beauty consultants "make them over" in a new image by changing their hair, their grooming, their cosmetics, their clothes, and sometimes even their demeanor. Lucy and Ethel at first targeted only women who wanted to look and feel like Marilyn Monroe for their business, but they discovered over time that there was a market for men also who wanted to be made over in the image of some of the men in Marilyn's life like Arthur Miller, Joe DiMaggio, or Clark Gable. Based on their robust business in Southern California, they were thinking of expanding to other locations (like Michigan and Wisconsin) and even to other stars (like Claudette Colbert and Audrey Hepburn), but for the present, their booming Balboa business took all their energies. MMM grossed over ten million dollars and employed more than 50 people. When MMM first does a makeover for a client, they assign a client# and note the person's address, and telephone#. Clients can either pay for all consultations received in a particular month on the 20th of the following month or they can spread their payments for each consultation over three months. Makeover consultations last 1-5 hours and are always finished on one day. When clients leave the shop, they are given remittance advices for their payments which they mail back in with their checks. Repeat business is a major part of the MMM marketing plan, and many clients use MMM multiple times, although Lucy and Ethel's exorbitant price structures do encourage them to use other establishments for more routine beauty and grooming services. Sometimes for marketing purposes, MMM relates one consultation to a single other that caused it (like a "Joe DiMaggio" who wants to match his "Marilyn"), but this is only done in 20-30 % of the cases, and payments are always tracked by individual consultation. A consultation is always directed by one employee who plans the makeover and performs some or all of the work. This "director" is assisted by 1-3 other employees in about 70% of the consultations. Employees often serve as both directors and assistants on a given day, depending upon the flow of customers. For costing and quality control purposes, MMM notes the directing or assisting roles and times of each person who works on a particular makeover. Consultations come in various types, ranging from the "Major Marilyn Makeover" to the "Joe DiMaggio Haircut and Trim." Each consultation type has a standard base fee to which is added the labor and product costs needed to make that individual consultation successful. At present, MMM offers 17 of these types, but that number goes up and down based upon fashion and fads. Lucy and Ethel figure out the composition of a new consultation type before they offer it. Product costs involving items such as cosmetics, clothing, jewelry, wigs, hairpieces, Marilyn paraphernalia, etc. are incurred in over 90% of the consultations, and MMM tracks them in detail because consultation directors are paid commissions on them. Obviously, directors push as many products as they can on to each client, although some clients resist products altogether. Products are never sold without consultations. Products are purchased from various vendors around the country. Each product type is given a product# and is usually supplied by multiple people. Before any purchases take place with a vendor, that supplier is asked to provide an undiscounted price quote for each item they intend to supply to MMM. Buying employees negotiate quantity discounts for all the different products on each purchase separately, and MMM tries to buy in large lots if they feel they can anticipate a need for "hot items." Purchase payment terms depend upon the vendor and range from all payments due at the end of the next month to one-year installments. Lucy and Ethel use multiple cash accounts for their receipts and disbursements, although each transaction involves just one account. Buyers are often the same people who do the makeovers, and MMM does not distinguish between these different types of employee. HINT: italic relational hint; bold-orphan attribute; underline-type attribute REQUIRED: Using the attributes below (don't add or subtract), build a data model (classes, associations, attributes, multiplicities) and a minimal relational database for MMM. Also, diagram as complete a value chain as you can for MMM given its minimal description (just two business processes). -check# -purchase-order# -undiscounted-price-quote -vendor-address -employee-name -client# -individual-accounts-payable -base-consultation-fee -consultation# -disbursement-voucher# -disbursement-amount -consultation-actual-length -quantity-of-product-purchased -consultation-type -employee#-for-this-cash-transaction -remittance-advice# -consultation-projected-length -product-description -YTD-sales-of-this-consultation-type -client-address -time-spent-on-makeover-by-director -purchase-order-Samount -client-check# -product# -vendor# -receipt-amount -employee# -individual-accounts-receivable -actual-unit-cost-of-purchased-item -client-tel# -quantity-of-product-used -account#-for-this-client-payment -time-spent-on-makeover-by-assisting-employee -total-$amount-due-for-consultation -cash-account# -cash-account-balance On Balboa Island near San Diego, in the shadow of the famous Hotel Del Coronado, where Marilyn Monroe starred in one of her most famous roles in Some Like It Hot, lies a unique beauty salon called Marilyn Monroe Makeovers or MMM for short. MMM's founders, Lucy and Ethel, got the idea for their business from TV talk shows where they observed that ordinary people delighted in letting a team of beauty consultants "make them over" in a new image by changing their hair, their grooming, their cosmetics, their clothes, and sometimes even their demeanor. Lucy and Ethel at first targeted only women who wanted to look and feel like Marilyn Monroe for their business, but they discovered over time that there was a market for men also who wanted to be made over in the image of some of the men in Marilyn's life like Arthur Miller, Joe DiMaggio, or Clark Gable. Based on their robust business in Southern California, they were thinking of expanding to other locations (like Michigan and Wisconsin) and even to other stars (like Claudette Colbert and Audrey Hepburn), but for the present, their booming Balboa business took all their energies. MMM grossed over ten million dollars and employed more than 50 people. When MMM first does a makeover for a client, they assign a client# and note the person's address, and telephone#. Clients can either pay for all consultations received in a particular month on the 20th of the following month or they can spread their payments for each consultation over three months. Makeover consultations last 1-5 hours and are always finished on one day. When clients leave the shop, they are given remittance advices for their payments which they mail back in with their checks. Repeat business is a major part of the MMM marketing plan, and many clients use MMM multiple times, although Lucy and Ethel's exorbitant price structures do encourage them to use other establishments for more routine beauty and grooming services. Sometimes for marketing purposes, MMM relates one consultation to a single other that caused it (like a "Joe DiMaggio" who wants to match his "Marilyn"), but this is only done in 20-30 % of the cases, and payments are always tracked by individual consultation. A consultation is always directed by one employee who plans the makeover and performs some or all of the work. This "director" is assisted by 1-3 other employees in about 70% of the consultations. Employees often serve as both directors and assistants on a given day, depending upon the flow of customers. For costing and quality control purposes, MMM notes the directing or assisting roles and times of each person who works on a particular makeover. Consultations come in various types, ranging from the "Major Marilyn Makeover" to the "Joe DiMaggio Haircut and Trim." Each consultation type has a standard base fee to which is added the labor and product costs needed to make that individual consultation successful. At present, MMM offers 17 of these types, but that number goes up and down based upon fashion and fads. Lucy and Ethel figure out the composition of a new consultation type before they offer it. Product costs involving items such as cosmetics, clothing, jewelry, wigs, hairpieces, Marilyn paraphernalia, etc. are incurred in over 90% of the consultations, and MMM tracks them in detail because consultation directors are paid commissions on them. Obviously, directors push as many products as they can on to each client, although some clients resist products altogether. Products are never sold without consultations. Products are purchased from various vendors around the country. Each product type is given a product# and is usually supplied by multiple people. Before any purchases take place with a vendor, that supplier is asked to provide an undiscounted price quote for each item they intend to supply to MMM. Buying employees negotiate quantity discounts for all the different products on each purchase separately, and MMM tries to buy in large lots if they feel they can anticipate a need for "hot items." Purchase payment terms depend upon the vendor and range from all payments due at the end of the next month to one-year installments. Lucy and Ethel use multiple cash accounts for their receipts and disbursements, although each transaction involves just one account. Buyers are often the same people who do the makeovers, and MMM does not distinguish between these different types of employee. HINT: italic relational hint; bold-orphan attribute; underline-type attribute REQUIRED: Using the attributes below (don't add or subtract), build a data model (classes, associations, attributes, multiplicities) and a minimal relational database for MMM. Also, diagram as complete a value chain as you can for MMM given its minimal description (just two business processes). -check# -purchase-order# -undiscounted-price-quote -vendor-address -employee-name -client# -individual-accounts-payable -base-consultation-fee -consultation# -disbursement-voucher# -disbursement-amount -consultation-actual-length -quantity-of-product-purchased -consultation-type -employee#-for-this-cash-transaction -remittance-advice# -consultation-projected-length -product-description -YTD-sales-of-this-consultation-type -client-address -time-spent-on-makeover-by-director -purchase-order-Samount -client-check# -product# -vendor# -receipt-amount -employee# -individual-accounts-receivable -actual-unit-cost-of-purchased-item -client-tel# -quantity-of-product-used -account#-for-this-client-payment -time-spent-on-makeover-by-assisting-employee -total-$amount-due-for-consultation -cash-account# -cash-account-balance
Expert Answer:
Answer rating: 100% (QA)
Based on the given information here is a proposed data model for MMM Classes Client Employee Consultation ConsultationType Product Vendor PurchaseOrder CashTransaction Account Associations Client 1 Co... View the full answer
Related Book For
Principles of Information Systems
ISBN: 978-0324665284
9th edition
Authors: Ralph M. Stair, George W. Reynolds
Posted Date:
Students also viewed these accounting questions
-
In Exercise 6.1-7, lead concentrations near the San Diego Freeway in 1976 are given. During the fall of 1977, the weekday afternoon lead concentrations (in g/m3) at the measurement station near the...
-
In 1997, Isbell purchased a building in San Diego with the intent to open an adult entertainment establishment there. Because this building was located within 1,000 feet of a residential area,...
-
4. This problem investigates nearest neighbor and bilinear interpolation. For simplicity, we will focus on estimating the image intensity at a single location. Interpolation is used when transforming...
-
Discuss the elements necessary to conduct good advertising testing research.
-
If a typical comet nucleus were to split apart while in the inner Solar System (i.e. when it is undergoing significant heating from the Sun), why might we expect to see an outburst of cometary...
-
In which engine values are used? (a) Two-stroke engine (b) Four-stroke engine (c) In both engines (d) None of the above
-
Growth Companys current share price is $20 and it is expected to pay a $1 dividend per share next year. After that, the firms dividends are expected to grow at a rate of 4% per year. a. What is an...
-
Calculate and report the classification accuracy for the given confusion matrix. 215 0 2 0 5 2 224 0 135 34 0 2 40 211 0 16 368 1 0 12 397 1 0 2 458 0 0 461 3 0 1 20 183 183 30 237 36 219 o 187 419...
-
The bookkeeper of Butterfly Co. gathered the following data from individual employee earnings records and daily time cards. Your task is to complete a payroll register on August 8. Assume the...
-
Ethylene dichloride is produced by the direct chlorination of ethylene using small amounts of ethylene dibromide as a catalyst: C 2 H 4 + Cl 2 = C 2 H 4 Cl 2 If stoichiometric amounts of ethylene and...
-
Lululemon is considering a new project that improves inventory management for the next 5 years. The project has similar risks as the overall firm. The new technology will require an investment in...
-
what are some of the requirements of hospice social worker Explain with Example
-
As the civil aviation and aerospace industries become more global in reach, the lives of people residing in impoverished nations may be affected very differently from those residing in developed...
-
Questions for Figure 7 What are the measures of the angles below? Angle AOB Angle AEC Angle AOC Angle COD Angle AEO Questions for Figure 9 What important conclusions can you make? List 2 important...
-
The Art Exchange sells art supplies at retail. On December 31, 20X0, the Art Exchange receives a check for $1,000 for supplies which it has in inventory. These are shipped on January 3, 20X1. When...
-
Given the following Income Statement Information: Consolidated Income Statement - USD ($) $ in Millions Operating Revenue: $ 18,827 Cost of Revenue: $ 8,405 General & Admin: $1,831 Selling Expense:...
-
Explain how the graph of each function can be obtained from the graph of y = 1/x or y = 1/x 2 . Then graph f and give the (a) Domain (b) Range. Determine the largest open intervals of the domain over...
-
Assume that you want to start a new video rental business for students at your college or university. Go through logical design for a new information system to help you keep track of the videos in...
-
(a) You have been hired as a project manager to develop a new Web site in the next six months for a store that sells music and books online. Describe how project management tools, such as a Gantt...
-
Identify four complications that multinational corporations must address in planning, building, and operating their ERP systems.
-
At 30 June 2024, the accountant for Woodbine Construction, Mary Ellam, is preparing the financial statements for the year ended on that date. To calculate the annual leave payable, the accountant had...
-
How would each of the following liabilities be classified (current, non-current, or both) at the end of the financial year? Unearned revenue Accrued expenses Provision for warranty repair costs...
-
The following were among transactions of Everluck Enterprises Ltd during the financial years ending 30 June 2023 and 30 June 2024. Required Record in general journal form all the above transactions,...
Study smarter with the SolutionInn App