Problem 11-5 (Algorithmic)
Special Deductions and Limitations (LO 11.3)

Fisafolia Corporation has gross income from operations of $426,600 and operating expenses of $362,610 for 2018. The corporation also has $42,660 in dividends from publicly traded domestic corporations in which the ownership percentage was 45%.

Below is the Dividends Received Deduction table to use for this problem.

If require, round final answers to the nearest dollar.

a. Calculate the corporation's dividends received deduction for 2018.
$

b. Assume that instead of $426,600, Fisafolia Corporation has gross income from operations of $319,950.

Calculate the corporation's dividends received deduction for 2018.
$

c. Assume that instead of $426,600, Fisafolia Corporation has gross income from operations of $350,000. Calculate the corporation’s dividends received deduction for 2018.
$

Just Dew It Corporation reports the following balance sheet information for 2017 and 2018. JUST DEW IT CORPORATION 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018 Current assets Current liabilities Cash $ 10,200 $ 13,200 Accounts payable $ 46,000 $ 62,160 Accounts receivable 30,200 38,640 Notes payable 27,800 33,120 Inventory 74,600 87,120 Total $ 115,000 $ 138,960 Total $ 73,800 $ 95,280 Long-term debt $ 40,000 $ 36,000 Owners’ equity Common stock and paid-in surplus $ 60,000 $ 60,000 Retained earnings 226,200 288,720 Net plant and equipment $ 285,000 $ 341,040 Total $ 286,200 $ 348,720 Total assets $ 400,000 $ 480,000 Total liabilities and owners’ equity $ 400,000 $ 480,000 Prepare the 2018 combined common-size, common-base year balance sheet for Just Dew It. (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.)

Mills Corporation acquired as a long-term investment $260 million of 5% bonds, dated July 1, on July 1, 2018. Company management has positive intent and ability to hold the bonds until maturity. The market interest rate (yield) was 3% for bonds of similar risk and maturity. Mills paid $300.0 million for the bonds. The company will receive interest semiannually on June 30 and December 31. As a result of changing market conditions, the fair value of the bonds at December 31, 2018, was $280.0 million.

Required:
1. & 2. Prepare the journal entry to record Mills’ investment in the bonds on July 1, 2018 and interest on December 31, 2018, at the effective (market) rate.
3. At what amount will Mills report its investment in the December 31, 2018, balance sheet?
4. Suppose Moody’s bond rating agency upgraded the risk rating of the bonds, and Mills decided to sell the investment on January 2, 2019, for $315 million. Prepare the journal entry to record the sale.

Casino Ltd is a company that owns a large holiday resort on Queensland’s Gold Coast. Casino Ltd employs 100 people who work in the catering, cleaning and the hospitality outlets of the resort. The company and its employees have had a history of industrial disputes involving wages and conditions. After the most recent dispute, Casino Ltd and its employees came to an agreement on 1 July 2005, under which it was agreed that all of its employees were to be paid wages and salaries that are in excess of other employees working in similar resorts in Australia. One month after the agreement was made, a new company was incorporated which is a wholly owned subsidiary of Casino Ltd. The new company is called Caterers Ltd. It has three directors, all of whom are appointed from the board of five directors of Casino Ltd. Caterers Ltd.’s constitution had a clause which stated that all of the profits of Caterers Ltd will be distributed as dividend to Casino Ltd. The incorporation of Caterers Ltd was preceded by a meeting between the board of directors and the senior managers of Casino Ltd where the reason for the creation of the new entity was discussed. The senior managers of Casino Ltd devised a strategic plan which called for a new corporate structure which will take into account that the catering and entertainment services of Casino Ltd has the potential to become a significant operation in its own right both within and outside the resort. The directors of Casino Ltd were genuinely impressed with the plan and believed it was in the long term interests of the company. They passed a resolution that the management of Casino Ltd put into place matters that will allow Caterers Ltd to pursue this new strategic objective. The redevelopment of the current resort was central to the management plan approved by the board of Casino Ltd in relation to the creation of Caterers. This meant closure of many of the restaurants in the resort and the redundancy of 60 employees. These redundant employees were offered new, but identical, positions working in Caterers Ltd. Faced with the choice of an uncertain future, all 60 employees accepted the job offer with Caterers Ltd. As a result, the redundant employees no longer work under the previous 1 July 2005 contract of employment they had while working for Casino Ltd. Instead, they work under wages and conditions that are not as favourable as they had while working for Casino Ltd. However, these wages and conditions are comparable to people who work in similar industries. Caterers Ltd, through its employees, started running the catering and entertainment services in the resort and due to the huge success of the business, Caterers expanded beyond the resort and started leasing outside premises to run a bigger catering and entertainment business. The Trade Union, on behalf of the 60 employees working for Caterers Ltd is concerned about the practical effect of this corporate reorganization on employment conditions. Assuming that the 1 July 2005 agreement between Casino Ltd and its employees is valid and that Caterers Ltd has been validly incorporated, advice the trade union as to its chances of success in enforcing that agreement. Refer to relevant statutes and case law based on Company Law.  

Answer the following questions to complete Homework

1. Use PubMed or another abstract database  to find an academic journal article on a health topic of interest to you. Read the article to find the answers to these questions: (a) What was the main study question? (b) Who participated in the study, where did it take place, and when was it conducted? (c) What study design was used? and (d) What was the answer to the main study question?

2. Find a recent news story from the popular press about a newly released health research report. Look up and read the scientific article on which the news report was based. Was the news story accurate? Did it leave out any critical information?

3. Do you identify with a particular ethnic group? Do you know of any health conditions that you are at special risk for because of your ethnic background? Are these conditions genetic? Are they related to health behaviors?

4. What are some of the conditions related to poverty that increase the risk of infectious diseases? Noncommunicable disease? Neuropsychiatric disorders? Injuries?

QUESTION 8

1. Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, Number of Production Workers, Value Added by Manufacture, New Capital Expenditures, and End-of-Year Inventories. Use Excel to perform a backward elimination regression analysis at a 5% level of significance. What is the test statistic of the independent variable that is dropped from the linear model in the first step. Write your answer as a number and round to 2 decimal places.

https://drive.google.com/file/d/19TI3HId0greXS0nkmDuoITv1IMPF_TUK/view?usp=sharing

Please answer tonight, I need help with this and my last questions got closed.

Edit question

Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables:

OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)

OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID)

GG_SERVICE (ServiceID, ServiceDescription, CostPerHour);

EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)

PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked)

The referential integrity constraints are:

OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER

PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY

ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE

EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in PROPERTY, and EmployeeID in EMPLOYEE are surrogate keys with values as follows:

OwnerID Start at 1 Increment by 1

PropertyID Start at 1 Increment by 1

ServiceID Start at 1 Increment by 1

EmployeeID Start at 1 Increment by 1

PropertyServiceID Start at 1 Increment by 1

Sample data are shown in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42. OwnerType is either Individual or Corporation. PropertyType is one of Office, Apartments, or Private Residence. ExperienceLevel is one of Unknown, Junior, Senior, Master or SuperMaster. These tables, referential integrity constraints, and data are used

Sample Data for Garden Glory OWNER Table OwnerID OwnerName OwnerEmailAddress OwnerType

1 Mary Jones [email protected] Individual

2 DT Enterprises [email protected] Corporation

3 Sam Douglas [email protected] Individual

4 UNY Enterprises [email protected] Corporation

5 Doug Samuels [email protected] Individual

Sample Data for Garden Glory OWNED_PROPERTY Table PropertyID PropertyName PropertyType Street City State ZIP OwnerID

1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2

2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 1

3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2

4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3

5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 98052 4

6 Jones House Private Residence 1456 48th St Bellevue WA 98007 1

7 Douglas House Private Residence 1567 51st St Bellevue WA 98007 3

8 Samuels House Private Residence 567 151st St Redmond WA 98052 5

as the basis for the SQL statements you will create in the exercises that follow. If possible, run these statements in an actual DBMS, as appropriate, to obtain your results. Name your database GARDEN_GLORY. Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows:

Will you please explain and write the instructions how to write on mySQL and thank you

FIGURE 3-40

Sample Data for Garden Glory EMPLOYEE Table EmployeeID LastName FirstName CellPhone ExperienceLevel

1 Smith Sam 206-254-1234 Master

2 Evanston John 206-254-2345 Senior

3 Murray Dale 206-254-3456 Junior

4 Murphy Jerry 585-545-8765 Master

5 Fontaine Joan 206-254-4567 Senior

FIGURE 3-41

Sample Data for Garden Glory GG_SERVICE Table ServiceID ServiceDescription CostPerHour

1 Mow Lawn 25.00

2 Plant Annuals 25.00

3 Weed Garden 30.00

4 Trim Hedge 45.00

5 Prune Small Tree 60.00

6 Trim Medium Tree 100.00

7 Trim Large Tree 125.00

FIGURE 3-42

Sample Data for Garden Glory PROPERTY_SERVICE Table PropertyServiceID PropertyID ServiceID ServiceDate EmployeeID HoursWorked

1 1 2 2019-05-05 1 4.50

2 3 2 2019-05-08 3 4.50

3 2 1 2019-05-08 2 2.75

4 6 1 2019-05-10 5 2.50

5 5 4 2019-05-12 4 7.50

6 8 1 2019-05-15 4 2.75

7 4 4 2019-05-19 1 1.00

8 7 1 2019-05-21 2 2.50

9 6 3 2019-06-03 5 2.50

10 5 7 2019-06-08 4 10.50

11 8 3 2019-06-12 4 2.75

12 4 5 2019-06-15 1 5.00

13 7 3 2019-06-19 2 4.00

D. Write SQL statements to list all columns for all tables.

E. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master.

will you please explain thank you

Sometimes when I'm working with a class (usually one that represents a database model), I'll have about 15 different properties on it, usually of different types. These are properties that need to be accessed by the users, as well, so each property will typically need some function like

T getPropertyName();
setPropertyName(T value);

But, it's also extremely valuable for me to be able to iterate through each property in a particular order(although, I suppose that "value" may stem from laziness of not having to type each one individually). Is there some logical way to set up this class, so that I could iterate through it in this order? Or am I helpless for organization, and I should just go back to the basics of having 15 private variables, and 15 "getters" and "setters"?

As an aside, currently I'm working with Android and Java, so answers pertaining specifically to that would be the most helpful, but seeing how I encounter this somewhat frequently in other languages, too, any solution would be ideal.

Use the following information to create SQL commands to retrieve data from Henry Books database :

For each book, list the book code, book title, publisher code, and publisher name. Order the results by publisher name.
For each book published by Plume, list the book code, book title, and price.
List the book title, book code, and price of each book published by Plume that has a book price of at least $14.
List the book code, book title, and units on hand for each book in branch number 4.
List the book title for each book that has the type PSY and that is published by Jove Publications.
Find the book code and book title for each book located in branch number 2 and written by author 20.
Find the book title, author last name, and units on hand for each book in branch number 4.
Repeat Exercise 7, but this time list only paperback books.
Find the book code and book title for each book whose price is more than $10 or that was published in Boston.
Find the book code and book title for each book whose price is more than $10 and that was published in Boston.
Find the book code and book title for each book whose price is more than $10 but that was not published in Boston.