Question

Using your own explained, numerical, practical examples, differentiate between periodic and perpetual inventory systems. You may...

  1. Using your own explained, numerical, practical examples, differentiate between periodic and perpetual inventory systems. You may apply your examples to the case of Dino's After School.
  2. Using your own explained, numerical, practical examples differentiate between LIFO, FIFO, and Weighted Average as forms of inventory valuation.
  3. On April 12, 2017 Dino's After School purchased $6,000 in inventory. Sales began to slow-down, so on May 12 they purchased only $2,000 worth of inventory. In June, with the start of summer when more customers are purchasing their inventory, they purchased $9,000 worth of inventory - June 20, 2017. If they had $4,780 of inventory remaining at the end of the first quarter, and sold $17,500 worth of inventory during the second quarter:
  • What is the ending inventory for Dino's After School at the end of June, 2017?
  • If there was no ending inventory from the first quarter, with the same levels of sales, what would have been the cost of goods sold during the second quarter?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Under periodic inventory system, cost of goods sold and stock in hand is determined using physical counting of inventory. Since, physical counting cannot be done on a regular basis, since entire business is required to be halted and thus periodic stock counting is done and that's why this system of inventory is called periodic inventory system. Also note that this system can be used only in businesses having lower quantity of inventory

In case of perpetual inventory system , inventory accounts are constantly updated as and when any buying or selling it inventory take place. Thus, such a system is generally used when we are having larger quantities of inventory.

Take the example of dino after school if periodic inventory method would have been implemented then we would have physically counted the stock on June 30 and then on the basis of such physical stock taking only we would record cost of goods sold and ending inventory. Whereas if we would be following perpetual inventory system then on puruchase of inventory on Apr 12, may 12 and June 20 we would have e updated all the inventory records on those individual dates.

Under LIFO method, the inventory which is purchased last will be deemed to have sold first whereas in FIFO method , the inventory which is purchased first will be seemed to have sold first, whereas in weighted average method we would average the cost of inventory purchased and accordingly on sale that average cost would be deducted .

Take example of dino after school if LIFO method would have followed then inventory purchased on June 20, would be considered to have been sold in the quarter 2, then inventory purchased on may 12 and then from April 12 and then difference if any from beginning inventoru. Whereas in case FIFO method any sale in quarter 3 will be first assumed to have made from beginning inventory then inventort purchsed in April 12, then may 12, then June 20 balance. Whereas in case of weighted average we would calculate of weighted average of cost of inventory purchsed on different dates and then any sale would be taken out on the basis of that weighted average

Ending inventory for dino's after school at the end of June, 2017 will be as follows :-

Particulars amount
Ending inventory of quarter 1 4780
Inventory purchased on April 12 6000
Inventory purchsed on may 12 2000
Inventory purchsed on June 20, 2017 9000
Total inventory 21780
Less : cost of inventory sold during quarter 2 (17500)
Ending inventory on quarter 2 $4280
Add a comment
Know the answer?
Add Answer to:
Using your own explained, numerical, practical examples, differentiate between periodic and perpetual inventory systems. You may...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Zira Co. reports the following production budget for the next four months. April July 607 May June Production (units) 5...

    Zira Co. reports the following production budget for the next four months. April July 607 May June Production (units) 594 635 627 Each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 20% of next month's production needs. Beginning raw materials inventory for April was 475 pounds. Assume direct materials cost $4 per pound. Prepare a direct materials budget for April, May, and June. (Round your intermediate...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets    Liabilities and Stockholders' Equity Cash $ 4,000    Accounts payable $31,000 Accounts receivable 31,000    Dividends payable 15,000 Inventory 36,000    Rent payable 3,000 Prepaid Insurance 3,000    Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000    Total liabilities...

  • Luther Electronics sell a variety of gadgets including tablets. The business uses a perpetual inventory system...

    Luther Electronics sell a variety of gadgets including tablets. The business uses a perpetual inventory system and the LIFO method to account for inventory and began the third quarter of 2018 with merchandise inventory of 10 “PIXI 3G 7” tablets at a total cost of $134,200. During the quarter, the company completed the following transactions. July 8 Purchased 38 tablets at a total cost of $528,200. July 31 The sales for July were 18 tablets which yielded total sales revenue...

  • Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following inform

    Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are:Sales are 20% for cash and 80% on account.Sales on account are collected over a three-month period with 10%...

  • Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...

    Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets Liabilities and Stockholders' Equity Cash $4,000 Accounts payable $31,000 Accounts receivable 31,000 Dividends payable 15,000 Inventory 36,000 Rent payable 3,000 Prepaid Insurance 3,000 Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000 Total liabilities and equity $99,000 Actual and forecasted sales...

  • Please use above formats for each budget and show cell references/formulas for all parts to receive...

    Please use above formats for each budget and show cell references/formulas for all parts to receive credit First Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2020. Balance Sheet March 31, 2020 Assets Cash Accounts receivable Inventory Prepaid Insurance Net Fixtures Total Assets 2,000 25,000 29,400 2,000 25,000 83,400 Liabilities 25,480 6,000 31,480 Accounts payable Dividends payable Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total liabilities and Stockholders' equity...

  • Please show excel formula references/formulas First Store prepares budgets quarterly. The following information is available for...

    Please show excel formula references/formulas First Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2020. Balance Sheet March 31, 2020 Assets Cash Accounts receivable Inventory Prepaid Insurance Net Fixtures Total Assets 2,000 25,000 29,400 2,000 25,000 83,400 Liabilities 25,480 6,000 31,480 Accounts payable Dividends payable Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total liabilities and Stockholders' equity $ 14,920 37,000 51,920 83,400 $ Sales Revenue Month January February March...

  • Cash Budget The Williams Supply Company sells for $40 one product that it purchases for $25....

    Cash Budget The Williams Supply Company sells for $40 one product that it purchases for $25. Budgeted sales in total dollars for next year are $1,400,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $ 34,000 June 48,000 July 56,000 August 64,000 Account balances at July 1 include these: Cash $ 24,000 Merchandise inventory 17,500 Accounts receivable (sales) 25,760 Accounts payable (purchases) 16,250 The company pays for one-half of its purchases in the month...

  • a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 470,000...

    a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 470,000 $1,000,000 $450,000 $ 350,000 329,000 700,000 315,000 245,000 141,000 300,000 135,000 105,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense Total selling and administrative expenses Net operating income 91,000 42,500 133,500 7,500 $ 95,000 56,800 151,800 148,200 $ 56,000 35,000 9 1,000 44,000 $ 35,000 33,000 68,000 37,000 $ *Includes $17,000 of depreciation each month. b. Sales...

  • April May June July $ 500,000 $700,000 $400,000 $300,000 350,000 490,000 280,000 210,000 150,000 210,000 120,000...

    April May June July $ 500,000 $700,000 $400,000 $300,000 350,000 490,000 280,000 210,000 150,000 210,000 120,000 90,000 Sales Coat of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 70,000 90,000 51,000 30,000 40,000 52, 800 32,000 28.000 110,000 142,800 83,000 58,000 $ 40,000 $ 67,200 $ $7,000 $32,000 "Includes $12,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. c. Sales on account...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT