Problem 6-10 (Algo) Long-term contract; revenue recognition over time [LO6-8, 6-9]

[The following information applies to the questions displayed below.]

In 2021, 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 2023. Information related to the contract is as follows:

Westgate recognizes revenue over time according to percentage of completion.

Problem 6-10 (Algo) Part 1

Required:
1. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years. (Do not round intermediate calculations. Loss amounts should be indicated with a minus sign.

2-a. In the journal below, complete the necessary journal entries for the year 2021 (credit "Various accounts" for construction costs incurred).
2-b. In the journal below, complete the necessary journal entries for the year 2022 (credit "Various accounts" for construction costs incurred).
2-c. In the journal below, complete the necessary journal entries for the year 2023 (credit "Various accounts" for construction costs incurred).

Write a function that accepts a dictionary and produces a sorted list of tuples

The dictionary looks like this:

{‘US’: [{'Chicago, IL': ('2/1/2020 19:43', 2, 0, 0)}, {'San Benito, CA': ('2/3/2020 3:53', 2, 0, 0)}, {'Santa Clara, CA': ('2/3/2020 0:43', 2, 0, 0)}, {'Boston, MA': ('2/1/2020 19:43', 1, 0, 0)}, {'Los Angeles, CA': ('2/1/2020 19:53', 1, 0, 0)}, {'Orange, CA': ('2/1/2020 19:53', 1, 0, 0)}, {'Seattle, WA': ('2/1/2020 19:43', 1, 0, 0)}, {'Tempe, AZ': ('2/1/2020 19:43', 1, 0, 0)}], 'Australia' : [{'New South Wales': ('2/1/2020 18:12', 4, 0, 2)}, {'Victoria': ('2/1/2020 18:12', 4, 0, 0)}, {'Queensland': ('2/4/2020 16:53', 3, 0, 0)}, {'South Australia': ('2/2/2020 22:33', 2, 0, 0)}]

For these counts, I need to use the numbers that are bolded above). The returned sorted list (in descending order) will contain key-value pairs such that each key is a country and the corresponding value is the number of cases observed within that country.

For example: [('Australia', 13),(‘US’: 11)]

researchers at harris interactive wondered if there was a difference between males and females in regard to whether they typically buy name- brand or store- brand products. they asked a random sample of males and females the following question. "for each of the following types of products, please indicate whether you typically buy name- brand products or store- brand products?" among the 1104 males surveyed, 343 indicated they buy name- brand over-the-counter drugs; among the 1172 females surveyed, 295 indicated they buy name- brand over-the-counter drugs. does the evidence suggests a lower proportion of females by name- brand over-the-counter drugs?

(a) explain why this study can be analyzed using the methods for conducting a hypothesis test regarding two independent portions.

(b) what are the null and alternative hypotheses?

(c) describe the sampling distribution of Pfemale- Pale draw a normal model with the area representing the P-value shaded for this hypothesis test.

(d) determine the P-value based on the model from part (c).

(e) interpret the P-value.

(f) based on the p-value, what does the sample evidence suggest? that is, what is the conclusion of the hypothesis test? Assume an alpha=0.05 level of significance.

Part 2:

On January 1, 2018, Caldwell Corporation had 75,000 shares of $1 par value common stock issued and outstanding. During the year, the following transactions occurred:

Mar.     1      Issued 45,000 shares of common stock for $675,000

June      1      Declared a cash dividend of $2.00 per share to stockholders of record on June 15

June    30      Paid the $2.00 cash dividend

Dec.      1      Purchased 4,000 shares of common stock for the treasury for $18 per share

Dec.    15      Declared a cash dividend on outstanding shares of $2.50 per share to stockholders of record on December 31

NOTE: Dividends are only declared and paid on the # shares OUTSTANDING. You need to keep a running total of the # shares outstanding so that your dividends on Dec 15^th are correct.

Required:

Prepare journal entries to record the above transactions.                                           (15 points)

Assume that you are trying to get an algorithm which is supposed to generate legit words. In default, any letter from the English alphabet is equally likely to occur right after any English letter (including itself). Now you introduce your name and lastname as separate samples to your algorithm. The algorithm will learn some information about legit words from these samples and accordingly, it will adjust the probabilities by an additive fixed value p. For example, if your name is EDA, then the algorithm adjust itself by setting the probability of having D right after E as p+1/28 similarly probability of having A right after D as p+ 1/28. Of course, in that case the probabilities of having other letters right after E and D will be adjusted accordingly. Algorithm works only on pairs, so the triple orders do not matter for the algorithm. For all other details, by aiming to maximize the learning capability of your algorithm, you are free to decide on the new strategies. So, what new information will the algorithm get from your name and last-name. With what probability your algorithm could generate the word MEDIPOL. With what probability your algorithm could generate your last-name.

• As a suggestion, you might want to accomplish this SQL exercise before you accomplish the primary assignment for this week.
• If you have not already done so, use MSSQLS Management Studio to create a new database named ch07_ConstructCo. Use the default settings. When the database has been created, run the Ch07_ConstructCo_SQL.txt script linked above to create and load the database tables and data.  
• Write a T-SQL query for the constructco tables to list the employee last name, first name, job code, and hire date from the employee table.
• Write a T-SQL query for the constructco tables to list the employee last name, first name, and hire date where the hire date is greater than 2000-01-01.
• Write a T-SQL query for the constructco tables to list the employee last name, project number, assigned job from the employee, and assignment tables where the employee table employee number is equal to the assignment table employee number.
• Ensure that you have copied and pasted all of the T-SQL statements and verification results into your assignment submission.

Once you have accomplished that action, paste the script into your assignment submission document for this part of your assignment.

Use only the operators discussed in class (select, project, Cartesian product, join, union, intersection, set difference and renaming). Type your answers.

Consider the following database schema:

INGREDIENT(ingredient-id,name,price-ounce)

RECIPE(recipe-id,name,country,time)

USES(rid,iid,quantity)

where INGREDIENT lists ingredient information (id, name, and the price per ounce); RECIPE lists recipe information (id, name, country of origin, and time it takes to cook it); and USES tells us which ingredients (and how much of each) a recipe uses. The primary key of each table is underlined; rid is a foreign key to RECIPE and iid is a foreign key to INGREDIENT.

Write the following queries in Relational Algebra.

(a) Find the names of French recipes that use butter and take longer than 45 minutes to cook.

(b) Find the names of recipes that use butter or lard.

(c) Find the names of recipes that use butter and lard.

(d) Find the name of recipes that do not use butter.

(e) Find the names of recipes that use 2 or more ingredients.

(f) (*) Find the names of recipes where at least 3 oz. (quantity) of every ingredient are used.

JAVA/Netbeans

•Design a class named Person with fields for holding a person’s name, address and phone number (all Strings)

–Write a constructor that takes all the required information.

–Write a constructor that only takes the name of the person and uses this to call the first constructor you wrote.

–Implement the accessor and mutator methods. Make them final so subclasses cannot override them

–Implement the toString() method

•Design a class named Customer, which extends the Person class. It should have a field for the Customer ID (String) and a Boolean field indicating whether the customer wishes to be on a mailing list.

–Write a constructor that takes the name of the customer, id, address, phone number and the Boolean. Use super to call the appropriate constructor in Person

–Write a constructor that takes the name of the customer and id only and uses this to call the first constructor you wrote. It should set the Boolean to false.

–Implement the accessor and mutator methods for the customer id and Boolean.

–Override the toString() method using @override and use super to call Person’s toString()

•Write a main method that asks the user for the info of two customers, the first asking only for name and id, and the second asking for all the information. It creates 2 Customers and prints them out.

2.13 Program: Food receipt (Python 3)

1.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

2.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

Enter second food item name: ice cream

Enter item price: 2.50

Enter item quantity: 4

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

4 ice cream @ $ 2.5 = $ 10.0

Total cost: $ 20.0

3.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

Enter second food item name: ice cream

Enter item price: 2.50

Enter item quantity: 4

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

4 ice cream @ $ 2.5 = $ 10.0

Total cost: $ 20.0

15% gratuity: $ 3.0

Total with tip: $ 23.0