In: Accounting
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.
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 |
Related SolutionsThe 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...
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....
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
April (actual)
7,500
$
1,200,000
May (actual)
3,000
480,000
June (budgeted)
6,500
1,040,000
July (budgeted)
6,000
960,000
August (budgeted)
4,200
672,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. The...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|