Operations Management Midterm -You are designing a grocery delivery business. Via the internet

Operations Management Midterm -You are designing a grocery delivery business. Via the internet

Question 1:You are designing a grocery delivery business. Via the internet, your company will offer staples and frozen foods in a large metropolitan area and then deliver them within a customer-defined window of time. You plan to partner with two major food stores in the area. What should your competitive priorities be and what capabilities do you want to develop in your own core and support processes?

Is it possible for a project to have more than one critical path? Discuss the implications of such a situation with respect to each of the following aspects:

a.Project risk

b.Total available slack

c.Resource dependencies

d.Responsibilities of the project manager

Question 2:A flowchart helps us see all of the steps in a process, which in turn helps us improve the process. It also helps us identify and eliminate any redundant steps in a process. Using Word tools (SmartArt under the Insert tab), design a process flow chart for the grocery delivery business in Question 1 above. In the discussion element of your response, clearly define the steps within the process and provide a rationale for each step. Include all elements that you feel are necessary and appropriate to the process of a singular customer. The assumption is that the process is repeatable for every customer using the service. Think of the elements that you will be addressing or answering in the succeeding questions.

Question 3:For the grocery delivery business addressed in Question 1, the grocery chains that you are planning to partner with use differing inventory control models. Company A utilizes the Just-in-Time (JIT) inventory control model and Company B uses an Economic Order Quantity model. In reviewing your business plan, the bank loan officer has noticed this. As the loan officer is not overly familiar with either model, a request has been made of you to provide a description of each model and an explanation of why partnering with these companies would or would not create a conflict within your operations. Provide a detailed analysis of the situation in your business model.

Question 4:A Quality Assurance (QA) Program is essential to the success of any business.In establishing your grocery delivery business, what are some of the Quality Control (QC) processes that you envision employing? Why? Provide examples of potential metrics. Justify your choices.

Question 5: Efficiency is a critical element both in terms of individuals and machinery in any business. Describe some efficiency measures that you would implement in your grocery delivery business. What are the analysis tools that you would utilize to determine the effectiveness of these efficiency measures?

Problem 1

Tried and True Clothing has opened four new stores in college towns across the state. Data on monthly sales volume and labor hours are given below. Which store location has the highest labor productivity?

Store
	

Annandale
	

Blacksburg
	

Charlottesville
	

Danville

Sales volume
	

$40,000
	

$12,000
	

$60,000
	

$25,000

Labor hours
	

????250
	

?????60
	

????500
	

????200

Problem 2

Construct a Gantt chart for the project described by the following set of activities, and indicate the project completion time:

Activity
	

Activity Predecessor
	

Time (Weeks)

1
	

—
	

5

2
	

—
	

4

3
	

1
	

3

4
	

2
	

6

Problem 3

Backwoods American, Inc., produces expensive water-repellent, down-lined parkas. The company implemented a total quality-management program in 2005. Following are quality-related accounting data that have been accumulated for the five-year period after the program's start.Please calculate failure costs as a percentage of total quality cost for each year in which the data is provided. Is there a trend.

	

Year

	

2006
	

2007
	

2008
	

2009
	

2010

Quality Costs (000s)
	

	

	

	

	

Prevention
	

$3.2
	

10.7
	

28.3
	

42.6
	

50.0

Appraisal
	

26.3
	

29.2
	

30.6
	

24.1
	

19.6

Internal failure
	

39.1
	

51.3
	

48.4
	

35.9
	

32.1

External failure
	

118.6
	

110.5
	

105.2
	

91.3
	

65.2

Accounting Measures (000s)
	

	

	

	

	

Sales
	

$2,700.6
	

2,690.1
	

2,705.3
	

2,310.2
	

2,880.7

Manufacturing cost
	

420.9
	

423.4
	

424.7
	

436.1
	

435.5

Problem 4

AV City stocks and sells a particular brand of laptop. It costs the firm $625 each time it places an order with the manufacturer for the laptops. The cost of carrying one laptop in inventory for a year is $130. The store manager estimates that total annual demand for the laptops will be 1500 units, with a constant demand rate throughout the year. Orders are received within minutes after placement from a local warehouse maintained by the manufacturer. The store policy is never to have stockouts of the laptops. The store is open for business every day of the year except Christmas Day. Determine the following:

a. Optimal order quantity per order

b. Minimum total annual inventory costs

c. The number of orders per year

d. The time between orders (in working days)

Problem 5

The Great North Woods Clothing Company sells specialty outdoor clothing through its catalog. A quality problem that generates customer complaints occurs when a warehouse employee fills an order with the wrong items. The company has decided to implement a process control plan by inspecting the ordered items after they have been obtained from the warehouse and before they have been packaged. The company has taken 30 samples (during a 30-day period), each for 100 orders, and recorded the number of defective orders in each sample, as follows:

Sample
	

Number of Defectives
	

Sample
	

Number of Defectives

?1
	

12
	

16
	

?6

?2
	

14
	

17
	

?3

?3
	

10
	

18
	

?7

?4
	

16
	

19
	

10

?5
	

18
	

20
	

14

?6
	

19
	

21
	

18

?7
	

14
	

22
	

22

?8
	

20
	

23
	

26

?9
	

18
	

24
	

20

10
	

17
	

25
	

24

11
	

?9
	

26
	

18

12
	

11
	

27
	

19

13
	

14
	

28
	

20

14
	

12
	

29
	

17

15
	

?7
	

30
	

18

Construct a-chart for the company that describes 99.74% (3?) of the random variation in the process, and indicate if the process seems to be out of control at any time.

Problem 03-02.

The Road King Tire Company in Birmingham wants to monitor the quality of the tires it manufactures. Each day the company quality-control manager takes a sample of 100 tires, tests them, and determines the number of defective tires. The results of 20 samples have been recorded as follows:

Sample
	

Number of Defectives
	

Sample
	

Number of Defectives

?1
	

14
	

11
	

18

?2
	

12
	

12
	

10

?3
	

?9
	

13
	

19

?4
	

10
	

14
	

20

?5
	

11
	

15
	

17

?6
	

?7
	

16
	

18

?7
	

?8
	

17
	

18

?8
	

14
	

18
	

22

?9
	

16
	

19
	

24

10
	

17
	

20
	

23

Construct a-chart for this process usinglimits and describe the variation in the process.

Problem 03-06.

One of the stages in the process of making denim cloth at the Southern Mills Company is to spin cotton yarn onto spindles for subsequent use in the weaving process. Occasionally the yarn breaks during the spinning process, and an operator ties it back together. Some number of breaks is considered normal; however, too many breaks might mean that the yarn is of poor quality. In order to monitor this process, the quality-control manager randomly selects a spinning machine each hour and checks the number of breaks during a 15-minute period. Following is a summary of the observations for the past 20 hours:

Sample
	

Number of Breaks
	

Sample
	

Number of Breaks

?1
	

3
	

11
	

3

?2
	

2
	

12
	

4

?3
	

4
	

13
	

6

?4
	

1
	

14
	

7

?5
	

5
	

15
	

8

?6
	

3
	

16
	

6

?7
	

2
	

17
	

5

?8
	

4
	

18
	

7

?9
	

0
	

19
	

8

10
	

2
	

20
	

6

Construct a-chart usinglimits for this process and indicate if the process was out of control at any time.

Problem 13-06.

The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of 116 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined numberhas been produced. When not producing cakes, the bakery uses its personnel and facilities for producing other bakery items. The setup cost for a production run of cakes is $700. The cost of holding frozen cakes in storage is $9 per cake per year. The annual demand for frozen cakes, which is constant over time, is 6000 cakes. Determine the following:

a. Optimal production run quantity (Q)

b. Total annual inventory costs

c. Optimal number of production runs per year

d. Optimal cycle time (time between run starts)

e. Run length in working days.

Problem 13-20.

Southwood Furniture Company is a U.S.-based furniture manufacturer that offshored all of its actual manufacturing operations to China about a decade ago. It set up a distribution center in Hong Kong from which the company ships its items to the United States on container ships. The company learned early on that it could not rely on local Chinese freight forwarders to arrange for sufficient containers for the company's shipments, so it contracted to purchase containers from a Taiwanese manufacturer and then sell them to shipping companies at the U.S. ports the containers are shipped to. Southwood needs 715 containers each year. It costs $1200 to hold a container at its distribution center, and it costs $6000 to receive an order for the containers. Determine the optimal order size, minimum total annual inventory cost, number of annual orders, and time between orders.

BUS 375 ASSIGNMENT 4: PROJECT MOTORCYCLES THE COMPREHENSIVE PROJECT PLAN

BUS 375 ASSIGNMENT 4: PROJECT MOTORCYCLES THE COMPREHENSIVE PROJECT PLAN

Assignment 4: project motorcycles - The comprehensive project plan

Due Week 8 and worth 300 points

Note: This assignment is a continuation from Assignment 2.

Write a six to eight (6-8) page paper in which you:

1.Describe the project scope and project management plan. Align your plan to the overall strategy that you had recommended to the senior executives in Assignment 2.

2.Analyze the type of staff that your company would need in order to make the manufacturing switch to motorcycles with larger motors.

3.Prepare four (4) team-building strategies for handling the newly formed team. Discuss the manner in which the strategies that you have prepared may positively or negatively affect productivity within the company.

4.Analyze the role of the project manager that this project would require. Examine three (3) characteristics of an effective project manager that are relevant to this particular expansion project. Provide a rationale for the response.

5.Emphasize the importance of identifying critical path on projects and the manner in which one would allocate resources to all of the activities on the critical path.

6.Outline the elements of the Work Breakdown Structure (WBS) and pricing and costing strategy. Delineate the fundamental ways in which the project in question is composed.

7.Develop the following using designated project management software (e.g., Microsoft Project):

a.Work Breakdown Structure (WBS)

b.Gantt chart

c.Assigned ResourcesAttach the project file that contains the items that you have developed.

8.Use at least three (3) quality references. Note: Wikipedia and other Websites do not quality as academic resources.

Your assignment must follow these formatting requirements:

    Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
    Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

    Apply the project manager’s critical skills, in terms of project leadership, team building, time management, conflict management, and effective communication with executive sponsors, peers, team members, and project clients.
    Evaluate the quality of planning throughout a project’s life cycle.
    Construct project schedules using network techniques and reports for both internal and external presentation.
    Use technology and information resources to research issues in project management.

Write clearly and concisely about project management using proper writing mechanics. 

Exercise #1 Tillman Chemicals, Inc. case study

Exercise #1 Tillman Chemicals, Inc. case study

Exercise #1


Tillman Chemicals, Inc. has five production facilities, labelled A through E, that provide chemicals to five different regions, labelled 1 through 5. The production and shipping costs related to satisfying regional demand are listed in the following table:

Demand Regions A B C D E Demand
(Tankers/yr)
1 1885 4084 6283 3770 6911 810
2 3770 4398 6597 2513 7225 570
3 4084 1885 4398 4398 4084 600
4 6283 4398 9425 6597 3142 360
5 5341 4084 2827 6597 2513 300
Capacity (Tankers/yr) 555 1425 150 600 240
Prod. Costs per Tanker 31400 23500 52600 23000 29000

Tillman needs a production plan for the coming fiscal year. Answer the following questions:

1) If plants can produce however much they want to (infinite production capacity), how much should each plant produce, and what is the cost?
2) If plants can produce as much as they want to UP TO THEIR STATED CAPCITY, how much should each plant produce, and what is the cost?
3) If plants MUST produce at no less than 45% capacity, then what should each plant produce, and what is the cost?
4) What do you observe about the relationship between constraints in your model and cost?




Exercise #2

Your company is choosing among several locations for its offices, each of which must serve multiple U.S. states. Your high-end products require regular servicing by repair technicians, who must report to the appropriate sales office. There are four potential sales office sites under consideration: San Diego, Dallas, Kansas City, and Seattle. The annual fixed cost of the San Diego office is $173,500, Dallas is $129,200, Kansas City is $142,000, and Seattle is $147,500. Repair technicians must make repair trips out of these offices, with costs per trip described in the following table:


Travel Costs
State San Diego Dallas Kansas City Seattle # of Trips
Washington 225 325 275 100 40
Oregon 225 325 275 150 35
California 150 275 200 200 100
Idaho 225 275 200 200 25
Nevada 175 275 200 225 40
Montana 250 250 200 200 25
Wyoming 225 250 175 225 50
Utah 225 225 175 275 30
Arizona 150 275 175 325 50
New Mexico 200 200 150 375 40
N. Dakota 375 275 225 275 30
S. Dakota 375 250 200 275 20
Nebraska 325 175 200 325 30
Kansas 325 150 150 375 40
Oklahoma 325 100 200 375 55
Colorado 225 225 175 325 65
Each technician may make up to 25 repair calls each year. Answer the following:
Assuming that, at most, 10 technicians are allowed at any one office, where should the offices be, and how many technicians should be at each office?
Now assume that unlimited technicians are allowed at each office. Where should the offices be, and how many technicians should be at each office?
How confident are you that the answer for #2 represents the best possible solutions? Explain your answer, and, if appropriate, suggest what might constitute a better solution. 

Exercise # 1													
													
Demand Regions	A	B	C	D	E	Capacity (Tankers/yr)	Prod. Cost per Tanker						
1	1885	4084	6283	3770	6911	555	31400						
2	3770	4398	6597	2513	7225	1425	23500						
3	4084	1885	4398	4398	4084	150	52600						
4	6283	4398	9425	6597	3142	600	2300						
5	5341	4084	2827	6597	2513	240	2900						
Demand (Tanker/yr)	810	570	600	360	300								
													
Decision Variables													
Demand Regions	A	B	C	D	E								
1													
2													
3													
4													
5													
Capacity (Tankers/yr)													
Prod. Costs per Tanker													
													
													
Constrants													
Demand Regions	Excess Capacity	Excess Capacity	Excess Capacity										
1													
2													
3													
4													
5													
													
													
Objective Function													
Cost	$												
													
													
Question # 1 - infinite production capacity													
Question # 2 - UP TO THEIR STATED CAPCITY													
													
Question # 3 - MUST produce at____________ to achieve no less than 45% capacity													
													
Exercise # 2													
													
State	San Diego 	Dallas	Kansas City	Seattle	# of Trips								
Idaho	225	275	200	200	25								
Nevada	175	275	200	225	40								
Montana	250	250	200	200	25								
Wyoming	225	250	175	225	50								
Utah	225	225	175	275	30								
Arizona	150	275	175	325	50								
New Mexico	200	200	150	375	40								
N. Dakota	375	275	225	275	30								
S. Dakota	375	250	200	275	20								
Nebraska	325	175	200	325	30								
Kansas	325	150	150	375	40								
Oklahoma	325	100	200	375	55								
Colorado	225	225	175	325	65								
													
													
Decision Variables													
State	San Diego 	Dallas	Kansas City	Seattle	# of Trips								
Idaho													
Nevada													
Montana													
Wyoming													
Utah													
Arizona													
New Mexico													
N. Dakota													
S. Dakota													
Nebraska													
Kansas													
Oklahoma													
Colorado													
													
Constrants													
State	San Diego 	Dallas	Kansas City	Seattle	# of Trips								
Idaho													
Nevada													
Montana													
Wyoming													
Utah													
Arizona													
New Mexico													
N. Dakota													
S. Dakota													
Nebraska													
Kansas													
Oklahoma													
Colorado													
													
													
Objective Function													
Cost	$												
													
Questions													
													
Question # 1 - 10 technicians are allowed at any one office													
													
Question # 2 - unlimited technicians are allowed at each office													
													
Question # 3 - How confident are you that the answer for #2 represents the best possible solutions? Explain your answer, and, if appropriate, suggest what might constitute a better solution.													
													

Describe the processes/techniques associated with the daguerreotype, the calotype paper negative, and the wet collodion glass negative. Who were the “inventors” of these processes? Compare the advantages/disadvantages of each process.

Describe the processes/techniques associated with the daguerreotype, the calotype paper negative, and the wet collodion glass negative. Who were the “inventors” of these processes? Compare the advantages/disadvantages of each process.

1. Describe the processes/techniques associated with the daguerreotype, the calotype paper negative, and the wet collodion glass negative. Who were the "inventors" of these processes? Compare the advantages/disadvantages of each process. 

2. Discuss at least three ways in which the camera was used as a tool for documentation. What impacts (social, economic, scientific, etc.) did this new form of documentation have in 19th century Europe and North America? 

3. Discuss the ways in which photography was used for anthropological/ethnographic study in the 19th and early 20th century. What ideological assumptions, if any, were apparent in these studies? 

4. Compare and contrast the early attempts to justify photography as an art form (e.g. Le Gray, Reijlander, Robinson, Emerson, Cameron and other pictorialists). What forces were against the perception of photography as a fine art and how did photographers work to overcome this? 
Additional Requirements 

Managerial Marketing 5070 – Pedigree Case Questions

Managerial Marketing 5070 – Pedigree Case Questions

Pedigree Case Questions
Managerial Marketing 5070

In answering the questions for any case, DO NOT do any research on the company and its progress since the case was written. Only use the information presented in the case.


Case analyses should be approximately 4-5 double-spaced pages (you can write them single-spaced, but that is just a roundabout estimate of their length).

APA Style

Case 1 will be done on an individual basis.

The writing format of the cases should be in the format of answering the questions rather than the format of a "traditional" paper. So you can format the responses as simply answering the questions one by one. However, please make sure to list the questions above your answers. I know that might seem simplistic, but I think that it actually makes responses more focused and thought through, which sometimes gets lost when the cases are done in the format of a traditional paper.

The Guide to Writing A Case Analysis may also have some useful information regarding cases in general. http://www.mhhe.com/business/management/thompson/11e/case.htm


Case and Questions


1. Is dog food an attractive category? In answering this question, please consider category size and growth rates, competitive intensity, competitive shares, advertising spending, and trends.

2. The dog food category can be segmented in several ways. Please identify at least three ways the dog food category can be segmented and the implications for brand marketing.

3. A. Who are the influencers on brand purchasing and how has this changed?

B. Are there high or low levels of brand loyalty and why?

C. What is the implication of this for Pedigree?

4. In reviewing the Pedigree financial statements, how has the company been managing this brand?

5. A. What is the current positioning of Pedigree?

B. What, if any, are there issues with this positioning?

6. A. What options does Pedigree see moving forward?

B. What are the pros and cons of each?

C. What do you recommend and why?

ABS 415 WEEK 2 DISCUSSIONS

ABS 415 WEEK 2 DISCUSSIONS

Do you think it is appropriate for a leader to spend time developing a team’s emotional intelligence (EI)? Why or why not? What would be the advantages/disadvantages? Discuss specific circumstances/influences/parameters that may impact a leader’s decision to spend time fostering the development of EI.
Do you think it is appropriate for a leader to spend time developing a team’s emotional intelligence (EI)? Why or why not?

MGT 330 Week 2 DQs. Get an A++.

MGT 330 Week 2 DQs. Get an A++.

Structure for Conglomerates. Reflect on your reading for the week, specifically Analytical Exercise 8. Is another form of structural configuration better suited to multiproduct, multiservice companies? If not, is there a form of departmentalization for multiproduct, multiservice companies which would match somewhat the divisional structure configuration?"

Explain how the following somewhat match each other:

functional structure with simple structure

divisional structure with departmentalization by product

machine bureaucracy with centralized, mechanistic structure

professional bureaucracy with decentralized, organic structure


Classifying Structure. Address the following questions and also provide the name of a company example of each structure with supporting rationale. Reply substantively to two other learners.

a. What kinds of companies should employ the simple structure organizational configuration?

b. What kind of companies should use the machine bureaucracy form of structure?

c. What kinds of organizations should feature a professional bureaucracy form of structure?

d. What kinds of firms should use the divisional form of structure?

e. What types of organizations are best suited to the adhocracy form of structure?

Statistics Overall Workbook -BUS 308

Statistics Overall Workbook -BUS 308

I really need assistance with my BUS 308 week 4 Assignment. Any Assistance would be appreciated. The first question is a follows...

Using our sample data, construct a 95% confidence interval for the population's mean salary for each gender. Interpret the results. How do they compare with the findings in the week 2 one sample t-test outcomes (Question 1). 

See comments at the right of the data set.																
ID	Salary	Compa	Midpoint	Age	Performance Rating	Service	Gender	Raise	Degree	Gender1	Grade					
8	23	1.000	23	32	90	9	1	5.8	0	F	A		The ongoing question that the weekly assignments will focus on is:  Are males and females paid the same for equal work (under the Equal Pay Act)?  			
10	22	0.956	23	30	80	7	1	4.7	0	F	A		Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.			
11	23	1.000	23	41	100	19	1	4.8	0	F	A					
14	24	1.043	23	32	90	12	1	6	0	F	A		The column labels in the  table mean:			
15	24	1.043	23	32	80	8	1	4.9	0	F	A		ID – Employee sample number 			Salary – Salary in thousands     
23	23	1.000	23	36	65	6	1	3.3	1	F	A		Age – Age in years			Performance Rating  – Appraisal rating (Employee evaluation score)
26	24	1.043	23	22	95	2	1	6.2	1	F	A		Service – Years of service (rounded)			Gender:   0 = male, 1 = female  
31	24	1.043	23	29	60	4	1	3.9	0	F	A		Midpoint – salary grade midpoint    			Raise – percent of last raise
35	24	1.043	23	23	90	4	1	5.3	1	F	A		Grade – job/pay grade			Degree (0= BS/BA 1 = MS)
36	23	1.000	23	27	75	3	1	4.3	1	F	A		Gender1 (Male or Female)			Compa - salary divided by midpoint
37	22	0.956	23	22	95	2	1	6.2	1	F	A					
42	24	1.043	23	32	100	8	1	5.7	0	F	A					
3	34	1.096	31	30	75	5	1	3.6	0	F	B					
18	36	1.161	31	31	80	11	1	5.6	1	F	B					
20	34	1.096	31	44	70	16	1	4.8	1	F	B					
39	35	1.129	31	27	90	6	1	5.5	1	F	B					
7	41	1.025	40	32	100	8	1	5.7	0	F	C					
13	42	1.050	40	30	100	2	1	4.7	1	F	C					
22	57	1.187	48	48	65	6	1	3.8	0	F	D					
24	50	1.041	48	30	75	9	1	3.8	1	F	D					
45	55	1.145	48	36	95	8	1	5.2	0	F	D					
17	69	1.210	57	27	55	3	1	3	0	F	E					
48	65	1.140	57	34	90	11	1	5.3	1	F	E					
28	75	1.119	67	44	95	9	1	4.4	1	F	F					
43	77	1.149	67	42	95	20	1	5.5	1	F	F					
19	24	1.043	23	32	85	1	0	4.6	1	M	A					
25	24	1.043	23	41	70	4	0	4	0	M	A					
40	25	1.086	23	24	90	2	0	6.3	0	M	A					
2	27	0.870	31	52	80	7	0	3.9	0	M	B					
32	28	0.903	31	25	95	4	0	5.6	0	M	B					
34	28	0.903	31	26	80	2	0	4.9	1	M	B					
16	47	1.175	40	44	90	4	0	5.7	0	M	C					
27	40	1.000	40	35	80	7	0	3.9	1	M	C					
41	43	1.075	40	25	80	5	0	4.3	0	M	C					
5	47	0.979	48	36	90	16	0	5.7	1	M	D					
30	49	1.020	48	45	90	18	0	4.3	0	M	D					
1	58	1.017	57	34	85	8	0	5.7	0	M	E					
4	66	1.157	57	42	100	16	0	5.5	1	M	E					
12	60	1.052	57	52	95	22	0	4.5	0	M	E					
33	64	1.122	57	35	90	9	0	5.5	1	M	E					
38	56	0.982	57	45	95	11	0	4.5	0	M	E					
44	60	1.052	57	45	90	16	0	5.2	1	M	E					
46	65	1.140	57	39	75	20	0	3.9	1	M	E					
47	62	1.087	57	37	95	5	0	5.5	1	M	E					
49	60	1.052	57	41	95	21	0	6.6	0	M	E					
50	66	1.157	57	38	80	12	0	4.6	0	M	E					
6	76	1.134	67	36	70	12	0	4.5	1	M	F					
9	77	1.149	67	49	100	10	0	4	1	M	F					
21	76	1.134	67	43	95	13	0	6.3	1	M	F					
29	72	1.074	67	52	95	5	0	5.4	0	M	F					
																
Week 1.	Measurement and Description - chapters 1 and 2																																																							
																																																								
																																																								
1	Measurement issues.  Data, even numerically coded variables, can be one of 4 levels - 																																																							
	nominal, ordinal, interval, or ratio.  It is important to identify which level a variable is, as																																																							
	this impact the kind of analysis we can do with the data.  For example, descriptive statistics 																																																							
	such as means can only be done on interval or ratio level data.																																																							
	Please list under each label, the variables in our data set that belong in each group.																																																							
	Nominal	Ordinal	Interval	Ratio																																																				
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
b.	For each variable that you did not call ratio, why did you make that decision?																																																							
																																																								
																																																								
																																																								
																																																								
																																																								
2	The first step in analyzing data sets is to find some summary descriptive statistics for key variables.																																																							
	For salary, compa, age, performance rating, and service; find the mean, standard deviation, and range for 3 groups: overall sample, Females, and Males.																																																							
	You can use either the Data Analysis Descriptive Statistics tool or the Fx =average and =stdev functions.  																																																							
	 (the range must be found using the difference between the =max and =min functions with Fx) functions.																																																							
	Note: Place data to the right, if you use Descriptive statistics, place that to the right as well.																																																							
			Salary	Compa	Age	Perf. Rat.	Service																																																	
	Overall	Mean																																																						
		Standard Deviation																																																						
		Range																																																						
	Female	Mean																																																						
		Standard Deviation																																																						
		Range																																																						
	Male	Mean																																																						
		Standard Deviation																																																						
		Range																																																						
																																																								
3	What is the probability for a:							Probability																																																
	a.       Randomly selected person being a male in grade E?																																																							
	b.      Randomly selected male being in grade E?  																																																							
		Note part b is the same as given a male, what is probabilty of being in grade E?																																																						
	c.     Why are the results different?																																																							
																																																								
4	For each group (overall, females, and males) find:								Overall	Female	Male																																													
a.	The value that cuts off the top 1/3 salary in each group.																																																							
b.	The z score for each value:																																																							
c.	The normal curve probability of exceeding this score:																																																							
d.	What is the empirical probability of being at or exceeding this salary value?																																																							
e.	The value that cuts off the top 1/3 compa in each group.																																																							
f.	The z score for each value:																																																							
g.	The normal curve probability of exceeding this score:																																																							
h.	What is the empirical probability of being at or exceeding this compa value?																																																							
i.	How do you interpret the relationship between the data sets?  What do they mean about our equal pay for equal work question?																																																							
																																																								
																																																								
																																																								
5.      	What conclusions can you make about the issue of male and female pay equality?  Are all of the results consistent? 																																																							
	What is the difference between the sal and compa measures of pay?																																																							
																																																								
																																																								
	Conclusions from looking at salary results:																																																							
																																																								
																																																								
	Conclusions from looking at compa results:																																																							
																																																								
																																																								
	Do both salary measures show the same results?																																																							
																																																								
																																																								
	Can we make any conclusions about equal pay for equal work yet?																																																							
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
																																																								
												Week 2	Testing means																				Q3		
	In questions 2 and 3, be sure to include the null and alternate hypotheses you will be testing.  																	Ho	Female		Male	Female	
	In the first 3 questions use alpha = 0.05 in making your decisions on rejecting or not rejecting the null hypothesis.																	45	34		1.017	1.096	
																		45	41		0.870	1.025	
1	Below are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean.  																	45	23		1.157	1.000	
	(Note: a one-sample t-test in Excel can be performed by selecting the 2-sample unequal variance t-test and making the second variable = Ho value -- see column S)																	45	22		0.979	0.956	
	Based on our sample, how do you interpret the results and what do these results suggest about the population means for male and female average salaries?																	45	23		1.134	1.000	
	Males				Females													45	42		1.149	1.050	
	Ho: Mean salary = 45				Ho: Mean salary = 45													45	24		1.052	1.043	
	Ha: Mean salary =/= 45				Ha: Mean salary =/= 45													45	24		1.175	1.043	
																		45	69		1.043	1.210	
	Note: While the results both below are actually from Excel's t-Test: Two-Sample Assuming Unequal Variances, 																	45	36		1.134	1.161	
	having no variance in the Ho variable makes the calculations default to the one-sample t-test outcome - we are tricking Excel into doing a one sample test for us.																	45	34		1.043	1.096	
		Male	Ho			Female	Ho											45	57		1.000	1.187	
	Mean	52	45		Mean	38	45											45	23		1.074	1.000	
	Variance	316	0		Variance	334.6666667	0											45	50		1.020	1.041	
	Observations	25	25		Observations	25	25											45	24		0.903	1.043	
	Hypothesized Mean Difference	0			Hypothesized Mean Difference	0												45	75		1.122	1.119	
	df	24			df	24												45	24		0.903	1.043	
	t Stat	1.968903827			t Stat	-1.913206357												45	24		0.982	1.043	
	P(T<=t) > 0.05?				Is P-value > 0.05?													45	65		1.157	1.140	
	Why do we not reject Ho?				Why do we not reject Ho?																		
Interpretation:																							
																							
																							
																							
																							
2	Based on our sample data set, perform a 2-sample t-test to see if the population male and female average salaries could be equal to each other.																						
	(Since we have not yet covered testing for variance equality, assume the data sets have statistically equal variances.)																						
																							
	Ho: 																						
	Ha: 																						
	Test to use:																						
	Place  B43 in Outcome range box.																						
																							
 																							
																							
																							
																							
																							
																							
																							
																							
																							
																							
																							
																							
																							
																							
	P-value is:																						
	Is P-value < 0.05?																						
	Reject or do not reject Ho:																						
If  the null hypothesis was rejected, what is the effect size value:																							
	Meaning of effect size measure:																						
																							
	Interpretation:																						
																							
b.	Since the >																															
Interpretation:																																
																																
																																
2	Using our sample data, construct a 95% confidence interval for the mean salary difference between the genders in the population.    																															
	 How does this compare to the findings in week 2, question 2?																															
																																
	Difference	St Err.	T value			Low 	to 	High																								
																																
																																
																																
				Yes/No																												
	Can the means be equal?				Why?																											
																																
	How does this compare to the week 2, question 2 result (2 sampe t-test)?																															
																																
a.	Why is using a two sample tool (t-test, confidence interval) a better choice than using 2 one-sample techniques when comparing two samples?																															
																																
																																
3	We found last week that the degrees compa values within the population.																															
	 do not impact compa rates.  This does not mean that degrees are distributed evenly across the grades and genders.																															
	Do males and females have athe same distribution of degrees by grade?																															
	(Note: while technically the sample size might not be large enough to perform this test, ignore this limitation for this exercise.)																															
																																
	What are the hypothesis statements:																															
	Ho: 																															
	Ha:																															
Note:  You can either use the Excel Chi-related functions or do the calculations manually.																																
	Data input tables - graduate degrees by gender and grade level																															
OBSERVED	A 	B	C	D	E	F	Total		Do manual calculations per cell here (if desired)																							
M Grad									A 	B	C	D	E	F																		
Fem Grad								M Grad																								
Male Und								Fem Grad																								
Female Und								Male Und																								
								Female Und																								
																																
									Sum =																							
EXPECTED																																
M Grad								For this exercise - ignore the requirement for a correction																								
Fem Grad								for expected values less than 5.																								
Male Und																																
Female Und																																
																																
																																
																																
																																
																																
Interpretation:																																
				What is the value of the chi square statistic: 																												
				What is the p-value associated with this value: 																												
				Is the p-value <0.05?																												
				Do you reject or not reject the null hypothesis: 																												
				If you rejected the null, what is the Cramer's V correlation:																												
				What does this correlation mean?																												
				What does this decision mean for our equal pay question: 																												
																																
																																
4	Based on our sample data, can we conclude that males and females are distributed across grades in a similar pattern																															
	within the population?																															
																																
	What are the hypothesis statements:																															
	Ho: 																															
	Ha:																															
																																
										Do manual calculations per cell here (if desired)																						
		A 	B	C	D	E	F			A 	B	C	D	E	F																	
	OBS COUNT - m								M																							
	OBS COUNT - f								F																							
																																
									Sum = 																							
	EXPECTED																															
																																
																																
																																
				What is the value of the chi square statistic: 																												
				What is the p-value associated with this value: 																												
				Is the p-value <0.05?																												
				Do you reject or not reject the null hypothesis: 																												
				If you rejected the null, what is the Phi correlation:																												
				What does this correlation mean?																												
																																
				What does this decision mean for our equal pay question: 																												
																																
5.      How do you interpret these results in light of our question about equal pay for equal work?																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																																
																								Week 5 Correlation and Regression																										
																										
1.    	Create a correlation table for the variables in our data set. (Use analysis ToolPak or StatPlus:mac LE function Correlation.)																									
	a. 	Reviewing the data levels from week 1, what variables can be used in a Pearson's Correlation table (which is what Excel produces)?																								
																										
																										
	b. Place table here (C8 in Output range box):																									
																										
																										
																										
																										
																										
																										
																										
																										
																										
	c.	Using r = approximately .28 as the signicant r value (at p = 0.05) for a correlation between 50 values, what variables are																								
		significantly related to Salary?																								
		To compa?																								
																										
	d.	Looking at the above correlations - both significant or not - are there any surprises -by that I 																								
		mean any relationships you expected to be meaningful and are not and vice-versa?																								
																										
	e.	Does this help us answer our equal pay for equal work question?																								
																										
																										
2		Below is a regression analysis for salary being predicted/explained by the other variables in our sample  (Midpoint,																								
		 age, performance rating, service,  gender, and degree variables. (Note: since salary and compa are different ways of																								
		 expressing an employee’s salary, we do not want to have both used in the same regression.)																								
		Plase interpret the findings.																								
																										
		Ho: The regression equation is not significant.																								
		Ha: The regression equation is significant.																								
		Ho: The regression coefficient for each variable is not significant						  Note: technically we have one for each input variable.																		
		Ha: The regression coefficient for each variable is significant						  Listing it this way to save space.																		
																										
		Sal																								
		SUMMARY OUTPUT																								
																										
		Regression Statistics																								
		Multiple R	0.991559075																							
		R Square	0.983189399																							
		Adjusted R Square	0.980843733																							
		Standard Error	2.657592573																							
		Observations	50																							
																										
		ANOVA																								
			df	SS	MS	F	Significance F																			
		Regression	6	17762.29967	2960.383279	419.1516111	1.81215E-36																			
		Residual	43	303.7003261	7.062798282																					
		Total	49	18066																						
																										
			Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%																
		Intercept	-1.749621212	3.618367658	-0.483538816	0.63116649	-9.046755043	5.547512618	-9.046755043	5.547512618																
		Midpoint	1.216701051	0.031902351	38.13828812	8.66416E-35	1.152363828	1.281038273	1.152363828	1.281038273																
		Age	-0.00462801	0.065197212	-0.070984788	0.943738987	-0.136110719	0.126854699	-0.136110719	0.126854699																
		Performace Rating	-0.056596441	0.034495068	-1.640711097	0.108153182	-0.126162375	0.012969494	-0.126162375	0.012969494																
 		Service	-0.042500357	0.084336982	-0.503935003	0.616879352	-0.212582091	0.127581377	-0.212582091	0.127581377																
		Gender	2.420337212	0.860844318	2.81158528	0.007396619	0.684279192	4.156395232	0.684279192	4.156395232																
		Degree	0.275533414	0.799802305	0.344501901	0.732148119	-1.337421655	1.888488483	-1.337421655	1.888488483																
		Note: since Gender and Degree are expressed as 0 and 1, they are considered dummy variables and can be used in a multiple regression equation.																								
																										
																										
		Interpretation:																								
		For the Regression as a whole:																								
					What is the value of the F statistic: 																					
					What is the p-value associated with this value: 																					
					Is the p-value <0.05?																					
					Do you reject or not reject the null hypothesis: 																					
					What does this decision mean for our equal pay question: 																					
																										
		For each of the coefficients:				Intercept	Midpoint	Age	Perf. Rat.	Service	Gender	Degree														
					What is the coefficient's p-value for each of the variables: 																					
					Is the p-value < 0.05?																					
					Do you reject or not reject each null hypothesis: 																					
					What are the coefficients for the significant variables?																					
					Using only the significant variables, what is the equation?	Salary =																				
					Is gender a significant factor in salary:																					
					If so, who gets paid more with all other things being equal?																					
					How do we know? 																					
																										
																										
3		Perform a regression analysis using compa as the dependent variable and the same independent																								
		variables as used in question 2.  Show the result, and interpret your findings by answering the same questions.																								
		Note: be sure to include the appropriate hypothesis statements.																								
		Regression hypotheses																								
		Ho:																								
		Ha:																								
		Coefficient hypotheses (one to stand for all the separate variables)																								
		Ho:																								
		Ha:																								
		Put C94 in output range box																								
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
																										
		Interpretation:																								
		For the Regression as a whole:																								
					What is the value of the F statistic: 																					
					What is the p-value associated with this value: 																					
					Is the p-value < 0.05?																					
					Do you reject or not reject the null hypothesis: 																					
					What does this decision mean for our equal pay question: 																					
																										
		For each of the coefficients: 				Intercept	Midpoint	Age	Perf. Rat.	Service	Gender	Degree														
					What is the coefficient's p-value for each of the variables: 																					
					Is the p-value < 0.05?																					
					Do you reject or not reject each null hypothesis: 																					
					What are the coefficients for the significant variables?																					
					Using only the significant variables, what is the equation?	Compa = 																				
					Is gender a significant factor in compa:																					
					If so, who gets paid more with all other things being equal?																					
					How do we know? 																					
																										
																										
4		Based on all of your results to date, do we have an answer to the question of are males and females paid equally for equal work?																								
				If so, which gender gets paid more? 																						
				 How do we know?																						
		Which is the best variable to use in analyzing pay practices - salary or compa?  Why?																								
		What is most interesting or surprising about the results we got doing the analysis during the last 5 weeks?																								
																										
																										
																										
5		Why did the single factor tests and analysis (such as t and single factor ANOVA tests on salary equality) not provide a complete answer to our salary equality question?																								
		What outcomes in your life or work might benefit from a multiple regression examination rather than a simpler one variable test?