a second worksheet called Pivot, where, from the Ribbon Menu, we will insert three Pivot Tables, respectively, for each of the three customer dimensions (seeFig. 13.2-1). The Source Data ofTable 13.2-1, used to build the Pivot Tables, are located in the worksheet called “Sales Data.”...
I-08.03 (a) FIFO perpetual: Date 1-Jan 5-Jan Purchases 7,000 X $21 = $147,000 Sales 12-Jan 9,000 @ $35 = $315,000 Perpetual inventory - application of methods Cost of Goods Sold Balance 5,000 X $20 = $100,000 17-Jan 4,000 X $22 = $ 88,000 26-Jan 31-Jan 3,000 @...