1) Gross profit margin for three market segments:
General | Drugstore | Mom & pop | Total | |
Revenue (a) | 3708000 | 3150000 | 1980000 | 8838000 |
Less: COGS | -3600000 | -3000000 | -1800000 | -8400000 |
Gross Margin (b) | 108000 | 150000 | 180000 | 438000 |
Gross profit margin (a/b) | 2.91% | 4.76% | 9.09% | 4.96% |
2) Cost driver rates for each of five activity areas:
Activity area | Cost (a) | General | Drugstore | Mom & pops | Total (b) | Cost driver rate (a/b) |
Orders processed | 80000 | 140 | 360 | 1500 | 2000 | $40 |
Line items ordered | 63840 | 1960 | 4320 | 15000 | 21280 | $3 |
Store deliveries | 71000 | 120 | 360 | 1000 | 1480 | $47.97 |
Cartons shipped to store | 76000 | 36000 | 24000 | 16000 | 76000 | $1 |
Shelf stocking hours | 10240 | 360 | 180 | 100 | 640 | $16 |
3) Allocation of other costs:
Orders processed | Line-items ordered | Stores deliveries | Carton shipped | Shelf stocking | Costs allocated to market segments (In $) | |
General | ||||||
Activity Level | 140 | 1960 | 120 | 36000 | 360 | |
Activity rate (in $) | 40 | 3 | 47.97 | 1 | 16 | |
Total cost (in $) | 5600 | 5880 | 5756 | 36000 | 5760 | 58996 |
Drugstore | ||||||
Activity Level | 360 | 4320 | 360 | 24000 | 180 | |
Activity rate (in $) | 40 | 3 | 47.97 | 1 | 16 | |
Total cost (in $) | 14400 | 12960 | 17269.2 | 24000 | 2880 | 71510 |
Mom & pops | ||||||
Activity Level | 1500 | 15000 | 1000 | 16000 | 100 | |
Activity rate (in $) | 40 | 3 | 47.97 | 1 | 16 | |
Total cost (in $) | 60000 | 45000 | 47974 | 16000 | 1600 | 170574 |
TOTAL COST | 301080 |
4) Income Statement for three segments: (In $)
General | Drugstore | Mom & pop | Total | |
Revenue | 3708000 | 3150000 | 1980000 | 8838000 |
Less: COGS | -3600000 | -3000000 | -1800000 | -8400000 |
Gross Margin | 108000 | 150000 | 180000 | 438000 |
Less: Operating costs | -58996 | -71510 | -170574 | -301080 |
Operating income | 49004 | 78490 | 9426 | 136920 |
Pharmahelp - Current Income Statement General Drugstore Mom & Pop Total 0 Revenues Cost of Goods...
The revenues, cost of goods sold, store support costs, activities that account for the store support costs, 2 and activity area usage of the three product lines are as follows: 3 4 Baked Goods Milk and Fruit Juice Frozen Products 6 $60,000 $41,000 $12,300 $66,500 $51,000 $15,300 $50,500 $32,000 $9,600 5 Financial data Revenues 7 Cost of goods sold 8 Store support 9 Activity area usage (cost-allocation base) 10 Ordering (purchase orders) 11 Delivery (deliveries) 12 Shelf-stocking (hours) Customer support...
0 function? P5-14 ACTIVITY-BASE OFITABILAN e company is has shown Jans to Wa CTIVITY-BASED COSTING AND PRODUCT LINE PRO "Percor is a grocery company with stores throughout Spain. Suppose the ning an expansion of its store in central Madrid. A preliminary analysis Ickaged Food department to be the most profitable, so the company plane space the most. Assume that the Madrid store has just three departments: Produce. Part at. The most recent annual report for the store showed sales of...
Create a Statement of Cost of Goods Purchased, Cost of Goods Sold and Income Statement for 2019, using the following information. Warehouse costs for finished goods are considered a period cost, NOT a cost of goods purchased. Be sure to include the terms "Cost of Goods Available for Sale", "Gross Margin" (gross profit), “Net purchases" and "Operating Income". These numbers will each be worth 1 point. Be sure to label each line. Building depreciation (headquarters) 6,000 not included in any...
Woodlands Inc. 2015 Income Statement ($ in millions) Total operating revenues $3,806 Cost of goods sold 2,315 Selling, general, and administrative expenses 546 Depreciation 311 Eamings before interest and taxes (EBIT) Interest expense $634 170 $464 Pretax income Taxes 162 Net income $302 Dividends 75 Woodlands Inc. Balance Sheet ($ in millions) 2015 2014 Liabilities and Stockholders' Equity $ 503 $ 227 Accounts payable 2015 2014 $ 686$ 613 Assets Cash and equivalents Accounts receivable Inventory Net property & equipment...
$3.806 Woodlands Inc. 2015 Income Statement ($ in millions) Total operating revenues Cost of goods sold 2,315 Selling, general, and administrative expenses 546 Depreciation 311 Earnings before interest and taxes (EBIT) Interest expense $634 170 Pretax income Taxes $464 162 $302 Net income 75 Dividends 2015 2014 $ 686$ 613 Assets Cash and equivalents Accounts receivable Inventory Net property & equipment Intangible assets Woodlands Inc. Balance Sheet ($ in millions) 2015 2014 Liabilities and Stockholders' Equity $ 503 $ 227...
0 Income statement 2016 2015 Sales revenues Less: Cost of goods sold Gross profit Less: Operating expenses Operating income Less: Interest expense Income before income taxes (amounts in thousands) 2017 211,400 $ 182,910 105,000 96,000 106,400 $ 86,910 53,000 46,000 53.400 $ 40,910 5.385 6,459 48,015 $ 34,451 22.617 16. 160 Print Done i Income statement JJUJ 0,435 LESS. Merest expense Income before income taxes 48,015 $ 22,647 25,368 $ 34,451 16,160 Less: Income tax expense Net income 18,291 Additional...
MininHot is a distributor of specialty sauces to the HORECA sector. MininHot operates at capacity and serves three main segments: a. Key accounts, comprising large hotel and restaurant chains as well as catering firms b. Multilocation, comprising medium size hotel and restaurant chains C. Owner operated, comprising HORECA customers owning a single location Erik Gonzalez, MininHot's controller, reported the following data for 2019: Revenues COGS Gross Margin Other Operating Costs Operating Income Key accounts $7,416,000 7,200,000 $216000 Multilocation $6,300,000 6,000,000...
PROBLEM 2–17 Schedule of Cost of Goods Manufactured; Income Statement; Cost Behaviour [LO1, LO2, LO3, LO4, LO5] eXcel The following information pertains to the most recent quarter at Precious Production Limited. $ 360,000 Purchases of raw materials Raw materials inventory, beginning. Raw materials inventory, ending.. Depreciation, factory. Insurance, factory Direct labour. Maintenance, factory. Administrative expenses 40.000 68,000 168,000 20.000 240,000 120,000 280,000 1,800,000 108,000 Sales Utilities, factory Supplies, factory Selling expenses 4,000 320.000 260,000 28,000 Indirect labour. Work in process...
Gross margin Operating profit Revenues Income tax rate $ 180,000 $ 58,000 $ 625,000 32 Required: (a) Compute the cost of services sold. (b) Compute the total marketing and administrative costs. (c) Compute net income. BI YA - A - IX E 33 13 x x - D R N V Nov 11 12pt The following data are taken from the financial statements: Current Preceding Year Year $3,600,000 $4,000,000 Sales Cost of goods sold 2,000,000 2,700,000 Average inventory 372,000 352,000...
Shown as follows is a segmented income statement for Drexel-Hall during the current month. 60 Sales Variable costs Contribution margin Traceable fixed costs: controllable Performance margin Traceable fixed costs: committed Store responsibility margin Common fixed costs Income from operations Drexel-Hall Dollars $1,800,000 100% 1,080,000 $ 720,000 40% 432,000 24 $ 288,000 16% 180,000 10 $ 108,000 6% 36,000 $ 72,000 4% Store 1 Dollars $600,000 372,000 $228,000 120,000 $108,000 48,000 $ 60,000 100% 62 38% 20 18% 8 Profit Centers...