Use the Database Below to Answer the Following Question CUSTOMER

question 65

Essay

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP
$$\begin{array} { l | l | l | } \hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Tones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Tohnson } & 11 / 23 / 1998 \\\hline\end{array}$$
CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345 \\\hline\end{array}$$
Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.

Understand the consolidation process for intercorporate investments.

Determine the deferred income tax consequences of intercompany transactions.

Grasp the effects of acquisition transactions on financial statements, including goodwill recognition.

Apply the initial value method in accounting for investments.

---

Definitions:

Contribution Margin

The amount remaining from sales revenue after variable expenses have been deducted, indicating the contribution towards covering fixed costs and generating profit.

Contribution Format

An income statement variant that divides expenses into variable and fixed groups, emphasizing the contribution margin.

Break-even Point

The point at which total costs and total revenue are equal, leading to neither profit nor loss.

Fixed Expenses

Costs that remain constant regardless of the level of goods or services produced, such as salaries and rent.