Please Help On December 1, 2019, Athabasca Building Supplies Ltd. (ABS) purchased Dunbar Doors Inc. (DDI) from Kevin Osepchuk. This was ABS’s entry into the door business and they welcomed the opportunity to sell doors to existing customers. When ABS acquired DDI, they also agreed to take over a DDI loan with the Royal Dominion Bank. The loan has a limit equal to 80% of the Merchandise Inventory account balance at year-end pertaining to doors. The loan had been held with that bank for a number of years and the current balance is $200,000. The bank requires verification of the inventory balance at the end of every year. As part of the deal to acquire DDI, Kevin agreed to serve as the new manager of ABS's Door Division and to receive a bonus equal to 10% of the operating profit of that division.

You are a student who is helping ABS prepare its year-end financial statements. At the inventory count on December 31, you noticed that the employees counting the inventory at that time found that there were 800 doors on hand. ABS uses the perpetual average cost method.

In looking at the company's inventory records, you discover that 2,600 doors were purchased from DDI on December 1 at a cost of $310 each. Later in the month, 800 doors were purchased from a U. S. supplier at CAD$240 each and shortly after, 600 doors were purchased from China at CAD$190 each. Finally, on the last day of the year, 100 more doors were purchased at CAD$200 but these were in transit on December 31 with terms FOB destination. The only sale for the month occurred after the purchase of the doors from China when 3,200 doors were sold at $400 each to a contractor developing the largest condominium project in the area. Kevin supervised the count and determined the cost of the ending inventory. He calculated the ending inventory to be 900 doors at $310 each. He added 100 doors to the amount counted because of the doors in transit. Kevin earned a bonus of $16,700 in December.

Instructions:
(a) Determine the number of units and cost of goods available for sale in December and the weighted average cost of inventory before the sale. (15 points)
(b) Determine the number of units and cost of ending inventory at December 31. (15 points)
(c) Determine the adjustment required to the merchandise inventory at year-end to correct it. What will be the impact on COGS? Based on the above, should there be an adjustment to Kevin's bonus, which is based on profit? (20 points)
(d) Does this adjustment have any other implications (e. g. the bank loan)? (15 points)
(e) Do you consider Kevin's actions ethical? What was his possible motivation? (10 points)
(f) Assume that the decrease in the cost of doors from China is indicative of future trends in the industry and that ABS will be forced to reduce its selling price in the future to $260 per door. Is there any adjustment that has to be made in the December financial statements related to the net realizable value of the doors in inventory, including any further adjustment to Kevin’s bonus? (15 points)