answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kolezko [41]
1 year ago
8

Suppose that we want the number of male employees in each department making more than $30,000, rather than all employees (as in

Exer- cise 7.5a). Can we specify this query in SQL? Why or why not?
Business
1 answer:
lana66690 [7]1 year ago
7 0

Answer:

The query may still be specified in SQL by using a nested query as follows (not all

implementations may support this type of query):

SELECT DNAME, COUNT (*)

FROM DEPARTMENT, EMPLOYEE

WHERE DNUMBER=DNO AND SEX='M' AND DNO IN ( SELECT DNO

FROM EMPLOYEE

GROUP BY DNO

HAVING AVG (SALARY) > 30000 )

GROUP BY DNAME;

Explanation:

You might be interested in
Alton Company uses a process-costing system for its single product. Material A is added at the beginning of the process; in cont
Semenov [28]

Answer:

e. A, 6,000; B, 6,000.

Explanation:

At the beginning of the process Materials A are added. Therefore it won't matter if the process is 80% or less/more is complete, the materials A have already been added and would be equivalent to the ending work-in-process inventory i.e. 6,000 units.

Materials B are added when the units are 75% complete. Since the ending work-in-process are 80% complete, then this means that the Materials B equivalent to 6,000 units have already been added to the ending inventory.

Hence, both materials A and B have been added to the ending work-in-process inventory for 6,000 units. Therefore, option E is correct.

8 0
1 year ago
RajDee Furniture Company (RFC) buys and sells office furniture. The company buys chairs from a manufacturer for $40 per unit. Or
skad [1K]

Answer:

(1) 2,28 units

(ii) 1,414 units

(iii) Minimum stock is less than EOQ.

Explanation:

(1) Units Ordered each time

Economic\ order\ Quantity=\sqrt{\frac{2\times A\times O}{C} }  

where,

A = Annual Requirement =40,000 Units

O = Ordering Cost = $200 Per unit

Minimum Stock for lead time:

= (40,000 Units × 10) ÷ 365

= 1096 (Approximately)

C=Annual Carrying cost per unit = $40 × 10%  × 1/2

                                                      = 2

Economic\ order\ Quantity=\sqrt{\frac{2\times 40,000\times 200}{2} }  

                                                  = 2828 Units

(2) Average Inventory = EOQ ÷ 2

                                    = 2828 Units ÷ 2

                                    = 1,414 Units

(3) If the Lead time Increase 10 to 15 days:

Minimum Stock Need to be Maintained:  

= Avg Daily Demand × Lead time

= (40,000 Units ÷ 365) × 15

= 1,644 Units

Minimum Stock is Less the EOQ , then Increasing Lead time to 15 Days Does not Have effect on EOQ.

8 0
1 year ago
Read 2 more answers
A hedge fund with net asset value of $71 per share currently has a high water mark of $78. Suppose it is January 1, the standard
Leto [7]

Answer:

Answer :The annual incentive fees according to Black Scholes Formular =2.5

Explanation:

a)Find the value of call option using below parameter

current price (st)=$71

Strike price(X)=$78

Rf=4%

std=42%

time=1

value of call option=15.555

Annual incentive=16% x 15.555=2.5

The annual incentive fees according to Black Scholes Formular =2.5

(b) The value of annual incentive fee if the fund had no high water mark and it earned its incentive fee on its return in excess of the risk-free rate? (Treat the risk-free rate as a continuously compounded value to maintain consistency with the Black-Scholes formula.)

current price (st)=71

Strike price(X)=78

Rf=(e^4%)-1 = 4.08%

std=42%

time=1

value of call option=17.319

Annual incentive=16% x 17.319=2.77

7 0
2 years ago
Suppose you purchase one share of the stock of Cereal Correlation Company at the beginning of year 1 for $50. At the end of year
cricket20 [7]
B the answer is going to be
6 0
2 years ago
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are p
PilotLPTM [1.2K]

Answer:

The number of units the company would have to manufacture during the year would be 780,000 units

Explanation:

To find out how much purchase is made, first we have to calculate the production level. The equation for production level is shown below:

Production level = Closing stock of finished goods + Sales - Opening stock of finished goods

= 76,000 + 730,000 - 26,000

= 780,000 units

Rest cost like opening and ending balance of raw material , required gram is irrelevant for computation part. Thus, it is not considered.

Hence, The number of units the company would have to manufacture during the year would be 780,000 units

8 0
2 years ago
Other questions:
  • At the end of its first year of operations, shapiro's consulting services reported net income of $27,000. they also had account
    12·1 answer
  • What will most likely happen if a toy supplier sets a price too low for a product?
    8·2 answers
  • Waller Co. paid a $0.137 dividend per share in 2000, which grew to $0.55 in 2012. This growth is expected to continue. What is t
    7·1 answer
  • A soft drink costs 75 cents for a 12-oz can. A two-liter bottle costs $1.25. In which form is the soft drink more expensive? How
    9·1 answer
  • Bovindar, a wholesale distributor of gym equipment, organizes its salesforce based on the region it caters to. Therefore, the sa
    8·1 answer
  • An upset forging plant will be built to produce 2,000,000 parts per year. The plant will operate for three 8-hour shifts per day
    11·1 answer
  • If Katerina were delivering an expository speech about strip mining, she would be presenting _______________________. a. an info
    9·1 answer
  • Tailoring movies slightly to appeal to different markets, such as editing Iron Man 3 for China, best reflects which kind of inte
    14·1 answer
  • Collingsworth, Inc. produces 3 products: AKM, BWT, and CPQ. Product AKM requires 700 purchase orders, Product BWT requires 1,080
    8·1 answer
  • In May 2020, Whitney filed for divorce from her husband, Michael. Although they lived apart for the last six months of the year,
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!