1

Bradpon Incorporated planned to use $37.50 of material per unit but actually used $36.75 of material per unit, and planned to make 1800 units but actually made 1600 units.

The sales-volume variance is:

Hobart Corporation manufactured 20 000 heaters during November. The overhead cost-allocation base is $15.75 per machine-hour. The following variable overhead data pertain to November:

                                                                                            Actual              Budgeted
Production                                                                   20 000 units         22 000 units
Machine-hours                                                            7875 hours          9000 hours
Variable overhead cost per machine-hour:            $15.50                 $15.75

What is the flexible-budget amount? ( rounded to two decimal)

Healesville Animal Products manufactured 32 000 horse grooming kits during 2018. The fixed-overhead cost-allocation rate is $20.00 per machine-hour. The following fixed overhead data pertain to 2018:

                                                                                                   Actual      Static Budget
Production                                                                   32 000 units        30 000 units
Machine-hours                                                             6100 hours          6000 hours
Fixed overhead costs for 2018                                  $123 000               $120 000

What is the fixed overhead spending variance?

Healesville Animal Products manufactured 32 000 horse grooming kits during 2018. The fixed-overhead cost-allocation rate is $20.00 per machine-hour. The following fixed overhead data pertain to 2018:

                                                                                                   Actual      Static Budget
Production                                                                   32 000 units        30 000 units
Machine-hours                                                             6100 hours          6000 hours
Fixed overhead costs for 2018                                  $123 000               $120 000

What is the fixed overhead production-volume variance?

a) It is commonly accepted that there are gains from adding securities to an investment portfolio. Explain what is meant by this statement. (Your answer should include a discussion and example regarding systematic and non‐systematic risk as well as an indication of the optimal number of assets to be included within a portfolio in theory and in practice.) ​​​​​

(b) The following table provides monthly percentage price changes for two well known market indexes.

Answer the following:   ​​

(i) What have you assumed about the distribution of data (that is, have you assumed the data is a sample or a population).

(ii) Calculate the expected monthly rate of return and standard deviation for each market index.

(iii) Calculate the correlation coefficient for Russell 2000 – Nikkei.

Do new entrants and employees affect the Healthcare industry for the years 2000-2018?

Dependent variable - industry's revenue

Independent variable - the number of new entrants and employees + omitted variables

Using the above table create:

- Hypothesis testing

- P-value

- T-test

- Level of significance

- Scatter Plot

- Regression analysis

In C#

Create classes: Person, Student, Employee, Professor, Staff and Address

1. ☐ Address class must have suitable auto-implemented properties for Address 1, Address 2 and City.
2. ☐ Person class must have suitable auto-implemented properties for Name, Residence (type Address) and email.
3. ☐ Student and Employee must be subclasses of Person.
4. ☐ Employee must be a super class for Professor and Staff.
5. ☐ Employee class must have suitable auto-implemented properties for salary (between 2000 to 8000), and hire date.
6. ☐ Professor class must have suitable auto-implemented properties for office hours and rank (use enum, e.g. Assist. Prof., Assoc. Prof., etc.)
7. ☐ Staff class must have auto-implemented property for a designation (use enum, e.g. Office Assistance, Clerk, etc.)
8. ☐ All classes must have suitable constructor(s) and making use of super class constructors as applicable.
9. ☐ Override the ToString method in each class to return the class name and all other information in one/single line (use string interpolation and use base class ToString as applicable)

In the Main Method, create three Lists for (Student, Staff, and Professor) with hard-coded data for at least 4 entries each.

Implement the menu driven CONSOLE logic taking a user input as:

Press 1 to modify Student

Press 2 to modify Staff

Press 3 to modify Professor

Press 0 to exit program

☐ Console application must have a hierarchy of above-shown menus and run continuously until the person quits the application

☐ To list, add, update and delete to a list one must use LINQ.

IN C#

Create classes: Person, Student, Employee, Professor, Staff and Address

1. ☐ Address class must have suitable auto-implemented properties for Address 1, Address 2 and City.
2. ☐ Person class must have suitable auto-implemented properties for Name, Residence (type Address) and email.
3. ☐ Student and Employee must be subclasses of Person.
4. ☐ Employee must be a super class for Professor and Staff.
5. ☐ Employee class must have suitable auto-implemented properties for salary (between 2000 to 8000), and hire date.
6. ☐ Professor class must have suitable auto-implemented properties for office hours and rank (use enum, e.g. Assist. Prof., Assoc. Prof., etc.)
7. ☐ Staff class must have auto-implemented property for a designation (use enum, e.g. Office Assistance, Clerk, etc.)
8. ☐ All classes must have suitable constructor(s) and making use of super class constructors as applicable.
9. ☐ Override the ToString method in each class to return the class name and all other information in one/single line (use string interpolation and use base class ToString as applicable)

In the Main Method, create three Lists for (Student, Staff, and Professor) with hard-coded data for at least 4 entries each.

Implement the menu driven CONSOLE logic as:

Press 1 to modify Student

Press 2 to modify Staff

Press 3 to modify Professor

Press 0 to exit program

☐ Console application must have a hierarchy of above-shown menus and run continuously until the person quits the application

☐ For Search (required to find and update) must use LINQ.

Maddow and Wells, Inc. purchased equity securities in 2018. The management of the company has decided that the securities will not be sold immediately, but will be held for at least three years. This will allow MW to maximize the potential gains from holding the securities. The new accountant at the company wants to classify the securities as held-to-maturity because they will be held for three years; the company has never held securities for this long before. How would you advise the management of the company to classify the securities? At the end of each reporting year, how will the securities be recognized on the company’s books? Support your response with an appropriate ASC reference (ASC xxx-xx-xx-x) or ASU (accounting standard update).

A small company is expanding into new offices spread across three buildings. To keep
track of office furniture, computers, and printers, the company would like a database to
keep track of everything. Each piece of office furniture, computer, or printer is given an
identification number. Each item (which is either a piece of furniture, a computer, or a
printer) is placed in a room of one of three buildings. The building manager is responsible
for the items in their building. The building manager is identified by an employee ID,
first name, last name, and DOB. Draw an ER diagram that will assist in the creation of
this database. After you have constructed your ER diagram, construct your database using
SQL queries on PHPMyAdmin. Lastly, populate the database with dummy data
(https://mockaroo.com/). Submit your ER diagram and screenshots of your queries to
generate the database, in addition to a screenshot of a SELECT query after the database
has been populated, to prove that you have successfully populated the database.

For the group project, you will be creating a database system to solve a business problem of your choice. The database system must meet the criteria shown below. In addition to the database solution, each student will prepare a system summary.

Database System Requirements (Group Work):

• Create a database and name it ITCO630_GPx where "x" is your group letter. Populate your database with appropriate test data.
• Include all of the scripts in a single file called ITCO630_GPx.SQL where x is your group letter.
• Create at least 3 related tables in the database.
• Create at least 2 stored procedures and a script to use each of them.
• Create at least 1 view (using a script).
• Create at least 1 trigger.
• Create at least 5 useful queries. At least one of these queries should use a subquery and at least 1 of the queries should use an aggregate function.
• All scripts should be well-documented.

Consider the following database schema:

               Product(maker, model, type)

               PC(model, speed, ram, hd, rd, price)

               Laptop(model, speed, ram, hd, screen, price)

               Printer(model, color, type, price)

Give SQL statement for each of the following:

(Grouping and Aggregation) Write the following queries in SQL:

1. Find the average speed of laptops costing over $2000.
2. Find the average price of PC’s and laptops made by manufacturer “D”.
3. Find, for each manufacturer, the average screen size of its laptops.
4. Find the manufacturers that make at least three different models of PC.
5. Find, for each manufacturer who sells PC’s, the maximum price of a PC.
6. Find, for each speed of PC above 800, the average price.
7. Find the average hard-disk size of a PC for all those manufacturers that make printers.

Can you please explain to me what is happening in the line

Update PRODUCT 11QER/31, P_QTYOH from 47 to 46

like why 47 to 46 and no other number?

in the code

Lock INVOICE

Insert row 10983 into INVOICE

Unlock INVOICE

Lock LINE

Insert row 10983, 1 into LINE

Unlock LINE

Lock PRODUCT

Update PRODUCT 11QER/31, P_QTYOH from 47 to 46

Unlock PRODUCT

Lock CUSTOMER

Update CUSTOMER 10010, CUS_BALANCE from 345.67 TO 464.47

Update CUSTOMER 10010, CUS_DATELSTPUR from 11-May-2016 to 03-June-2016

Unlock CUSTOMER