Question

In: Accounting

Rabin Ltd uses a perpetual FIFO inventory system and has compiled the following cost information for...

Rabin Ltd uses a perpetual FIFO inventory system and has compiled the following cost information for the year ended December 31, 2017. Opening inventory consisted of 100 units. The cost per unit of opening inventory is $100 DM, $60 DL and $110 MOH (of which 20% is variable). Robin produced 1,400 units and sold 1,250 units during 2017. The selling price per unit is $320.

Direct materials $135,000
Wages for assembly workers   104,000
Utilities on factory (of which 25,000 is fixed)    68,000
Factory supervisor salary    50,000
Bookkeeper salary    35,000
Office rent    60,000
Amortization of factory and equipment    45,000

Answer the following for the year ended December 31, 2017 (round your answer to the nearest unit or dollar and use the rounded answer for subsequent calculations):
(a) How many units are left in ending inventory at December 31, 2017? units

(b) What is the cost per unit in ending inventory under:

                    absorption costing $/ unit?

                    variable costing $/ unit?

                    throughput costing $/ unit?

(c) Calculate the total cost of opening inventory using:

                    absorption costing $?

                    variable costing $?

                    throughput costing $?

(d) Calculate: gross profit $?

                     contribution margin $?

                     throughput margin $?

(e) Net income will be greatest under which costing method? Absorption costing or Variable costing

(f) Net income will be lowest under which costing method? Absorption costing or Variable costing

Solutions

Expert Solution

a) Opening Inventory Units 100
Units Produced 1400
Units available for sale 1500
Units Sold 1250
Ending Inventory Units 250
b) Absorption Costing
Direct Material                         135,000
Wages                         104,000
Utilities on Factory                           68,000
Factory Supervisor Salary                           50,000
Amortisation of Factory and Equipment                           45,000
Total Cost                         402,000
Units produced                              1,400
Cost per unit                                 287
Total Cost on Ending Inventory                           71,786
Variable Costing
Direct Material                         135,000
Wages                         104,000
Variable Utilities on Factory (68000-25000)                           43,000
Total Cost                         282,000
Units Produced                              1,400
Cost per unit                                 201
Total Cost on Ending Inventory                           50,357
Throughput costing
Direct Material                         135,000
Units Produced                              1,400
Cost per unit                                    96
Total Cost on Ending Inventory                           24,107
c) Absorption Costing Per unit Total Cost
Direct Material            100 10000
Wages               60 6000
MOH            110 11000
Total Cost of Opening Inventory 27000
Variable Costing Per unit Total Cost
Direct Material            100 10000
Wages               60 6000
Variable MOH (20% of 110)               22 2200
Total Cost of Opening Inventory 18200
Throughput Costing Per unit Total Cost
Direct Material            100 10000
Total Cost of Opening Inventory 10000
d) Absorption Costing
Sales            400,000
COGS          357,214
(27000+402000-71786)
Gross Profit            42,786
Variable Costing
Sales            400,000
Variable Cost          249,843
(18200+282000-50357)
Contribution Margin          150,157
Throughput Margin
Sales          400,000
Variable Cost          120,893
(10000+135000-24107)
Throughput Margin          279,107

(e)

e) Absorption Costing
Sales 400000
COGS 357214
Gross Profit 42786
Bookkeeper Salary 35000
Office rent 60000
Net Income -52214
Variable Costing
Sales   400000
Variable Cost 249843
Contribution 150157
Fixed Utilties 25000
Factory Supervisor Salary 50000
Bookkeeper Salary 35000
Office rent 60000
Amortisation 45000
Net Income -64843

Net Income will be greatest under absorption costing. This is because under absorption costing, some cost of fixed manufacturing cost is deferred to next period. It forma part of the cost of inventory.

Net Income will be lowest under variable costing as all fixed cost for the period is booked in the same period.

If you also consider throughput costing also, then net income under throughput costing will be the lowest because only direct materials are considered while valuing inventory. Direct labour and variable cost is debited to profit and loss in the same period as it is incurred instead of deferring the cost to the extent of ending inventory to next period.


Related Solutions

McMillan Company uses the periodic inventory system. It has compiled the following information in order to...
McMillan Company uses the periodic inventory system. It has compiled the following information in order to prepare the financial statements at December 31, 2014: Gross sales during 2014 $2,000,000 Sales returns and allowances during 2014 50,000 Begining inventory, January 1, 2014 100,000 Ending inventory, December 31, 2014 120,000 Purchases during 2014 750,000 Required: Calculate each of the following: A. Cost of goods available for sale B. Cost of goods sold C. Gross profit
Blue Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June...
Blue Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June 1, of 490 bookcases at a cost of $130 each. During June, the company had the following purchases and sales of bookcases: Purchases Sales Date Units Unit cost Units Unit price June 6 1,200 $132 10 1,030 $204 14 1,770 133 16 1,670 209 26 960 134 (a) Determine the cost of goods sold and the cost of the ending inventory using the average...
Bramble Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June...
Bramble Furniture Ltd. uses a perpetual inventory system and has a beginning inventory, as at June 1, of 520 bookcases at a cost of $125 each. During June, the company had the following purchases and sales of bookcases: Purchases Sales Date Units Unit cost Units Unit price June 6 1,170 $127 10 950 $216 14 1,750 128 16 1,600 221 26 1,040 129 (a) Correct answer iconYour answer is correct. Determine the cost of goods sold and the cost of...
Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month...
Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Explanation Units Unit Cost Total Cost June 1 Beginning inventory 1,390 $4 $5,560.00 12 Purchases 2,230 5 11,150 15 Sale (2,640 ) 16 Purchases 4,580 6 27,480 23 Purchases 1,640 7 11,480 27 Sales (5,460 ) Part 1 Determine the cost of goods sold and the cost of the ending inventory using (1) FIFO and (2) Average cost. (Round average final...
Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month...
Ayayai Ltd. uses the perpetual inventory system and reports the following inventory transactions for the month of June: Date Explanation Units Unit Cost/Price Total Cost June 1 Beginning inventory 1,480 $5 $7,400 12 Purchases 2,340 6 14,040 15 Sale (2,420 ) 12 16 Purchases 4,280 7 29,960 23 Purchases 1,580 8 12,640 27 Sales (5,580 ) 15 alculate the gross profit for the month of June using (1) FIFO and (2) average cost. (Round average final answers to 2 decimal...
The following transactions occurred during 2020 (the company uses a perpetual inventory system with FIFO): 1)...
The following transactions occurred during 2020 (the company uses a perpetual inventory system with FIFO): 1) Jan 4 Stockholders invested an additional $10,000 cash in the business in exchange for common stock 2) Jan 4 Purchased 20 rabbits at $50 each on account from Jelly Bean Farms. 3) Jan 4 Established a $200 petty change fund 4) Jan 5 Sold 6 rabbits for $200 each to Mr. Karrot, terms 2/10, n/30. 5) Jan 6 Sold 12 rabbits at $200 each...
A corporation uses a FIFO perpetual inventory system. During August, it had the following transactions: August...
A corporation uses a FIFO perpetual inventory system. During August, it had the following transactions: August 1, Beginning inventory of 8 units @ $11 per unit August 2, 25 units were purchased at $12 per unit. August 15, 12 units were sold at $25 per unit. August 18, 15 units were purchased at $14 per unit. August 20. 18 units were sold at $25 per unit August 28. 14 units were sold at $26 per unit What was the amount...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the month of september: Sep. 1 Inventory 24 units at $15          5 sold 17 units         17 Purchased 10 units at $20          30 sold 8 units If Addison uses LIFO, the cost of the ending inventory on September 30 is a. $160 b.$125 c. $180 d. $145 Please help! I don't understand. Due at 11:59 p.m. Thanks!
A company that uses the PERPETUAL inventory system has the following records for 2017 Beginging inventory...
A company that uses the PERPETUAL inventory system has the following records for 2017 Beginging inventory Units Unit cost Purcahses: 120 $48 Febuary 8th 60 52 June 15th 70 54 22-Aug 55 57 Novemeber 29 45 61 Salkes: 30-Mar 145 20-Jul 90 December 15th 60 Please compute the cost of ending inventory and the cost of goods sold using the follow methods: Please also show all steps/work A) FIFO B) Weighted Average c) LIFO
Compute cost of goods sold, assuming Kingbird uses: 1.Perpetual system, FIFO cost flow 2.Perpetual system, LIFO...
Compute cost of goods sold, assuming Kingbird uses: 1.Perpetual system, FIFO cost flow 2.Perpetual system, LIFO cost flow 3. Perpetual system, moving-average cost flow Kingbird Company is a multi product firm. Presented below is information concerning one of its products, the Hawkeye. Date Transaction Quantity Price/Cost 1/1 Beginning inventory 3,500 $19 2/4 Purchase 4,500 28 2/20 Sale 5,000 47 4/2 Purchase 5,500 36 11/4 Sale 4,700 52   
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT