UML/REA diagram, table listings, and BPMN diagrams.

Ralph Wilson started his machine shop in Santa Ana, CA with a small business loan about 10 years ago. Since then, he has built a thriving business making products for companies such as Boeing, Walt Disney Corporation, and several others. This case describes the process by which Wilson Precision Products (WPP) converts a variety of materials into finished products. Although WPP sells its finished products to customers and purchases its materials from vendors, those processes are not part of this case.

Production. After WPP receives an order from a customer, Ralph or another supervisor signs one production order for each finished product that the customer ordered. This starts the production process. The inventory manager checks the bill of materials for that finished product and prepares one or more materials issue lists depending on when the materials are needed. For some products, materials are issued multiple times, since not everything is needed at once. The manager then removes the materials from their designated bins and gets them ready for use in production.

As soon as the materials are available, WPP manufacturing employees begin production following the labor plan. Production usually involves cutting, treating, machining, assembly, testing, etc., but the specific steps depend on the particular finished product. Precision machining is characterized by the tight tolerances for hard-to-machine materials, so WPP only allows qualified employees to work on each step. Employees scan their ID cards to record when they start and end work on each production labor step. When production finishes, the finished products are placed on designated racks. Each rack holds one finished product so WPP can plan for packaging and delivery. Of course, some racks can be empty while waiting for new finished products and some finished products with zero quantity on hand will not be on racks.

Inventories. WPP maintains a materials inventory required for manufacturing its finished products. The materials inventory includes both metallic and non-metallic materials. Materials typical of aerospace machining include lightweight aluminum for structural members; hard and temperature-resistant metals including titanium and Inconel alloys for engine parts; and carbon-fiber composites that are both hard and lightweight for outer skins. For other customers such as theme parks, WPP works with both common and engineering thermoplastics as well as advanced, expensive thermoset laminates. Additionally, some government customers need products that require composite materials such as carbon fiber reinforced plastic (CFRP), Kevlar and quartz-epoxy composite. WPP tracks its materials inventory by material # and each material is placed in a separate bin for ease of access.

WPP also maintains an inventory of finished products, but in most cases, it only produces those products after it receives a firm order from a customer. It tracks its finished products by product #. Over time, WPP works with its customers to develop precise specifications for each finished product. From those specifications, WPP creates a bill of materials that itemizes the materials necessary to create each finished product. The bill of materials specifies the quantity, quality, structural integrity, etc. of each material used for that finished product. Some materials are used in several finished products, and each finished products uses one or more materials.

Production planning. Over time, WPP has developed precise labor plans for constructing each finished product and controlling its labor costs. It implemented its labor plans as a series of control cards for each step in the production process. Each labor plan step is assigned a labor plan control #. The labor plan specifies the type of employee that will execute each step, the number of hours required, and the standard labor rate. Each labor plan step involves only one type of employee. WPP creates new finished products first and then develops the labor plan for each product.

Miscellaneous. WPP keeps all employee records in one class. Employee information is recorded before employees they issue production orders, issue material, or work in production. It categorizes employees based on their qualifications to perform particular jobs in the production process. It records materials in its inventory records before they are first issued. It records each finished product in its inventory records before it is first produced. There are some employee types that are not yet specified in labor plans. There are some employee types for which there are no qualified employees, yet.

Question 1.

Create UML and REA diagram, as well as BPMN diagrams based on the information provided. List all the relational tables

ACCT 480 Wilson Precision Products Ralph Wilson started his machine shop in Santa Ana, CA with a small business loan about 10 years ago. Since then, he has built a thriving business making products for companies such as Boeing, Walt Disney Corporation, and several others. This case describes the process by which Wilson Precision Products (WPP) converts a variety of materials into finished products. Although WPP sells its finished products to customers and purchases its materials from vendors, those processes are not part of this case. Production. After WPP receives an order from a customer, Ralph or another supervisor signs one production order for each finished product that the customer ordered. This starts the production process. The inventory manager checks the bill of materials for that finished product and prepares one or more materials issue lists depending on when the materials are needed. For some products, materials are issued multiple times, since not everything is needed at once. The manager then removes the materials from their designated bins and gets them ready for use in production. As soon as the materials are available, WPP manufacturing employees begin production following the labor plan. Production usually involves cutting, treating, machining, assembly, testing, etc., but the specific steps depend on the particular finished product. Precision machining is characterized by the tight tolerances for hard-to-machine materials, so WPP only allows qualified employees to work on each step. Employees scan their ID cards to record when they start and end work on each production labor step. When production finishes, the finished products are placed on designated racks. Each rack holds one finished product so WPP can plan for packaging and delivery. Of course, some racks can be empty while waiting for new finished products and some finished products with zero quantity on hand will not be on racks. Inventories. WPP maintains a materials inventory required for manufacturing its finished products. The materials inventory includes both metallic and non-metallic materials. Materials typical of aerospace machining include lightweight aluminum for structural members; hard and temperature-resistant metals including titanium and Inconel alloys for engine parts; and carbon-fiber composites that are both hard and lightweight for outer skins. For other customers such as theme parks, WPP works with both common and engineering thermoplastics as well as advanced, expensive thermoset laminates. Additionally, some government customers need products that require composite materials such as carbon fiber reinforced plastic (CFRP), Kevlar and quartz-epoxy composite. WPP tracks its materials inventory by material # and each material is placed in a separate bin for ease of access. WPP also maintains an inventory of finished products, but in most cases, it only produces those products after it receives a firm order from a customer. It tracks its finished products by product #. Over time, WPP works with its customers to develop precise specifications for each finished product. From those specifications, WPP creates a bill of materials that itemizes the materials necessary to create each finished product. The bill of materials specifies the quantity, quality, structural integrity, etc. of each material used for that finished product. Some materials are used in several finished products, and each finished products uses one or more materials. Production planning. Over time, WPP has developed precise labor plans for constructing each finished product and controlling its labor costs. It implemented its labor plans as a series of control cards for each step in the production process. Each labor plan step is assigned a labor plan control #. The labor plan specifies the type of employee that will execute each step, the number of hours required, and the standard labor rate. Each labor plan step involves only one type of employee. WPP creates new finished products first and then develops the labor plan for each product. Miscellaneous. WPP keeps all employee records in one class. Employee information is recorded before employees they issue production orders, issue material, or work in production. It categorizes employees based on their qualifications to perform particular jobs in the production process. It records materials in its inventory records before they are first issued. It records each finished product in its inventory records before it is first produced. There are some employee types that are not yet specified in labor plans. There are some employee types for which there are no qualified employees, yet. Question 1. Create UML and REA diagram, as well as BPMN diagrams based on the information provided. List all the relational tables