Pistol Corporation acquired $70$ percent of Scope Corporation's voting stock on May $18,201.$ The companies reported the following data with respect to intercompany sales in $20x4$

and $20$x$5$:

Pistol reported operating income $($excluding income from its investment in Scope$)$ of $$160,000$ and $$220,000$ in $204$ and $205,$ respectively. Scope reported net income of $$90,000$

and $$85,000$ in $204$ and $205,$ respectively.

Required:

Compute consolidated net income for $204.$

Note: Use cells A$2$ and H$9$ from the given information to complete this question.

Compute the inventory balance reported in the consolidated balance sheet at December $31,205,$ for the transactions shown.

Note: Use cells $A2$ and $H9$ from the given information to complete this question.

Compute the amount included in consolidated cost of goods sold for $20$X$5$ relating to the trans$-$actions shown.

Note: Use cells A$2$ and H$9$ from the given information to complete this question.

Compute the amount of income assigned to the controlling interest in the $205$ consolidated income statement.

Note: Use cells A$2$ and H$9$ from the given information to complete this question.

Please show computations for the yellow cells by using cells from A$2$ to H$9$