| 1.00 | Cost Driver | Total Activity Cost (A) | Standard (B) | Extra Virgin (C) | Total Hours (D) | Cost per acitvity (D/A) |
| Washing pressing and filtering Hours | 1,537,500.00 | 45,000.00 | 105,000.00 | 150,000.00 | 10.25 | |
| Number of bottles | 412,500.00 | 300,000.00 | 75,000.00 | 375,000.00 | 1.10 | |
| 2 | Extra Vigrin | |||||
| Cost Driver | Acitvity | Cost per acitvity | Total | |||
| Washing pressing and filtering Hours | 105,000.00 | 10.25 | 1,076,250.00 | |||
| Bottlings | 75,000.00 | 1.10 | 82,500.00 | |||
| Overhead Assigned to Extra Virgin | 1,158,750.00 | |||||
| Standard | ||||||
| Cost Driver | Acitvity | Cost per acitvity | Total | |||
| Washing pressing and filtering Hours | 45,000.00 | 10.25 | 461,250.00 | |||
| Bottlings | 300,000.00 | 1.10 | 330,000.00 | |||
| Overhead Assigned to Standard | 791,250.00 | |||||
| 3 | Total Manuafacturing Cost | |||||
| Standard | Extra Virgin | |||||
| Direct Material | 900,000.00 | 600,000.00 | ||||
| Add | Direct Labour | 375,000.00 | 150,000.00 | |||
| Add | Overhead Cost | 791,250.00 | 1,158,750.00 | |||
| = | Total Manuafacturing Cost | 2,066,250.00 | 1,908,750.00 | |||
| 4 | Gross Profit | |||||
| Standard | Extra Virgin | |||||
| Sales Revenue | 5,100,000.00 | 2,100,000.00 | ||||
| Less | Total Manuafacturing Cost | 2,066,250.00 | 1,908,750.00 | |||
| = | Gross Profit | 3,033,750.00 | 191,250.00 |
#1 #2 #3 E4-16 (Static) Calculate Total Manufacturing Costs and Gross Profit (LO 4-4) Rosehut Olive...
Rosehut Olive Oil Company makes two grades of olive oil: standard and extra virgin. Rosehut has identified two activity cost pools, the related costs per pool, the cost driver for each pool, and the expected usage for each pool. Activity Total Activity Cost Cost Driver Standard Extra Virgin Washing, Pressing & Filtering (WPF) $ 1,778,400 Washing, Pressing, and Filtering hours 47,400 hours 108,600 hours Bottling $ 931,500 Number of bottles 324,000 bottles 81,000 bottles Additional information about each grade of...
Rosehut Olive Oil Company makes two grades of olive oil: standard and extra virgin. Rosehut has identified two activity cost pools, the related costs per pool, the cost driver for each pool, and the expected usage for each pool. Total Activity Activity Cost Cost Driver Standard Extra Virgin Washing, Pressing & Filtering (WPF) $1,673,150 Washing, Pressing, and Filtering hours 46,400 hours 107,100 hours Bottling $ 706,500 Number of bottles 314,000 bottles 78,500 bottles Additional information about each grade of olive...
E4-14 (Algo) Assigning Costs Using Traditional System, ABC System (LO 4-1, 4-3, 4-4,4-5) Julio produces two types of calculator, standard and deluxe. The company is currently using a traditional costing system with machine hours as the cost driver but is considering a move to activity-based costing. In preparing for the possible switch, Julio has identified two cost pools materials handling and setup. The collected data follow: Standard Model 26,800 Deluxe Model 31,800 Number of machine hours Number of material moves...
E4-6 (Algo) Calculating Activity Rates, Assigning Costs [LO 4-3, 4-4) Feltar Corp. has identified the following information Activity cost pools Materials handling $33,440 Machine 25,92€ maintenance Cost drivers Number of material 760 moves Number of machine 72.000 hours Required: 1. Calculate the activity rate for each cost pool. 2. Determine the amount of overhead assigned to Fellar's products if they have the following activity demands: Product Product Number of 610 150 material moves Number of machine 41,800 30,280 hours Complete...
E4-6 (Algo) Calculating Activity Rates, Assigning Costs [LO 4-3, 4-4] Fellar Corp. has identified the following information: Activity cost pools Materials handling Machine maintenance Cost drivers Number of material moves Number of machine hours $42,660 26,730 790 Required: 1. Calculate the activity rate for each cost pool. 2. Determine the amount of overhead assigned to Fellar's products if they have the following activity demands: Number of material moves Number of machine hours Product A Product B 460 3 30 42,60038,400...
Case Olive Oil
Bertolli, an Italian leading companies in sales of olive oil,
will be the primary player in the project “PREMIUM EXTRA VIRGIN
OLIVE OIL” financed by the European Union. The main purpose of the
project is to promote consumption of top-quality olive oil and
consequently motivate trade in extra-virgin olive oil between the
European Union and Latin America. The main theme specifically
relates to the contribution made by technological innovation to the
production chain of extra virgin olive...
E4-6 (Algo) Calculating Activity Rates, Assigning Costs [LO 4-3, 4.4) Fellar Corp. has identified the following information: Activity cost pools Materials handling Machine maintenance Cost drivers Number of material moves Number of machine hours $34,760 32,000 790 80,000 Required: 1. Calculate the activity rate for each cost pool. 2. Determine the amount of overhead assigned to Fellar's products if they have the following activity demands: Number of material moves Number of machine hours Product A Product B 560 230 42,000...
E4-12 Assigning Costs Using Traditional System, ABC System [LO 4-1, 4-3, 4-4, 4-5, 4-6] Bunker makes two types of briefcase, fabric and leather. The company is currently using a traditional costing system with labor hours he cost driver but is considering switching to an activity-based costing system. In preparation for the possible switch, Bunker has identified two activity cost pools: materials handling and setup. Pertinent data follow: Leather Case 11,000 Number of labor hours Number of material moves Number of...
PA4-2 (Algo) Assigning Costs Using Traditional System, Assigning Costs Using Activity Proportions (LO 4-1, 4-3, 4-5, 4-6) Carlise Corp., which manufactures ceiling fans, currently has two product lines, the Indoor and the Outdoor. Carlise has total overhead of $133,472 Carlise has identified the following information about its overhead activity cost pools and the two product lines: Cost Quantity/Amount Quantity/Amount Assigned consumed by Indoor Consumed by Outdoor Activity Cost Pools Cost Driver to Pool Line Line Materials handling Number of moves...
PA4-3 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3,4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 39 $ 67 Direct labor cost per unit 15 36 Sales price per unit 362 580 Expected production per month 760 units 300 units Harbour has monthly overhead of $181,260, which is divided into the following cost pools: Setup costs...