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. 

 

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

Answer rating: 100% (QA)

Relational Tables Employees Materials Inventory Orders Production EXPLANATION The RE... View the full answer