/* 1. Fix the CREATE and INSERT statements below to create the SHIPMENT table and insert its data in DB Fiddle*/

CREATE TABLE SHIPMENT (
ShipmentID Int NOT NULL,
ShipperName Char(35) NOT NULL,
ShipperInvoiceNumber Int NOT NULL
DepartureDate Date NULL,
ArrivalDate Date NULL,
InsuredValue Numeric(12,2) NOT NULL,
CONSTRAINT Shipment_PK PRIMARY KEY (ShipmentID))
);

INSERT INTO SHIPMENT VALUES (1,'ABC Trans-Oceanic', 2008651, '10-Dec-14', '15-Mar-18', 15000.00);
INSERT INTO SHIPMENT VALUES (2,'ABC Trans-Oceanic', 2009012, '10-Jan-18', '20-Mar-18', 12000.00);
INSERT INTO SHIPMENT VALUES (3,'Worldwide', 49100300, '05-May-18', '17-Jun-18', 20000.00)
INSERT INTO SHIPMENT VALUES (4,'International', 399400, '02-Jun-18', '17-Jul-18', 17500.00 );
INSERT INTO SHIPMENT VALUES (5,'Worldwide', 84899440, '10-Jul-18', '28-Jul-18', 25000.00);
INSERT INTO SHIPMENT VALUES (6,'International', 488955, '05-Aug-18', '11-Sep-18', 18000.00);

Now you can work on the following 5 queries:

/* Query 1. Show the shipper, the invoice number and insured value for each shipment. */

/* Query 2. Show the shipper and the number of shipments made by each one. */

/* Query 3. Show the shipper and the number of shipments made by each one but only include shipments with insured values that are 15,000 or over. */

/* Query 4. Show the shipper and the number of shipments made by each one but only include shipments with insured values that are 15,000 or over and only show shippers with 2 or more shipments.*/

/* Query 5. Show the shipper, the number of shipments made by each one and the total insured value for all shipments made by each shipper -- but only include shipments with insured values that are 15,000 or over and only show shippers with 2 or more shipments and only show shippers with a total insured value over 40000. */

Please, I need a unique answer, use your own words (don't copy and paste, no handwritten notes)

give me an the biosynthesis and chemical structure of (Dexamethasone & COVID-19)

language is C++

1. Design a class that manages a Pet Food Company's quarterly summarized activity. It should contain the following:

( This is all private data )

Company Name - char[40]   //  This is a static member 

Quarter              - char         // This is a static member.  Validate to be 1-4 in the setter method

Division Name - char[40]

BonusBudgetRate - float   - set to 0.02
Total Sales        - float

Total Expenses - float

1a. Create a public method named netIncome() which will return total sales - total expenses as float.

2. Create public class methods (Setters and Getters) that load the data values.

3. Do not create getter/setter methods for the BonusBudgetRate item. It can be set in a constructor or initialized to the default value of 0.02. There is no other reference to it.

4. This class needs a header file and a corresponding cpp file.

5. Create a 'driver' program that contains the main() method and includes the header file for PetFoodCompany class.

   In the driver program, create an instance of the object PetFoodCompany. 

   Internally set the Quarter to 1 and the CompanyName to a name of your choosing.
   Display the CompanyName and Quarter values
   Prompt for total sales and total expenses for this object
   Display the result of netIncome(). 

Below is an example:

Company Name is myCompanyName
Current Quarter is 1

Enter Total Sales: 1000

Enter Total Expenses: 600
Net Income = 400

The deliverable is a working program (CPPs & H files) and a UML diagram of the this class.

1) What operational and organizational impacts must be considered when transitioning from the planning to the implementation phase of your project? What else is impacted? Think about operational activities, resources, responsibilities, and dependencies.

Explain what equity and non-equity entry modes are and summarize their main types.

Becton Labs, Inc., produces various chemical compounds for industrial use. One compound, called Fludex, is prepared using an elaborate distilling process. The company has developed standard costs for one unit of Fludex, as follows:

During November, the following activity was recorded related to the production of Fludex:

1. Materials purchased, 10,500 ounces at a cost of $216,825.

2. There was no beginning inventory of materials; however, at the end of the month, 2,600 ounces of material remained in ending inventory.

3. The company employs 20 lab technicians to work on the production of Fludex. During November, they each worked an average of 180 hours at an average pay rate of $14.00 per hour.

4. Variable manufacturing overhead is assigned to Fludex on the basis of direct labor-hours. Variable manufacturing overhead costs during November totaled $7,000.

5. During November, the company produced 3,700 units of Fludex.

Required:

1. For direct materials:

a. Compute the price and quantity variances.

b. The materials were purchased from a new supplier who is anxious to enter into a long-term purchase contract. Would you recommend that the company sign the contract?

2. For direct labor:

a. Compute the rate and efficiency variances.

b. In the past, the 20 technicians employed in the production of Fludex consisted of 8 senior technicians and 12 assistants. During November, the company experimented with fewer senior technicians and more assistants in order to reduce labor costs. Would you recommend that the new labor mix be continued?

3. Compute the variable overhead rate and efficiency variances.

1. Research different tools for assessing leadership styles. Summarize at least three tools and the styles they mention. Do you believe that it’s best for leaders to use different styles in different situations? Why or why not?

1. What is the difference between infrastructure security and premises security?
2. List and describe three categories of physical threats caused by humans.
3. What are the two requirements for physical security?

1. State the differences between hardware and software-based encryption.
2. How Wi-Fi Pineapples work?

Arlo Industries manufactures three types of dog collars: a deluxe model with solid leather and upgraded leash rings, a standard model using a "leatherette" compound, and a bargain model that they sell to discount outlets. The profit contributions of these collars are $12 Deluxe, $10 Standard, and $8 Bargain. All collars must be cut, assembled and shipped using three different production lines. The following table shows the time (in minutes) for each operation:

Next month, the company estimates there will be 380 hours available for cutting, 370 hours for assembly and 400 hours available for shipping. In addition, up to 80 hours of overtime is available that can be used on either the cutting and/or assembly production lines at a cost of $20 per hour. The company has already received orders for 1200 deluxe collars, 1000 standard collars, and 600 bargain collars that must be filled, but believes they can sell as many collars as they can make. The company is interested in maximizing profit, subject to the constraints listed above.

**Please answer me**

6 Food AND Beverage

As you learned in your Reading, procurement or purchasing is the precursor to the rest of the foodservice management system. In this Journal assignment, you will decide both a purchasing method and process based on your understanding of the readings. Read the scenario and address the checklist items in a thorough response. Scenario: You are the new Beverage Manager at a new large hotel that has banquets and has several restaurants. You are tasked with deciding on the purchasing method and process for purchasing all the alcoholic beverages at the hotel. Checklist: Identify and explain the purchasing method will you use and why. Provide the purchasing process will you use and explain why.

250 word minimum

4. You have a fourth project that will cost 1700 to invest in one year from now, will generate a cash inflow of 150 starting in year three and continuing forever. If the discount rate is 8%, what is the NPV and should you accept the project based on the NPV?

5. Finally, you have a fifth project that will cost 1500 to invest in today, will generate a cash inflow of 165 in year one, which will grow at a constant rate of 2% for 29 additional years (for a total of 30 cash inflows), and will have a shutdown cost of 1000 at the end of year 30. If the project’s discount rate is 10%, what is the NPV and should you accept the project based on the NPV?

please show the formula for question 5

Discuss the differences between the quality analysis methods to reduce
product defects (FMEA, FTA) and the project risk analysis equivalents.

Please try not to upload hand-written images, thank you!