Test 3 Quizzes

Question 1

The reading mentioned several steps to cleaning your data. Which item below was not mentioned in the reading?

• Spell checking
• Removing duplicate rows
• Fixing dates and times
• Merging and splitting columns
• All the above were mentioned and discussed

Answer 1

All

Question 2

Which command removes the 7-bit ASCII space character (value 32) from text (i.e., which function removes spaces)?

• Clean
• Trim
• Substitute
• Replace

Answer 2

Trim

Question 3

Bill of materials

Answer 3

A list of the raw materials used to create a finished product

Question 4

Operations list

Answer 4

A document that lists the steps required to manufacture a finished good

Question 5

Lean manufacturing

Answer 5

A production planning technique that is an extension of the just-in-time inventory control method

Question 6

Master production schedule

Answer 6

A document that specifies how much of a finished good is to be produced during a specific time period

Question 7

Production order

Answer 7

A document that authorizes manufucture of a finished good

Question 8

Materials requisition

Answer 8

A document used to authorize removal of raw materials from inventory

Question 9

Move ticket

Answer 9

A document that tracks transfer of inventory from one work center to another

Question 10

Job-order costing

Answer 10

A cost accounting method that assigns costs to specific batches or production runs and is used when the product or service consists of uniquely identifiable items

Question 11

Throughput

Answer 11

A measure of the number of good units produced in a period of time

Question 12

Computer-integrated manufacturing

Answer 12

A term used to refer to the use of robots and other IT techniques as part of the production process

Question 13

The AIS compiles and feeds information among the business cycles. What is the relationship between the revenue and production cycles regarding the exchange of information?

• The production cycle sends cost of goods manufactured information back to the revenue cycle.
• The revenue cycle provides sales forecast and customer order information to the production cycle, but the production cycle sends information back to revenue about finished goods production.
• The revenue cycle receives information from the production cycle about raw materials needs.
• The production cycle does not exchange information with the revenue cycle.

Answer 13

The revenue cycle provides sales forecast and customer order information to the production cycle, but the production cycle sends information back to revenue about finished goods production.

Question 14

The bill of materials shows the __________ of each product component.

a. quantity required
b. part number and description
c. quantity ordered
d. both a and b

Answer 14

d. both a and b

Question 15

The second step in the production cycle is planning and scheduling. One of the methods of production planning is referred to as push manufacturing. This method is also known as 

• the economic order quantity (EOQ) system.
• just-in-time manufacturing system (JIT).
• manufacturing resource planning (MRP)
• ahead-of-time production implementation (ATPI).

Answer 15

manufacturing resource planning (MRP)

Question 16

What document authorizes the manufacturing of a product?

• move ticket
• materials requisition
• master production schedule
• production order

Answer 16

Production Order

Question 17

A __________ is used to document the subsequent relocation of materials through the factory for manufacturing in process.

• materials requisition
• production order
• master production schedule
• move ticket

Answer 17

move ticket

Question 18

Which type of information below should not be maintained by the AIS in accounting for fixed assets?

• identification/serial number
• improvements
• cost
• market value

Answer 18

market value

Question 19

Detailed data about warranty and repair costs is considered an applicable control used to mitigate the threat of 

• underproduction.
• overproduction.
• suboptimal investment of fixed assets.
• poor product design.

Answer 19

poor product design

Question 20

The general threat of the loss of production data can greatly slow or halt production activity within an organization. To counteract such a major threat, which of the following organization controls should be implemented and maintained?

• back up data files only after a production run has been physically completed
• store key master inventory and production order files on-site only to prevent their theft
• allow access to inventory records from any terminal within the organization to provide efficient data entry
• access controls should apply to all terminals within the organization

Answer 20

access controls should apply to all terminals within the organization

Question 21

There are various costs associated with quality control, or its absence in a production operation. Such information can help a company determine the effects of actions taken to improve production and identify areas of improvement. The cost of a product liability claim can be classified as a(n)

• inspection cost.
• prevention cost.
• internal failure cost.
• external failure cost.

Answer 21

external failure cost