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

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

A construction company is planning to sign a Build, Operate and Transfer (BOT) contract with Turkish Government for the construction and operation of a Duty Free Shopping center composed of 120 shops in the second phase of Istanbul Grand Airport Project. The Duty Free Shopping Center will be transferred to Turkish Government at the end of 20 years of operation.

Some figures with respect to proposed BOT agreement is as follows;

a. Initial construction cost for 120 shops is $500,000.
b. Maintenance per shop per month is $50.
c. Each shop should pay $50,000 of tax to Turkish Government yearly.
d. Additional tax surcharge is demanded by the Turkish Government for the entire Duty Free Shopping Center (120 shops) every 6 years, payment of $30,000 is to be paid.
e. Within the first 10 years of operation, Turkish Government is demanding a fixed fee from the revenue from each shop. This fee is $100,000 per month. At the end of 10 years, this fee increases to $150,000 per shop per year until the contract fulfills its duration of 20 years.

Subsequent to completion of the Duty Free Shopping Center, the construction company is planning to rent out the 120 shops to generate an income. In line with the figures given above, what should be the minimum monthly rent of each shop in order to obtain the breakeven point if the desired discount rate is 10 %.
You must consider in your analysis that during the 20 years of operation, on average 75% of the shops are rented, and 6% of the rent income will be paid back to government.

Early in its fiscal year ending December 31, 2021, San Antonio Outfitters finalized plans to expand operations. The first stage was completed on March 28 with the purchase of a tract of land on the outskirts of the city. The land and existing building were purchased by paying $390,000 immediately and signing a noninterest-bearing note requiring the company to pay $790,000 on March 28, 2023. An interest rate of 8% properly reflects the time value of money for this type of loan agreement. Title search, insurance, and other closing costs totaling $39,000 were paid at closing.

At the end of April, the old building was demolished at a cost of $89,000, and an additional $69,000 was paid to clear and grade the land. Construction of a new building began on May 1 and was completed on October 29. Construction expenditures were as follows: (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

San Antonio borrowed $6,500,000 at 8% on May 1 to help finance construction. This loan, plus interest, will be paid in 2022. The company also had a $7,150,000, 8% long-term note payable outstanding throughout 2021.

In November, the company purchased 10 identical pieces of equipment and office furniture and fixtures for a lump-sum price of $790,000. The fair values of the equipment and the furniture and fixtures were $623,000 and $267,000, respectively. In December, San Antonio paid a contractor $380,000 for the construction of parking lots and for landscaping.

I need this question answered assuming that Westgate Construction's contract with Santa Clara County does NOT qualify for revenue recongnition over time... In 2016, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2018. Information related to the contract is as follows:

Southport Pty Ltd is considering a proposal for a warehouse project in Gold Coast. Initial investment (i.e acquisition of land, construction cost and others) for the proposed warehouse is estimated $20,000,000. A total amount of $15,000,000 will be taken as loan from bank @ 10% interest and equal repayment method for five years counting from first year (assuming that bank loan is available at any time). The company is expected to complete construction in less than one year and the warehouse is expected to be in full operation exactly one year from today (since initial investment are made) if the project proposal is approved within short time. Expected operational life of the project is 4 years (i.e total project life including construction time is 5 years). Storage capacity of the warehouse is 240,000 m² (floor space). The company is expecting to earn $100 per m² per year by renting the floor spaces. The company has to maintain all the costs of warehouse administration (including staff payments, council rates, insurance, electricity and water bills etc) which is estimated as $60 per m² per year. Assume discounting rate of 10%, investment occurring at the starting, and gross profit acquired at the end of any period after construction. The Company is expecting to earn $12,000,000 by selling the discarded warehouse at the end of the project life (end of 5^th year). Assume straight-line depreciation and 40% taxes on income.

1. What is the payback period of the Investment?                                                          
2. Determine Net present value and Internal rate of return.                             
3. What is your recommendation?

1. You want to design a pendulum for a grandfather clock so that it has a period of 2.00 seconds (so that one “tick” plus one “tock” occur during one complete period). The pendulum has a heavy 8.00-kg bob. (Throughout this problem, assume an ideal simple pendulum: the pendulum’s arm has negligible mass, the bob can be approximated as a point-mass, the initial angle of displacement is small, and there is negligible friction.)

a.) If you want the clock to be used on the surface of the Earth near sea level (where g = 9.80 m/s2 ), what length should you use for the pendulum arm? Show your work. (Note: How many significant figures should your final answer have? Watch your rounding!)

b.) Suppose that the temperature in the room gets much warmer, and the length of the pendulum’s arm expands by 2.50%. By what percentage will the pendulum’s period increase? Show your work. Express your final answer as either a decimal factor or a percentage (with appropriate sig. figs.).

c.) Which one or more of the following changes would (when considered separately and individually) increase the period of the pendulum, thereby making the clock run “slower”? Circle ALL that apply:

A. moving the pendulum to the top of a (fictitiously) high mountain where g = 9.70 m/s2

B. sticking some putty on the pendulum bob, thereby increasing its mass

C. decreasing the amplitude of the pendulum’s swings

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.