Spreadsheet Automation of the Unrealized Profit ^Analysis and the Inventory Transfer Elimination Entry Before working this assignment, you should first have worked Problems 9-1, 9-2, 9-4, or 9-5 using MODEL09 of the software package that accompanies the text. Next perform the follow¬

ing steps for automating the inventory transfer elimination entry on the spreadsheet.

Required 1. In the unrealized profit analysis (begins on row 26) program formulas to automatically insert from either the Parent column or the Subsidiary column of the worksheet amounts for

(a) in¬

tercompany sales,

(b) intercompany cost of sales, and

(c) intercompany inventory on hand. To allow this analysis to accommodate the possibility of intercompany inventory transfers being ei¬

ther downstream or upstream, you must program a logic formula (using the = IF function of EXCEL) for inserting amounts from either (1) the parent’s column or (2) the subsidiary’s col¬

umn, as appropriate.

2. In the analysis, program formulas to automatically insert the remaining three missing amounts.

3. Below the analysis in the required consolidation entry section that is derived from this analysis, program formulas to bring forward the appropriate amounts from the analysis.

4. In the Debit and Credit columns of the consolidation worksheet, program formulas to bring for¬

ward the amounts that are in the elimination entry you prepared in the preceding instruction.