I have completed the assignment but would like to double check my work. If this can be done in excel along with all possible functions needed to perform each task that would be great. Detail and organization would be a great benefit. If you can also put it in the order for which is displayed that would be greatly appreciated. DUE BY MIDNIGHT. can you manual input the answer?

Name Box 1 Type your name BELOW: 4 Change the name of the file to your last name first, then Excel HW 3 5 Example: "Knight Excel Hw 3.xls" 7 Bieber Inc. is a retailer operating in Calgary, Alberta. Bieber uses the perpetual inventory method. You are provided with the following inform Unit Cost or Selling Date Description Quantity Price 160 9 Dec. 31 Ending inventory 19.00 100 21.00 10 Jan. 2 Purchase 11 Jan. 6 sale 180 39.00 12 Jan. 9 Purchase 23.00 75 13 Jan. 10 sale 44.00 50 14 Jan. 23 Purchase 24.00 100 15 Jan. 30 sale 130 47.00 16 Calculate: ending inventory cost, cost of goods sold, gross profit and gross profit rate under each of the following methods: 17 LIFO, FIFO and Average Cost. (Round cost per unit to three decimal places using the "Round" function in Excel.) Please prepare your worksheet with tables similar to the format as the class handout for Chapter 6. Include a table for "Purchases" and a table for "Sales". 18 Also complete the "Proof of Cost of Goods Sold" calculations for LIFO and FIFO