Download and Use this inventory Problem Worksheet to Help you complete this problem >>> Ch Candy Bar Inventory Problem.xlsx Purchase Date Units Items Unit Price Total 10/1/XX 2 Candy Bars $0.25 $0.50 10/15/xx 2 Candy Bars $0.30 $0.60 10/31/XX 1 Candy Bars $0.40 $0.40 5 Total Cost of Inventory $1.50 Sales - Sell 3 Candy Bars for $1.00 each on 11/4/XX. Answer the following questions based on the three inventory Methods 1. FIFO 2. LIFO 3. Weighted Average Question 1 2.5 pts Based on the following data, complete the required questions from the handout for this slement Be sure to complete the handout first then you can enter the required answers below. Use the following rules to enter your answers 1. Round answers to TWO decimals. Example 20 or 230) 2. Do not use commas or dollar sions in your answers FIFO Method Amounts What is the cost of goods sold? What is the cost of remaining Inventory? What is the total sales revenue? What Gross Profit D Question 2 2.5 pts Based on the following data, complete the required questions from the handout for this assignment. Be sure to complete the handout first then you can enter the required answers below. Use the following rules to enter your answers, 1. Round answers to TWO decimals. (Example - 20 or 2.30) 2. Do not use commas or dollar signs in your answers, LIFO Method Amounts What is the cost of goods sold? What is the cost of remaining inventory? What is the total sales revenue? What is Gross Profit? Question 3 2.5 pts Based on the following data, complete the required questions from the handout for this assignment. Be sure to complete the handout first then you can enter the required answers below. Use the following rules to enter your answers. 1. Round answers to TWO decimals. (Example - 20 or 2.30) 2. Do not use commas or dollar signs in your answers. Weighted Average Method Amounts What is the cost of goods sold? What is the cost of remaining inventory? What is the total sales revenue? What is Gross Profit? Question 4 1.25 pts Which method has the highest Cost of Goods Sold? FIFO O UFO Weighted Average Question 5 1.25 pts Which method has the Lowest Cost of Goods Sold? FIFO OLIFO Weighted Average