Question: In this assignment, you will develop a simple relational database system for the manufacturing process of Electric Controls Company, the firm for which we develop

In this assignment, you will develop a simple relational database system for the manufacturing process of Electric Controls Company, the firm for which we develop a simple relational database system for its purchasing process. You will complete the system using Microsoft Access. Different from many other assignments, this Access Assignment has three stages and you are required to turn in your work in different stages. By reviewing your work in different stages, we will ensure your progress of the assignment and the quality of the final system. The Narrative of ECC Manufacturing Process: Electric Controls Company (ECC) manufactures custom electric control panels for industrial customers. ECC buys components of the control panels, and then has its employees assemble them into finished goods. ECC tracks the direct materials and direct labor to jobs. Also, in the manufacturing (conversion) process, overhead costs are incurred. ECC applies these overhead costs to jobs based on direct labor hours. ECC's estimated manufacturing overhead cost to be $78,000 and direct labor hours to be 4,800 hours. ECC creates a job record for each control panel or set of control panels that a customer orders. Each job can use many direct material items and can incur many

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!