ACCOUNTING INFORMATION SYSTEMS DATA MODEL (REA) EXERCISE | Beach Dental Case (Conversion Process) Beach Dental Instruments,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ACCOUNTING INFORMATION SYSTEMS DATA MODEL (REA) EXERCISE | Beach Dental Case (Conversion Process) Beach Dental Instruments, Inc. (BDI) manufactures dental instruments, such as inspection mirrors, picks, scalars. Their superior technicians manufacture surgical quality dental instruments using advanced production techniques. This case describes their conversion process. Materials inventory. BDI maintains an inventory of highest quality steel rods, bars, glass mirrors, etc. They track their materials inventory by material number. Of course, they also closely track which materials are used to create each dental instrument, although most materials can be used in several instruments (and each instrument uses several materials). Instruments inventory. BDI offers an extensive catalog of dental instruments, including diagnostic, periodontal, implant, endodontic, operative, elevators, forceps, crown, orthodontic, and surgery instruments. They maintain inventory levels to meet the demand for their highest moving instruments, but they only maintain minimal quantities on hand of their slower selling instruments. Instrument manufacturing process. Since BDI builds to inventory, they carefully track the quantity on hand of each instrument. A BDI supervisor signs the production order to authorize production of that instrument when the quantity on hand drops below designated minimum levels. Then, a BDI inventory manager issues the materials necessary to manufacture the ordered quantity of that instrument. Next, the skilled BDI technicians craft the instruments according to the labor plan for that instrument. The labor plan for each instrument describes the sequence of labor operations, the expected labor hours for each labor operation, and the type of employee for each labor operation. When all labor operations are complete, the instruments are placed in inventory and the production order is updated. BDI technicians. BDI tracks its technicians by employee number. All employees are modeled as one class. Each technician is assigned to a supervisor and classified by type of technician, e.g., assembler, nachinist, polisher, glass cutter General. BDI adds information about agents, resources, and type images before those classes are connected to other classes. REQUIRED. Using the narrative and the attributes below, prepare: ACCOUNTING INFORMATION SYSTEMS DATA MODEL (REA) EXERCISE | Beach Dental Case (Conversion Process) a) REA diagram (classes, associations, and multiplicities) and define the relational tables (list the tables with all their attributes, underline the primary keys, and indicate the foreign keys with an asterisk). Complete the table definitions using only the listed attributes (remember that there should be no entities without attributes). You may abbreviate attribute names if the abbreviation is clear. List the tables in the following order: Resources, Events, Agents, Types, and Linking tables. b) BPMN activity diagram with one pool for the BDI conversion process and swimlanes for 1) supervisors, 2) inventory managers, and 3) technicians. Attributes Average pay for employees of this type Employee hire date Employee hourly pay Employee name Employee number (emp #) Employee type Instrument catalog number (cat #) Instrument description Instrument minimum quantity Instrument price Instrument quantity on hand Labor operation date Labor operation number (labor op #) Labor operation time Labor plan number (plan #) Labor plan standard hours Material description Material issue date Material issue number (issue #) Material issue time Material number (matl #) Material quantity on hand Material standard cost Number of employees of this type Number of hours for this technician on this labor operation Production completion date/time Production order date Production order number (prod #) Quantity of this instrument ordered on this production order Quantity of this material issued on this issue Quantity of this material used in this instrument Supervisor employee number Total actual labor cost for this production order ACCOUNTING INFORMATION SYSTEMS DATA MODEL (REA) EXERCISE | Beach Dental Case (Conversion Process) Beach Dental Instruments, Inc. (BDI) manufactures dental instruments, such as inspection mirrors, picks, scalars. Their superior technicians manufacture surgical quality dental instruments using advanced production techniques. This case describes their conversion process. Materials inventory. BDI maintains an inventory of highest quality steel rods, bars, glass mirrors, etc. They track their materials inventory by material number. Of course, they also closely track which materials are used to create each dental instrument, although most materials can be used in several instruments (and each instrument uses several materials). Instruments inventory. BDI offers an extensive catalog of dental instruments, including diagnostic, periodontal, implant, endodontic, operative, elevators, forceps, crown, orthodontic, and surgery instruments. They maintain inventory levels to meet the demand for their highest moving instruments, but they only maintain minimal quantities on hand of their slower selling instruments. Instrument manufacturing process. Since BDI builds to inventory, they carefully track the quantity on hand of each instrument. A BDI supervisor signs the production order to authorize production of that instrument when the quantity on hand drops below designated minimum levels. Then, a BDI inventory manager issues the materials necessary to manufacture the ordered quantity of that instrument. Next, the skilled BDI technicians craft the instruments according to the labor plan for that instrument. The labor plan for each instrument describes the sequence of labor operations, the expected labor hours for each labor operation, and the type of employee for each labor operation. When all labor operations are complete, the instruments are placed in inventory and the production order is updated. BDI technicians. BDI tracks its technicians by employee number. All employees are modeled as one class. Each technician is assigned to a supervisor and classified by type of technician, e.g., assembler, nachinist, polisher, glass cutter General. BDI adds information about agents, resources, and type images before those classes are connected to other classes. REQUIRED. Using the narrative and the attributes below, prepare: ACCOUNTING INFORMATION SYSTEMS DATA MODEL (REA) EXERCISE | Beach Dental Case (Conversion Process) a) REA diagram (classes, associations, and multiplicities) and define the relational tables (list the tables with all their attributes, underline the primary keys, and indicate the foreign keys with an asterisk). Complete the table definitions using only the listed attributes (remember that there should be no entities without attributes). You may abbreviate attribute names if the abbreviation is clear. List the tables in the following order: Resources, Events, Agents, Types, and Linking tables. b) BPMN activity diagram with one pool for the BDI conversion process and swimlanes for 1) supervisors, 2) inventory managers, and 3) technicians. Attributes Average pay for employees of this type Employee hire date Employee hourly pay Employee name Employee number (emp #) Employee type Instrument catalog number (cat #) Instrument description Instrument minimum quantity Instrument price Instrument quantity on hand Labor operation date Labor operation number (labor op #) Labor operation time Labor plan number (plan #) Labor plan standard hours Material description Material issue date Material issue number (issue #) Material issue time Material number (matl #) Material quantity on hand Material standard cost Number of employees of this type Number of hours for this technician on this labor operation Production completion date/time Production order date Production order number (prod #) Quantity of this instrument ordered on this production order Quantity of this material issued on this issue Quantity of this material used in this instrument Supervisor employee number Total actual labor cost for this production order
Expert Answer:
Answer rating: 100% (QA)
a REA Diagram Table Definitions Resources materials materialnumber PK materialdescription materialquantity materialstandardcost Events productionorder... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1118385388
2nd edition
Authors: Ramji Balakrishnan, Konduru Sivaramakrishnan, Geoff B. Sprinkle
Posted Date:
Students also viewed these accounting questions
-
As technology continues to progress, careers in accounting information systems are being created. For this discussion take a moment to explore some of the new career paths in accounting information...
-
I am including this case as it contains background information concerning Blockbuster from its inception through 2006. This case details the history of Blockbuster, the massive video rental chain,...
-
Diagram the answer to Exercise 15.13. (a) What is the a priori power of this experiment? (b) Run the t test on the data. (c) What, if anything, does the answer to (a) have to say about the answer to...
-
Gerald De Beer is a 38-year-old vibrant, outgoing young man who has been employed as a digital artist at Innovate Tech Solutions (Pty) Ltd ("Innovate Tech") since 1 May 2019. Details of Geralds...
-
What is meant by a one-sided versus two-sided message? Discuss some of the reasons marketers may or may not want to use a two-sided message.
-
Discuss the two potential dangers of strategic alliances and three ways that firms can protect themselves against these dangers.
-
Explain with a neat sketch the working of a centrifugal pump.
-
The T-accounts below summarize the ledger of Santana Landscaping Company at the end of its first month of operations. Instructions (a) Prepare the complete general journal (including explanations)...
-
15. Apply the implicit Runge-Kutta method (5.69) to the model problem Y' = XY, t 0, Y(0) = 1. (a) Show that the solution can be written as yn = [R(Ah)]" with R(z) = 1+ 1 - (b) For any real z < 0 show...
-
You have been hired to do the payroll for a small software development start-up company in Kanata, Ontario with 3 employees. This is one of several clients you have. The payroll must be done on...
-
Write ALL POSSIBLE outputs from the following multithreaded program (8pts). Explain your reasons (8pts). class Sum{ private int sum; public int getSum(){ } return sum; } public void setSum(int sum){...
-
Think of one event in Malaysia that has affected a group of community, and personally has affected you in particular for example covid 19 or else. What type of risks can you observe from this event?...
-
The Allen Corp. acquired inventory on account. Allens current ratio and quick ratio are both greater than 1-to-1. Required : What will be the immediate effect of this purchase of inventory on Allens ...
-
what are the factors affecting professional relationship ?
-
Taxpayers pay $8,000 in state income taxes and $4,000 in state sales taxes - Taxpayers pay $3,000 in real estate taxes on rental property they have invested for a profit - Taxpayers incur $4,000 in...
-
Consider the following organization. RentIT is an equipment rental company providing a wide range of construction equipment on demand, all the way from minor equipment items such as water pumps and...
-
For the remainder of this problem, we're going to analyze the average cost associated with different preventa- tive maintenance policies. Doing preventative maintenance costs cm =$50, while repairing...
-
Interview managers at three companies in your area about their use of ERP. How have their experiences been similar? What accounts for the similarities and differences?
-
Naomi Soderstrom sells over-boots for use in wintry conditions. Naomi's products, worn over shoes, provide traction on ice and packed snow, helping prevent falls. Naomi's income for her most recent...
-
Crystal Clear Pool Services maintains swimming pools. For the most recent year, Crystal budgeted to pay $8.00 per gallon of chlorine and to use gallon of chlorine per pool serviced. Crystal actually...
-
Refer to the data in Problem 4.54. As an alternative to the detailed account analysis, management at Comfort Pillows desires to use the high-low method to estimate the variable cost associated with...
-
What ideas do you have for a new business? How can you multiply the stimuli around these ideas to enhance them and identify attractive opportunities?
-
What do you really enjoy doing? What is your passion? Can your passion be a platform for a viable opportunity?
-
What do your friends and family envision you doing? What strengths and weaknesses do they observe? How do their insights help lead you to an opportunity that is right for you?
Study smarter with the SolutionInn App