Product profitability analysis1[1]

%5bCompany+Name%5d+Product+Profitability+Analysis+%5bDate%5d%0d%0aDark+gray+cells+will+be+calculated+for+you.+You+do+not+need+to+enter+anything+into+them.%0d%0a%0d%0a%5bProduct+Name%5d%0d%0aInventory+Movement+Number+of+units+in+inventory%e2%80%94Beginning+of+period+Production+Units+sold+Number+of+units+in+inventory%e2%80%94End+of+period+Profitability+Analysis+Product+revenue+Cost+of+Goods+Sold+Material+costs+Labor+costs+Logistics+costs+Other+direct+costs+Total+cost+of+goods+sold+Gross+margin+Margin+contribution+percentage+Indirect+Product+Costs+Product+marketing+Other+indirect+product+costs+Total+other+product+costs+Quarterly+product+profit+(loss)+Summary+Metrics+Average+sales+price+per+unit+sold+Material+cost+per+unit+produced+Labor+cost+per+unit+produced+Q1+1%2c200+700+800+1%2c100+Q1+%24400%2c000+Q1+%2490%2c000+120%2c000+45%2c000+0+%24255%2c000+%24145%2c000+36.3%25+Q1+%2460%2c000+25%2c000+%2485%2c000+%2460%2c000+Q1+%24500.00+%24128.57+%24171.43+Q2+1%2c100+800+600+1%2c300+Q2+%24425%2c000+Q2+%2480%2c000+120%2c000+40%2c000+0+%24240%2c000+%24185%2c000+43.5%25+Q2+%2460%2c000+25%2c000+%2485%2c000+%24100%2c000+Q2+%24708.33+%24100.00+%24150.00+Q3+1%2c300+800+500+1%2c600+Q3+%24285%2c000+Q3+%2480%2c000+115%2c000+35%2c000+0+%24230%2c000+%2455%2c000+19.3%25+Q3+%2460%2c000+25%2c000+%2485%2c000+(%2430%2c000)+Q3+%24570.00+%24100.00+%24143.75+Q4+1%2c600+600+750+1%2c450+Q4+%24395%2c000+Q4+%2475%2c000+110%2c000+45%2c000+0+%24230%2c000+%24165%2c000+41.8%25+Q4+%2460%2c000+30%2c000+%2490%2c000+%2475%2c000+Q4+%24526.67+%24125.00+%24183.33+Annual+1%2c200+2%2c900+2%2c650+1%2c450%0d%0a%0d%0a%241%2c505%2c000+Annual+%24325%2c000+465%2c000+165%2c000+0+%24955%2c000+%24550%2c000+36.5%25+Annual+%24240%2c000+105%2c000+%24345%2c000+%24205%2c000+Annual+%24567.92+%24112.07+%24160.34%0d%0a%0d%0a%0cSummary+Metrics+per+Quarter%0d%0a%24800.00%0d%0a%0d%0a%24700.00+%24600.00%0d%0a%0d%0a%24500.00%0d%0a%0d%0a%24400.00+%24300.00%0d%0a%0d%0a%24200.00+%24100.00%0d%0a%0d%0a%240.00%0d%0a%0d%0aAverage+sales+price+per+unit+sold%0d%0a%0d%0aMaterial+cost+per+unit+produced%0d%0a%0d%0aLabor+cost+per+unit+produced%0d%0a%0d%0a%0c