Just as you finished your studies of inventory in BUS 285, you received a phone call from Bob. It turns out that he is considering purchasing a property to house his business. He is at the bank and they have indicated it will require the December 31, 2016 financial statements which were recently finalized and also financial statements as at and for the two months ended February 28, 2017 before making a decision about whether to finance the purchase of the property. To help him prepare the required financial statements, Bob has asked you to help him with some inventory issues. As you are aware, Economy Small Engine Repair uses a periodic inventory system but Bob knows that there are differences in value for inventory if you use a perpetual inventory system with different costing structures. Bob needs to maximize his inventory value for this loan so without "breaking the rules, he wants to know what happens if inventory records for routine parts that are easily identified like spark plugs and filters are maintained using FIFO and inventory records for things like fasteners and other bulk products are done using weighted average. Shortly after your telephone conversation, Bob emailed you the following information: An inventory count was performed on December 31, 2016. Included in inventory were 50 spark plugs and filters at a cost of $1.25 each and 80 liters of oil at a cost of $2.50 per liter. Due to the bank's requirements, another inventory count was performed on February 29, 2017. On that date, ESER had 85 spark plugs and filters and 95 liters of oil in inventory. The following are the summaries of inventory purchases and uses/sales for January 1 to February 29, 2017: Spark Plugs and Filters Date Units Purchased Cost/Unit Units Used 20 units 50 units $1.30 40 units January 2 January 9 January 30 February 6 February 20 February 27 30 units $1.40 45 units 60 units $1.50 ESER has a work-order system for each repair and records cost of goods sold immediately upon using the parts. Bulk Oil Units Purchased Cost/Unit Units Sold 50 units 100 units $2.60 Date January 9 January 23 January 30 February 13 February 28 40 units 50 units $2.75 45 units Note: The number of purchases and uses/sales of inventory have been reduced to demonstrate the important inventory accounting concepts, but manage the workload required to respond to the tasks in this lab. Tasks 1. Based on the information provided, Bob would like you to determine the February 29, 2017 inventory of Spark Plugs and bulk oil (in units and dollars) and cost of goods sold for the two-month period from January 1 to February 29, 2017 on these items. He has asked that you provide detailed supporting calculations and round all per unit amounts to the nearest cent and all cost of goods sold and inventory amounts to the nearest dollar. 2. Throughout January and February 2017, ESER sold its Spark Plugs and Filters at a price of $3.50 each. Please calculate the gross profit margin on Spark Plugs and Filters. Please express the gross profit margin as a percentage and round the result to two decimal places. 3. As you are using currently using a perpetual inventory system for ESER, you decided to redo the calculations of ending inventory and cost of goods sold for the two products using a periodic inventory system to show Bob the difference and practice what you learned in BUS 285. Similar to the work you did above, you plan to provide detailed supporting calculations and round all per unit amounts to the nearest cent and all cost of goods sold and inventory amounts to the nearest dollar