Question

The following transactions occurred for the month of May. Date    Units Cost Total Sales Price...

The following transactions occurred for the month of May.

Date    Units Cost Total Sales Price
1-May Beginning Balance 70 15 $1,050
2-May Purchase 75 11 $825
3-May Purchase 85 12 $1,020
10-May Sale 150 $35
15-May Purchase 40 18 $720
17-May Sale 50 $35
30-May Sale 40 $35

Create a perpetual inventory record then calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO

Purchases Cost of Goods Sold Inventory on Hand
Dates Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
May 1
May 2
May 3
May 10
May 15
May 17
May 30

End of the month totals

Cost of Goods Sold $
Ending Inventory $
Gross Profit $

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following transactions occurred for the month of May. Date Units Cost Total Sales Price 1-May...
The following transactions occurred for the month of May. Date Units Cost Total Sales Price 1-May Beginning Balance 80 14 $1,120 2-May Purchase 65 13 $845 3-May Purchase 85 16 $1,360 10-May Sale 130 $30 15-May Purchase 45 19 $855 17-May Sale 55 $30 30-May Sale 85 $30 Create a perpetual inventory record then calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 60 $300 $18,000 8 Purchase 120 360 43,200 11 Sale 80 1,000 80,000 30 Sale 50 1,000 50,000 May 8 Purchase 100 400 40,000 10 Sale 60 1,000 60,000 19 Sale 30 1,000 30,000 28 Purchase 100 440 44,000 June 5 Sale 60 1,050 63,000...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 72 $300 $21,600 8 Purchase 144 360 51,840 11 Sale 96 1,000 96,000 30 Sale 60 1,000 60,000 May 8 Purchase 120 400 48,000 10 Sale 72 1,000 72,000 19 Sale 36 1,000 36,000 28 Purchase 120 440 52,800 June 5 Sale 72 1,050...
These are the inventory transactions for a start up business. Date Type Units Unit Cost 01/07/17...
These are the inventory transactions for a start up business. Date Type Units Unit Cost 01/07/17 Purchase 100 50 15/07/17 Sale 40 31/07/17 Purchase 25 60 15/08/17 Sale 70 Do not use punctuation in numerical answers. Calculate Cost of Goods Sold using periodic average cost: Answer Calculate Closing inventory using periodic FIFO: Answer B) Given: Please note this information is used for the next three questions. Do not use punctuation or symbols in your answers. Opening Inventory 44476 Net Purchases...
Requirement 1. Requiremen Compute cost of goods sold and gross profit using the FIFO inventory costing...
Requirement 1. Requiremen Compute cost of goods sold and gross profit using the FIFO inventory costing method. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the...
The following inventory transactions took place for Crane Corporation for the month of May: Date Event...
The following inventory transactions took place for Crane Corporation for the month of May: Date Event Quantity Cost/ Selling Price May 1 beginning inventory 2,060 $3.30 May 5 purchase 5,320 3.50 May 10 purchase 3,900 3.60 May 15 sale 5,900 6.50 May 20 sale 1,970 6.50 May 22 purchase 4,130 3.80 May 24 purchase 2,020 3.80 May 25 sale 5,980 6.50 Calculate the ending inventory balance for Crane Corporation, assuming the company uses a periodic inventory system and the weighted...
Buffalo Industries reports the following for the month of June. Date Explanation Units Unit Cost Total...
Buffalo Industries reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 131 $5 $655 12 Purchases 359 6 2,154 23 Purchases 195 7 1,365 30 Inventory 267 A sale of 371 units occurred on June 15 for a selling price of $8 and a sale of 47 units on June 27 for $9. Calculate the average cost per unit, using a perpetual inventory system. (Round answers to 3 decimal places, e.g....
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period...
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Transaction Number of Units Per Unit Total Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1,912,500 28 Sale 11,250 150.00 1,687,500 30 Sale 3,750 150.00 562,500 Feb. 5 Sale 1,500 150.00 225,000 10 Purchase 54,000 87.50 4,725,000 16 Sale 27,000 160.00 4,320,000 28 Sale 25,500 160.00 4,080,000 Mar. 5 Purchase 45,000 89.50 4,027,500 14 Sale...
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of...
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of June 2018:   Date Transactions Units Cost per Unit Total Cost   June 1 Beginning inventory 17     $240     $ 4,080        June 7 Sale 12       June 12 Purchase 13     230     2,990        June 15 Sale 11       June 24 Purchase 14     220     3,080        June 27 Sale 15       June 29 Purchase 8     210     1,680      $11,830...
Crane Company reports the following for the month of June. Units Unit Cost Total Cost June...
Crane Company reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 200 $4 $ 800 12 Purchase 400 5 2,000 23 Purchase 400 6 2,400 30 Inventory 100 Calulate Weighted Average Unit Cost. (Round answer to 2 decimal places, e.g. 15.25.) Weighted Average Unit Cost $ eTextbook and Media Compute the cost of the ending inventory and the cost of goods sold using the average-cost method. (Round answers to 0 decimal places, e.g....