Question

In: Accounting

This company uses a perpetual inventory system. It had the following beginning inventory and current year...

This company uses a perpetual inventory system. It had the following beginning inventory and current year purchases of its product.

Jan 1. Beginning Inventory ..... 50 units @ $100 = $5,000

Jan 14. Purchase .......................150 units @ $120 = 18,000

Apr 30. Purchase........................ 200 units @ $150= 30,000

Sept 26th. Purchase................... 300 units @ $200= 60,000

The company transacted sales on the following dates at $350 per unit sales price.

Jan 10. 30 units (specific cost: 30 @ $100)

Feb 15. 100 units (specific cost: 100 @ $120)

Oct 5. 350 units (specific cost: 100 @ $150 and 250 @ $200)

USING (THE WEIGHTED AVERAGE COSTING METHOD) ANSWER THE FOLLOWING QUESTIONS:

A. Identify and compute the costs to assign to the units sold. (Round per unit costs to three decimals.)

B. Identify and compute the costs to assign to the units in ending inventory. (Round inventory balances toe the dollar)

C. How likely is it that the Weighted Average method will reflect the actual physical flow of goods? How relevant is that factor in determining wether this is an acceptable method to use?

D. What is the impact of this method versus others in determining net income and income taxes?

E. How closely does the ending inventory amount reflect replacement cost?

Solutions

Expert Solution

  1. Identity and Compute the Costs to assign to the units sold:

The cost of 30 units = 30 x$100 = $3,000 – These units sold from Beginning Inventory

The cost of 100 units sold = 100 units x$120 = $12,000 – These units are sole from the purchase on Jan. 14.

The cost of 350 Units sold = (100 units x$150)+(250 units x$200) = $65,000 – Out of these 350 units, 100 Units are purchased on April 30 and 250 units are purchased on Sept. 26.

2. Identify and compute the costs to assign to the units in ending inventory

Cost of Ending Inventory:     

       From Beginning Inventory     - 20 units x $100 =       $2,000

       From the Purchase on Jan. 14 – 50 units x $120=       $6,000

       From the Purchase on Apr. 30 – 100 units x$150 = $15,000

       From the Purchase on Sept.26-    50 units x $200= $10,000

------------

                The costs of Ending units (220 units)                  $33,000

-------------

3. Continuous stock – taking will make the storekeeper and the stores accountant more vigilant in their work and they will try to keep their record accurate and up-to-date. A detailed and more reliable check on the stores is obtained.

Factor in determining whether this an acceptable method - This system is comprised of the following three:

a.Bin Cards (i.e., Quantitative perpetual inventory)

b.Stores Ledger (Quantitative valued perpetual inventory)

c.Continuous Stock taking ( i e., Physical Perpetual Inventory)

4. Impact of this method in determining net income and income taxes:

        Closing Inventory Value is taking from Bin Cards or Stores Ledger. So, the     

        closing value reflect the actual cost of the closing inventory.

5. Since the ending inventory shows its qty and its value apparently in the bin card.


Related Solutions

During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. C.           Compute gross profit under for a...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out Compute gross profit under for a and b....
Chris Company uses the perpetual inventory system and had the following activity during the current monthly...
Chris Company uses the perpetual inventory system and had the following activity during the current monthly period. November 1:             Beginning Inventory of 100 units @$20 November 5:              Purchased 100 units @ $22 November 8:              Purchased 50 units @$23 November 16:            Sold 200 units @ $45 November 19:            Purchased 50 units @ $25 Using the weighted-average inventory method, the company's ending inventory would be reported at: A)   $2,200. B) $2,320. C) $2,250. D) $2,400. E) $2,270. The answer is B but I need a detailed explanation...
Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for...
Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $12.00 5/5 Purchase 200 $10.50 5/10 Sales 300 $25 5/15 Purchase 200 $13.00 5/20 Sales 250 $28 5/25 Purchase 150 $13.50 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent.
A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory.
  A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory. January 1: Purchased 30 units at SAR11 per unit February 5: Purchased 30 units at SAR 13 per unit March 16: Sold 50 Units for SAR 15 per unit A.Prepare general journal entries to record the March 16 sale using the FIFO inventory valuation method. LIFO inventory valuation method. Weighted average valuation method. B. What is the cost of...
A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory.
  Q1- A company wants to implement good internal control. What are the policies and procedures you can suggest to minimize human frauds and errors? (1Mark) Q2- Assume that you have a company. And the management team estimates that 3% of sales will be uncollectible. Give any amount of sales and prepare the journal entry using the percent of sales method.                                                                                              (1Mark) Q3- A company that uses a perpetual inventory system made the following cash purchases and sales. There was...
A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases...
A company uses a perpetual inventory system. The company's beginning inventory of shoes and the purchases during a month as as follows: Beginning Inventory Jan 1: 16 pairs at $10 ea Purchase Jan 11: 14 pairs @ $12 ea Purchase Jan 20: 23 pairs at $15 ea On Jan 14 the company sold 25 units of shoes. The other 28 units remained in inventory at Jan 31. Question 1: Assuming the company uses the average cost flow assumption what is...
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019....
Walstrom Company uses a perpetual inventory system and had the following inventory transactions for June 2019. June 1 Beg. Inventory 50 units @ $14 for $700, on June 4 Purchased 115 units @ $15 for $1,725, on June 5 Sold 100 units, on June 10 Purchased 75 units @ $16 for $1,200, and on June 24 Sold 50 units. Total Cost of Goods Sold Available equals $3,625. The June 30th Ending Inventory is 90 units. The June 30th ending inventory...
Olaf Corp. uses a perpetual inventory system. The company had the following inventory transactions in April:...
Olaf Corp. uses a perpetual inventory system. The company had the following inventory transactions in April: April 3 Purchased merchandise from Flounder Ltd. for $30,700, terms 1/10, n/30, FOB shipping point. 6 The appropriate company paid freight costs of $660 on the merchandise purchased on April 3. 7 Purchased supplies on account for $5,490. 8 Returned damaged merchandise to Flounder and was given a purchase allowance of $3,700. The merchandise was repaired by Flounder and returned to inventory for future...
Ranns Supply uses a perpetual inventory system. On January 1, its inventory account had a beginning...
Ranns Supply uses a perpetual inventory system. On January 1, its inventory account had a beginning balance of $6,900,000. Ranns engaged in the following transactions during the year. Purchased merchandise inventory for $9,700,000. Generated net sales of $25,000,000. Recorded inventory shrinkage of $10,000 after taking a physical inventory at year-end. Reported gross profit for the year of $15,000,000 in its income statement. a. At what amount was Cost of Goods Sold reported in the company's year-end income statement? b. At...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT