Question

Please show method in excel

Charles Shoe manufactures handmade wooden jewelry boxes. A total of 23 employees each work 160 hours per month carving and assembling the boxes. In 2016 the company plans to make 5842 to meet expected global demand. What is their productivity at this level of production?

Select one:

a. 0.1323

b. 3.0427

c. 0.6299

d. 1.5875

e. 7.5591

Question 2

Persis Corporation manufactures water heaters. A total of 213 employees each work 160 hours per month making the water heaters. In 2016 the company plans to make 54685 water heaters to meet expected global demand. What is their productivity at this level of production?

Select one:

a. 0.6232

b. 0.1337

c. 28.4818

d. 1.6046

e. 7.4785

Answer 1

A	B	C	D	E	F	G	H
2		Q1)
3		Number of units produced	5842
4
5		Number of employees	23
6		Number of hours per employee per month	160
7
8		Producitivity	=Total units produced / Total hours used
9			0.1323	=D3/(12*D5*D6)
10
11		Hence the productivity is	0.1323	unit per hour
12		Thus the option (a) is correct.
13