Closing Cost

Closing Cost

Use the excel sheet as a reference. 

question one: 


Let's calculate the Closing Cost (in column M) for ALL properties. It is determined based on the Style of the property and is summarized in the look-up table in R24:T26. Note that on th elook-up table, the first column is the style of the property, the second column is the county code, and the third column is the corresponding closing cost. The county code is not used for the calculation. Select ALL of the correct answers below. You will have to get all the answers right in order to receive credit for this question.

a. The correct formula for property #101 is:

=VLOOKUP(M2,$R$24:$T$26,3,TRUE)

b. The correct formula for property #101 is:

=VLOOKUP(E2,$R$24:$T$26,3,FALSE)


c. The correct formula for property #101 is:

=VLOOKUP(M2,$R$24:$T$26,2,FALSE)

d. 
The closing cost for property #125 is $400.

e. 
The correct formula for property #101 is:

=VLOOKUP(E2,$R$24:$T$26,2,TRUE)

ID	Asking Price	Square feet	Age	Style	Bedroom	Bath	Date Listed	Date Sold	Sales Price			
101	 $87,400 	1236	3	Condo	2	1	22/11/2012	14/04/2013	 $77,750 			
102	 $110,900 	1740	4	Victorian	2	1.5	23/08/2012	20/06/2013	 $105,250 			
103	 $95,000 	1715	4	Ranch	2	1.5	18/05/2013	22/05/2013	 $95,000 			
104	 $87,000 	1273	4	Condo	2	1	30/09/2012	12/05/2013	 $81,750 			
105	 $73,900 	970	4	Victorian	1	0.5	07/02/2013	24/04/2013	 $63,500 			
106	 $77,000 	900	5	Victorian	1	0.5	21/06/2012	14/05/2013	 $67,750 			
107	 $133,000 	1850	5	Ranch	2	1.5	02/03/2013	16/05/2013	 $115,500 			
108	 $116,000 	1720	5	Ranch	2	1.5	18/03/2013	23/04/2013	 $99,750 			
109	 $102,000 	1606	5	Ranch	2	1.5	05/08/2012	29/05/2013	 $103,000 			
110	 $94,000 	1305	5	Victorian	2	1.5	20/06/2012	25/05/2013	 $88,250 			
111	 $112,900 	1700	6	Condo	2	1.5	04/02/2013	08/04/2013	 $115,000 			
112	 $105,000 	1620	6	Condo	2	1.5	27/06/2012	03/05/2013	 $106,000 			
113	 $104,500 	1630	6	Condo	2	1.5	22/07/2012	02/04/2013	 $98,000 			
114	 $103,000 	1540	6	Ranch	2	1.5	24/03/2013	12/06/2013	 $90,500 			
115	 $87,200 	1229	6	Ranch	2	1	23/01/2013	26/06/2013	 $87,000 			
116	 $97,500 	1500	7	Ranch	2	1.5	28/06/2012	16/04/2013	 $82,750 			
117	 $100,000 	1535	7	Victorian	2	1.5	09/05/2012	28/04/2013	 $91,000 			
118	 $92,000 	1415	7	Ranch	2	1.5	06/07/2012	24/04/2013	 $91,000 			
119	 $86,900 	1165	7	Victorian	2	1	10/08/2012	15/05/2013	 $88,500 			
120	 $76,600 	1200	7	Condo	2	1	07/05/2012	01/05/2013	 $68,000 			
121	 $105,000 	1920	8	Ranch	2	1.5	27/04/2013	14/05/2013	 $95,500 			
122	 $94,500 	1580	9	Victorian	2	1.5	05/04/2013	15/06/2013	 $95,250 			
123	 $97,500 	1739	13	Victorian	2	1.5	10/05/2013	21/06/2013	 $84,750 			
124	 $70,000 	1505	14	Condo	2	1.5	15/03/2013	30/05/2013	 $70,500 			
125	 $60,000 	1198	14	Ranch	2	1	08/03/2013	09/05/2013	 $51,000 			
126	 $158,000 	2563	14	Victorian	3	2.5	19/11/2012	11/06/2013	 $159,500 			
127	 $58,000 	1051	15	Ranch	2	1	05/12/2012	17/05/2013	 $58,000 			
128	 $169,500 	3750	19	Victorian	4	2.5	14/03/2013	30/05/2013	 $165,000 			
129	 $78,000 	1080	21	Victorian	2	1	09/01/2013	02/04/2013	 $68,500 			
130	 $54,000 	1142	21	Victorian	2	1	11/10/2012	05/05/2013	 $51,750 			
131	 $107,000 	1464	22	Victorian	2	1.5	22/12/2012	25/05/2013	 $107,000 			
132	 $210,000 	2116	25	Victorian	3	2	01/09/2012	20/06/2013	 $195,250 			
133	 $66,000 	1159	25	Ranch	2	1	13/09/2012	13/06/2013	 $62,500 			
134	 $72,500 	1280	38	Victorian	2	1	01/03/2013	04/05/2013	 $70,250 			
135	 $93,900 	1428	40	Victorian	2	1.5	03/10/2012	23/05/2013	 $82,500 			
136	 $82,000 	1375	40	Victorian	2	1.5	17/05/2012	06/05/2013	 $82,750 			
137	 $62,000 	1480	40	Ranch	2	1.5	11/09/2012	20/05/2013	 $59,500 			
138	 $184,400 	2250	40	Condo	3	2	04/11/2012	21/05/2013	 $182,500 			
139	 $69,900 	1400	45	Ranch	2	1.5	10/03/2013	10/04/2013	 $60,750 			
140	 $156,000 	1920	1	Ranch	2	1.5	29/12/2012	28/04/2013	 $134,000 			
141	 $144,900 	1710	1	Victorian	2	1.5	16/04/2013	02/06/2013	 $143,250 			
142	 $180,000 	2774	2	Victorian	3	2.5	10/12/2012	05/04/2013	 $165,500 			
143	 $215,000 	2921	3	Victorian	3	2.5	17/11/2012	06/05/2013	 $215,000 			
144	 $75,500 	1275	3	Condo	2	1	10/10/2012	01/04/2013	 $77,000 			
145	 $199,900 	2580	4	Ranch	3	2.5	30/06/2012	18/04/2013	 $187,750 			
146	 $190,000 	2580	4	Victorian	3	2.5	02/09/2012	22/04/2013	 $171,000 			
147	 $137,500 	1837	4	Victorian	2	1.5	16/04/2012	07/04/2013	 $137,500 			
148	 $215,000 	2848	4	Ranch	3	2.5	25/12/2012	30/05/2013	 $193,500 			
149	 $75,000 	1338	4	Ranch	2	1.5	08/04/2013	15/05/2013	 $76,500 			
150	 $75,900 	997	4	Ranch	1	0.5	13/06/2012	02/06/2013	 $75,000 			
151	 $87,000 	1280	5	Victorian	2	1	23/01/2013	27/06/2013	 $87,000 			
152	 $85,500 	1900	5	Ranch	2	1.5	04/07/2012	01/06/2013	 $81,000 			
153	 $215,000 	2664	6	Victorian	3	2.5	20/09/2012	13/06/2013	 $212,750 			
154	 $87,500 	1173	6	Victorian	2	1	29/08/2012	27/05/2013	 $87,500 			
155	 $81,000 	1365	6	Ranch	2	1.5	29/06/2012	23/06/2013	 $81,750 			
156	 $75,000 	1030	6	Ranch	2	1	19/11/2012	28/05/2013	 $69,750 			
157	 $88,900 	1549	7	Condo	2	1.5	04/06/2012	04/05/2013	 $77,250 			
158	 $80,500 	1258	7	Victorian	2	1	16/04/2013	27/05/2013	 $74,750 			
159	 $127,000 	1880	8	Ranch	2	1.5	27/07/2012	29/04/2013	 $127,000 			
160	 $208,000 	2600	10	Victorian	3	2.5	04/08/2012	29/04/2013	 $178,750 			
161	 $145,000 	2150	10	Victorian	3	2	02/11/2012	01/06/2013	 $146,250 			
162	 $89,000 	1746	10	Condo	2	1.5	04/02/2013	13/04/2013	 $77,250 			
163	 $61,900 	837	10	Condo	1	0.5	05/02/2013	20/06/2013	 $53,000 			
164	 $130,000 	2000	11	Victorian	2	2	15/05/2013	25/05/2013	 $117,000 			
165	 $83,500 	1560	11	Ranch	2	1.5	13/08/2012	13/05/2013	 $73,250 			
166	 $99,500 	1725	12	Condo	2	1.5	25/02/2013	12/04/2013	 $98,500 			
167	 $205,000 	2650	13	Victorian	3	2.5	09/01/2013	21/06/2013	 $178,250 			
168	 $97,500 	1430	13	Victorian	2	1.5	19/05/2012	05/04/2013	 $99,250 			
169	 $92,500 	1050	13	Ranch	2	1	04/05/2013	19/06/2013	 $78,500 			
170	 $105,000 	1680	13	Ranch	2	1.5	26/04/2012	06/04/2013	 $101,750 			
171	 $67,000 	1350	13	Condo	2	1.5	23/09/2012	06/05/2013	 $68,250 			
172	 $123,500 	1894	14	Ranch	2	1.5	27/07/2012	15/05/2013	 $123,500 			
173	 $97,500 	1360	14	Condo	2	1.5	25/05/2012	01/04/2013	 $97,500 			
174	 $92,200 	1326	14	Victorian	2	1.5	20/04/2013	20/06/2013	 $81,000 			
175	 $123,900 	1706	14	Ranch	2	1.5	10/05/2013	13/05/2013	 $110,250 			
176	 $120,000 	1948	14	Condo	2	1.5	01/10/2012	03/04/2013	 $120,000 			
177	 $79,900 	1314	14	Condo	2	1.5	23/02/2013	02/04/2013	 $70,250 			
178	 $125,000 	2150	15	Ranch	3	2	06/01/2013	25/05/2013	 $123,750 			
179	 $111,000 	1630	15	Victorian	2	1.5	13/07/2012	25/04/2013	 $99,750 			
180	 $99,500 	1500	15	Victorian	2	1.5	11/05/2013	29/05/2013	 $99,500 			
181	 $70,000 	1215	15	Ranch	2	1	28/08/2012	15/04/2013	 $67,750 			
182	 $73,000 	1027	15	Victorian	2	1	18/11/2012	16/06/2013	 $70,750 			
183	 $69,000 	1348	15	Victorian	2	1.5	06/02/2013	04/06/2013	 $70,250 			
184	 $115,500 	1767	16	Condo	2	1.5	28/07/2012	31/05/2013	 $103,750 			
185	 $90,000 	1400	16	Victorian	2	1.5	10/09/2012	06/05/2013	 $89,000 			
186	 $86,000 	1385	16	Victorian	2	1.5	28/05/2012	08/04/2013	 $75,500 			
187	 $112,500 	1710	16	Victorian	2	1.5	05/10/2012	19/04/2013	 $114,750 			
188	 $113,900 	1680	17	Ranch	2	1.5	09/06/2012	03/06/2013	 $105,750 			
189	 $96,000 	1573	17	Victorian	2	1.5	20/06/2012	08/06/2013	 $89,250 			
190	 $125,000 	2180	17	Ranch	3	2	02/02/2013	07/04/2013	 $121,250 			
191	 $117,000 	1928	18	Victorian	2	1.5	06/11/2012	18/04/2013	 $112,250 			
192	 $159,900 	2440	19	Victorian	3	2	26/02/2013	26/05/2013	 $163,000 			
193	 $72,900 	1007	19	Ranch	2	1	04/01/2013	24/04/2013	 $64,750 			
194	 $110,000 	1657	20	Ranch	2	1.5	16/06/2012	29/05/2013	 $100,000 			
195	 $95,500 	1565	20	Ranch	2	1.5	08/11/2012	10/06/2013	 $93,500 			
196	 $93,400 	1543	20	Ranch	2	1.5	07/10/2012	16/04/2013	 $83,000 			
197	 $67,000 	1181	21	Ranch	2	1	13/02/2013	07/05/2013	 $61,500 			
198	 $89,900 	1464	22	Condo	2	1.5	14/05/2012	03/04/2013	 $90,750 			
199	 $71,000 	1083	22	Ranch	2	1	15/10/2012	18/05/2013	 $61,000 			
200	 $118,000 	1830	23	Victorian	2	1.5	10/06/2012	01/04/2013	 $114,250 			
201	 $87,600 	1156	23	Condo	2	1	14/07/2012	04/05/2013	 $76,000 			
202	 $135,000 	2253	23	Ranch	3	2	25/04/2013	29/04/2013	 $116,000 			
203	 $73,100 	1299	24	Condo	2	1	23/12/2012	30/05/2013	 $70,000 			
204	 $77,300 	1320	24	Ranch	2	1.5	20/12/2012	04/04/2013	 $75,750 			
205	 $125,000 	2277	25	Ranch	3	2	09/08/2012	07/05/2013	 $121,250 			
206	 $129,900 	2743	25	Victorian	3	2.5	13/09/2012	07/06/2013	 $116,750 			
207	 $108,000 	2200	26	Condo	3	2	20/07/2012	28/04/2013	 $100,250 			
208	 $169,500 	2931	28	Victorian	3	2.5	01/07/2012	08/05/2013	 $169,500 			
209	 $155,300 	2200	28	Victorian	3	2	21/02/2013	20/06/2013	 $141,250 			
210	 $102,000 	1713	30	Condo	2	1.5	09/02/2013	07/05/2013	 $98,750 			
211	 $72,500 	1140	30	Ranch	2	1	05/01/2013	27/06/2013	 $66,500 			
212	 $104,900 	1900	34	Victorian	2	1.5	11/08/2012	11/04/2013	 $97,500 			
213	 $72,000 	1050	40	Ranch	2	1	23/07/2012	17/04/2013	 $65,500 			
214	 $85,000 	1190	41	Ranch	2	1	02/10/2012	20/05/2013	 $73,750 			
215	 $74,900 	1733	43	Victorian	2	1.5	01/12/2012	04/05/2013	 $66,500 			
216	 $72,000 	1121	46	Ranch	2	1	02/09/2012	20/04/2013	 $66,750 			
217	 $102,000 	1478	53	Ranch	2	1.5	21/12/2012	17/04/2013	 $91,750 			

ID	Asking Price	Square feet	Age	Style	Bedroom	Bath	Date Listed	Date Sold	Sales Price	Warranty purchase	Warranty cost	Closing cost	Tax Rate	Condo Fee						
101	 $87,400 	1236	3	Condo	2	1	22/11/2012	14/04/2013	 $77,750 	Y										
102	 $110,900 	1740	4	Victorian	2	1.5	23/08/2012	20/06/2013	 $105,250 	Y										
103	 $95,000 	1715	4	Ranch	2	1.5	18/05/2013	22/05/2013	 $95,000 	Y										
104	 $87,000 	1273	4	Condo	2	1	30/09/2012	12/05/2013	 $81,750 	N										
105	 $73,900 	970	4	Victorian	1	0.5	07/02/2013	24/04/2013	 $63,500 	N										
106	 $77,000 	900	5	Victorian	1	0.5	21/06/2012	14/05/2013	 $67,750 	N							Condo fee	$150 		
107	 $133,000 	1850	5	Ranch	2	1.5	02/03/2013	16/05/2013	 $115,500 	Y								only for condos with 2 or more bedrooms		
108	 $116,000 	1720	5	Ranch	2	1.5	18/03/2013	23/04/2013	 $99,750 	Y										
109	 $102,000 	1606	5	Ranch	2	1.5	05/08/2012	29/05/2013	 $103,000 	Y							Warranty Cost	$200 	Age < 5	
110	 $94,000 	1305	5	Victorian	2	1.5	20/06/2012	25/05/2013	 $88,250 	N								$300 	Age >=5	
111	 $112,900 	1700	6	Condo	2	1.5	04/02/2013	08/04/2013	 $115,000 	N								only pay if purchased		
112	 $105,000 	1620	6	Condo	2	1.5	27/06/2012	03/05/2013	 $106,000 	Y										
113	 $104,500 	1630	6	Condo	2	1.5	22/07/2012	02/04/2013	 $98,000 	Y							Tax Rate Table			
114	 $103,000 	1540	6	Ranch	2	1.5	24/03/2013	12/06/2013	 $90,500 	Y							Square feet	County Code	Tax Rate	
115	 $87,200 	1229	6	Ranch	2	1	23/01/2013	26/06/2013	 $87,000 	N							0	10	0.15%	
116	 $97,500 	1500	7	Ranch	2	1.5	28/06/2012	16/04/2013	 $82,750 	N							1000	11	0.21%	
117	 $100,000 	1535	7	Victorian	2	1.5	09/05/2012	28/04/2013	 $91,000 	Y							1500	12	0.22%	
118	 $92,000 	1415	7	Ranch	2	1.5	06/07/2012	24/04/2013	 $91,000 	Y							2000	13	0.24%	
119	 $86,900 	1165	7	Victorian	2	1	10/08/2012	15/05/2013	 $88,500 	Y							3000	14	0.25%	
120	 $76,600 	1200	7	Condo	2	1	07/05/2012	01/05/2013	 $68,000 	Y										
121	 $105,000 	1920	8	Ranch	2	1.5	27/04/2013	14/05/2013	 $95,500 	Y							Closing Cost Table			
122	 $94,500 	1580	9	Victorian	2	1.5	05/04/2013	15/06/2013	 $95,250 	Y							Style	County Code	Cost	
123	 $97,500 	1739	13	Victorian	2	1.5	10/05/2013	21/06/2013	 $84,750 	Y							Condo	10	200	
124	 $70,000 	1505	14	Condo	2	1.5	15/03/2013	30/05/2013	 $70,500 	N							Victorian	11	250	
125	 $60,000 	1198	14	Ranch	2	1	08/03/2013	09/05/2013	 $51,000 	Y							Ranch	12	400	
126	 $158,000 	2563	14	Victorian	3	2.5	19/11/2012	11/06/2013	 $159,500 	N										
127	 $58,000 	1051	15	Ranch	2	1	05/12/2012	17/05/2013	 $58,000 	N							Average Sales Price for:			
128	 $169,500 	3750	19	Victorian	4	2.5	14/03/2013	30/05/2013	 $165,000 	N							All 2 bedroom properties			
129	 $78,000 	1080	21	Victorian	2	1	09/01/2013	02/04/2013	 $68,500 	Y							All Victorian properties			
130	 $54,000 	1142	21	Victorian	2	1	11/10/2012	05/05/2013	 $51,750 	N							Properties with 1.5 bathrooms			
131	 $107,000 	1464	22	Victorian	2	1.5	22/12/2012	25/05/2013	 $107,000 	N										
132	 $210,000 	2116	25	Victorian	3	2	01/09/2012	20/06/2013	 $195,250 	N										
133	 $66,000 	1159	25	Ranch	2	1	13/09/2012	13/06/2013	 $62,500 	Y										
134	 $72,500 	1280	38	Victorian	2	1	01/03/2013	04/05/2013	 $70,250 	Y										
135	 $93,900 	1428	40	Victorian	2	1.5	03/10/2012	23/05/2013	 $82,500 	Y										
136	 $82,000 	1375	40	Victorian	2	1.5	17/05/2012	06/05/2013	 $82,750 	N										
137	 $62,000 	1480	40	Ranch	2	1.5	11/09/2012	20/05/2013	 $59,500 	N										
138	 $184,400 	2250	40	Condo	3	2	04/11/2012	21/05/2013	 $182,500 	Y										
139	 $69,900 	1400	45	Ranch	2	1.5	10/03/2013	10/04/2013	 $60,750 	N										
140	 $156,000 	1920	1	Ranch	2	1.5	29/12/2012	28/04/2013	 $134,000 	Y										
141	 $144,900 	1710	1	Victorian	2	1.5	16/04/2013	02/06/2013	 $143,250 	N										
142	 $180,000 	2774	2	Victorian	3	2.5	10/12/2012	05/04/2013	 $165,500 	Y										
143	 $215,000 	2921	3	Victorian	3	2.5	17/11/2012	06/05/2013	 $215,000 	N										
144	 $75,500 	1275	3	Condo	2	1	10/10/2012	01/04/2013	 $77,000 	Y										
145	 $199,900 	2580	4	Ranch	3	2.5	30/06/2012	18/04/2013	 $187,750 	Y										
146	 $190,000 	2580	4	Victorian	3	2.5	02/09/2012	22/04/2013	 $171,000 	Y										
147	 $137,500 	1837	4	Victorian	2	1.5	16/04/2012	07/04/2013	 $137,500 	N										
148	 $215,000 	2848	4	Ranch	3	2.5	25/12/2012	30/05/2013	 $193,500 	N										
149	 $75,000 	1338	4	Ranch	2	1.5	08/04/2013	15/05/2013	 $76,500 	Y										
150	 $75,900 	997	4	Ranch	1	0.5	13/06/2012	02/06/2013	 $75,000 	Y										
151	 $87,000 	1280	5	Victorian	2	1	23/01/2013	27/06/2013	 $87,000 	N										
152	 $85,500 	1900	5	Ranch	2	1.5	04/07/2012	01/06/2013	 $81,000 	N										
153	 $215,000 	2664	6	Victorian	3	2.5	20/09/2012	13/06/2013	 $212,750 	N										
154	 $87,500 	1173	6	Victorian	2	1	29/08/2012	27/05/2013	 $87,500 	Y										
155	 $81,000 	1365	6	Ranch	2	1.5	29/06/2012	23/06/2013	 $81,750 	Y										
156	 $75,000 	1030	6	Ranch	2	1	19/11/2012	28/05/2013	 $69,750 	N										
157	 $88,900 	1549	7	Condo	2	1.5	04/06/2012	04/05/2013	 $77,250 	Y										
158	 $80,500 	1258	7	Victorian	2	1	16/04/2013	27/05/2013	 $74,750 	N										
159	 $127,000 	1880	8	Ranch	2	1.5	27/07/2012	29/04/2013	 $127,000 	Y										
160	 $208,000 	2600	10	Victorian	3	2.5	04/08/2012	29/04/2013	 $178,750 	N										
161	 $145,000 	2150	10	Victorian	3	2	02/11/2012	01/06/2013	 $146,250 	Y										
162	 $89,000 	1746	10	Condo	2	1.5	04/02/2013	13/04/2013	 $77,250 	N										
163	 $61,900 	837	10	Condo	1	0.5	05/02/2013	20/06/2013	 $53,000 	N										
164	 $130,000 	2000	11	Victorian	2	2	15/05/2013	25/05/2013	 $117,000 	N										
165	 $83,500 	1560	11	Ranch	2	1.5	13/08/2012	13/05/2013	 $73,250 	Y										
166	 $99,500 	1725	12	Condo	2	1.5	25/02/2013	12/04/2013	 $98,500 	Y										
167	 $205,000 	2650	13	Victorian	3	2.5	09/01/2013	21/06/2013	 $178,250 	Y										
168	 $97,500 	1430	13	Victorian	2	1.5	19/05/2012	05/04/2013	 $99,250 	Y										
169	 $92,500 	1050	13	Ranch	2	1	04/05/2013	19/06/2013	 $78,500 	Y										
170	 $105,000 	1680	13	Ranch	2	1.5	26/04/2012	06/04/2013	 $101,750 	N										
171	 $67,000 	1350	13	Condo	2	1.5	23/09/2012	06/05/2013	 $68,250 	N										
172	 $123,500 	1894	14	Ranch	2	1.5	27/07/2012	15/05/2013	 $123,500 	N										
173	 $97,500 	1360	14	Condo	2	1.5	25/05/2012	01/04/2013	 $97,500 	N										
174	 $92,200 	1326	14	Victorian	2	1.5	20/04/2013	20/06/2013	 $81,000 	Y										
175	 $123,900 	1706	14	Ranch	2	1.5	10/05/2013	13/05/2013	 $110,250 	Y										
176	 $120,000 	1948	14	Condo	2	1.5	01/10/2012	03/04/2013	 $120,000 	N										
177	 $79,900 	1314	14	Condo	2	1.5	23/02/2013	02/04/2013	 $70,250 	N										
178	 $125,000 	2150	15	Ranch	3	2	06/01/2013	25/05/2013	 $123,750 	Y										
179	 $111,000 	1630	15	Victorian	2	1.5	13/07/2012	25/04/2013	 $99,750 	N										
180	 $99,500 	1500	15	Victorian	2	1.5	11/05/2013	29/05/2013	 $99,500 	Y										
181	 $70,000 	1215	15	Ranch	2	1	28/08/2012	15/04/2013	 $67,750 	Y										
182	 $73,000 	1027	15	Victorian	2	1	18/11/2012	16/06/2013	 $70,750 	N										
183	 $69,000 	1348	15	Victorian	2	1.5	06/02/2013	04/06/2013	 $70,250 	N										
184	 $115,500 	1767	16	Condo	2	1.5	28/07/2012	31/05/2013	 $103,750 	Y										
185	 $90,000 	1400	16	Victorian	2	1.5	10/09/2012	06/05/2013	 $89,000 	Y										
186	 $86,000 	1385	16	Victorian	2	1.5	28/05/2012	08/04/2013	 $75,500 	N										
187	 $112,500 	1710	16	Victorian	2	1.5	05/10/2012	19/04/2013	 $114,750 	N										
188	 $113,900 	1680	17	Ranch	2	1.5	09/06/2012	03/06/2013	 $105,750 	N										
189	 $96,000 	1573	17	Victorian	2	1.5	20/06/2012	08/06/2013	 $89,250 	Y										
190	 $125,000 	2180	17	Ranch	3	2	02/02/2013	07/04/2013	 $121,250 	Y										
191	 $117,000 	1928	18	Victorian	2	1.5	06/11/2012	18/04/2013	 $112,250 	N										
192	 $159,900 	2440	19	Victorian	3	2	26/02/2013	26/05/2013	 $163,000 	N										
193	 $72,900 	1007	19	Ranch	2	1	04/01/2013	24/04/2013	 $64,750 	Y										
194	 $110,000 	1657	20	Ranch	2	1.5	16/06/2012	29/05/2013	 $100,000 	Y										
195	 $95,500 	1565	20	Ranch	2	1.5	08/11/2012	10/06/2013	 $93,500 	Y										
196	 $93,400 	1543	20	Ranch	2	1.5	07/10/2012	16/04/2013	 $83,000 	Y										
197	 $67,000 	1181	21	Ranch	2	1	13/02/2013	07/05/2013	 $61,500 	N										
198	 $89,900 	1464	22	Condo	2	1.5	14/05/2012	03/04/2013	 $90,750 	N										
199	 $71,000 	1083	22	Ranch	2	1	15/10/2012	18/05/2013	 $61,000 	Y										
200	 $118,000 	1830	23	Victorian	2	1.5	10/06/2012	01/04/2013	 $114,250 	N										
201	 $87,600 	1156	23	Condo	2	1	14/07/2012	04/05/2013	 $76,000 	Y										
202	 $135,000 	2253	23	Ranch	3	2	25/04/2013	29/04/2013	 $116,000 	N										
203	 $73,100 	1299	24	Condo	2	1	23/12/2012	30/05/2013	 $70,000 	Y										
204	 $77,300 	1320	24	Ranch	2	1.5	20/12/2012	04/04/2013	 $75,750 	Y										
205	 $125,000 	2277	25	Ranch	3	2	09/08/2012	07/05/2013	 $121,250 	Y										
206	 $129,900 	2743	25	Victorian	3	2.5	13/09/2012	07/06/2013	 $116,750 	N										
207	 $108,000 	2200	26	Condo	3	2	20/07/2012	28/04/2013	 $100,250 	N										
208	 $169,500 	2931	28	Victorian	3	2.5	01/07/2012	08/05/2013	 $169,500 	Y										
209	 $155,300 	2200	28	Victorian	3	2	21/02/2013	20/06/2013	 $141,250 	Y										
210	 $102,000 	1713	30	Condo	2	1.5	09/02/2013	07/05/2013	 $98,750 	Y										
211	 $72,500 	1140	30	Ranch	2	1	05/01/2013	27/06/2013	 $66,500 	Y										
212	 $104,900 	1900	34	Victorian	2	1.5	11/08/2012	11/04/2013	 $97,500 	N										
213	 $72,000 	1050	40	Ranch	2	1	23/07/2012	17/04/2013	 $65,500 	N										
214	 $85,000 	1190	41	Ranch	2	1	02/10/2012	20/05/2013	 $73,750 	N										
215	 $74,900 	1733	43	Victorian	2	1.5	01/12/2012	04/05/2013	 $66,500 	Y										
216	 $72,000 	1121	46	Ranch	2	1	02/09/2012	20/04/2013	 $66,750 	Y										
217	 $102,000 	1478	53	Ranch	2	1.5	21/12/2012	17/04/2013	 $91,750 	Y										
218	 $130,000 	1525	22	Ranch	3	2	01/05/2013			Y										
Average sales price:									 $100,462 											
																				
Question number two:



Go to the bottom of the list. The average of all the Sales Price is listed in cell J120. Notice that Propery #218 is listed but not sold yet. How much does Property #218 need to be sold at (to be shown in cell J119) in order for the average sales price to become $100,800? Only enter whole number in the answer box; no dollar sign, no comma, no decimal point.



answer: __________
																				
question three: 



Add a Total Row to the table. Display only the properties with 1 bathroom. What is the Average Sales Price of all the 1 bathroom properties? Write your answer in whle number; no dollar sign, no comma, no decimal.

answer: _____
																				
question four : 



Create a PivotTable to calculate summary statistics. Use the following filed as labels: Style, Bedroom, and Date Sold. And use the Sales Price as the value field. Answer the following questions:

1. What is the number of Condo properties with 2 bedrooms that were sold in May 2013? answer: ______
2. What is the average sales price for all the Ranch properties with 2 bedrooms sold in April 2013? answer: _______
Make sure you enter whole number only; no dollar sign, no comma, no decimal. You will need to get both answers right to receive credit for this question.



question five: 




Conditional format the column Sales Price to highlight the bottom 7% of the price in green. How many properties have a green highlighted cell?



11


10


9


8


7

 
croani posted a reply
Jun 19, 2014 at 8:43pm
question six: 





Calculate Condo Fee in column O. Only those properties that are condos with 2 or more bedrooms have to pay a condo fee of $150, listed in cell S7. Enter a formula to calculate condo fees for ALL the properties. What is the correct formula (use property #101 as an example)?




a. =IF(E2="Condo",150,IF(F2>=2,0,0)


b. =IF(AND(F2>=2,E2="Condo"),S7,0)


c. =IF(OR(E2="Condo",F2>=2),S7,0)


d. =IF(AND(E2="Condo",F2>=2),$S$7,0)


e. =IF(OR(F2<2,E2="Condo"),S$7,0)
question seven: 



To calculate the warranty cost, the following criteria are used (as in R10:T12):

If a warranty is purchased (that is, the value in Warranty purchase is Y), then the warranty cost is determined by the age of the property. The cost is $200 when the age of the property is less than 5 years old, and $300 when it is greater than or equal to 5 years old. When a warranty is not purchased (that is, the value in Warranty purchase is N), the warranty cost is 0.

Use a nested IF formula to calculate the warranty cost in column L for All the properties (remember to autofill). Choose ALL the correct answers below. You have to pick all the correct answers to receive credit for this question.



1. The correct formula (using propery #121 as an example) is:

=IF(D22<5,200,IF(K22>=5,300,IF(K22="N",0)))


2. The correct formula (using propery #121 as an example) is:

=IF(K22="N",0,IF(D22>=5,300,200))


3. The correct formula (using propery #121 as an example) is:

=IF(D22="Y",300,IF(D22<5,200,0))


4. The warranty cost for property #119 is $300.


5. The warranty cost for property #158 is $200.

question eight: 



Sort the table in the following order:

Square Feet, largest to smallest
Style, A to Z
Age, smallest to largest
Date Sold, newset to oldest
Make sure you use the exact order with the correct criteria for each. What is the ID number (in column A) for the first property on the sorted list?



a. 128


b. 140


c. 153


d. 217


e. 193

question nine: 



Enter a formula in the cell T29 to calculate the average Sales Price for all the properties with 2 bedrooms. Note that the number of Bedrooms is recorded in column F, and the Sales Price is in column J. Write the result shown in T29 in the answer box in whole number; no dollar sign, no comma, no decimal point.



answer: _____

Psychology-adolescent

Psychology-adolescent

Consider the following:

Is the experience of being an adolescent the same for males and females?  Is it the same across different historical time periods or eras?  What about across different cultures or subpopulations within a culture? This assignment involves exploring similarities and differences in one of these areas. Using the UOPX library, search for articles that address gender, historical, cultural, or sub-cultural differences in adolescence. 

 

Write a 1000-1500 word paper summarizing your findings. Your paper should include a brief introduction to the topic, a review of research findings, and a conclusion. 

 

Include at least four references from professional peer-reviewed journals.

key qualities of drama and poetry

key qualities of drama and poetry

All literature involves some kind of performance which is intended for an audience. Sometimes, however, the performative quality of a work (i.e., the fact that it is being presented to an audience) is more obvious than at others. Drama and poetry, for example, tend to emphasize overt performance more than do short stories, which more often are read silently and in solitude. 

How is the more direct performative aspect of drama and/or poetry reflected in these forms? (Consider for example, each genre’s uses of literary structure, language, technique, and style.) How do these literary elements affect your reading experience? 

In your post, identify key qualities of drama and poetry which emphasize their performative qualities. Discuss how these characteristics shape your reading response. Support your views with at least one example of a dramatic text and one example of a poem.

Your initial post should be at least 150 words in length

Post MGT497 unit 3 discussion

Post MGT497 unit 3 discussion

Unit 3.1 DB: Laws of the Fifth Discipline

Select one Law of the Fifth Discipline that you are not going to discuss in your assignment for this week, define the law, describe how you have experienced this law at work and discuss what you have learned from this law.

Make sure you respond in a substantive manner to two peers’ posts that have discussed a different Law than your post.

Conflict Identification and Resolution

Conflict Identification and Resolution

Conflict Identification and Resolution
We live in a very complex and culturally diverse society. When we bring individuals together from diverse backgrounds in a work environment conflict can arise when expectations are not realized or met. Rather than hoping conflict will go away, this paper should explore and identify the reasons for conflict and how to successfully address them in a team environment.

Write a 4-5 page paper (excluding title & reference pages) assessing the components of conflict. The following need to be addressed within your paper:
Describe a conflict within an organization or team with which you are familiar.
Identify and describe the source(s) and level of the conflict and support with evidence.
Describe the steps taken to resolve the conflict or, if it is an ongoing conflict, propose steps to resolve the conflict.
Describe a minimum of three conflict outcomes that could reasonably occur as a result of the conflict resolution. Support your reasoning for each possible outcome.
Paper must use a minimum of three scholarly sources, in addition to the attached document, your paper must include citations and be formatted according to APA style 

This is a final exam paper that must be completed no later than

This is a final exam paper that must be completed no later than

This is a final exam paper that must be completed no later than 24:00 midnight, Sunday, July 6th 2014. Here are the directions:

A final case study and strategic plan is due the last class session.

Focus of the Final Case Study and Strategic Plan

Read the Starbucks’ Global Quest 2006: Is the Best Yet to Come? case provided in the Course Materials section. From the perspective of an executive with the firm, prepare a 10-12 page, three-year strategic management proposal to Starbuck’s managing board of directors. Your proposal must be future-oriented and include an economic assessment, marketing assessment plan, a financial plan, an organizational structure recommendation, and supporting rationale. Use non-course materials to support your contentions and incorporate pro-rata financial statements and supporting documentation. Use APA style and submit your proposal to the instructor by the last day of class.

Writing the Final Case Study and Strategic Plan

The Final Case Study and Strategic Plan:

Must be 10-12 double-spaced pages in length and formatted according to APA style as outlined in the approved APA style guide.
Must include a cover page that includes:
- Title of paper
- Student’s name
- Course name and number
- Instructor’s name
- Date submitted
Must include an introductory paragraph with a succinct thesis statement.
Must address the topic of the paper with critical thought.
Must conclude with a restatement of the thesis and a conclusion paragraph.
Must use at least five professional resources, including a minimum of two from ProQuest.
Must use APA style as outlined in the approved APA style guide to document all sources.
Must include, on the final page, a Reference Page that is completed according to APA style as outlined in the approved APA style guide.

Only one problem, I am having problems uploading the PDF. file that is required to read through to complete the assignment. Does anyone know how to upload a pdf. here?

Additional Requirements

Min Pages: 10
Level of Detail: Show all work
Other Requirements: I am having a problem uploading the PDF file. Would you happen to know how to upload it? 

Your Rating:12345. “Lost Cause” Please…

Your Rating:12345. “Lost Cause” Please…

Your Rating:12345.
"Lost Cause" Please respond to the following: (Note: Please respond to one [1] of the following two [2] bulleted items in a primary posting of at least 125 words. In addition, please make a substantive comment to one [1] of your classmates.)

•From the e-Activity about the Lost Cause, compare the two (2) different narratives about the causes and results of the Civil War that Americans developed in both Union states and Confederate states. Describe the key reasons why these narratives are an important part of understanding differences between the North and South in the present-day of United States. Provide a rationale for your response.
•From the e-Activity about the Lost Cause, identify at least two (2) reasons for these narratives’ importance in regard to race relations in today’s society. Provide a rationale and real-world example for each reason. 

Additional Requirements 
Min Pages: 1 
Level of Detail: Only answer needed 
Other Requirements: Need at least a paragraph to one of the questions.

Nervous Tissue a) Describe the positive and…

Nervous Tissue a) Describe the positive and…

Nervous Tissue
a) Describe the positive and negative aspects of Nervous Tissue (consider description, location, or function). 
b) Describe one disease/disorder that is associated with nervous tissue. Be sure to include any specific characteristics of the tissue that may be implicated in the disease/disorder 
c) Supporting citations.
Based on your knowledge of location & functions of tissues: Explain why it is better to have non-keratinized Stratified Squamous epithelium lining the mouth rather than simple columnar epithelium. 
RESOURCES: Students may use the following web sites (and other sources) for the description, functions and locations of the tissue assigned: (a) Web Site: www.pathguy.com/histo/000.htm www.kumc.edu/instruction/medicine/anatomy/histoweb/

Additional Requirements 

Min Words: 200 
Max Words: 200 
Min Pages: 2 
Max Pages: 3 
Level of Detail: Only answer needed

BSOP 588 Final Exam

BSOP 588 Final Exam

BSOP 588 Fianl Exam

Page 1

1. TCO E) Determining how customers will value your products can be assessed by all of the following EXCEPT:

2. TCO D) All of the following are stages in developing an improvement plan EXCEPT:

3. (TCO C) Terms such as kanban, single-minute exchange of dies, and visual controls are most closely associated with:

4. (TCO C) Which one of the following would not be a primary step in the poka-yoke process?

5. (TCO B) _____ measures are generally tracked by senior leadership to gauge overall organizational performance.

6. (TCO I) The cost associated with unplanned machine downtime, when operators halt the production line after identifying an unacceptably high rate of defective output, should be classified as:

7. (TCO A) Lean approaches focus on:

8. (TCO B) Robert Kaplan and David Norton developed a balanced scorecard which had four perspectives. Which one of the following is NOT one of them?

9. (TCO D) ISO 9000 requires that all the elements required for a quality system, such as control processes, measuring and test equipment, and other resources needed to achieve the required quality of conformance, be documented in a _____, which serves as a permanent reference for implementing and maintaining the system.

10. (TCO H) Determining the most likely causes of defects occurs during which DMAIC phase?

Page 2

1. TCO B) Explain why it is difficult to obtain a single, universal definition of quality. Be specific in your response.

2. (TCO I) Identify three aspects of managing and using performance data so that it is useful to the organization. Provide an example of each aspect. Be specific in your response.

3. (TCO G) Discuss how the corporate culture is displayed and its role on quality management behavior. Please provide multiple examples.

4.(TCO F) What could be the reason(s) for failed quality management strategies?

5.(TCO H) Explain the process of design failure mode and effects analysis and describe how it could be applied to the cashier checkout stand at a supermarket. Make sure you provide at least three examples.

6. TCO C) Some have argued the Six Sigma programs are merely repackaged versions of older quality improvement programs that originally accompanied TQM initiatives in the 1980s. Present arguments both support and refute this view. Make sure you link your discussion with examples of the older quality improvement programs (i.e. Deming, Juran, and so forth).

HOSP 585 Week 8 Final Exam

HOSP 585 Week 8 Final Exam

HOSP 585 Week 8 Final Exam

1.(TCO F) You are the vice president of purchasing for Darden Restaurant group in Orlando, which owns several restaurant chain brands. You have just hired a new purchasing director for food service equipment. You are preparing to spend some time with him and review some key features of various types of kitchen equipment that will assist him in determining the needs of the corporation. Prepare an outline of what you will review with your new employees. Arrange and assemble a training guide on key features for the following pieces of food service equipment: stoves and ovens, deep-fat fryers, low-temperature ovens, forced-air convection oven, microwave oven, infrared oven, hot-food holding tables, refrigerators and freezers, and ice machines. You will also compare and contrast the benefits and disadvantages of these types of equipment so that a better purchasing job will be done. (Points : 40)

2.(TCO G) You are planning to open a restaurant with expected sales volume of $1,500,000 per annum. You have located an ideal location for your new restaurant venture. You are meeting with the property managers and developers to negotiate a lease. Develop and formulate a strategy on what you would like to have included in the lease. Defend why you selected this strategy. (Points : 40)

3.(TCO B) The registration staff functions are critical to the overall satisfaction of the guest. If you were an assistant manager responsible for the room's division of a full-service hotel, how would you organize the registration and guest services staff? What are the best practices you would establish for handling guest services, the registration process, arrivals, departures, and group arrivals? How will your staff interact with the guest as they arrive and check out of the hotel? (Points : 40)

4.(TCO C) The cost of labor in the housekeeping department can be highest at a full-service hotel. How would you control labor costs in a full-service hotel? Explain in detail how you would calculate a labor schedule for the hotel. Using best practices, how would you calculate and what methods would you use to reduce turnover? (Points : 40)

5.(TCO A) Analyze and appraise the various kinds and characteristics of restaurant organizations and their owners. Compare and contrast corporate owned and independent restaurants. Examine three restaurateurs who have been successful. Give examples and analysis of the organization of three multi-unit chains. In your judgment, were they successful or unsuccessful? (Points : 40)

6.(TCO E) You have decided to open a new restaurant. You have located a restaurant location that meets all the site requirements and demographics for all the site requirements and demographics for a fast food operation. Would you consider leasing of the property? Why or why not? What might be included in the lease agreement if you decided to lease from the current owner? Give some specifics on typical restaurant leases. (Points : 40)

7.(TCO D) You are the general manager of a full-service hotel. You need to set up best practices to organize and staff your sales and marketing department. Discuss how you would set up your sales staff. What are the responsibilities of the various members of the sales department? Give an overview of characteristics you would like to promote and establish in your sales department and the characteristics of your sales people. (Points : 40)