| 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% | ||
The revenues, cost of goods sold, store support costs, activities that account for the store support...
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 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 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 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: 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 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 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 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: 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 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...