Question

In: Finance

Inventory TableClose The following data pertain to Company A’s inventory that was purchased on January 5,...

Inventory TableClose

The following data pertain to Company A’s inventory that was purchased on January 5, Year 1, for $40,000:

March 31, Year 1

June 30, Year 1

December 31, Year 1

Estimated selling price

$42,000

$44,000

$41,000

Cost of disposal

2,000

2,000

2,500

Normal profit margin

1,200

1,400

1,100

Cost of completion

1,000

1,000

1,000

Current replacement cost

38,000

42,000

36,000

Note: Entire inventory was sold on May 1, Year 2.

EmailClose

To:

Bill West

From:

Rufus Brown

Date:

June 1, Year 2

RE:

GAAP vs. IFRS

Hey Bill,

As you have probably already seen, there is a great newspaper article detailing the company’s plans to go global. You will notice that the biggest challenge that we face is learning the new accounting standards (IFRS). To get us started, I will need your help in calculating some of the Year 1 quarterly inventory balances under both U.S. GAAP policy and IFRS policy. I know that this is a bit of a challenge, but I have ultimate faith in you. Let me know if I can do anything to help.

Sincerely,

Rufus

P.S. Remember that Company A accounts for its inventory using the LIFO method under U.S. GAAP and the FIFO method under IFRS.

Newspaper Article Announcing Global ExpansionClose

Company Seeks to Go Global

Company A is a publicly traded company that reports interim financial statements on a quarterly basis. Until recently, that is all that Company A has ever been. Now, Company A seeks to maintain their old traditions while simultaneously traversing the unknown seas into foreign lands, in the hopes of increasing their global market share.

“We really believe that going global will not only benefit our current employees and their families, but also the lives of potential future employees and their families,” the CEO stated when asked about the decision to go global. “I am really looking forward to leading the way in the greatest project that this company has ever undertaken,” the CEO continued, beaming with pride.

When asked about the challenges that lie ahead, the CEO responded, “Our biggest challenge so far has been learning the new accounting rules and regulations that are applied overseas. For the most part they are similar to the regulations that we abide by here in the States, but there are some instances in which the two standards are wildly different.” However, despite whatever adversity might lie ahead, Company A has an attitude that cannot and will not be defeated.

Scroll down to complete all parts of this task.

Use the information provided in the exhibits to calculate the inventory amounts as they should be reported in the financial statements prepared under U.S. GAAP and IFRS. Enter the appropriate amounts in the associated cells. Enter all amounts as positive values. Round all amounts to the nearest whole number.

U.S. GAAP

IFRS

1. Inventory balance on March 31, Year 1
2. Inventory balance on June 30, Year 1
3. Inventory balance on December 31, Year 1

Solutions

Expert Solution

Differences in valuing and reporting Inventory as per USGAAP and IFRS
S.No. Parameters USGAAP IFRS
1 Inventory Accounting Methods allowed FIFO; LIFO; Weighted Average Cost; Specific Identification.

FIFO; Weighted Average. LIFO not allowed. Specific identification allowed for goods that are not normally interchangeable.

2 Measurement of Carrying Value Lesser of Cost or Market Value (i.e, Current Replacement Cost limited by Net Realizable Value (NRV)) Lesser of Cost or Net Realizable Value (NRV)
3 Net Realizable Value Estimated Selling Price less any reasonable costs associated with sale. Estimated Selling Price Less Estimated Cost of Completion + Estimated cost of Sale
Inventory U.S. GAAP See Note 1 & 2 below

IFRS

See Note 3 below

1. Inventory balance on March 31, Year 1                    38,000                  39,000
2. Inventory balance on June 30, Year 1                    38,000                  39,000
3. Inventory balance on December 31, Year 1                    36,400                  37,500
Given:
Opening Balance of Inventory on January 5, Yr 1 $                 40,000.00
Ending Inventory as at May 1, Yr 2 $                               -  

Working Notes:

Note for USGAAP

USGAAP
Market = Current cost to replace inventory subject to certain limitations.
Market cannot exceed Ceiling = Net Realizable Value
Market cannot be less than Net Realizable Value less Profit Margin
Original cost > Replacement cost.If replacement cost > NRV Ceiling is NRV

Note 2 : Inventory Value as per USGAAP

US GAAP
Net Realizable Value (NRV) Calculations Market USGAAP Inventory Value = Cost / Market which ever is lower (i.e, Lower of 1 or 10.
Ceiling Floor Market Value
Period ending Cost Estimated Selling Price-Given in Ques Estimated cost of completion - Given in Ques Cost of Disposal - Given in Ques Net Realizable Value Current Replacement Cost - Given in Ques Net Realizable Value (NRV) Normal Profit Margin - Given in Question NRV Less Normal Profit Margin
1 2 3 4 5=2-(3+4) 6 7 8 9= 5-8 10 11
Mar-31        40,000           42,000                 1,000              2,000         39,000            38,000          39,000              1,200      37,800         38,000              38,000
Jun-30        38,000           44,000                 1,000              2,000         41,000            42,000          41,000              1,400      39,600         41,000              38,000
Dec-31        38,000           41,000                 1,000              2,500         37,500            36,000          37,500              1,100      36,400         36,400              36,400
On June 30, opening inventory = Closing Inventory as on March 31.

Note 3 : Inventory Value as per IFRS

IFRS
Net Realizable Value (NRV) Calculations IFRS Inventory Value = Cost / Market which ever is lower (i.e, Lower of 1 or 6.
Market Value = NRV
Period ending Cost Estimated Selling Price-Given in Ques Estimated cost of completion - Given in Ques Cost of Disposal - Given in Ques Net Realizable Value
1 2 3 4 5=2-(3+4) 6 7
Mar-31               40,000               42,000               1,000                  2,000                39,000             39,000                39,000
Jun-30               39,000               44,000               1,000                  2,000                41,000             41,000                39,000
Dec-31               39,000               41,000               1,000                  2,500                37,500             37,500                37,500

Related Solutions

The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit...
The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit sold……………………………9,000          Unit Produced………………………8,000          Sales price per unit…………………$30          Direct Manufacturing cost per unit…$10          Fixed factory overhead-total……….$40,000          Fixed factory overhead-per unit……$5          Commercial expenses (all fixed)…..$50,000          Required: Prepare an income statement using absorption costing Prepare an income statement using direct costing Provide computation explaining the difference in        operating income between the two methods.
The following data pertain to April operations for Josephson Company: Beginning inventory    3,000      Units...
The following data pertain to April operations for Josephson Company: Beginning inventory    3,000      Units sold     9,000      Units produced     8,000      Sales price per unit     $ 30      Direct manufacturing cost per unit     $ 10      Fixed factory overhead-total    $40,000      Fixed factory overhead-per unit    $ 5      Commercial expense (all fixed)    $44,000      Required: a. Prepare an income statement using absorption costing. b. Prepare an income statement using marginal costing....
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                           &
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                                                 295 units @ $50 per unit Purchases, January 12                                                            590 units @ $88 per unit Purchases, January 20                                                             450 units @ $91 per unit Purchases, January 31                                                            300 units @ $93 per unit 1,635 Sales, January 5                                                                         75 units @ $200 per unit Sales, January 15                                                                     350 units @ $200 per unit Sales, January 22                                                                     550 units @ $200 per unit Sales, January 30                                                                     140 units @ $200 per unit 1,115                                          (1,115 x...
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                           &n
The following pertain to the cost of H’s only inventory item: Inventory on hand, January 1                                                10 units @ $  9 per unit Purchases, January 2                                                             150 units @ $14 per unit Purchases, January 12                                                         195 units @ $15 per unit Purchases, January 16                                                           75 units @ $15 per unit Purchases, January 20                                                            50 units @ $16 per unit Purchases, January 26                                                          205 units @ $19 per unit 685 Sales during January totaled 615 units. Each unit sold for $40. Calculate COGS AND GP for January AND...
The following data concerns inventory and purchases at Muse Company. Inventory, January 1 92 units at...
The following data concerns inventory and purchases at Muse Company. Inventory, January 1 92 units at $105 Purchases: January 6 62 units at $104 January 15 47 units at $104 January 22 37 units at $98 Inventory, January 31 91 units Determine the cost of the ending inventory on January 31 under the average cost method. Determine the cost of the ending inventory on January 31 under the first in, first out (FIFO) method. Determine the cost of the ending...
Question The following data pertain to the operations of a manufacturing company for the year 2018...
Question The following data pertain to the operations of a manufacturing company for the year 2018 Item Amount (sh) Sales revenues 1,000,000 Direct materials inventory, Jan 1, 2018 15,000 Direct labour 300,000 Depreciation, plant   60,000 Depreciation, equipment 40,000 Cutting tools used 10,000 Indirect labour 5,000 Factory lighting and power 10,000 Factory supervisor’s salary 50,000 Indirect materials 10,000 Finished goods inventory, Jan 1, 2018 30,000 Work in progress inventory, December 31, 2018 20,000 Office Supplies 10,000 Finished goods inventory, December 31,...
Snow Inc. is a manufacturing company that specializes in snowmobiles. The following data pertain to the...
Snow Inc. is a manufacturing company that specializes in snowmobiles. The following data pertain to the company from its most recent fiscal year: Direct materials inventory, beginning $26,000 Work-in-process inventory, beginning $36,000 Direct materials inventory, ending $32,000 Work-in-process inventory, ending $28,000 Purchases of direct materials $76,000 Direct labor $83,000 Insurance on plant $8,500 Maintenance on plant equipment $12,900 Repairs and maintenance - plant $4,000 Marketing expenses $50,000 General and administrative expenses $26,500 What are the total manufacturing costs for this...
The following data pertain to Marseilles Labs: Sales Sales $1,120,000 Cost of Sales $784,000 Inventory $110,000...
The following data pertain to Marseilles Labs: Sales Sales $1,120,000 Cost of Sales $784,000 Inventory $110,000 Accounts receivable $73,000 Accounts payable $41,000 Compute the additional working capital period. Assume a 365 day year for calculations. 55.9 51.2 23.8 19.1
The following data pertain to the Northwest Co." Material inventory, 1/1/19 $20,000 Material inventory, 12/31/19. 30,000...
The following data pertain to the Northwest Co." Material inventory, 1/1/19 $20,000 Material inventory, 12/31/19. 30,000 Material purchases. 140,000 work in process inventory, 1/1/19. 40,000 work in process inventory, 12/31/19. 34,500 direct labor. 162,000 manufacturing overhead. 143,000 finished goods inventory, 1/1/19. 90,000 finished goods inventory, 12/31/19. 74,000 Cost of goods sold should be: A. $456,500 B. $326,500 C. $486,500 D. $530,500
The following direct materials and direct labor data pertain to the operations of Laurel Company for...
The following direct materials and direct labor data pertain to the operations of Laurel Company for the month of August. Costs Actual labor rate $15 per hour Actual materials price $190 per ton Standard labor rate $14.50 per hour Standard materials price $193 per ton Quantities Actual hours incurred and used 4,600 hours Actual quantity of materials purchased and used 1,700 tons Standard hours used 4,650 hours Standard quantity of materials used 1,680 tons Compute the total, price, and quantity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT