Question

2. The Precision Door Company sold 2,200 doors during 2018 at $160 per door. Its beginning inventory on January 1 was 130 doors at $56. Purchases made during the year were as follows:

February 225 doors at $62

April 350 doors at $65

June 700 doors at $70

August 300 doors at $66

October 400 doors at $68

November 250 doors at $72

Compute the COGS and Ending Inventory under each of the following inventory cost flow assumptions: (a) Simple Weighted Average, (b) FIFO, (c) LIFO.

Answer 1

		The Precision Door Company
		Unit	Unit Cost	Total Cost
	Beginning Inventory on Januay 1	130	$            56.00	$                             7,280.00
	February	225	$            62.00	$                          13,950.00
	April	350	$            65.00	$                          22,750.00
	June	700	$            70.00	$                          49,000.00
	August	300	$            66.00	$                          19,800.00
	October	400	$            68.00	$                          27,200.00
	November	250	$            72.00	$                          18,000.00
	Total	2355		$                       1,57,980.00
	Closing Inventory(2355-2200)	155
	Unit Price=	Total cost/Total Units
	Unit Price=	($157980/2355)
	Unit Price=	$                                        67.08
a)	Simple Weighted Average Inventory
	Ending Inventory(Units)=(A)	155
	Price per unit=(B)	$                                        67.08
	Ending Inventory Price=(A)*(B)	$                                10,397.83
	Cost of goods available for sales	$                            1,57,980.00
	Less: Ending Inventory	$                                10,397.83
	Cost of goods sold(2355*$67.08)	$                            1,47,582.17
	Simple Weighted average: Weight are taken for all purchases including beginning inventory to caluclated unit price.
	FIFO Ending Inventory
b)		Units	Rate	Total cost
	November	155	$            72.00	$                          11,160.00
	Total	155		$                          11,160.00
	FIFO -Cost of goods sold
	Cost of goods available for sales	$                            1,57,980.00
	Less: Ending Inventory	$                              -11,160.00
	Cost of goods sold	$                            1,46,820.00
	FIFO Method: First in first out,it means units which are purchased first are sold first.
	LIFO Ending Inventory
c)		Units	Rate	Total cost
	Beginning Inventory	130	$            56.00	$                             7,280.00
	February	25	$            62.00	$                             1,550.00
	Total	155		$                             8,830.00
	LIFO-Cost of goods sold
	Cost of goods available for sales	$                            1,57,980.00
	Less: Ending Inventory	$                                 -8,830.00
	Cost of goods sold	$                            1,49,150.00
	LIFO Method: Last in first out ,it means inventory which are purchased last,sold first.
		Simple weighted Average	FIFO	LIFO
	Ending Inventory	ekkarill92 Next > < Previous Related Solutions The Company P produces doors and windows. The company produces 4 windows per door. In each... The Company P produces doors and windows. The company produces 4 windows per door. In each window the company uses half an hour of direct labor and for each door uses one hour. The prime costs of making doors are $ 20 and $ 16 for the windows. Labor represents 60% of the prime costs. The indirect costs estimated for this production total $ 330,000. The company distributes indirect costs through the use of machine hours. The labor cost used... During April, Wiggins Company sold 900 units of Product X for $10 per unit.  Its beginning inventory,... During April, Wiggins Company sold 900 units of Product X for $10 per unit.  Its beginning inventory, purchases, and sales during the month were as follows: April   1          Beginning Inventory   200 units @ $1             5          Purchases                    200 units @ $2             8          Sales                            300 units             10        Purchases                    200 units @ $3             15        Purchases                    200 units @ $4             18        Sales                            300 units             20        Purchases                    200 units @ $5             25        Purchases                    200 units @ $6             28        Sales                            300 units Compute the proper cost to be assigned to ending inventory, cost of goods sold, and gross profit under each of these methods using the... Thompson Garage Doors is a company that installs automatic garage door openers. It charges an average... Thompson Garage Doors is a company that installs automatic garage door openers. It charges an average price of $500 per installation. Variable costsexcluding wages for workers amount to $200 per installation. In addition, you are given the following information about the productivity of the workers: Number of Workers Installations per Week Marginal Product Net Marginal Revenue Product 1 5 2 13 3 18 4 22 5 25 6 27 7 28           a)Complete the table. b)If each worker receives $1400... Violins Galore produces? student-grade violins for beginning violin students. The company produced 2,200 violins in its... Violins Galore produces? student-grade violins for beginning violin students. The company produced 2,200 violins in its first month of operations. At? month-end, 550 finished violins remained unsold. There was no inventory in work in process. Violins were sold for $117.50 each. Total costs from the month are as? follows: Direct materials used $94,800 Direct labor $60,000 Variable manufacturing overhead $30,000 Fixed manufacturing overhead $41,800 Variable selling and administrative expenses $7,000 Fixed selling and administrative expenses $13,700 1a. Total expenses shown... Violins Galore produces? student-grade violins for beginning violin students. The company produced 2,200 violins in its... Violins Galore produces? student-grade violins for beginning violin students. The company produced 2,200 violins in its first month of operations. At? month-end, 550 finished violins remained unsold. There was no inventory in work in process. Violins were sold for $117.50 each. Total costs from the month are as? follows: Compute the following amounts that would be shown on these income? statements: 1. Gross Profit 2. Contribution Margin 3. Total expenses shown below the gross profit line 4. Total expenses shown... 3. Fifer Company produces two types of entry doors: the Hollow Core and the Solid Door... 3. Fifer Company produces two types of entry doors: the Hollow Core and the Solid Door models. The Company has used direct labor dollars to allocate the overhead cost $47,450,000. The company’s CFO, Brian Smythe , has offered the following information regarding the two products: Hollow Core       Solid Door Sales in units      400,000        50,000 Sales price per unit          $475.00                 $650.00 Direct materials per unit               55.00     130.00 Direct labor cost per unit              75.00     50.00 The company has hired you... 2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801... 2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801 Other expenses 170 140 Interest 137 158 Cash 1,075 1,099 Accounts receivable 1,423 1,603 Short-term notes payable 208 195 Long-term debt 3,600 4,200 Net fixed assets 9,015 9,230 Accounts payable 1,129 1,095 Inventory 2,530 2,600 Dividends 250 ? Common Shares 1,000 Tax rate 40% 40% 2017 2018 Sales $        2,050 $ 2,200 Depreciation 295 295 Cost of goods sold 705 801 Other expenses 170... Steve Company buys and sells one product. Its beginning inventory, purchases, and sales during calendar-year 2018... Steve Company buys and sells one product. Its beginning inventory, purchases, and sales during calendar-year 2018 follow. Date                                     Units Acquired at Cost                                         Sold at Retail     Jan.     1 Beg. inventory    400 units @ $14  =  $  5,600                 Jan.  15                                                                                     Sale                   200 units @ $30             Mar. 10 Purchase             200 units @ $15  =  $  3,000                 Apr.   1                                                                                      Sale                        200 units @ $30 May   9 Purchase              300 units @ $16  =  $  4,800                 Sep. 22 Purchase              250 units @ $20  =  $  5,000                 Nov.   1                                                                                      Sale                 300 units @ $35             Nov. 28 Purchase             100 units @ $21  =  $  2,100                          Totals Units Available for Sale 1,250 units =  $20,500                       Total Units Sold 700 units          Additional tracking data for... Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units... Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 5,000 $ 800,000 May (actual) 2,000 320,000 June (budgeted) 4,500 720,000 July (budgeted) 3,500 719,000 August (budgeted) 3,900 624,000 All sales are on credit. Recent experience shows that 26% of credit sales is collected in the month of the sale, 44% in the month after the sale, 26% in the second month after the sale, and 4% proves to be uncollectible.... Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units... Aztec Company sells its product for $160 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 3,500 $ 560,000 May (actual) 2,000 320,000 June (budgeted) 5,000 800,000 July (budgeted) 4,000 799,000 August (budgeted) 4,100 656,000 All sales are on credit. Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 25% in the second month after the sale, and 5% proves to be uncollectible.... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Samsung Industry that requires you to act as a change agent to form an organizational change... Use fork() Create a program that reads characters from an input file. Use fork to create... A pension fund manager is considering three mutual funds. The first is a stock fund, the... Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not... During his project presentation, Bob falls sick and performs poorly. However, his colleague, Dan, concludes that... A sample human input file that contains test values that a human would enter on the... A solution is prepared by dissolving 15 ml of methanol in 150.0 ml water at 25... ADVERTISEMENT About @ 2020 WizEdu