Examlex

Solved

Integrated Case Combining Both Sales and Purchases Processes

question 6

Essay

Integrated Case combining both sales and purchases processes.
Background: When Arnold retired from politics after the state budget crises of 2008,2009,and 2010 he found that the downturn in the overall economy had affected his retirement plans.Plus,he needs money for his divorce from Maria while his new movies are still in production.So,he decided to open a unique health spa that will cater to movie stars and other wealthy clients.Taking advantage of the historically low mortgage rates,he acquired an impressive estate in Rancho Palos Verdes overlooking the Pacific Ocean and converted it into an expensive spa.After some extensive market research and a number of personal visits to other spas (it was a tough job but someone had to do it),he opened Arnold's California Spa offering a variety of activities (such as golf,Pilates,yoga,massage,mud baths,aerobics,weight lifting,dodge ball,etc.)so clients have the option of either 1)getting physically fit with the latest in exercise technology or 2)just relaxing in luxury.His spa quickly became extremely successful and he plans to expand to other cities.Arnold realizes that his business needs an accounting system,and he has asked you to analyze his requirements and help him design a system that can grow along with his business.
Arnold's business requirements: During your interview with Arnold,he describes his business requirements for his purchasing and sales processes as follows:
Spa Packages.We offer our clients a selection of spa packages that changes according to the time of year and customer demand.For example,we might offer the Spring Getaway Package,the Relaxing Escape from the Economy Package,the Pure Indulgence Package,the Sports Package,and the Steroid-Free Bodybuilding Package.Each package includes several activities,such as weight lifting,aerobics,Pilates,mountain biking,yoga,tennis,golf,various skin care therapies,hydrotherapies,body therapies,and massage.
The price of each spa package depends on the specific activities included in the package.For example,the Steroid-Free Bodybuilding Package includes weight lifting,yoga,dodge ball,and scientifically designed ice baths to restore the muscles.Each activity could appear multiple times in each spa package,for example we could include two rounds of golf in one package.Of course,each activity is included in multiple spa packages.
We set the price of each spa package by first determining what we want to charge for each of the activities depending on the time of year,the products used in the activity,and expected popularity.We then add up the charges for each activity to form the overall price for the spa package; however,the clients only see one single price for the whole package.To monitor profitability,we track year-to-date sales information for each activity included in any spa package.
Sales process (spa visits): Arnold's California Spa emphasizes customer service,of course.Each client makes reservations in advance,and one reservation could schedule several future spa visits (each individual spa visit involves only one spa package,but the client could select a different spa package for each visit).When the client arrives for a spa visit,we assign one of our employees to be responsible for the client and direct all the client's activities for that visit.This responsibility only applies to the specific visit.Other employees will also be involved in the spa visit depending upon the activities included in the specific spa package that the client selected.For example,the visit director may conduct a golf lesson for the client while an assisting employee may provide a therapeutic massage for the client's guest (to maintain appropriate discretion,we don't track clients' guests).We expect our employees to provide the highest quality customer service and we plan to hold them accountable.Since all of our employees will be able to be visit directors,we want to track who directs and who assists with each specific visit as well as the number of hours they spend with the client.
Since most clients love their experience and want to return,we offer them an opportunity to become members of Arnold's Entourage.Entourage members earn membership rewards based on the number of visits and the amounts spent.Entourage members also get priority reservations and can pay for visits over time with regular monthly payments,where the number of payments depends on their membership group: bronze,silver,or gold.Since an Entourage member could visit several times while also making payments for prior visits,each client payment could apply to several spa visits.Clients that are not Entourage members must pay for each spa visit in full at the time of the visit.To plan for future marketing,we track year-to-date spending for each combination of Entourage Group and activity,so we can see which activities appeal to which membership group.
Product Inventory and purchasing.We maintain an inventory of products-such as sports gear,towels,robes,shampoos,golf balls,body-wrap material,seaweed,massage oils,bodybuilding supplements,raw fruit juices,and vitamins- that we use in the spa visits.We record the quantity and cost of each product used in a spa visit as well as the total costs for each visit to determine profitability.For planning,we also track which products are used in each activity,although many products are used in multiple activities.We estimate the quantity and cost of each product used in each activity,which then allows us to estimate the overall cost of each activity,so we can decide what to charge for the activity when it is offered in any spa package.
We buy our products from a number of vendors.We've already worked out agreements for them to deliver products on a regular basis.We record purchases by purchase number when they deliver the products.All our vendors require payment in full within 30 days after we receive the products,but depending on timing,we may issue one check to pay for multiple purchases from a vendor.
Other information.We record information about activities before they are offered in any spa package,and we add new spa packages before any client purchases them.We have a payroll service that handles all our payroll needs,so you don't need to consider payroll in your analysis.We assign each employee an employee number and a job title,like "master masseuse","yoga instructor supervisor","hair styling specialist" and "the guy who will pump you up." However,every employee can perform several different jobs at the spa,so we keep all the employee information in one set of records.We only use the title to impress our clients and not for any real business purpose (we don't categorize employees by employee types).We record information about all agents,resources,and type images before they are linked to other classes.
REQUIRED: 1)use the information above and the list of attributes below to draw a UML class diagram showing the classes,associations,and multiplicities,2)prepare a listing of the tables necessary to support Arnold's California Spa processes using all the attributes.Name each table and clearly identify primary keys with PK and foreign keys with FK.List your tables in the following order: RESOURCES,EVENTS,AGENTS,TYPE IMAGES,and LINKING.Use only the following list of attributes (remember that there should be no classes without attributes).
Integrated Case combining both sales and purchases processes. Background: When Arnold retired from politics after the state budget crises of 2008,2009,and 2010 he found that the downturn in the overall economy had affected his retirement plans.Plus,he needs money for his divorce from Maria while his new movies are still in production.So,he decided to open a unique health spa that will cater to movie stars and other wealthy clients.Taking advantage of the historically low mortgage rates,he acquired an impressive estate in Rancho Palos Verdes overlooking the Pacific Ocean and converted it into an expensive spa.After some extensive market research and a number of personal visits to other spas (it was a tough job but someone had to do it),he opened Arnold's California Spa offering a variety of activities (such as golf,Pilates,yoga,massage,mud baths,aerobics,weight lifting,dodge ball,etc.)so clients have the option of either 1)getting physically fit with the latest in exercise technology or 2)just relaxing in luxury.His spa quickly became extremely successful and he plans to expand to other cities.Arnold realizes that his business needs an accounting system,and he has asked you to analyze his requirements and help him design a system that can grow along with his business. Arnold's business requirements: During your interview with Arnold,he describes his business requirements for his purchasing and sales processes as follows: Spa Packages.We offer our clients a selection of spa packages that changes according to the time of year and customer demand.For example,we might offer the Spring Getaway Package,the Relaxing Escape from the Economy Package,the Pure Indulgence Package,the Sports Package,and the Steroid-Free Bodybuilding Package.Each package includes several activities,such as weight lifting,aerobics,Pilates,mountain biking,yoga,tennis,golf,various skin care therapies,hydrotherapies,body therapies,and massage. The price of each spa package depends on the specific activities included in the package.For example,the Steroid-Free Bodybuilding Package includes weight lifting,yoga,dodge ball,and scientifically designed ice baths to restore the muscles.Each activity could appear multiple times in each spa package,for example we could include two rounds of golf in one package.Of course,each activity is included in multiple spa packages. We set the price of each spa package by first determining what we want to charge for each of the activities depending on the time of year,the products used in the activity,and expected popularity.We then add up the charges for each activity to form the overall price for the spa package; however,the clients only see one single price for the whole package.To monitor profitability,we track year-to-date sales information for each activity included in any spa package. Sales process (spa visits): Arnold's California Spa emphasizes customer service,of course.Each client makes reservations in advance,and one reservation could schedule several future spa visits (each individual spa visit involves only one spa package,but the client could select a different spa package for each visit).When the client arrives for a spa visit,we assign one of our employees to be responsible for the client and direct all the client's activities for that visit.This responsibility only applies to the specific visit.Other employees will also be involved in the spa visit depending upon the activities included in the specific spa package that the client selected.For example,the visit director may conduct a golf lesson for the client while an assisting employee may provide a therapeutic massage for the client's guest (to maintain appropriate discretion,we don't track clients' guests).We expect our employees to provide the highest quality customer service and we plan to hold them accountable.Since all of our employees will be able to be visit directors,we want to track who directs and who assists with each specific visit as well as the number of hours they spend with the client. Since most clients love their experience and want to return,we offer them an opportunity to become members of Arnold's Entourage.Entourage members earn membership rewards based on the number of visits and the amounts spent.Entourage members also get priority reservations and can pay for visits over time with regular monthly payments,where the number of payments depends on their membership group: bronze,silver,or gold.Since an Entourage member could visit several times while also making payments for prior visits,each client payment could apply to several spa visits.Clients that are not Entourage members must pay for each spa visit in full at the time of the visit.To plan for future marketing,we track year-to-date spending for each combination of Entourage Group and activity,so we can see which activities appeal to which membership group. Product Inventory and purchasing.We maintain an inventory of products-such as sports gear,towels,robes,shampoos,golf balls,body-wrap material,seaweed,massage oils,bodybuilding supplements,raw fruit juices,and vitamins- that we use in the spa visits.We record the quantity and cost of each product used in a spa visit as well as the total costs for each visit to determine profitability.For planning,we also track which products are used in each activity,although many products are used in multiple activities.We estimate the quantity and cost of each product used in each activity,which then allows us to estimate the overall cost of each activity,so we can decide what to charge for the activity when it is offered in any spa package. We buy our products from a number of vendors.We've already worked out agreements for them to deliver products on a regular basis.We record purchases by purchase number when they deliver the products.All our vendors require payment in full within 30 days after we receive the products,but depending on timing,we may issue one check to pay for multiple purchases from a vendor. Other information.We record information about activities before they are offered in any spa package,and we add new spa packages before any client purchases them.We have a payroll service that handles all our payroll needs,so you don't need to consider payroll in your analysis.We assign each employee an employee number and a job title,like master masseuse , yoga instructor supervisor , hair styling specialist and the guy who will pump you up. However,every employee can perform several different jobs at the spa,so we keep all the employee information in one set of records.We only use the title to impress our clients and not for any real business purpose (we don't categorize employees by employee types).We record information about all agents,resources,and type images before they are linked to other classes. REQUIRED: 1)use the information above and the list of attributes below to draw a UML class diagram showing the classes,associations,and multiplicities,2)prepare a listing of the tables necessary to support Arnold's California Spa processes using all the attributes.Name each table and clearly identify primary keys with PK and foreign keys with FK.List your tables in the following order: RESOURCES,EVENTS,AGENTS,TYPE IMAGES,and LINKING.Use only the following list of attributes (remember that there should be no classes without attributes).

Identify the role of auditing standards and the standard of care expected from professionals.
Comprehend the concept of privity and its implications for professional liability.
Recognize the significance of the Sarbanes-Oxley Act of 2002 for accountants and auditors.
Understand the ownership and confidentiality of work papers and documents in the professional context.

Definitions:

Donee Beneficiary

A third party who benefits from a contract, although not one of the principals to the contract.

Uniform Commercial Code

A comprehensive set of laws governing commercial transactions in the United States, intended to standardize legal statutes across states.

Sale of Goods

A transaction where the ownership of tangible personal property is transferred from one party to another, usually in exchange for a price.

Writing

The act or process of composing text or creating a written record of thoughts, information, or transactions.

Related Questions

Q6: Integrated Case combining both sales and purchases

Q9: Identify the classes and associations in the

Q10: Correct the BPMN Activity Diagram<br>After a very

Q30: Even though women represent more than half

Q42: With the term sex,anthropologists are referring to

Q45: In Spanish-speaking Latin America,social scientists and politicians

Q45: The reason there are more modern-day "Rosie

Q54: Understanding kinship systems is an important part

Q55: The American Institute of Certified Public Accountants

Q68: The influential sociologist Max Weber defined which