1answer.
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
kodGreya [7K]
3 years ago
15

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:
DanielleElmas [232]3 years 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
Weighted Average Cost Flow Method Under Perpetual Inventory System
Fudgin [204]

Answer and Explanation:

The computation of the cost od merchandised sold for each sale and the inventory balance after each sale is presented in the attachment below;

The perpetual inventory is the system which updated the inventory as on a regular basis

While on the other hand,  the weighted average cost method is the method in which the average cost is calculated after each every purchase is made

In the calculation below:

1. The weighted average cost of $30.90 come from

= (Total inventory cost) ÷ (Total quantity)

= ($180,000 + $1,674,000) ÷ (60,000 units)

= $30.90

1. The weighted average cost of $31.60 come from

= (Total inventory cost) ÷ (Total quantity)

= ($463,500 + $674,100) ÷ (36,000 units)

= $31.60

6 0
3 years ago
Prepare income statements based on variable costing for each of the 2 years. 2.Prepare income statements based on absorption cos
enot [183]

Answer:

The question is incomplete, it is missing the accounts and numbers, so I looked for a similar question:

<em>The Rehe Comany sells its razors at $3 per unit. The company uses a first-in, first-out actual costing system. A fixed manufacturing cost rate is computed at the end of each year by dividing the actual fixed manufacturing costs by the actual production units. The following data are related to its first two years of operation: </em>

<em>                    2011 2012 </em>

<em>Sales 1000 units  1200 units </em>

<em>Costs: </em>

<em>Variable manufacturing  700 500</em>

<em>Fixed manufacturing  700 700</em>

<em>Variable operating (marketing) 1000 1200 </em>

<em>Fixed operating (marketing)  400 400</em>

<em />

                                                           2011                  2012

Sales                                               1000 units         1200 units

Production                                          1400                  1000  

Costs:  

Variable manufacturing                      $700               $500

per unit $0.50

Fixed manufacturing                           $700               $700

Variable operating (marketing)         $1000             $1200

Fixed operating (marketing)               $400               $400

cogs under absorption costing 2011 = ($1,400 / 1,400) x 1,000 = $1,000

cogs under absorption costing 2012 = $400 + ($1,200 / 1,000) x 800 = $1,360

1.                                    INCOME STATEMENTS

                                      VARIABLE COSTING

                                                             2011                    2012

Total sales revenue:                        $3,000                $3,600            

Opening inventory:                               ($0)                 ($200)

Variable manufacturing:                   ($700)                 ($500)

<u>Ending inventory:                               $200                   $100 </u>

Gross contribution margin:             $2,500               $3,000

<u>Variable operating:                         ($1,000)              ($1,200)</u>  <u> </u>

Contribution margin:                        $1,500                $1,800  

Fixed manufacturing:                         ($700)                ($700)

<u>Fixed operating:                                ($400)                ($400) </u>

Net operating income:                       $400                  $700

2.                                   INCOME STATEMENTS

                                   ABSORPTION COSTING

                                                             2011                    2012

Total sales revenue:                        $3,000                $3,600            

<u>COGS:                                             ($1,000)                ($1,360) </u>

Gross margin:                                  $2,000                $2,240

<u>Operating costs:                             ($1,400)               ($1,600) </u>

Net operating income:                       $600                   $640

3. Under variable costing, closing inventory = 400 units x $0.50 (variable production costs per unit) = $200.

Under absorption costing, closing inventory = 400 units x $1 (production cost per unit) = $400

Since closing inventory is $200 higher under absorption costing, then net operating income during 2011 increases by $200.

4. a) Variable costing is more likely to result in inventory buildups. Since variable costing determines the value of closing inventory only using variable manufacturing costs, their value is much lower. E.g. in this case the value of closing inventory 2011 under variable costing is $200, while under absorption costing it is $400. This means that less costs are transferred from one year to another.

b) Cost of goods sold must include all production costs (both variable and fixed). This way COGS costs cannot be over estimated during one year and under estimated the next.

<em> </em>

<em />

3 0
3 years ago
Identify the type of business writing for each description.
Westkost [7]
There are four types of businesses organisation. Sole trader is owned by one person and he makes all the decisions, and earns profit and bears the loss himself. A partnership is owned by 2 or more people and they help each other. The profit and loss is divided between them.
4 0
2 years ago
Lagle Corporation has provided the following information: Cost per Unit Cost per Period Direct materials$5.25 Direct labor$3.90
Vikentia [17]

Answer:

$16,050

Explanation:

The computation of the total amount of the period cost is shown below:

= Sales commission per unit × number of units sold + Fixed selling and administrative expense + Variable administrative expense per unit  × number of units sold

= $1.80 × 4,500 units + $6,600 + $0.30 × 4,500 units

= $8,100 + $6,600 + $1,350

= $16,050

7 0
3 years ago
Ed is a 30 year old veterinary technician. Physical exam reveals a height of 5 foot 9 inches, and a weight of 210 pounds. Accord
lianna [129]

Answer:

BMI = 31.18 kg/m²

According to BMI, this patient is diagnosed as Obese.

Explanation:

BMI known as body mass index is taken from a person height and weight. BMI is a person's weight in kilograms divided by the square of height in meters. BMI is usually expressed in kg/m².

Mathematically ,

BMI = weight(kg)/height(m²)

we have to convert the weight and the height to the required units.

converting pounds to kg

2.2 pounds = 1 kilogram

210 pounds = ?

cross multiply

210/2.2 = 95.50 kilograms

converting foot to inches and to meter.

1 foot = 12 inches

5 foot = ?

12 × 5 = 60 inches

60 inches + 9 inches = 69 inches

1 inches = 0.0254 meters

69 inches = ?

69 × 0.0254 = 1.7526  meters

using the formula

BMI = weight(kg)/height(m²)

BMI = 95.50/(1.75)²

BMI = 95.50/3.0625   kg/m²

BMI = 31.1836734694  kg/m²

BMI = 31.18 kg/m²

6 0
3 years ago
Other questions:
  • Which member of the restaurant and food/beverage service career is most likely to plan menus and direct workers?
    12·2 answers
  • Which of the following will appear as a line item in the income statement prepared under variable​ costing? A. Total Cost of Goo
    11·1 answer
  • The following information is for Bright Eyes Auto Supplies: Bright Eyes Auto Supplies Balance Sheet December 31, 2015 Cash $ 40,
    6·1 answer
  • Week 5 Rachel is a financial investor who actively buys and sells in the securities market. Now she has a portfolio of all blue
    13·1 answer
  • Critical analysis Q16 Suppose that the Federal Reserve purchases a bond for $100,000 from Reggie Rich, who deposits the proceeds
    7·1 answer
  • Wilton Corporation had beginning retained earnings of $724,000 and ending retained earnings of $833,000. During the year, it iss
    10·1 answer
  • According to Laurent, managers in Sweden, Denmark, and Great Britain believe that employees should ________. A. adopt a collecti
    9·1 answer
  • During the current year, assets increased from $11,000 to $19,000, and liabilities decreased from $9,000 to $7,500. If no additi
    10·1 answer
  • Each of the items below must be considered in preparing a statement of cash flows for Baskerville Co. for the year ended Decembe
    8·1 answer
  • Well-known responses to demands that occur in a normal, predictable way are known as.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!