Question

Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Ma1. Prepare a product-line profitability report for SFS under the current costing system. 2. Prepare a product-line profitabil1. Prepare a product-line profitability report for SFS under the current costing system. 2. Prepare a product-line profitabil

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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%

Add a comment
Know the answer?
Add Answer to:
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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 perio...

    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...

    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...

    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...

    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...

    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...

    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...

    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%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT