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
Ilya [14]
3 years ago
5

List the order number and order date for each order placed by the customer named johnson s department store. (hint: to enter an

apostrophe (single quotation mark) within a string of characters, type two single quotation marks.)
Business
1 answer:
iris [78.8K]3 years ago
8 0

Answer:

Explanation:

To obtain the needed detail of order table and order date for each order place by customer, has to be filtered with "John's Department Store"

select ORDER_NUM, ORDER_DATE frome orders as o

inner join customer as c on c.CUSTOMER_NUM=o.CUSTOMER_NUM

where c.CUSTOMER_NAME = "Johnson's Department Store"

You might be interested in
helene, corp. reports a net operating loss in year 1 of $20,000. in year 2, the company reports income of $10,000. what amount o
gtnhenbr [62]

$8,000 (80% limitation) amount of year 2 income may be offset by the carryforward of the year 1 net operating loss

When a business' running costs are higher than its gross income, it experiences an operating loss (or revenues in the case of a service-oriented company).

Operating profit is the profit a business makes before taxes and interest. In the same manner as cost of goods sold, selling, general, and administrative expenditures are, interest and taxes are not regarded as operating costs. In many cases, businesses make enough money to pay their costs and turn a profit.

To know more about operating refer here:

brainly.com/question/15080057

#SPJ4

3 0
1 year ago
Cody Mountain Sports is an outdoor sporting goods guiding service located in northern Wyoming. Cody Mountain Sports (CMS) primar
saveliy_v [14]

Answer:

Cody Mountain Sports (CMS)

T-accounts:

Cash

Date       Account Titles               Debit    Credit

Mar. 1     Common Stock       $100,000

Mar. 1     Prepaid Insurance                     $1,200

Mar. 4    Service Revenue       20,000

Mar. 19  Vehicle Expenses                       1,000

Mar. 22 Accounts Receivable  3,000

Mar. 24 Rent Expense                            4,000

Mar. 27 Salaries Payable                         1,000

Mar. 31 Cash dividends                          2,500

Accounts Receivable

Date       Account Titles               Debit    Credit

Mar. 15   Service Revenue       $3,000

Mar. 22  Cash                                          $3,000

Prepaid Insurance

Date       Account Titles               Debit    Credit

Mar. 1     Cash                             $1,200

Salaries Payable

Date       Account Titles               Debit    Credit

Mar. 18   Salaries Expense                     $10,000

Mar. 27  Cash                             $1,000

Common Stock

Date       Account Titles               Debit    Credit

Mar. 1     Cash                                       $100,000

Service Revenue

Date       Account Titles               Debit    Credit

Mar. 4    Cash                                         $20,000

Mar. 15  Accounts Receivable                   3,000

Salaries Expense

Date       Account Titles               Debit    Credit

Mar. 18   Salaries Payable        $10,000

Vehicle Expense

Date       Account Titles               Debit    Credit

Mar. 19   Cash                             $1,000

Rent Expense

Date       Account Titles               Debit    Credit

Mar. 24  Cash                             $4,000

Cash Dividends

Date       Account Titles               Debit    Credit

Mar. 31   Cash                           $2,500

Explanation:

a) Data and Analysis:

Mar. 1 Cash $100,000 Common Stock $100,000

Mar. 1 Prepaid Insurance $1,200 Cash $1,200

Mar. 4 Cash $20,000 Service Revenue $20,000

Mar. 15 Accounts Receivable $3,000 Service Revenue $3,000

Mar. 18 Salaries Expense $10,000 Salaries Payable $10,000

Mar. 19 Vehicle Expenses $1,000 Cash $1,000

Mar. 22 Cash $3,000 Accounts Receivable $3,000

Mar. 24 Rent Expense $4,000 Cash $4,000

Mar. 27 Salaries Payable $1,000 Cash $1,000

Mar. 31 Cash dividends $2,500 Cash $2,500

6 0
3 years ago
What are the limitations of gdp and gnp
shutvik [7]

The limitations of GDP. GDP is a useful indicator of a nation's economic performance, and it is the most commonly used measure of well-being. However, it has some important limitations, including: The exclusion of non-market transactions.

7 0
3 years ago
Read 2 more answers
Has anyone done the managing payroll quiz for Personal Finance on connexus???
trasher [3.6K]

Answer:

a) withholdings

b) deductions

c) payroll register

d) methods of paying employees

e) commission

f) specific required deductions

g) hourly rate

h) voluntary deductions

i) Salary

j) standard deductions

Explanation:

A)

Withholdings are the amount that is associated with the payroll deductions from an employee's gross wages. The employer does not include withholdings in the employee's paycheck. Instead of adding it to the salary, the amount is transferred to the federal, state, or local government or tax authorities. It also decreases the tax that an employee has to pay during the yearly tax return.

B)

When an employer withholds any amount from an employee's gross salary, such as taxes, insurance, wage responsibilities, saving plans, and child support payments, it refers to deductions. The payroll deduction is also known as involuntary deductions because the employer is withholding the amount. Those deductions are legally deductible; therefore, it is automatic deductions.

C)

A list of periodic reports that enlist the hourly wages, additionals, gross pay, deductions, net pay, and the date of payrolls refers to the payroll register. More precisely, it is a summary of each employee's paycheck throughout a period. It starts with the current quarter's or month's total hourly wages and ends with the net pay of the employee.

D)

The commission is the percentage paid to an employee for his or her additional service provided for the company. For example, a company asks an employee to produce anything over 500 shirts per week will receive 10% additions, if the employee contributes in 510 shirts, he will receive an extra payment, it is commission. The hourly rate is the amount paid to the employee per hour. The salary is the monthly or weekly amount paid to an employee for his periodic contribution towards a business.

E)

The commission is the portion given to an employee for his or her supplementary service rendered for the company. For example, a manager of a firm urges the sales representative to sell $10,000 per month to receive an extra 10% of the total sales. If the sales representative sells $10,000 or more, he will receive an additional fee as a percentage. That percentage refers to the commission.

F)

Specific payroll deduction means deduction from paycheck to meet the obligations of income tax and other required duties. Every individual and corporation whose income is taxable is obliged to pay a tax. In the case of specific payroll deduction, an employee is legally obligated to withhold this money from an employee's payroll check based on federal and state laws. But specifically required deduction is not only used for tax provisions but also used for employee-related benefits like health insurance and short time disability plans that are offered by the employer.

G)

According to the Cambridge dictionary, hourly rate means the amount of money that is charged, paid, or earned for every hour worked. An employer is bound to pay a minimum hourly wage to the employee. It is one of the critical issues as many workers work as a part-time job. Since it is not a fixed job, so monthly or weekly payment is not applicable here. To adjust the amount for every type of employment, whether it is a permanent or temporary hourly rate of wage, is the best solution.

H)

When any deductions from employees salary or wages are not legally binded, those deductions are termed as Voluntary deductions. Voluntary deduction does not need any imposition of law. As it is not legally required, it is offered by the employer for employee's acceptance. This kind of deduction may include health, accident, disability, retirement plans; flexible spending accounts such as parking and transit costs; union dues; and deductions for paycheck advances and other company-sponsored benefits.

I)

Salary is most commonly known as compensations paid by the employer to an employee in return for required job performance. Salary generally paid in fixed intervals for an individual's performance. The intervals may be weekly, monthly, etc. and these are set up by a mutual contract between employer and employee. Salary mainly includes base pay and other benefits,  bonuses, or rises. Salary mainly gives security towards the employee as it is fixed payment for their work performances.

J)

Standard deduction means deduction of some amount of money from the total amount of income to reduce total taxable income. In short, it means a portion of income that is not subject to tax. The amount of one's standard deduction depends on one's filing status, age, or whether one is disabled or claimed as a dependent on someone else's tax return. But all the taxpayers are not qualified to enjoy this provision. Nonresident husbands and wives, married people filing separately whose spouses itemized, and trusts and estates cannot entertain this benefit.

8 0
3 years ago
Watson consulting, llc is a consultancy to consultants. They have bonds which have a face value of $1,000. The bonds carry a 3.5
Montano1993 [528]

Answer:

The current market price is $ 883.08  

Explanation:

The current market price can be ascertained using the pv excel function as follows:

=-pv(rate,nper,pmt,fv)

rate is the semiannual yield to maturity which is 5%/2

nper is the number of semiannual coupons in the bond i.e 10*2=20

pmt is the semiannual coupon=3.5%*1/2*$1000=$17.5

fv is the face value of the bond

=-pv(5%/2,20,17.5,1000)=$ 883.08  

3 0
3 years ago
Other questions:
  • _____ is the total value of all the finished goods and services produced in a country over a certain period of time
    5·1 answer
  • - - - - - is the fundamental goods or services offered to the consumer
    8·1 answer
  • Sam has $65 to spend on clothes. he wants to buy a pair of jeans for $29 and spend the rest on t-shirts. each t-shirt costs $9.
    5·1 answer
  • What bill will have to be paid one of these days to kill a mockingbird?
    14·1 answer
  • The health care workforce during the current market-driven changes is experiencing: A. Significant expansion at professional lev
    11·1 answer
  • Your insurance firm processes claims through its two facilities: facility A and facility B. Each month, facility A handles 6,000
    8·1 answer
  • Fixed vs variable cost preference. bates operates a kiosk at a local mall, selling duck calls for $30 each. the variable cost to
    6·1 answer
  • A company has two options for manufacturing boots. The manual process has monthly fixed costs of $26,380 and variable costs of $
    10·1 answer
  • __ strategy customizes the product offering to local demands and increases the value of that product in the local market. A tran
    15·1 answer
  • Limitations of Electronic Business can be categorised as technical and non-technical. identify and explain three (3) technical a
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!