Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Just as you finished your studies of inventory in BUS 2 8 5 , you received a phone call from Bob. It turns out that
Just as you finished your studies of inventory in BUS 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 financial statements which were recently finalized and also financial statements as at and for the two months ended February 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 Included in inventory were spark plugs and filters at a cost of $ each and liters of oil at a cost of $ per liter.
Due to the banks requirements, another inventory count was performed on February On that date, ESER had spark plugs and filters and liters of oil in inventory.
The following are the summaries of inventory purchases and usessales for January to February :
Spark Plugs and Filters
Date Units Purchased CostUnit Units Used
January units
January units $
January units
February units $
February units
February units $
ESER has a workorder system for each repair and records cost of goods sold immediately upon using the parts.
Bulk Oil
Date Units Purchased CostUnit Units Sold
January units
January units $
January units
February units $
February units
Note: The number of purchases and usessales 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
In class, your BUS instructor discussed periodic and perpetual inventory systems. To date, you have been using a periodic inventory system for ESER. You decided to review your BUS notes and prepare a summary of how a perpetual inventory system differs from a periodic inventory system and which type of inventory system would be more appropriate for Bob to use at ESER.
In BUS you discussed the specific identification, FIFO and average cost inventory cost determination methods. You decided to make some brief notes explaining each of the methods and when they should be used and then decide on the most appropriate method to recommend to Bob for ESER.
Based on the information provided above, Bob would like you to determine the February inventory of Spark Plugs and bulk oil in units and dollars and cost of goods sold for the twomonth period from January to February 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.
Throughout January and February ESER sold its Spark Plugs and Filters at a price of $ 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.
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 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started