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
Vaselesa [24]
2 years ago
15

Required: a. How many customer records are stored in the database? b. List customers who live in New York. c. List customers wit

h credit limits greater than $50,000. d. List sales transactions made in July, 2018. e. What’s the number of total sales transactions made to each customer?
Business
1 answer:
Feliz [49]2 years ago
5 0

Answer:

a- How many customer records are stored in the database

SQL Command for knowing number of customer records are stored is

SELECT COUNT(Customer Name) FROM tbl Customer ;

b- List customers who live in New york.

SQL Command for knowing number of customers who live in New york

SELECT Customer State, FROM tbl Customer WHERE CITY = 'New york' ;

c- List customers who credit limits grater than $50,000.

SQL Command for knowing number of customers who's credit limit is grater than $50,000

SELECT Customer Credit Limit, FROM tbl Customer WHERE Credit limit > 50,000 ;

d. List sales transaction made in July - 18

SQL Command for knowing sales in July - 18

SELECT InvoiceDate, FROM tbl Sales ;

e. What the number of total sales transactions made to each customer

You might be interested in
Sole Mates Inc. is planning a one-month campaign for July to promote sales of one of its two shoe products. A total of $100,000
Cerrena [4.2K]

Answer:

Sole Mates Inc.

Differential analysis:

                                        Tennis Shoe      Walking Shoe

Unit selling price                      $85                  $100

Unit production costs:

Direct materials                        $19                   $32

Direct labor                                  8                      12

Variable factory overhead          7                       5

Unit variable selling expenses   6                     10

Total variable costs                $40                   $59

Contribution margin per unit $45                   $41            

                                        Tennis Shoe      Walking Shoe   Difference

                                        Alternative 1       Alternative 2

Total contribution margin    $315,000         $287,000       $28,000

Advertising costs                  (100,000)          (100,000)                  0

Total income (loss)             ($215,000)          $187,000      $28,000

Promote the Tennis Shoes (Alternative 1) because it will bring in more contribution margin than Alternative 2.

Explanation:

a) Data and Calculations:

Budgeted advertising costs = $100,000

                                        Tennis Shoe      Walking Shoe

Unit selling price                      $85                  $100

Unit production costs:

Direct materials                        $19                   $32

Direct labor                                  8                       12

Variable factory overhead          7                        5

Fixed factory overhead             16                       11

Total unit production costs    $50                  $60

Unit variable selling expenses   6                     10

Unit fixed selling expenses     20                     15

Total unit costs                       $76                 $85

Operating income per unit      $9                   $15

3 0
3 years ago
Money is a ______ of some item or group of items that is used as a medium of exchange.
Naily [24]

The fact that money can be used as a medium of exchange is as a result of it being a <u>stock </u>of some items.

<h3>What can money do?</h3>

Money allows for us to trade goods and services which makes it invaluable as a medium of exchange.

The reason money can do this is because it can be denoted as the stock or value of some items.

Find out more on the purposes of money at brainly.com/question/3182649.

4 0
2 years ago
The following three independent sets of facts relate to contingent liabilities: 1. In November of the current year an automobile
aalyn [17]

Answer:

Situation 1 is a probably contingency. This recall is occurring and can be estimated as costing $2 million. This amount should be charge to the warranties payable and warranties expense accounts.

Date

Particulars

Ref.no

Debit $

Credit $

Warrantee expenses

20,00,000

Warranty payable account

20,00,000

[To record the estimated claims]

Comment

Step 3 of 3

Situation 2 is a reasonable contingency. The costs are possible and there are rough estimates for cleanup but there are also rough estimates about reimbursements for property damage. This situation would be disclosed on the balance sheet.

Situation 3 is a remote contingency. There is a small change that there could be property damage but there is no way to determine how much or what the costs could be. There is no amount marked down for this situation

Explanation:

5 0
2 years ago
Banko Inc. manufactures sporting goods. The following information applies to a machine purchased on January 1, Year 1: Purchase
ioda

Answer: See Explanation

Explanation:

You didn't give the methods to use but let me use 2 main methods.

First, let's use the Straight line Depreciation. This will be:

= ($71000 + $3000 + $2000 - $3000) / 5

= $73000/5

= $14600

Year 1 Depreciation = $14600

Year 2 depreciation = $14600

Secondly, let's use the double declining method of Depreciation will be:

= 1/5 × 2

= 0.2 × 2

= 0.4

= 40%

Year 1 depreciation will be:

= 76000 × 40%

= 76000 × 0.4

= $30400

Year 2 Depreciation will be:

= ($76000 - $30400) × 40%

= $45600 × 40/100

= $45600 × 0.4

= $18240

7 0
2 years ago
On June 1, year 2, Oak Corp. granted stock options to certain key employees as additional compensation. The options were for 1,0
Dimas [21]

Answer:

Since the options were granted at an exercise price of $15 when the market value of the shares was $20, total compensation under the intrinsic method would be $5 per share on 1,000 shares or $5,000. Since the options are exercisable on 1/2/X2, the $5,000 in compensation would all be recognized n 20X1.

Explanation:

3 0
3 years ago
Other questions:
  • What are ethics? how would they apply to business and technology?
    11·1 answer
  • Bill wants to open a checking account to pay bills from and a savings account to cover overdrafts and other emergencies. He want
    5·1 answer
  •  Stan works on an assembly line. What effective and appropriate approach would he be wise to use when coping with minor frustrat
    5·1 answer
  • George manages inventory for a company. The company has been struggling to reduce production costs in all departments for severa
    6·1 answer
  • From the buyer's perspective, which of the following is a benefit of a product with a well-known brand name?
    6·1 answer
  • In the chapter, we used Rosengarten Corporation to demonstrate how to calculate EFN. The ROE for Rosengarten is about 7.3 percen
    5·1 answer
  • During the process of confirming receivables as of December 31, Year 1, a positive confirmation was returned indicating the "Bal
    13·1 answer
  • Material delays have routinely limited production of household sinks to 400 units per day. If the plant efficiency is 80%, what
    12·1 answer
  • which circumstance is most likely to cause a farmer to store soybeans for a future sale instead of selling them right after harv
    12·1 answer
  • A financial analyst, assesses the likelihood of various possible future values of a stock price, assigns the following probabili
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!