Complete the Colombo Yogurt Profit-Loss Statement below:

File Home Insert Page Layout Formulas Data Review View Help Com 0 PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing G17 EX fx D E F G H I J A B 1 PROFIT AND LOSS BY SEGMENT - PRE-ABC 2 Colombo Soft-Serve Frozen Yogart 3 Income Statement Category 4 Impulse Segment Yogurt Shops 5 Line Total # Sales in Cases 1,500,000 1,200,000 300,000 6 I Sales Revenue $ 23,880,000 $ 5,970,000 7 8 $ 29,850,000 4,500,000 $ 25,350,000 $ 17,250,000 9 2 Less: Price Promotions 3 Net Sales (Line I - 2) 4 Less: Cost of Goods Sold $ 3,600,000 20,280,000 13,800,000 $ 900,000 5,070,000 3,450,000 1,620,000 10 $ 8,100,000 $ 6,480,000 $ 11 12 13 14 15 5 Gross Margin = Net Sales - COGS (Line 3-4) 6 Less: Merchandising Expenses 7 Less: Selling General & Admin. Expenses 8 Net Income (Line 7-8-9) 1,725,000 1,185,000 5,190,000 1,380,000 948,000 4,152,000 345,000 237,000 1,038,000 $ $ $ ACTIVITY BASED COSTING ANALYSIS B E F H I J K L M N o 15 ACTIVITY BASED COSTING ANALYSIS 16 Colombo Soft-Serve Frozen Yogart 17 Income Statement Category Cost Cost Per Total 18 Impulse Segment Quantity Yogart Shops Quantity Impulse Segment Yogart Shops Driver Driver Quantity 19 20 Line Total 1,500,000 # Sales in Cases 1,200,000 300,000 21 $ 23,880,000 3,600,000 S 20,280,000 22 Sales Revenue I 23 2 Less: Price Promotions 24 3 Net Sales (Line 1 - 2) 25 4 COGS (ingred. , pkg. & storing) 26 5 COGS (pick pack & shipping) Pallets 27 6 COGS (pick pack & shipping) Ind. Cases 28 7 Total Cost of Goods Sold (Line 4+ 5+ 6) 29 8 Gross Margin = Net Sales - COGS (Line 3 -7) 30 9 Less: Merchandising Expenses 31 10 Less: Selling General & Admin. Expenses 32 11 Net Income (Line 8 - 9 - 10) 33 $ 29,850,000 4,500,000 $ 25,350,000 $ 14,250,000 300,000 2,700,000 $ 17,250,000 8.100.000 1,725,000 3,900,000 2.475,000 $ 5,970,000 900,000 S 5,070,000 Cases $9.50 per case Pallets $75 per pallet Ind. Cases $2.25 per ind. 1,200,000 800 1,140,000 300,000 1,500,000 3,200 4,000 60,000 1,200,000 Kits $500 per kit % of time 3360 99% 90 1% 3450 100% Time