Complete problems 1.1, 1.9, and 1.13 in the textbook.
Submit one Excel file. Put each problem result on a separate sheet in your file.
1.1 Chuck Sox makes wooden boxes in which to ship
motorcycles. Chuck and his three employees invest a total of 40
hours per day making the 120 boxes.
a) What is their productivity?
b) Chuck and his employees have discussed redesigning the process
to improve efficiency. If they can increase the rate to 125
per day, what will be their new productivity?
c) What will be their unit increase in productivity per hour?
d) What will be their percentage change in productivity? PX
1.9 Lillian Fok is president of Lakefront Manufacturing,
a producer of bicycle tires. Fok makes 1,000 tires per day with the
Labor: 400 hours per day @ $12.50 per hour
Raw material: 20,000 pounds per day @ $1 per pound
Energy: $5,000 per day
Capital costs: $10,000 per day
a) What is the labor productivity per labor-hour for these tires at
b) What is the multifactor productivity for these tires at
c) What is the percent change in multifactor productivity if Fok
can reduce the energy bill by $1,000 per day without cutting
production or changing any other inputs?
1.13 Charles Lackey operates a bakery in Idaho Falls, Idaho.
Because of its excellent product and excellent location, demand has
increased by 25% in the last year. On far too many occasions, customers
have not been able to purchase the bread of their choice.
Because of the size of the store, no new ovens can be added. At a
staff meeting, one employee suggested ways to load the ovens differently
so that more loaves of bread can be baked at one time. This
new process will require that the ovens be loaded by hand, requiring
additional manpower. This is the only thing to be changed. If the
bakery makes 1,500 loaves per month with a labor productivity of
2.344 loaves per labor-hour, how many workers will Lackey need to
add? (Hint: Each worker works 160 hours per month.)