Question

The revenues, cost of goods sold, store support costs, activities that account for the store support costs, 2 and activity ar
1. Use the simple costing system to prepare a product-line profitability report for FS. (Always use cell references and formu


Activity-Based Costing and Activity-Based Management ABC, Retail Product-line Profitability Fitzgerald Supermarkets (FS) oper
0 0
Add a comment Improve this question Transcribed image text
Answer #1
1 Simple Costing System
Baked Goods Milk & Fruit Juice Frozen Products Total
Revenues 60,000 66,500 50,500 177,000
Costs
Cost of Goods Sold 41,000 51,000 32,000 124,000
Store Support 12,300 15,300 9,600 37,200
Total Costs 53,300 66,300 41,600 161,200
Operating Income 6,700 200 8,900 15,800
Operating Income / Revenues % 11.17% 0.30% 17.62% 8.93%
2 ABC System
Baked Goods Milk & Fruit Juice Frozen Products Total
Revenues 60,000 66,500 50,500 177,000
Costs
Cost of Goods Sold 41,000 51,000 32,000 124,000
Ordering 4,180 2,280 1,330 7,790
Delivery 9,120 4,560 2,736 16,416
Shelf Stocking 3,230 2,850 380 6,460
Customer Support 2,310 3,030 1,194 6,534
Total Costs 59,840 63,720 37,640 161,200
Operating Income 160 2,780 12,860 15,800
Operating Income / Revenues % 0.27% 4.18% 25.47% 8.93%
Add a comment
Know the answer?
Add Answer to:
The revenues, cost of goods sold, store support costs, activities that account for the store support...
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
  • Ordering Delivery and receipt of merchandise Shelf-stocking Customer support and assistance $104 per purchase order $82...

    Ordering Delivery and receipt of merchandise Shelf-stocking Customer support and assistance $104 per purchase order $82 per delivery $18 per hour $0.24 per item sold Milk and Baked Goods Fruit Juice Frozen Products Financial data je ne Revenues $ 57,500 $ 66,500 $ 50,500 Cost of goods sold 39,000 $ 46,000 $ 33,000 Store suppbrt $ 11,700 $ 13,800 $ 9,900 Activity-area usage (cost-allocation base) Ordering (purchase orders) 20 15 5 Delivery (deliveries) 100 40 35 Shelf-stocking (hours) 195 170...

  • I don't know if my numbers are right, but I need help calculating the operating income...

    I don't know if my numbers are right, but I need help calculating the operating income and the operating income in revenues percentage Activity-Based Costing and Activity-Based Management ABC, Retail Product-line Profitability Free work cells Answer cells Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their activity cost rates as follows: Ordering Delivery and receipt of merchandise Shelf-stocking...

  • Towa 4 of 5 (1 complete) HW Score: 20%, 1 of 5 pts Score: 0 of...

    Towa 4 of 5 (1 complete) HW Score: 20%, 1 of 5 pts Score: 0 of 1 pt E5-27 (book/static) Question Help diston proto prote costs Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their activity cost rates as follows: (Click the icon to view the activity cost rates.) The revenues, cost of goods sold, store support costs,...

  • Z-Mart operates a supermarket with three product lines: Baked Goods, Milk, and Frozen Foods. The revenues...

    Z-Mart operates a supermarket with three product lines: Baked Goods, Milk, and Frozen Foods. The revenues and cost data of the three product lines are: Baked Goods Milk Frozen Foods Total Revenues $59,500 $66,000 $50,500 $176,000 Cost of Goods Sold $40,000 $49,000 $37,000 $126,000 Store Support Cost $ 37,800 Under the simple costing system, Z-Mart allocated its indirect cost (i.e., Store Support costs) to products at the rate of 30% of cost of goods sold. a) Using the simple costing...

  • b. Genie Corner Stores operates aleancity and decides to apply ABC analysis to three product lines:...

    b. Genie Corner Stores operates aleancity and decides to apply ABC analysis to three product lines: baked goods. milk and fruit juice and frozen foods. Total store and supporting costs (indirect/overhead costs) are $37,760. These indirect/overhead costs are identified in the following activities (cost pools) and their respective cost drivers Activity Total cost Cost driver Ordering Delivery Shelf-stocking Customer support Total $ 7.890 $ 17, 445 $ 5.640 $6785 $37, 760 Number of purchase orders Number of deliveries Number of...

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

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

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

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