Excel Templates to accompany Operations Management, Eleventh Edition
created by Lee Tangedahl
Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved.
Chapter Two – Competitiveness, Strategy, and Productivity
Templates: Productivity (B)
(B) – includes Basic template
Lecture Suggestions
See Instructions template for complete instructions.
Productivity
Productivity Basic Notes
<Back
Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
1720 4 8 22.50
268 234.00
3
10
Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
17040 1000 520 2000 2.00
2
3
4
5
6
7
8
9
10
^Top
1
2
3
4
5
Productivity
1
2
3
4
5
6
7
Clear
Clear
Page 2
4
5
6
7
8
9
Productivity
Basic Template: You can simply copy the basic template below and paste into another worksheet.
^Top
Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
Multifactor Productivity:
Output Input ($) Productivity
Page 3
Lecture Suggestions – Chapter 2
<Back
General Introduction
2. Worksheet: Each workbook is made up of worksheets (or pages), the name of each worksheet is on
the tab at the bottom and you can open a worksheet by clicking on the tab.
3. Table of contents: The first worksheet in each workbook is the table of contents and contains
hyperlinks to the other worksheets in the workbook. You can open a worksheet by clicking on the
4. Clear Button: The Clear button is used to clear all input data from the template. When you
click on the Clear button a message box will appear and you can confirm by clicking on OK.
5. Data input area: the data input area is shaded, you cannot enter data except in the shaded area.
You may enter either numbers or formulas, be sure to begin a formula with an = sign (e.g. =6*40*140).
Example 2: Productivity per Worker Hour (note: this corresponds to example 2 in the textbook)
1. Select the Examples 2,3 worksheet.
2. Clear and re-enter data, although the data is in the template, you may want clear it (press the Clear
3. Computation, the template will compute the productivity per hour using the following formula:
4. Graph, the graph is a simple bar chart comparing the productivity for each line entered.
Example 3: Multifactor Productivity (note: this corresponds to example 3 in the textbook)
1. Select the Examples 2,3 worksheet.
2. Clear and re-enter data, although the data is in the template, you may want clear it (press the Clear
1. Workbook: There is an Excel template workbook (or file) for each chapter, e.g. Chap2.xltm is a workbook.
3. Computation, the template will compute the productivity per dollar using the following formula:
4. Graph, the graph is a simple bar chart comparing the productivity for each line entered.
Examples 2,3
Productivity Notes
<Back
Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
1720 4 8 22.50
268 234.00
3
10
Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
17040 1000 520 2000 2.00
2
3
4
5
6
7
8
9
10
^Top
1
2
3
4
5
Productivity
1
2
3
4
5
6
7
Clear
Clear
Page 6
4
5
7
8
9
Solved Problems 1,2,3,4
Productivity Notes
<Back
Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
1400 40.5 200.00
2
9
10
Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
1
22000 160 50 320 3.77
48000 1600 130 1000 2.93
5
6
7
8
9
10
^Top
0100 200 300
1
2
3
Productivity
1
2
3
Clear
Clear
Page 7
3
4
5
6
7
8
Chapter 2 – Problems 1-9 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
1. Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
2. Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
196 424.00
272 324.00
392 423.00
450 225.00
569 323.00
652 226.00
7
3. Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
130000 2880 2700 4320 3.03
233600 3360 2820 5040 2.99
332200 3360 2760 5040 2.89
435400 3840 2880 5760 2.84
4. Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
180 516.00
284 421.00 31.3%
3
Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
5. Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
172 172.00
280 180.00 11.1%
3
6. Productivity per Worker Hour:
Output Workers or
Units Machines Hours Productivity
1138 36 3.83
2160 40 4.00 4.3%
7. Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
136 800 180 800 0.0202
240 1000 200 1000 0.0182
360 1600 300 1600 0.0171
420 600 100 600 0.0154
640 800 200 800 0.0222
745 1000 225 1000 0.0202
868 1600 340 1600 0.0192
923 600 115 600 0.0175
8. Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar
1400 80 5.00
2400 63.5 6.30
3400 59.6 6.71
9. Multifactor Productivity:
Output Input ($) Productivity
Units or $ Labor Machine Material Overhead per Dollar