At the beginning of May, Williams Industries has 200 units of a product with a unit...

At the beginning of May, Williams Industries has 200 units of a product with a unit cost of $500. Its inventory records report the following transactions for the month of May:

	Units	Unit Cost	Total Cost
Beginning Inventory	200	$500	$100,000
Purchase #1	250	$550	137,500
Purchase #2	100	$600	60,000
Purchase #3	60	$650	39,000
Total	610		$336,500

Williams sells 500 units in May.

a) Compute the Cost of Goods Sold (COGS) for May for this product, assuming Hanna uses FIFO, LIFO, and Average Cost inventory methods.

b) Compute the Ending Inventory Balance (EI) for May for this product, assuming Hanna uses FIFO, LIFO, and Average Cost inventory methods.

c) Assume the total revenue is $350,000, what are the Gross Profit Margin under FIFO, LIFO, and Average Cost methods?

Expert Solution

ekkarill92 answered 1 year ago

Botter Company had a beginning inventory of 200 units at a cost of $13 per unit...

Botter Company had a beginning inventory of 200 units at a cost of $13 per unit on August 1. During the month, the following purchases and sales were made. Purchases Sales August 4 250 units at $14 August 7 150 units August 15 350 units at $15 August 11 100 units August 28 200 units at $16 August 17 300 units August 24 200 units Botter uses a periodic inventory system. Instructions Determine ending inventory and cost of goods sold...

Elston Company had a beginning inventory of 200 units at a cost of rm12 per unit...

Elston Company had a beginning inventory of 200 units at a cost of rm12 per unit on August 1. During the month, the following purchases and sales were made. Purchases ______________Sales ________ August 4 250 units at RM13/unit August 7 150 units @ RM20 August 15 350 units at RM15/unit August 11 100 units @ RM20 August 28 200 units at RM14/unit August 17 250 units @ RM25 August 24 260 units @...

A firm has 200 units of a product in inventory. The forecasts of the demands are...

A firm has 200 units of a product in inventory. The forecasts of the demands are 40 units per week. An MPS quantity of 50 units is planned to arrive in period 2. Customer orders are 40 for period 1, 10 for period 2, and 50 for period 3. Present the computation to estimate the projected on-hand inventory at the end of period 3, and the result (for example, 500-400+10=110 units.)

1) Weatherspoon Company has a product with a selling price per unit of $200, the unit...

1) Weatherspoon Company has a product with a selling price per unit of $200, the unit variable cost is $110, and the total monthly fixed costs are $300,000. How much is Weatherspoon’s contribution margin per unit? a. $ 90 b. $110 c. $200 d. $300 2) An Italian bakery on Franklin Avenue in Hartford is famous for its cakes. The bakery sells its cakes for $19.95 to the public. The cost for the ingredients and labor to make the cake...

Bush Industries currently manufactures 56,000 units of a product with the following costs per unit Direct...

Bush Industries currently manufactures 56,000 units of a product with the following costs per unit Direct materials......................................... $6.00 Direct labor.............................................. $18.00 Variable manufacturing overhead............ $9.00 Fixed manufacturing overhead................$12.00 Variable selling..........................................$3.00 Fixed selling..............................................$4.00 The company has the capacity to produce 60,000 units. The product regularly sells for $60. A wholesaler has offered to pay $55 a unit for 5,000 units and will pick up the units, thereby saving Bush the variable selling costs. If the special order is accepted, what would be...

Units Per unit cost Beginning Inventory 200 $ 120.00 $ 24,000.00 30-Jan purchase 130 $ 124.00...

Units Per unit cost Beginning Inventory 200 $ 120.00 $ 24,000.00 30-Jan purchase 130 $ 124.00 $ 16,120.00 12-Mar purchase 220 $ 128.00 $ 28,160.00 Total Sales 350 $ 320.00 $ 112,000.00 Ending Inventory FIFO LIFO Ending Inventory Ending Inventory Goods Available for Sale Goods Available for Sale Deduct ending Inventory Deduct ending Inventory Cost of Goods Sold Cost of Goods Sold Sales Sales Cost of Goods Sold Cost of Goods Sold Gross Profit Gross Profit Operating Expense $ 24,000.00...

The machine produces annual units of 1,000 units. Each unit has sale price of $200 per...

The machine produces annual units of 1,000 units. Each unit has sale price of $200 per unit and cost of $100 per unit. Sale price and cost will increase 3% per year. The tax rate is 25%. If NWCt= 12% * Sale (t+1), what is FCF at year 2? Given the machine is bought at $200,000 with shipping cost of $10,000 and installation cost of $30,000. The machine has economic life of 4 years. Year MACRS 1 33% 2 45%...

Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at...

Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at cost of $20 per unit. During the year, the following purchases were made. Mar. 15 500 units at $21, July 20 313 units at $22 Sept. 4 413 units at $27. Dec. 2. 125 units at $31 1250 units were sold. Sekhon Company uses a periodic inventory system. 1. Determine the cost of good available for sale. 2. Calculate average cost per unit. 3....

Tomlinson Company has the following production data for May: · Beginning Work in Process, 0 units · Units...

Tomlinson Company has the following production data for May: · Beginning Work in Process, 0 units · Units started, 94,000 · Ending Work in Process, 17,000 units that are 100% complete for materials and 50% complete for conversion costs · Unit materials cost, $6 · Unit conversion cost, $12 · Total costs to be assigned, $618,000 Tomlinson uses the FIFO method to calculate equivalent units. Determine the costs to be assigned to the units transferred out and the units in ending Work in Process.

DGT industries expects to sell 420 units of product a and 420 units of product b...

DGT industries expects to sell 420 units of product a and 420 units of product b each day at an average price of $18 for product a and $28 for product b . The expected cost for product a is 42% of its selling price and the expected cost for product b is 58% of its selling price. DGT industries has no beginning inventory but it wants to have a six day supply of ending inventory for each product. Compute...

Question