Answer -
1. Answer -
Frozen food | Baked food | Fresh produce | |
Sales | $120000 | $91000 | $158175 |
Cost of goods sold | $105000 | $67000 | $110000 |
Gross margin | $15000 | $24000 | $48175 |
Store support | $24000 | $18200 | $31635 |
Operating income (loss) | ($9000) | $5800 | $16540 |
Operating margin (loss) | (7.50%) | 6.37% | 10.46% |
Calculation:
1. Gross margin:
Frozen food:
Gross margin = Sales - Cost of goods sold
= $120000 - $105000
= $15000
Baked food:
Gross margin = Sales - Cost of goods sold
= $91000 - $67000
= $24000
Fresh produce:
Gross margin = Sales - Cost of goods sold
= $158175 - $110000
= $48175
2. Store support:
As per given information, SFS estimates that store support expenses are 20% of revenues.
Frozen food:
Store support = 20% * Sales
= 20% * $120000
= $24000
Baked food:
Store support = 20% * Sales
= 20% * $91000
= $18200
Fresh produce:
Store support = 20% * Sales
= 20% * $158175
= $31635
3. Operating income (loss):
Frozen food:
Operating income (loss) = Gross margin - Store support
= $15000 - $24000
= ($9000)
Baked food:
Operating income (loss) = Gross margin - Store support
= $24000 - $18200
= $5800
Fresh produce:
Operating income (loss) = Gross margin - Store support
= $48175 - $31635
= $16540
4. Operating margin (loss):
Frozen food:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [($9000) / $120000] * 100
= (7.50%)
Baked food:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [$5800 / $91000] * 100
= 6.37%
Fresh produce:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [$16540 / $158175] * 100
= 10.46%
2. Answer -
Frozen food | Baked food | Fresh produce | |
Sales | $120000 | $91000 | $158175 |
Cost of goods sold | $105000 | $67000 | $110000 |
Gross margin | $15000 | $24000 | $48175 |
Store support: | |||
Order processing | $800 | $3600 | $8000 |
Receiving | $1320 | $6050 | $13200 |
Shelf-stocking | $31 | $8 | $61 |
Customer support | $6300 | $8400 | $18060 |
Total store support cost | $8451 | $18058 | $39321 |
Operating income (loss) | $6549 | $5942 | $8854 |
Operating margin (loss) | 5.46% | 6.53% | 5.60% |
Calculation:
1. Order processing:
Frozen food:
Order processing = [Number of purchase orders * $80 per purchase order]
= [10 * $80 per purchase order]
= $800
Baked food:
Order processing = [Number of purchase orders * $80 per purchase order]
= [45 * $80 per purchase order]
= $3600
Fresh food:
Order processing = [Number of purchase orders * $80 per purchase order]
= [100 * $80 per purchase order]
= $8000
2. Receiving:
Frozen food:
Receiving = [Number of deliveries * $110 per delivery]
= [12 * $110 per delivery]
= $1320
Baked food:
Receiving = [Number of deliveries * $110 per delivery]
= [55 * $110 per delivery]
= $6050
Fresh food:
Receiving = [Number of deliveries * $110 per delivery]
= [120 * $110 per delivery]
= $13200
3. Shelf-stocking:
Frozen food:
Shelf-stocking = [Number of hours per delivery * $15.25 per hour]
= [2 * $15.25 per hour]
= $30.50 ≈ $31
Baked food:
Shelf-stocking = [Number of hours per delivery * $15.25 per hour]
= [0.5 * $15.25 per hour]
= $7.625 ≈ $8
Fresh food:
Shelf-stocking = [Number of hours per delivery * $15.25 per hour]
= [4 * $15.25 per hour]
= $61
4. Customer support:
Frozen food:
Customer support = [Total units sold * $0.21 per item]
= [30000 units * $0.21 per item]
= $6300
Baked food:
Customer support = [Total units sold * $0.21 per item]
= [40000 units * $0.21 per item]
= $8400
Fresh food:
Customer support = [Total units sold * $0.21 per item]
= [86000 units * $0.21 per item]
= $18060
5. Total store support:
Frozen food:
Total store support = Order processing + Receiving + Shelf-stocking + Customer support
= $800 + $1320 + $31 + $6300
= $8451
Baked food:
Total store support = Order processing + Receiving + Shelf-stocking + Customer support
= $3600 + $6050 + $8 + $8400
= $18058
Fresh food:
Total store support = Order processing + Receiving + Shelf-stocking + Customer support
= $8000 + $13200 + $61 + $18060
= $39321
6. Operating income (loss):
Frozen food:
Operating income (loss) = Gross margin - Store support
= $15000 - $8451
= $6549
Baked food:
Operating income (loss) = Gross margin - Store support
= $24000 - $18058
= $5942
Fresh produce:
Operating income (loss) = Gross margin - Store support
= $48175 - $39321
= $8854
7. Operating margin (loss):
Frozen food:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [$6549 / $120000] * 100
= 5.46%
Baked food:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [$5942 / $91000] * 100
= 6.53%
Fresh produce:
Operating margin (loss) = [Operating income (loss) / Sales] * 100
= [$8854 / $158175] * 100
= 5.60%
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Sales Cost of goods sold $288,000 271, 000 Fresh Produce $524, 000 404, 000 Baked Goods $493, 000 399,000 SFS estimates that store support expenses, in total, are approximately 13% of revenues. The controller says...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $129,000 111,000 Sales Cost of goods sold Baked Goods $102,000 75,000 Fresh Produce $170,000 118,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Baked Fresh Frozen Foods Goods Produce $126,000 110,000 Sales $98,000 $165,000 115,000 Cost of qoods sold 72,000 SFS estimates that store support expenses, in total, are approximately 14% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods $135,000 119,000 Fresh Baked Goods Produce $120,000 $184,000 88,000 128,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 17% of revenues. The controller says that not every sales...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 135,000 $ 120,000 $ 194,000 Cost of goods sold 117,000 88,000 136,000 SFS estimates that store support expenses, in total, are approximately 23% of revenues. The controller says that...
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 148,000 $ 142,000 $ 211,000 Cost of goods sold 128,000 104,000 153,000 SFS estimates that store support expenses, in total, are approximately 14% of revenues. The controller says that...
TELEIL penuu die. Frozen Foods $135,000 117,000 Fresh Baked Goods Produce $120,000 $194,000 88,000 136,000 Sales Cost of goods sold SFS estimates that store support expenses, in total, are approximately 23% of revenues The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are: Frozen Foods Baked Goods Fresh Produce 12 Activity (cost driver) Order processing (number of purchase orders)...
Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. SPF’s management team thinks that the store will improve its profitability if it discontinues the Other Flooring Products line. The operating results from the most recent period are: Paint and Paint Supplies Carpet Other Flooring Products Sales $ 431,400 $ 261,000 $ 196,000 Cost of goods sold 132,000 155,000 161,000 SPF estimates that store support expenses are approximately 25%...
Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. SPF’s management team thinks that the store will improve its profitability if it discontinues the Other Flooring Products line. The operating results from the most recent period are: Paint and Paint Supplies Carpet Other Flooring Products Sales $ 174,100 $ 280,000 $ 216,000 Cost of goods sold 100,000 195,000 172,000 SPF estimates that store support expenses are approximately 25%...