Suppose a Company Supplies Four of Its Products A, B

question 28

Essay

Suppose a company supplies four of its products A, B, C, and D, to five different regions. The management wants to know the total number of all products supplied to each region as well as the total number of units of each product supplied. The data collected over a period of month are given below. $$\begin{array} { | c | c | c | } \hline \text { Region } & \text { Model } & \begin{array} { c } \text { Number of } \\\text { units }\end{array} \\\hline \text { Region 1 } & \text { A } & 1784 \\\hline \text { Region 2 } & \text { A } & 2170 \\\hline \text { Region 3 } & \text { A } & 415 \\\hline \text { Region 4 } & \text { A } & 2040 \\\hline \text { Region 5 } & \text { A } & 2991 \\\hline \text { Region 1 } & \text { B } & 947 \\\hline \text { Region 2 } & \text { B } & 2111 \\\hline \text { Region 3 } & \text { B } & 1234 \\\hline \text { Region 4 } & \text { B } & 2061 \\\hline \text { Region 5 } & \text { B } & 607 \\\hline \text { Region 1 } & \text { C } & 2907 \\\hline \text { Region 2 } & \text { C } & 4790 \\\hline \text { Region 3 } & \text { C } & 2191 \\\hline \text { Region 4 } & \text { C } & 1942 \\\hline \text { Region 5 } & \text { C } & 220 \\\hline \text { Region 1 } & \text { D } & 2557 \\\hline \text { Region 2 } & \text { D } & 2980 \\\hline \text { Region 3 } & \text { D } & 1518 \\\hline \text { Region 4 } & \text { D } & 2957 \\\hline \text { Region 5 } & \text { D } & 4462 \\\hline\end{array}$$ ​
Display your use of the SUMIF function and find the total volume by each region and total volume by each product.
​

---

Definitions:

Common Equity

The amount of ownership interest that is common stockholders have in a company, reflecting their equity stake.

Borrow

The act of receiving funds from a lender with the agreement to return the principal amount along with interest or other charges, if applicable.

Assets

Economic resources owned or controlled by a person or entity that are expected to produce value or benefit in the future.

Assets

Resources owned by a company or individual that have economic value and can provide future benefit.