Weighted cost of goods percentage question

reidf

New member
Joined
Nov 10, 2016
Messages
1
I am trying to find out the consolidated cost of good sold (cgs) percentage between three separate stores. Store one has a cgs of 34.46% and represents 69% of total company sales. Store two has a cgs of 46.55% and represents 18% of total company sales. Store three has a cgs of 43.52% and represents 13% of total company sales. What is the company cgs?
 
I am trying to find out the consolidated cost of good sold (cgs) percentage between three separate stores. Store one has a cgs of 34.46% and represents 69% of total company sales. Store two has a cgs of 46.55% and represents 18% of total company sales. Store three has a cgs of 43.52% and represents 13% of total company sales. What is the company cgs?
One of the ways to go about working out these type of problems is to put some numbers together, From this you should be then be able to see what formula you should use in general. So suppose you had the same three stores which had a total of $100000 in sales and we have
Store 1: 47.96% cgs, 63% sales ==> $63000 sales and 0.4796 * 63000 = $30214.80 cgs,
Store 2: 44.00% cgs, 25% sales ==> $25000 sales and 0.4400 * 25000 = $11000.00 cgs,
Store 3: 23.07% cgs, 12% sales ==> $12000 sales and 0.2307 * 12000 = $ 2768.40 cgs
So what formula does this suggest?
 
Top