On January 1, 2018, the Mason Manufacturing Company began construction of a building to be used as its office headquarters. The building was completed on September 30, 2019.

Expenditures on the project were as follows:

On January 1, 2018, the company obtained a $3,800,000 construction loan with a 15% interest rate. The loan was outstanding all of 2018 and 2019. The company’s other interest-bearing debt included two long-term notes of $4,000,000 and $6,000,000 with interest rates of 8% and 10%, respectively. Both notes were outstanding during all of 2018 and 2019. Interest is paid annually on all debt. The company’s fiscal year-end is December 31.

Required:
1. Calculate the amount of interest that Mason should capitalize in 2018 and 2019 using the specific interest method.
2. What is the total cost of the building?
3. Calculate the amount of interest expense that will appear in the 2018 and 2019 income statements.

1 & 3. Calculate the amount of interest that Mason should capitalize in 2018 and 2019 using the specific interest method and interest expense that will appear in the 2018 and 2019 income statements. (Enter your answers in dollars.)

Calculate the amount of interest that Mason should capitalize in 2018 and 2019 using the specific interest method and interest expense that will appear in the 2018 and 2019 income statements. (Enter your answers in dollars.)

2. What is the total cost of the building? (Enter your answer in dollars.)

Research Evaluation Checklist

Complete the checklist below for the study/article you are to evaluate.

Define topic and need.

What phenomenon does the study investigate?

Is the phenomenon a problem, an opportunity, or a dilemma?

What symptoms (easily observable signs) indicate that it is a problem, opportunity or a dilemma?

How do people who know this organization explain these symptoms? What do administrators want to know about the phenomenon?

How can it be expressed in manageable terms?

Assess relevant knowledge.

How much is already known?

Is additional background information necessary? Should this research be conducted?

Is the topic a special case of a broader, more fundamental and important problem?

Identify variables and measures, and research questions and hypotheses.

What variables associated with the phenomenon are investigated? How are the variables measured?

What are the research questions?

What specific hypotheses are formulated?

Identify and analyze the research design.

What is the research design—exploratory, descriptive, or causal research? Is this non-experimental, quasi-experimental, or experimental research? What is the nature of data—primary or secondary?

What is the source of data—interviews, questionnaires, existing databases? Are answers obtained through interviews and questionnaires objective?

Analyze the sample.

What is the population from which the respondents have been selected? How large is the sample?

Is it random, stratified, or other sample?

Gather data.

How are data gathered?

Does the procedure of gathering data ensure objectivity?

Analyze data.

Are the data words (qualitative data) or numbers (quantitative)? How are qualitative data analyzed?

How are quantitative data recorded and checked for accuracy? What statistical methods are used to analyze data?

Assess results.

What are the answers to research questions? Are hypotheses supported?

What evidence did the study produce that helps answer research questions or support/refute hypotheses?

Evaluate recommendations.

What recommendations can be made on the basis of results?

What recommendations are made that cannot be supported with results?

Evaluate the study.

What limitations does the study have?

What improvements in research design can be recommended?

Following is an extract from the database of a construction company. The table shows the height of walls in feet and the cost of raising them. The estimated simple linear regression equation is given as Ŷ = b0 + b1X. (Hint: Use Excel functions).

1) What is the value of the coefficient b1?

A) 254.8371

B) 0.010697

C) -2.14625

D) 86.81704

2) What is the estimated cost of raising a 10 foot wall?

A) 1123.008

B) 1505.786

C) 1103.578

D) 968.6109

According to UNCTAD database, France ranks as the 6th largest in the world imports with a 3.40% of the world total. Thus, it can be considered that France has a strong bargaining power in the world markets. As a result, a tariff will _________ increase its national welfare.

A) Never

B) Always

C) Sometimes

D) Only when tariff equalizes the world prices to France's domestic prices

E) None of the above is correct

tableA is a table in a relational database with a composite prime key consisting of fields F1 and F2. You have determined that tableA is 1NF. There are four other fields in tableA. Two of them, F10 and F12, are functionally determined by F1. The other two, F50 and F55, are functionally determined by F2. Because all fields are functionally determined by at least a portion of the key, is tableA 2NF?   If you believe the table is not yet 2NF, what would be required to make it 2NF? Explain your answer

Go to the WCU Library and search the database for the following article. Read the article, and then answer the questions that follow:

Soriano S., Alonso-Magdalena P., Garcıa-Arevalo M., Novials A., & Muhammed S. J. (2012). Rapid insulinotropic action of low doses of Bisphenol-A on mouse and human islets of langerhans: Role of estrogen receptor b. PLoS ONE 7(2): e31109. doi:10.1371/journal.pone.0031109

1. What are the causes of type 2 diabetes?
2. What is the relationship between insulin resistance and hyperinsulinemia?
3. What are endocrine disrupters and what are their functions in our body? Provide some examples.
4. How does concentration of glucose effect insulin secretion?
5. Explain how data from article support or refute the hypothesis that endocrine disrupters can change insulin secretion.

QUESTION 1

1. Which of the following statement is CORRECT about normalisation?

   		A database that is not in at least third normal form cannot be implemented with MySQL.
   		A database that is only in first normal form would breach the CAP theorem.
   		Normalisation ensures consistent formatting, for example, that all the phone numbers would have the same number of digits.
   		All of the above.
   		None of the above.

0.5 points   

QUESTION 2

1. Complete the four blanks in the following SQL query to retrieve all information from the table Customers where birthYear is greater than (or equal to) 1970 but less than (or equal to) 2005. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces.

   SELECT
   FROM
   WHERE  BETWEEN ;

1 points   

QUESTION 3

1. When normalising from first to third normal form, we would typically have:

   		more relations
   		less relations
   		more data stored
   		less data stored
   		none of the above

0.5 points   

QUESTION 4

1. Complete the table below by matching each definition with the appropriate SQL constraint.

   -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    A mandatory clause that is at the start of all SQL retrieval queries       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    A clause used to return only the values in a result table that are unique       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    A clause used to filter rows according to some condition or predicate       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    A clause that is used to list the tables and any joins required in a query       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    An operator that allows multiple values to be specified in a comparison statement       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    An operator used to assign an alias to a table or column       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    If used, it must be the last clause in a query       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    Allows rows which have the same value for one or more columns to be grouped together and treated as a unit when using aggregate functions       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    A clause which is used to filter aggregate values in the final result table       -       A.       B.       C.       D.       E.       F.       G.       H.       I.       J.       K.       L.       M.       N.    An operator used to create a table with all rows from two tables

   A. IN B. ON C. UNION D. AS E. FROM F. SELECT G. WHERE H. SELECT DISTINCT I. NATURAL JOIN J. ORDER BY K. GROUP BY L. LIKE M. INNER JOIN N. HAVING

This refer to the “om” database (or Schema) that you will find in your MySQL Workbench program if you have run the sample database install script.

Please save all of your answers in one script (.sql) or type all your answers into Notepad++ and submit them as a single .sql file. Please test your SQL statements in Workbench

1.       Using an INNER JOIN, select the order_id, order_date, shipped_date, fname, and customer_phone from the orders and customers tables. The fname is a column alias and should be formatted as “Smith, John” (last name, first name). Result table should be in order of order_id in ascending order.

2.       Write a SELECT statement that returns these columns using a JOIN of three tables:

a.       order_date from the orders table

b.       shipped_date from the orders table

c.       order_qty from the order_details table

d.       title from the items table

e.       artist from the items table

f.        unit_price from the items table

g.       Result table should be in order of order_date in ascending order

3.       Expand the SELECT statement from the previous question to include the customer last name and first initial from the customers table. The name should be formatted as “Lastname, F.” and given the column alias cname.

Order table is making by yourself. Please do as soon as possible. Please use the tidy tools for SQL proper format.