Consumers are primarily price-driven when shopping on the internet.<br> a. true<br> b. false

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

Feliz [49]

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

5 0

3 years ago

Bristo Corporation has sales of 1,000 units at $60 per unit. Variable expenses are 40% of the selling price. If total fixed expe

Misha Larkins [42]

Answer:

3.60

Explanation:

Given that,

Sales units = 1,000

Sales price per unit = $60

Variable expenses = 40% of the selling price

Total Fixed cost = $26,000

Contribution margin per unit:

= Selling price - Variable cost

= $60 - ($60 × 40%)

= $60 - $24

= $36

Total contribution:

= Contribution margin per unit × Sales units

= $36 × 1,000

= $36,000

Profit = Total contribution - Fixed cost

= $36,000 - $26,000

= $10,000

Degree of operating leverage:

= (Sales - Variable costs) ÷ (Sales - Variable costs - Fixed Expenses)

= (60,000 - 24,000) ÷ (60,000 - 24,000 - 26,000)

= 36,000 ÷ 10,000

= 3.60

8 0

3 years ago

Josie recently took a job in the marketing department for Beachside Bagels and Bakery. After just a few days on the job, Josie l

Natalija [7]

Answer: Bureaucratic organization

Explanation:

A bureaucratic organization is an organization with a pyramidal shaped structure thereby decisions are made in an organized manner and there is high formality in its operations. It involves different layers of management from the top executives to managers till it gets to the lower staffs

Authority and decision making generally comes from the top till it gets to lower layers. Examples of bureaucratic organizations can be found in colleges and police departments.

6 0

4 years ago

Read 2 more answers

Brianna was a veteran manager and had been with the company for several years when she got promoted to the company's flagship o

Kitty [74]

Answer:

In the restaurant business, self inspections can help you ensure that the food is always safe for your customers (better quality food) , lower the overall costs of the restaurant and helps to increase your reputation (a clean restaurant is always seen as a better restaurant).

Self inspection doesn't mean that the manager herself has to carry out the inspection, another employee can. Self inspection refers to making sure you comply with all regulations without having an inspector come and evaluate your restaurant. Self inspections will help the restaurant get higher inspection scores, and that was one of Brianna's major accomplishments.

8 0

4 years ago

In the vast majority of commercials that advertise cleaners, a woman is shown using the product, even though the high percentage

erma4kov [3.2K]

Answer:

Sex roles are portrayed stereotypical

Explanation:

The people perceive that the household issues like cooking, washing clothes, children mentoring, etc are the jobs of the women becuase this is how they had contributed to the family in the past. So media stereotypically perceives the same way the society does and also portrays it the same way.

7 0

4 years ago

Consumers are primarily price-driven when shopping on the internet. a. true b. false