Question

In: Accounting

Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales...

Given the following information:

Beginning Inventory

$ 52,000

Ending Inventory

20,800

Sales

214,400

Purchases

69,600

Sales Returns and Allowances

3,600

Purchase Discounts

2,400

Transportation-In

4,400

Purchase Returns and Allowances

3,600

Sales Discounts

1,920


Required:
a.     Determine net sales
b.     Determine net cost of purchases
c.     Determine gross margin
d.     Determine cost of goods available for sale
e.     Determine cost of goods sold

(Show your work for each calculation labeling each amount included.)

Solutions

Expert Solution

Solution: A
Calculation of Net Sales
Sales $             214,400
Less: Sales Returns and Allowances $                 3,600
Less: Sales Discounts $                 1,920
Net Sales $             208,880
Solution: B
Calculation of Net Cost of Purchases
Purchases $               69,600
Add: Transprtation - in $                 4,400
Less: Purchase Discount $                 2,400
Less: Purchase Returns and Allowances $                 3,600
Net Cost of Purchases Purchases $               68,000
Solution: C , D & E
Calculation of Gross Margin ,COGS & Cost of goods available for sale
Amount Amount
Net Sales $            208,880
Less: Cost of Goods Sold
Beginning inventory $               52,000
Add: Net Purchases $               68,000
Total Goods Available for Sale $             120,000
Less: Ending Inventory $               20,800
Cost of goods Sold $              99,200
Gross Margin $            109,680
Gross Margin % =Gross Margin / Net Sales 52.51%

Related Solutions

1) Calculate the missing amounts for each company. Sales Revenue Beginning Inventory Inventory Purchases Ending Inventory...
1) Calculate the missing amounts for each company. Sales Revenue Beginning Inventory Inventory Purchases Ending Inventory COGS Gross Profit Company 1 $100,000 $20,000 $65,000 $22,000 A B Company 2 $140,000 $25,000 C $30,000 D $45,000 Company 3 E F $45,000 $20,000 $50,000 $35,000 Company 4 $85,000 $10,000 $30,000 G $35,000 H
Given Information: As of December 31, 20## Beginning Ending Finished Goods Inventory              99,500        122,500 Sales &nbsp
Given Information: As of December 31, 20## Beginning Ending Finished Goods Inventory              99,500        122,500 Sales       1,750,000 Work In Process Inventory              22,000           23,500 Property Taxes (Factory)              24,000 Factory Utilities              32,000 Direct Material Used        155,000 Amortization (80 % Factory)              45,000 Direct Manufacturing Labour        400,500 Selling and Admin Expense           120,250 InDirect Manufacturing Labour           75,000 Admin Salaries           182,750 Prepare a Cost of Goods Manufactured Statement Along with an income Statement.
When calculating ending inventory under a periodic inventory, you are provided this information: Purchases $88,000; Beginning...
When calculating ending inventory under a periodic inventory, you are provided this information: Purchases $88,000; Beginning Inventory $4,000; Sales Revenue $125,000; physical count of Ending Inventory $7,500. Which of the following is true? Question 23 options: The journal entry to record the ending inventory is Debit Inventory $3,500, Credit Cost of Goods Sold $3,500 Debit Cost of Goods Sold $92,000, Credit Inventory $4,000 and Credit Purchases $88,000 Both a. and b. Neither a. nor b.
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000...
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000 5,000 Cost of goods sold (b)______ 60,000 Gross profit 65,000 (f)______ Operating expenses (c)______ (g)_______ Income before taxes (d)______ 40,000 Income tax expense (30%) 14,100 (h)_______ Net income (loss) 32,900 (i)________ Can you add your work for each missing blank please! Required: Fill in the blanks for the missing data.
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods...
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods Sold Inventory Event Unit Cost Total Cost Unit Cost Total Cost Total Cost QTY Bought Qty sold Qty Unit Cost Beginning Inventory 150 755 First Sale 120 First Purchase 400 785 Second Sale 200 Second Purchase 300 805 Sale 290 The firm uses the perpetual inventory system and there are 240 units of the item on hand at the end of the year A....
beginning inventory, purchases and sales data for the month of august are as follows beginning inventory...
beginning inventory, purchases and sales data for the month of august are as follows beginning inventory 10 units @ 25 august 5 sale 5 units august 10 purchase 18 units @ 27 august 12 sale 13 units August 27 purchase 10 units @ 30 assuming the business maintains a perpetual inventory system, calculate the cost of goods sold and Ending inventory using FIFO, LIFO , Weighted Average
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows:
PR 6-1A FIFO perpetual inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: PR 6-3A Weighted average cost method with perpetual inventoryThe beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are shown in Problem 6-1A. Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted...
The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:
FIFO Perpetual InventoryThe beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:DateTransactionNumberof UnitsPer UnitTotalApr. 3Inventory48$450$21,6008Purchase9654051,84011Sale641,50096,00030Sale401,50060,000May 8Purchase8060048,00010Sale481,50072,00019Sale241,50036,00028Purchase8066052,800June 5Sale481,57575,60016Sale641,575100,80021Purchase144720103,68028Sale721,575113,400Required:Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of...
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle =   days Cash Cycle =  days
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables = 6825 Beginning Payables = 8304 Ending Payables = 8758 Credit Sales = 91199 Cost of Goods Sold = 73243 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT