Company
1. Albin Calculate net sale's for the year Date 31-Mar-05 Sales Less: sales discounts Less: sales returns and allowances Net Sales: 2. Cost of merchandise purchased Date 31-Mar-05 Invoice cost of merchandise purchased Purchase discounts received Purchase returns and allowances Costs of transporation in Total cost of merchandise purchases: $136,500.00 $(2,850.00) $(6,600.00) $5,850.00 $132,900.00 $318,000.00 $(4,875.00) $(21,000.00) $292,125.00
ALBIN COMPANY INCOME STATEMENT Journal Entries FOR THE YEAR ENDED MARCH 31, 2005 Month Date Account Titles and Explanation Mar 31 Sales Less: Sales discounts Sales returns and allowances Net sales: Costs of goods sold Gross profit Expenses: Selling expenses Sales salaries expense Rent expense -Selling space Store supplies expense Avertising expense Total selling expense General and administrative expense Office salaries expense Rent expense - Office space Office supplies expense Total general and administrative expenses Total expenses: Net income
Debit $4,875.00 $21,000.00
Credit $318,000.00 $25,875.00 $292,125.00 $123,900.00 $168,225.00
$43,500.00 $15,000.00 $3,750.00 $27,000.00 $89,250.00 $39,750.00 $3,900.00 $1,200.00 $44,850.00 $134,100.00 $34,125.00
ALBIN COMPANY INCOME STATEMENT Journal Entries FOR THE YEAR ENDED MARCH 31, 2005 Month Date Account Titles and Explanation Mar 31 Net sales Expenses: Costs of goods sold Selling expenses General and administrative expense Total expenses: Net income
Debit $123,900.00 $89,250.00 $44,850.00
Credit $292,125.00
$258,000.00 $34,125.00
1. Use the retail inventory mehtod to estimate the company's year-end inventory NILSON COMPANY Estimated Inventory Journal Entries 31-Dec Month Date Account Titles and Explanation Dec 31 Beginning inventory Cost of goods purchased Goods available for sale Sales: Less: sales returns Net sales Ending inventory at retail Cost to retail ratio: Ending inventory at cost: 52% $912,808.00
At Cost $471,350.00 $3,276,030.00 $3,747,380.00
At Retail $927,150.00 $6,279,350.00 $7,206,500.00 $5,495,700.00 $(44,600.00) $5,451,100.00 $1,755,400.00
2. Prepare a calculation showing the company's loss from shrinkage at cost and at retail NILSON COMPANY Inventory Shrinkage Journal Entries 31-Dec Month Date Account Titles and Explanation Dec 31 Estimated inventory Physical inventory: Inventory shortage:
At Cost $912,808.00 $871,416.00 $41,392.00
At Retail $1,755,400.00 $1,675,800.00 $79,600.00
1. Use the gross profit method to estimate the company's first-quarter ending inventory WAYMAN COMPANY Estimated Inventory 31-Mar Account Titles and Explanation 1 Beginning inventory Cost of goods purchased Goods available for sale Less estimated cost of goods sold Sales Less sales returns Net sales Estimated cost of goods sold Estimated March 31 inventory
Journal Entries Month Date Jan
Debit $300,260.00 $939,050.00 $1,239,310.00
Credit
$1,191,150.00 $1,181,700.00 $(9,450.00) $768,105.00 $471,205.00
Venus Company
1. Compute cost of goods available for sale & units available for sale Date Beginning Inventory
600 units @ $55 10-Jan-05 450 units @ $56 13-Feb-05 200 units @ $57 21-Jul-05 230 units @ $58 5-Aug-05 345 units @ $59 Units available 1,825 Costs of goods available for sale
$33,000.00 $25,200.00 $11,400.00 $13,340.00 $20,355.00 $103,295.00
2. Compute the number of units in ending inventory Date Units available Less: units sold Ending inventory 1825 765 1060
3A. FIFO Perpetual Date 1-Jan 10-Jan 450@$56=$25,200 13-Feb 250@$57=$11,400 15-Feb 430@$55=$23,650 Goods Purchased Cost of Goods Sold Inventory Balance 600@$55.00 =$33000 600@$55.00 450@$56.00 =$58,200 600@$55.00 450@$56.00 200@$57.00 =$69,600 170@$55.00 450@$56.00 200@$57.00 =$45,950 170@$55.00 450@$56.00 200@$57.00 230@$58.00 =$59,290 170@$55.00 450@$56.00 200@$57.00 230@$58.00 =$79,645 345@$59.00 285@$56.00 200@$57.00 230@$58.00 345@$59.00 =$61,055
21-Jul 230@$58=$13,340
5-Aug 345@$59=$20,355 170@$55.00 165@$56.00 =$18,590 =$42,240
10-Aug 3B. LIFO Perpetual Date 1-Jan 10-Jan 450@$56=$25,200 13-Feb 250@$57=$11,400 15-Feb 21-Jul 230@$58=$13,340
Goods Purchased Cost of Goods Sold
Inventory Balance 600@$55.00 =$33000 600@$55.00 450@$56.00 =$58,200 600@$55.00 450@$56.00 200@$57.00 =$69,600 600@$55.00 200@$56.00 600@$55.00 200@$56.00 230@$58.00 600@$55.00 200@$56.00 230@$58.00 345@$59.00 600@$55.00 200@$56.00 230@$58.00 10@$59.00 =$45,320 =$58,660
200@$57.00 230@$56.00 =$24,280
5-Aug 345@$59=$20,355
=$79,015
10-Aug
335@$59=$19,765 =$44,045
=$59,250
3C. Specific Identification Date Costs of goods available for sale Less: Cost of goods sold 600@$55.00 165@$57.00 765 Cost of goods sold Ending Inventory $103,295.00 $33,000.00 $9,405.00 $42,405.00 $60,890.00
3D. Weighted Average Perpetual Date 1-Jan 10-Jan 450@$56=$25,200 Goods Purchased Cost of Goods Sold Inventory Balance 600@$55.00 =$33000 600@$55.00 450@$56.00 average cost is $55.43 =$58,200 600@$55.00 450@$56.00 200@$57.00 average cost is $55.68 =$69,600 =$45,658 =$58,998
13-Feb 250@$57=$11,400 15-Feb 430@$55.68
=$23,942 820@$55.68 820@$55.68 230@$58.00 21-Jul 230@$58=$13,340 average cost is $56.19 820@$55.68 230@$58.00 345@$59.00 5-Aug 345@$59=$20,355 average cost is $56.88 10-Aug 335@$56.88=$19,055 1,060@$56.88 =$42,997 4. Compute gross profit earned by the company for each of the 4 costing methods in part 3 FIFO Sales (765 x $90) Less: Cost of goods sold Gross Profit $68,850.00 $42,240.00 $26,610.00 LIFO $68,850.00 $44,045.00 $24,805.00
=$79,353 =$60,293
Spec. ID Weighted Average $68,850.00 $68,850.00 $42,405.00 $42,997.00 $26,445.00 $25,853.00
5. Which method of inventory costing will the manager likely prefer? I think that the manager of the Venus Company will prefer the FIFO method. The FIFO method looks like it will yield the largest gross profit.