Question regading the overall productivity

Assignment Help Business Management

Reference no: EM13974220

Question Set 1. A hotel manager has tracked hours worked and orders processed as given below.

	*Cashier*
*Hours Worked*	Jack	Wendy	Casey	Matt	Victoria	Susan
Sunday	6	5		5
Monday		8	8	7	7	7
Tuesday	8			8	8	8
Wednesday	6	8	7			8
Thursday	7	7		8	8
Friday	8		8		8	8
Saturday			6		7	5

	*Cashier*
*Orders Processed*	Jack	Wendy	Casey	Matt	Victoria	Susan
Sunday	55	62		63
Monday		85	88	82	91	84
Tuesday	68			78	91	98
Wednesday	87	85	67			83
Thursday	82	91		79	85
Friday	88		93		75	79
Saturday			58		56	51

1. For each cashier, compute his or her overall productivity (in orders per hour) over Monday-Friday (including these two days). You should have one number per cashier.

2. For each cashier, compute his or her productivity (in orders per hour) over the weekends (Sunday and Saturday). Using the MAX function, find the highest productive cashier for the weekend among the cashiers.

3. For each cashier, computer his or her productivity (in orders per hour) over all 7 days. Using the MIN function, find the lowest productive cashier for all 7 days among the cashiers.

4. Is the overall productivity (in orders per hour) of the store lower on weekdays or on weekends?

Reference no: EM13974220

Questions Cloud

Advantages and disadvantages of draft approach : What are some of the possible advantages and disadvantages of the "draft approach" to placing candidates in business units?

What struck you most about this given case : Read this and answer the question. What struck you most about this case? Where do you think the ethical issues (if there are any) are found within it

What are the actual variable costs : What is the total sales-volume variance (E)? What are the actual variable costs (C)? What is the total static-budget variance? What are the static-budget revenues (B)? What are the flexible-budget revenues (A)?

Which is a proper use of naming convention for a control : Which of the following is a proper use of naming convention for a control? Allow the user to hit the Enter key by setting a default button on the form using the property?

Question regading the overall productivity : For each cashier, compute his or her overall productivity (in orders per hour) over Monday-Friday (including these two days). You should have one number per cashier.

What is the relationship between art and culture : What image of America was communicated by the innovations and buildings presented at the 1883 Chicago's World Fair? How was this image communicated?

Create a balance sheet with this trial balance : Create a Balance Sheet with this Trial Balance

Specifie the rules for the game of checkers : Write a decision table that specifies the rules for the game of checkers

Include the social-ethical responsibility policy : The final exam is now available, and the student must do current research and use critical-thinking in responding to the question below

User Account

All Pages