please use the excel pictures as a visual on how to set up the answers of the highlighted problems! thank you

The transactions listed below are typical of those involving New Books Inc, and Readers' Corner. New Books is a wholesalc merchandiser and Readers' Corner is a retail merchandiser. Assume all sales of merchandise from New Books to Readers' Corner are made with terms n/30, and the two companies use perpetual inventory systems. Assume the following transactions between the two companies occurred in the order listed during the year ended August 31 . a. New Books sold merchandise to Reader' Corner at a selling price of $550,000. The merchandise had cost New Books $415,000. b. Two days later. Readers' Corner complained to New Books that some of the merchandise differed from what Readers' Corner had ordered. New Books agreed to give an allowance of $10,000 to Readers' Corner. Readers' Corner also returned some books, which had cost New Books $2,000 and had been sold to Readers' Corner for $3,500. No further returns are expected. c. Just three days later. Readers' Corner paid New Books, which settled all amounts owed. Required: 1. Indicate the effect (direction and amount) of each transaction on the Imentory balance of Readers' Corner. 2. Prepare the journal entries that Readers' Corner would record and show any computations. PA6-2 Reporting Sales Transactions between Wholesale and Retail Merchandisers Using Perpetual Inventory Systems LO 6-4, 6.6 Use the information in PA6-1 to complete the following requirements. Required: 1. For each of the events (a) through (c), indicate the amount and direction of the effect (+ for inerease, - for decrease, and NE for no effect) on New Books in terms of the followine items. 2. Prepare the journal entries New Books would record; and show any compatations