39.9k views
1 vote
Using the query updated in question 5 above, create a new query that computes total sales and total revenue (sales plus shipping cost). What is the total sales (without shipping cost)?

User Aeonaut
by
6.8k points

1 Answer

4 votes

Final answer:

Total sales (without shipping cost) can be calculated by subtracting the shipping cost from the total revenue.

Step-by-step explanation:

Total revenue is the income the firm generates from selling its products.

We calculate it by multiplying the price of the product times the quantity of output sold:
Total Revenue = Price x Quantity

In the given scenario, the total sales (without shipping cost) can be calculated by subtracting the shipping cost from the total revenue.

Let's assume the total revenue is $500 and the shipping cost is $50. So, the total sales (without shipping cost) would be $500 - $50 = $450.

User Leopold Joy
by
7.6k points