Assignment4aFacultyLabVersion

Assignment4aFacultyLabVersion - $3,708,000 $3,150,000...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Pearson Interactive Computer Assignments (PICA) Assignment 4a: Activity-Based Costing, Merchandising Registered User: Yang Xu Student Number: 307198650 Activity Area August Costs August Data Supermarkets Drugstores Order processing $80,000 Annual revenue per delivery $30,900 $10,500 $1,980 Line item ordering $63,840 Average cost of goods sold per delivery $30,000 $10,000 $1,800 Store deliveries $71,000 Number of deliveries 120 300 1000 Carton deliveries $76,000 Shelf stacking $10,240 More August Data Supermarkets Drugstores Cost Driver August Volume Total number of orders 140 360 1500 Number of orders 2,000 Average number of line items per order 14 12 10 Number of line items 21,280 Average number of cartons per delivery 300 80 16 Number of store deliveries 1,420 Average hours shelf stack per delivery 3.0 0.6 0.1 Number of cartons delivered 76,000 No. of hours shelf stacking 640 Supermarkets Drugstores Overall Company 2.91% 4.76% 9.09% $136,920 $40.00 $3.00 $50.00 $1.00 $16.00 Supermarkets Drugstores Sales revenue
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $3,708,000 $3,150,000 $1,980,000 Cost of goods sold 3,600,000 3,000,000 1,800,000 Gross margin $108,000 $150,000 $180,000 Order processing costs 5,600 14,400 60,000 Line item ordering costs 5,880 12,960 45,000 Store deliveries costs 6,000 15,000 50,000 Carton deliveries costs 36,000 24,000 16,000 Shelf stacking costs 5,760 2,880 1,600 Total operating costs 59,240 69,240 172,600 Operating income (loss) $48,760 $80,760 $7,400 Required 1: Compute August gross margin %'s Required 2: Compute August operating income. Order Processing Line Item Ordering Store Deliveries Carton Deliveries Shelf Stacking Required 3: Compute the per unit cost driver application rate for each activity area. Required 4: Compute the operating income of each distribution market in August using the activity-based-costing information. Help / Self Assessment Custom Menu Same features as PICA menu command Click to use How to Formal Assessment...
View Full Document

Ask a homework question - tutors are online