Which of the following is equivalent to ‘=SUMPRODUCT(A1:A4,B2:B6)’?
a) A1*A4 + B2*B6
b) A1*B2 + A2*B3 + A3*B4 + A4*B5
c) (A1+A4)*(B2+B6)
d) (A1+A2+A3+A4)*(B2+B3+B4+B5+B6)
e) This is an invalid function.
In Excel, which function returns the number of cells containing numerical values?
a) CELLS(range)
b) NUMBER(range)
c) VALUES(range)
d) COUNT(range)
e) NUMBERS(range)
Early supplier involvement refers to the involvement of critical suppliers for what?
a) Strategic planning
b) Assembly line design
c) Speedy delivery planning
d) Selection of new suppliers
e) New product design
A machine shop produces metal frames on two different machines. The average daily
production on machine 1 is 300 frames, and the average daily production on machine 2
is 180 frames. What is the daily machine productivity?
a) 480 frames/machine
b) 330 frames/machine
c) 240 frames/machine
d) 160 frames/machine
e) 300 frames/machine
Which ERP module includes investment management?
a) finance and accounting
b) information systems
c) sales and marketing
d) production and materials management
e) human resources
A visual depiction of the subassemblies and components that are needed to produce a
finished product is called a(n) ______________________.
a) assembly time chart
b) product structure tree
c) peg
d) product chart
e) blueprint
Firms that have areas that have little customer contact and others with high customer
contact are classified as _________ services.
a) pure services
b) quasi-manufacturing
c) quasi-services
d) mixed services
e) manufacturing
Which of the following is not typical of overtime?
a) 50% wage premium
b) quality may decrease
c) productivity decreases
d) workers’ output rate increases
e) cost of labor per unit increases
Each day for two workweeks (10 days total), George weighs 4 bags from that day’s
production. If the average of the means is 14 oz. and the average range is 0.4 oz., what
is the lower control limit for an x-bar chart for this process?
a) 13.7084 oz.
b) 13.8768 oz.
c) 14.2916 oz.
d) 12.8000 oz.
e) 13.5908 oz.
Which type of technology provides ‘point-of-sale information?’
a) Automatic guided vehicles (AGV)
b) Automatic storage and retrieval systems (ASRS)
c) Barcode scanners
d) Flexible manufacturing systems (FMS)
e) Computer aided design/computer aided manufacturing (CAD/CAM)
In Excel, the command to print Cell Comments is selected under which
menu/submenu?
a) Print
b) Page Setup
c) Tools
d) View
e) Insert
Due to globalization, which of the following are not some commonly shared ocean
shipping logistical characteristics?
a) goods arrive in larger quantities
b) greater break-bulk activity is required
c) crossdocking is required
d) typically have higher inventories
e) longer port times occur
Given the following data:
The end product J is made from components K and L. K is made from M and N. L is
made from O and P. P is made from Q, R, and S.
(a) What is the replenishment lead time for J, assuming there are no inventories?
(b) Calculate the gross requirements for each of the components if the company plans to
build 10 of its J model. Assume that there are no beginning inventories.
(c) Calculate the gross requirements for each of the components if the company plans to
build 10 of its J model if you have these beginning inventories: 20 K, 10 L, and 30 P.
(d) What is the replenishment lead time if the company plans to build 10 of its J model,
assuming the beginning inventories given in (c) above?
Which of the following historical figures would probably have the most different
management style from the others?
a) Elton Mayo
b) Henry Ford
c) Eli Whitney
d) Frederick W. Taylor
e) Adam Smith
When there is insufficient inventory to cover the gross requirements for a period
a) an MRP is placed
b) an ERP is placed
c) a planned order is placed
d) a scheduled order is placed
e) a rush order occurs
Schools, colleges, and universities consider the size of the classrooms carefully because
_____________________.
When a company experiences a stockout, what are the two possibilities?
Waiting line models are important to a company because they directly affect customer
service _________.
What information about activities is needed in determining how to crash a project?
The old concept of quality involved ________________________
What is ABC Widget Company’s inventory turns if it sells goods whose cost is
$7,350,000 and its average inventory is $1,225,000?
Suppose that the annual cost of goods sold is $4,000,000, annual sales amount to
$6,000,000, and average inventory in dollars equals $2,000,000. What is the inventory
turnover?
At the national level why is it important to measure productivity?
Raissa’s teapot firm is moving to a JIT system. One question they are trying to answer is
what level of safety stock they should maintain. They produce 240 teapots every four
hours. The teapot ceramic handle vendor will deliver a container containing 30 parts
one hour after they receive a request to ship. Raissa’s kanban system uses four
containers. What should they maintain as a safety stock?
Terry’s cycle shop standard hour input/output report is below. Calculate the output
deviation and backlog hours for periods 1, 2, 3, and 4.
