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...
-
A mass of 15 kg of air in a piston - cylinder device is heated from 25 to 77oC by passing current through a resistance heater inside the cylinder. The pressure inside the cylinder is held constant at...
-
What is the maximum angular momentum L max that an electron with principal quantum number n = 5 can have? Express your answer in units of h .
-
Consider the statement Customer complaints are customer opportunitiesbut only if we know about them. Do you agree or disagree? Why?
-
Production managers and marketing managers are like oil and water. They just dont mix, how can a budget assist in reducing battles between these two areas?
-
During 2021, Albert redeems Series EE savings bonds for $6,000 - - consisting of $2,000 interest and $4,000 principal. Albert has net qualifying education expenses of $5,000 in 2021. Albert, a single...
-
Ralph usually buys one pizza and two colas from the local pizzeria. The pizzeria announces a special: All pizzas after the first one is half-price. Show the original and new budget lines. What can...
-
On January 1, 2011, Price Company purchased an 80% interest in the common stock of Stahl Company for $1,040,000, which was $60,000 greater than the book value of equity acquired. The difference...
-
What is the standard in the law for the court to determine who will have parenting time or custody of a child and decision making authority?
-
In what ways do digital technologies and social media platforms reshape traditional modes of social interaction, and how do these changes impact individuals' social behaviors and psychological...
-
Family Courts are often seen as a 'legacy of feminist activism'. However, they have failed to be truly feminist spaces. Would you agree with this statement?
-
The balance sheet of Mega Company includes the following accounts: Accounts Receivable $25,000, Goodwill $7,000, Furniture $5,000, Cash $8,000, Supplies $11,000, Equipment $14,000, patents $3,000 and...
-
Using the Indiana Code section that discusses our state's custody provisions. Is domestic violence a factor to be considered? If so, how?
-
Consider a call option and put option on the same underlying stock with the same exercise price and time to maturity. The call price is $2.59, the underlying stock price is $28.63, the exercise price...
-
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.
-
(a) The following trial balance was extracted from the books of M. Jackson on 30 April 2017. From it, and the note below it, prepare his statement of profit or loss for the year ending 30 April 2017,...
-
On 1 April 2013 a business purchased a machine costing 112,000. The machine can be used for a total of 20,000 hours over an estimated life of 48 months. At the end of that time the machine is...
-
On 1 January 2015 a business purchased a laser printer costing 1,800. The printer has an estimated life of four years after which it will have no residual value. It is expected that the output from...
Study smarter with the SolutionInn App