RYAN R, ACCT 3110 25 POINT PROJECT Project Due October 23, 2017 You are given the following information for a single-process company with both beginning and ending inventory. Assume that no inventory is lost in production due to shrinkage or other reasons. ALL materials are added at the beginning of processing. The weighted-average method is to be used. COSTS Materials Conversion Total UNITS Begin. Inventory 20p00 $12000 $3200D Begin Inventory'2500 Added this period Aded this pertiod28,000 2Mooo 5200Oddedthis period5 00 (seg Ending Inventory# * percentage of conversion complete for beginning inventory = # percentage of conversion complete for ending inventory Complete two different sheets on EXCEL (MUST be done on EXCEL unless special permission is given). One sheet should look like Exhibit 17-4 (p. 685) and should summarize Steps one and two of the five- step process covered on p. 679. The second sheet should look like Exhibit 17-5 (p. 686) and summarize steps three through five of the five-step process. Form will be a relatively small factor, but will be taken into account