Jose and Emily work as auditors for the state of Texas. They have been assigned to the audit of the Lone Star School District. There have been some problems with audit documentation for the travel and entertainment reimbursement claims of the manager of the school district. The manager knows about the concerns of Jose and Emily, and he approaches them about the matter. The following Conversations takes place:

Manager: Listen, I've requested the documentation you asked for, but the hotel says it's no longer in its system.

Jose: Don't you have the credit card receipt or credit card statement?

Manager: I paid cash.

Jose: What about a copy of the hotel bill?

Manager: I threw it out.

Emily: That's a problem. We have to document all your travel and entertainment expenses for the city manager's office.

Manager: Well, I can't produce documents that the hotel can't find. What do you want me to do?

Questions: Multiple Choice

The manager seems to be failing in regard to which Pillar of Character?

A. Caring

B. Respect

C. Responsibility

D. Fairness

If Jose and Emily decide to report this incident to the school, they would be operating under which Pillar of Character?

A. Caring

B. Respect

C. Responsibility

D. Fairness

1. You have been provided information on summary statistical data for two neighborhoods. Specifically, you have been provided calculations on the Average Price Per Square Foot, Average Age and Average, and the Average Prices for houses in the two neighborhoods and the Standard Deviation of each variable. Apply the method of Confidence Intervals at (97%) to Estimate answer the question whether:
   1. Average Age of House in each neighborhood is significantly different from 60 years
   2. Average Price of Houses in each neighborhood is significantly different from $415,000
   3. List at least two reasons that you think that the Average Price of houses and the Average Age of Houses in one neighborhood will be different from the other neighborhood in the file (You may use personal knowledge of the neighborhoods).

      Comparative Descriptive Statistics – Arocher vs Borough Park Average Price per Square Foot, Average Age of House & Average Price of House
      Neighborhood and Sample Size (n)	Average	Standard Error	Standard Deviation
      Average Age of House
      Staten Island, Arocher (40)	39.4250	4.48128	28.34213
      Brooklyn, Borough Park (49)	91.6939	2.04233	14.29628
      Average Price of House
      Staten Island, Arocher (40)	$396,374.30	$14,930.990	$94,431.873
      Brooklyn, Borough Park (49)	$696,638.78	$24,093.715	$168,656.005

Database Management System

Complete the following exercises in Connolly & Begg:

4.8 The following tables from part of a database held in a relational DBMS

Hotel (hotelNo, hotelName, city)

Room (roomNo, hotelNo, type, price)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Guest (guestNo, guestName, guestAddress)

a) Identify the foreign keys in this schema.

b) Explain how the entity integrity rule and the referential integrity rule apply to these relations.

5.8 Describe the relations that would be produced by the following relational algebra operations. In your description, make clear what attribute your relations have, and explain what each relation represents in the real world.

a) π_hotelNo(σ_{price > 50}(Room))

b) σ_{Hotel.hotelno = Room.hotelNo}(Hotel × Room)

c) π_hotelName(Hotel ⨝ _{Hotel.hotelNo = Room.hotelNo}(σ_{price > 50}(Room)))

The following tables form part of a Library database held in an RDBMS:

Book (ISBN, title, edition, year)

BookCopy (copyNo, ISBN, available)

Borrower (borrowerNo, borrowerName, borrowerAddress)

BookLoan (copyNo, dateOut, dateDue, borrowerNo)

Formulate the following queries in relational algebra:

5.24 List all book titles

5.25 List all book titles published in the year 2012.

5.27 List all copies of book titles that are available for borrowing.

5.30 List the names of borrowers with overdue book.s

Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated with use of the center are charged to the hotel group (luxury, resort, standard, and budget) based on the length of time of calls made (time usage). Idle time of the reservation agents, time spent on calls in which no reservation is made, and the fixed cost of the equipment are allocated based on the number of reservations made in each group. Due to recent increased competition in the hotel industry, the company has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each hotel group was as follows: Division Time Usage(thousands of minutes) Number of Reservations (thousands) Luxury 220 104 Resort 110 143 Standard 440 273 Budget 330 780 During this period, the cost of the call center amounted to $870,000 for personnel and $660,000 for equipment and other costs.

Required: a. Determine the allocation to each of the divisions using the following:

1. A single rate based on time used. (Do not round intermediate calculations.)

2. Dual rates based on time used (for personnel costs) and number of reservations (for equipment and other cost). (Do not round intermediate calculations.)

Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated with use of the center are charged to the hotel group (luxury, resort, standard, and budget) based on the length of time of calls made (time usage). Idle time of the reservation agents, time spent on calls in which no reservation is made, and the fixed cost of the equipment are allocated based on the number of reservations made in each group. Due to recent increased competition in the hotel industry, the company has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each hotel group was as follows:

During this period, the cost of the call center amounted to $890,000 for personnel and $630,000 for equipment and other costs.

Required:

a. Determine the allocation to each of the divisions using the following:

1. A single rate based on time used. (Do not round intermediate calculations.)

2. Dual rates based on time used (for personnel costs) and number of reservations (for equipment and other cost). (

The Wilton is an all-inclusive spa and hotel in the heart of Brooklyn and uses guests as its measure of activity. During June, The Wilton budgeted for 2,000 guests, but it actually hosted 2,100 guests. The hotel used the following revenue and cost formulas in its budgeting, where q is the number of guests:

Revenue: $62.90q
Personnel expenses: $28,500 + $20.40q
Food and beverage supplies: $1,400 + $9.90q
Occupancy expenses: $8,200 + $3.30q
Spa expenses: $4,000 + $0.40q

The hotel reported the following actual results for June:

Revenue                                       $129,450

Personnel expenses                      $ 74,770

Food and beverage supplies           $ 22,940

Occupancy expenses                     $ 14,640

Spa expenses                                   $   4,740

Required:
a. Prepare a flexible budget performance report showing The Wilton’s revenue and spending variances and activity variances for June. Label each variance as favorable (F) or unfavorable (U), filling out the shaded squares. (22 points)

b. Describe at least two potential reasons for the revenue, spa expenses and food/beverage supplies variances found above. Are any of the variances related? Describe. (6 pts)

1. Parkruns are free 5km timed runs usually run on weekends in different cities, towns and suburbs around the world. It is suspected that they are competitive and hence faster than 5km family fun runs which require payment for registration. Parkrun finishers do not get medals whereas all family fun run finishers get medals. The summary statistics below are from two random samples of 10 park runners and 10 5km family fun runners in Bellville. The races were run on the same route and on 2 separate days but with identical weather conditions. The summary statistics are for the recorded finishing times (in minutes) of the runners. park runners family fun runners Sample Mean: 20.58 25.67 Sample standard deviation : 3.5 5.7 (a) Is there evidence that the mean finishing time differs between the park runners and family fun runners? Perform an appropriate statistical test. (b) Construct a 95% confidence interval for the difference between the population means of the two groups. Compare your results to your conclusions in (a). (c) What assumption(s) are necessary for performing the hypothesis tests and constructing the confidence interval above? Hint: Use a 5% significance level for the F-test but report a p-value for the t-test

1) “Demand” is best defined as the relationship between:

1. the price of a good and the quantity consumers are willing and able to buy at each price level.
2. the current price of a good and the quantity demanded at that price.
3. the quantity supplied and the price people are willing to pay for a good.
4. the amount of income someone has and the price he is willing to pay for a good.

2) A home theater system and an HD television would be considered an example of:

A) substitute goods.

2. giffen goods.
3. inferior goods.
4. complementary goods.

3) Many people consider hot dogs to be an inferior good. For such people, all else held constant, a decrease in income would cause their demand for hot dogs to:

1. increase.
2. stay the same.
3. decrease.
4. cannot be determined with the information given.

4) If movies on DVD for home rental and movies seen at a theater are substitutes, and the price of movies seen at a theater increases, the demand for movies on DVD will:

A) increase.

2. stay the same.
3. decrease.
4. cannot be determined.

5) Which of the following is not considered a factor that influences supply?

A) Technology.

2. Production taxes and subsidies.
3. The number of buyers.
4. Resource prices.

6) For the U.S. economy, the largest expenditure category is:

A) government expenditures.

2. net export expenditures.
3. personal consumption expenditures.
4. investment expenditures.

7) Greater consumer confidence, wealth, available consumer credit, and disposable income ________ personal consumption expenditures.

1. increase
2. decrease
3. have no effect on
4. none of the above

8) Higher expected profits and business confidence ________ investment spending.

A) decrease

2. increase
3. do not affect
4. none of the above.

9) Appreciation of the U.S. dollar will ________ exports and ________ imports, other things equal.

1. increase; increase
2. increase; decrease
3. decrease; decrease
4. decrease; increase

10) The reserve requirement is 0.20. What is the simple deposit multiplier?

A) 1

2. 5
3. 0.10
4. 100

11) The interest rate that commercial banks charge each other for loans of reserves to meet their minimum reserve requirements is called:

A) treasury bill rate.

2. federal funds rate.
3. prime interest rate.
4. none of the above.

12) An increase in the reserve requirement would:

1. decrease excess reserves and reflect an expansionary monetary policy.
2. decrease excess reserves and reflect a contractionary monetary policy.
3. increase excess reserves and reflect an expansionary monetary policy.
4. increase excess reserves and reflect a contractionary monetary policy.

R. B. is an 80-year old English woman who is visiting a friend in the United States. One morning her friend noticed that upon awakening, R. B. had slurred speech, a R-facial droop, and was disoriented. She was transported to the hospital where a CT scan confirmed the diagnosis of intracranial hemorrhage. Because of the location of the bleed, surgery was not possible and over the next couple days R. B.’s R-facial droop progressed to a totally flaccid R-side. R. B. was transferred to your rehabilitation facility for therapy. Ten days after the initial insult, R. B. still has some confusion, memory problems, difficulty swallowing, slurred speech, and profound R-sided weakness. She is hoping to be able to return to England soon.

1. Define CVA.

2. List 3 main causes of a CVA and describe how they disrupt the O₂ supply.

3. List 10 factors that increase the risk of a CVA.

What is the overall goal of rehabilitation

R. B. is an 80-year old English woman who is visiting a friend in the United States. One morning her friend noticed that upon awakening, R. B. had slurred speech, a R-facial droop, and was disoriented. She was transported to the hospital where a CT scan confirmed the diagnosis of intracranial hemorrhage. Because of the location of the bleed, surgery was not possible and over the next couple days R. B.’s R-facial droop progressed to a totally flaccid R-side. R. B. was transferred to your rehabilitation facility for therapy. Ten days after the initial insult, R. B. still has some confusion, memory problems, difficulty swallowing, slurred speech, and profound R-sided weakness. She is hoping to be able to return to England soon.

1. Define CVA.

2. List 3 main causes of a CVA and describe how they disrupt the O₂ supply.

3. List 10 factors that increase the risk of a CVA.

What is the overall goal of rehabilitation

R. B. is an 80-year old English woman who is visiting a friend in the United States. One morning her friend noticed that upon awakening, R. B. had slurred speech, a R-facial droop, and was disoriented. She was transported to the hospital where a CT scan confirmed the diagnosis of intracranial hemorrhage. Because of the location of the bleed, surgery was not possible and over the next couple days R. B.’s R-facial droop progressed to a totally flaccid R-side. R. B. was transferred to your rehabilitation facility for therapy. Ten days after the initial insult, R. B. still has some confusion, memory problems, difficulty swallowing, slurred speech, and profound R-sided weakness. She is hoping to be able to return to England soon.

1. Define CVA.

2. List 3 main causes of a CVA and describe how they disrupt the O₂ supply.

3. List 10 factors that increase the risk of a CVA.

What is the overall goal of rehabilitation

R. B. is an 80-year old English woman who is visiting a friend in the United States. One morning her friend noticed that upon awakening, R. B. had slurred speech, a R-facial droop, and was disoriented. She was transported to the hospital where a CT scan confirmed the diagnosis of intracranial hemorrhage. Because of the location of the bleed, surgery was not possible and over the next couple days R. B.’s R-facial droop progressed to a totally flaccid R-side. R. B. was transferred to your rehabilitation facility for therapy. Ten days after the initial insult, R. B. still has some confusion, memory problems, difficulty swallowing, slurred speech, and profound R-sided weakness. She is hoping to be able to return to England soon.

1. Define CVA.

2. List 3 main causes of a CVA and describe how they disrupt the O₂ supply.

3. List 10 factors that increase the risk of a CVA.

What is the overall goal of rehabilitation

R. B. is an 80-year old English woman who is visiting a friend in the United States. One morning her friend noticed that upon awakening, R. B. had slurred speech, a R-facial droop, and was disoriented. She was transported to the hospital where a CT scan confirmed the diagnosis of intracranial hemorrhage. Because of the location of the bleed, surgery was not possible and over the next couple days R. B.’s R-facial droop progressed to a totally flaccid R-side. R. B. was transferred to your rehabilitation facility for therapy. Ten days after the initial insult, R. B. still has some confusion, memory problems, difficulty swallowing, slurred speech, and profound R-sided weakness. She is hoping to be able to return to England soon.

1. Define CVA.

2. List 3 main causes of a CVA and describe how they disrupt the O₂ supply.

3. List 10 factors that increase the risk of a CVA.

What is the overall goal of rehabilitation

Many lakes in the Adirondack State Park in New York are carefully managed. At some lakes, fines are levied for introducing non-intended fish into the lake. Why would such a rule exist? (Answer this question from an externality perspective!)