Ask Experts Questions for FREE Help !
Ask
    sagnik2422's Avatar
    sagnik2422 Posts: 77, Reputation: 1
    Junior Member
     
    #1

    Jan 2, 2015, 10:33 AM
    Ending Inventory Question Accounting
    The data below regards The Bag House, a store that sells bags.

    Budgeted Sales (credit) : For January, February, and March, are $420,000, $310,000, and $280,000.
    Budgeted Collections : 60% in month of sale, 30% in following month, and 10% uncollectible
    Cost of Goods sold : 50% of sales
    Purchases of Merchandise: 30% in month prior to sale, and 70% in month of sale
    Payment for Purchases : 80% in month of purchase and 20% in following month
    Selling and Admin Costs : $32,500 paid in cash monthly
    Depreciation of Equipment : $21,500 monthly
    Question : What is the cash disbursement for purchases of merchandise in February?
    A) 165,500 B) 159,100 C) 149,750 D) 153,000 E) None
    Solution shows 159,100 but I don't get their steps as to how:
    They started with budgeted sales for February of 310,000 and then showed COGS of $155,000 (1/2 of 310,000 I know that), and then they add ending inventory of $42,000 (I don't understand where this comes from), and then they subtract beginning inventory of 46,500 ( I don't get where this comes from, i.e. the math, I know it comes from January), to get required purchases of 150,500. Prior to this they showed the same thing for January, with budgeted sales of 420,000, then COGS of 210,000, then they added ending inventory of 46,500 (don't get where it came from) and then they subtract beginning inventory of 63,000 to get required purchases of 193,500.

    I understand the end steps : 0.8 x February Required Purchases + 0.2 x January Required Purchases where I plug in the above numbers to get $159,100 but again I don't get how to calculate the beginning and ending inventory for January and the ending inventory for February.

    Thanks for your help in advance.
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member
     
    #2

    Jan 12, 2015, 03:52 PM
    logic if you purchase 30% in the month prior to sale this must be in inventory ie; 30% of 210000 = 63000 you have all the numbers to do the calculations

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Accounting question about inventory. Please help. [ 0 Answers ]

The Village Hat Shop Limited counted the entire inventory in its store on August 31 and arrived at a total inventory cost of $66,000. The count included $5,800 of inventory held on consignment for a local designer; $500 of inventory that was being held for customers who were deciding if they...

How do I find the ending inventory using the FIFO Method through perpetual inventory? [ 0 Answers ]

How do I find the ending inventory using the FIFO Method through perpetual inventory?

How to find ending inventory using the average inventory cost method [ 3 Answers ]

The Boxwood Company Sells blankets for $60 each. Purchase 5 units 30$ Purchase 10 units 34$ Purchase 10 units 40$ Sale 3 units Sale 6 units Sale 3 units Assuming that the company uses the perpetual inventory system, determine the ending inventory for the month of May using the average...

How do you find average inventory using only ending inventory and COGS? [ 3 Answers ]

In searching the Internet on a method of how to do this, all examples include beginning inventory and purchases to determine average inventory. I know ending inventory for one year is beginning inventory for the next, but when you don't have information on purchases, how does one arrive at finding...

Determine the ending inventory under a perpetual inventory system [ 1 Answers ]

Hi ! I've honestly spent a long time trying to figure this out, but I keep getting the answer wrong and I'm not sure how I should go about this question. I'm not asking for you to just give me the answer, if you have time to give a little explanation that would be nice so I could understand what...


View more questions Search