Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  Answer this Question    Ask about Accounting    Ask about another Subject  
 

Rarequeen
Aug 23, 2007, 04:33 PM
Can some one tell me if i am right? the ones with the * are the ones im concerned about please help

Sales . . . . . . . . . . . . . . . . . . . . . . . .. $60,000 $42,500 $36,000 $18400* $23,600
Cost of goods sold
Merchandise inventory (beginning) . . .. 6,000 17,050 7,500 7,000 2,560
Total cost of merchandise purchases 36,000 62,250 * 51500* 32,000 5,600
Merchandise inventory (ending) . 30,000 * (2,700) (9,000) (6,600) 20,560*
Cost of goods sold . . . . . . . . . . . 34,050 15,900 12,750 * 52,000 * 5,600
Gross profit . . . . . . . . . . . . . . . . 74050 * 26600 3,750 45,600 26160*
Expenses . . . . . . . . . . . . . . . . . . . . . 9,000 10,650 12,150 2,600 6,000
Net income (loss) . . . . . . . . . . . . . 60,050 * $15,950 (8,400) $43,000 20,160*

CaptainForest
Aug 25, 2007, 12:50 AM
Please refer to this Announcement (http://www.askmehelpdesk.com/finance-accounting/announcements.html)

Rarequeen
Aug 25, 2007, 01:04 PM
I did the assignment the ones with the *'s by them are my answers I was just wanting to know if I did it correctly.

CaptainForest
Aug 25, 2007, 01:46 PM
Indeed you did. I misread what you had done.

Sorry about that.

I reviewed your answers and here are my comments.

I have divided it into 5 “companies”. Company 1 is the company with sales of 60,000, Company 2 has sales of 42, 500 and so on….


General Notes:
Sales – COGS = Gross Profit
Gross Profit – Expenses = Net Income

Or you can say, Sales – COGS – Expenses = Net Income

If you look at your numbers, they do not hold true to the above equations. Your biggest mistake seems to be in calculating COGS

To calculate COGS, the formula is:
COGS = Beg Inv + Purchases – End Inv

Company 1:
End Inv = 7,950

Check to make sure its right.
Beg Inv 6,000 + Purchases 36,000 – End Inv 7,950 = COGS 34,050

GP is therefore 25,950 and Net Income is 16,950

Based on the above formulas, do you think you would be able to solve the other companies?

Rarequeen
Aug 25, 2007, 03:00 PM
I'm going to try thanks a lot

Rarequeen
Aug 25, 2007, 03:21 PM
how do u calculate the ending merchandise?

Rarequeen
Aug 25, 2007, 04:24 PM
Sales . . . . . . . . . . . . . . . . . . . . . . .$60,000 $42,500 $36,000 $98,200 $23,600
Cost of goods sold
Merchandise inventory (beginning) . . 6,000 17,050 7,500 7,000 2,560
Total cost of merchandise purchases 36,000 (38,050) 15,750 32,000 5,600
Merchandise inventory (ending) . 7950 (2,700) (9,000) (6,600) 2,560
Cost of goods sold . . . . . . . . . . . 34,050 15,900 32,250 52,600 5,600
Gross profit . . . . . . . . . . . . . . . 25,950 26600 3,750 45,600 18,000
Expenses . . . . . . . . . . . . . . . . . . . 9,000 10,650 12,150 2,600 6,000
Net income (loss) . . . . . . . . . . . . . 16,950 $15,950 (8,400) $43,000 12,000
can u tel me if this is right

CaptainForest
Aug 25, 2007, 10:44 PM
how do u calculate the ending merchandise?

How to calculate Ending Inventory?
The formula is:
Beg Inv + Purchases– End Inv = COGS

Therefore, we can also say that
Beg Inv + Purchases – COGS = End Inv

Plus in the numbers and you get your answer.

CaptainForest
Aug 25, 2007, 10:55 PM
Company 2:
Purchases = -3,850
Formula: COGS + End Inv – Ben Inv

Company 3:
COGS = 32,350
Formula: Sales – GP

Purchases = 15,750
Formula: COGS + End Inv – Ben Inv

Company 4:
COGS = 45,600
Formula: Ben Inv + Purchases – Ending Inventory

Sales = 91,200
Formula: GP + COGS

Company 5:
End Inv = 2,560
Formula: Ben Inv + Purchases – COGS

GP = 18,000
Formula = Sales – COGS

NI = 12,000
Formula = GP - Expenses

Rarequeen
Aug 26, 2007, 09:55 AM
thnak Captain I got all of them right except 3 u r a great teacher! Cudos to you

CaptainForest
Aug 26, 2007, 02:06 PM
you're welcome