Utica Lighting Company is a company manufacturing outdoor area lighting systems such as parks, trails, and public areas. Marketing the product to create a scene corporate or urban. ULC uses a centralized computer system with distributed terminals in every department. Often companies experience production delays and swelling cost. ULC employs auditing firms to access company operations and procedures internal control. The ULC Conversion System is triggered from the finished goods warehouse report. Warehouse clerk periodically reviews inventory records in search of goods that are running low on quantity. When the current inventory quantity in the finished goods warehouse drops below the required minimum, the warehouse clerk sends digital inventory status from warehouse terminals to production planning and control advises them to schedule production in phases of finished goods that are still questionable. Through acceptance of the report, the planning and control workers' section of the production accesses digital Material Lists and Production Line Documents for manufactured goods and additional details production into digital data production scheduling. The system automatically adds notes to Open Production Order file and send the digital document to the Work Center Supervisor Terminal and to the Terminal Cost Accounting officer. The Work Center Supervisor accesses the Work Order from his terminal and prints out a physical Transfer Ticket and Raw Material Purchase Requests for each stage of the production process. Production Workers take the Request for Purchase of Raw Materials from the Warehouse Officer and secure it Components, assembly parts and raw materials needed to carry out production tasks they. If there is an excess of raw materials exceeding the required standard amount, the supervisor will prepare additional Raw Material Purchase Requests. Workers also complete Work Time Tickets after each stage of the process to reflect on the time spent during processing. When Workers completing his task, he submitted a Transfer Ticket and Time Ticket to the Cost Accounting Department. Warehouse clerk receives a Request to Purchase Goods and releases the Goods to the production area. He then update the raw material inventory records and then send a Purchase Request Goods to the Cost Accounting Department. When Inventory Components, Parts and Raw Materials the amount drops to the point of Reorder, the warehouse clerk prepares a Purchase Order and sends it to Chosen Supervisor. The supervisor sends the raw material supplies directly to the warehouse room, which is deep at the same time the Warehouse Officer checks the item and updates the Digital Ledger Data Assistant for Raw Material Supplies. Every day the warehouse clerk makes journal vouchers and books them on the Raw Material Inventory Ledger Account. The Cost Accounting Officer receives a digital Work Order and starts creating a Work In Process account step by step. During the production process, the clerk receives a print of the Transfer Ticket, Request Purchases and Work Tickets from the Work Center, which the officer uses to update the Goods account In the process. When production is finished, the clerk closes the In-Process Goods account book gradually and sent to the Finished Goods inventory subsidiary ledger account. At the end of the day, the Cost Accounting officer prepares a digital journal voucher that presents the status Work-in-Process and any records moving from Work-in-Process to Inventory So. The clerk also records the voucher journal into the Goods in Process and Goods Ledger account So. Requested: a. Prepare a Data Flow Diagram of this system b. Prepare a Flowchart of this system c. Describe the Internal Control that

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 6P
icon
Related questions
Question

Utica Lighting Company is a company manufacturing outdoor area lighting systems such as
parks, trails, and public areas. Marketing the product to create a scene
corporate or urban. ULC uses a centralized computer system with distributed terminals
in every department. Often companies experience production delays and swelling
cost. ULC employs auditing firms to access company operations and procedures
internal control.
The ULC Conversion System is triggered from the finished goods warehouse report. Warehouse clerk periodically reviews
inventory records in search of goods that are running low on quantity. When the current inventory quantity
in the finished goods warehouse drops below the required minimum, the warehouse clerk sends
digital inventory status from warehouse terminals to production planning and control
advises them to schedule production in phases of finished goods that are still
questionable.
Through acceptance of the report, the planning and control workers' section of the production accesses
digital Material Lists and Production Line Documents for manufactured goods and additional details
production into digital data production scheduling. The system automatically adds notes to
Open Production Order file and send the digital document to the Work Center Supervisor Terminal
and to the Terminal Cost Accounting officer.
The Work Center Supervisor accesses the Work Order from his terminal and prints out a physical Transfer Ticket
and Raw Material Purchase Requests for each stage of the production process. Production Workers
take the Request for Purchase of Raw Materials from the Warehouse Officer and secure it
Components, assembly parts and raw materials needed to carry out production tasks
they. If there is an excess of raw materials exceeding the required standard amount, the supervisor will
prepare additional Raw Material Purchase Requests. Workers also complete Work Time Tickets
after each stage of the process to reflect on the time spent during processing. When Workers
completing his task, he submitted a Transfer Ticket and Time Ticket to the Cost Accounting Department.
Warehouse clerk receives a Request to Purchase Goods and releases the Goods to the production area. He
then update the raw material inventory records and then send a Purchase Request
Goods to the Cost Accounting Department. When Inventory Components, Parts and Raw Materials
the amount drops to the point of Reorder, the warehouse clerk prepares a Purchase Order and sends it to
Chosen Supervisor. The supervisor sends the raw material supplies directly to the warehouse room, which is deep
at the same time the Warehouse Officer checks the item and updates the Digital Ledger Data
Assistant for Raw Material Supplies. Every day the warehouse clerk makes journal vouchers and books them
on the Raw Material Inventory Ledger Account.
The Cost Accounting Officer receives a digital Work Order and starts creating a Work In Process account
step by step. During the production process, the clerk receives a print of the Transfer Ticket, Request
Purchases and Work Tickets from the Work Center, which the officer uses to update the Goods account
In the process. When production is finished, the clerk closes the In-Process Goods account book gradually
and sent to the Finished Goods inventory subsidiary ledger account.
At the end of the day, the Cost Accounting officer prepares a digital journal voucher that presents the status
Work-in-Process and any records moving from Work-in-Process to Inventory
So. The clerk also records the voucher journal into the Goods in Process and Goods Ledger account
So.
Requested:
a. Prepare a Data Flow Diagram of this system
b. Prepare a Flowchart of this system
c. Describe the Internal Control that is applied.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Types of Database Architectures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning