1.

2.

August 6,500 $ 617,500 370, 500 247,000 September 7,000 $ 665,000 399,000 266,000 For the Three Months Ended September 30 July Sales in units 6,000 Sales $570,000 Cost of goods sold 342,000 Gross margin 228,000 Selling and administrative expenses: Advertising expense 26,200 Shipping expense 58,000 Salaries and commissions 110,000 Insurance expense 8,450 Depreciation expense 17,900 Total selling and administrative expenses 220,550 Net operating income 7,450 26,200 61,600 116,800 8,450 17,900 230,950 $ 16,05 26,200 65,200 123,600 8,450 17,900 241, 350 $ 24,650 Required: 1. By analyzing the data from the company's income statements, classify each of its expenses (including cost of goods sold) as either variable, fixed, or mixed. 2. Using the high-low method, separate each mixed expense into variable and fixed elements. Express the variable and fixed portions of each mixed expense in the form Y = a + bx. 3. Redo the company's income statement at the 7,000-unit level of activity using the contribution format. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Using the high-low method, separate each mixed expense into variable and fixed elements. Express the variable and fixed portions of each mixed expense in the form Y = a + bx. (Round the Variable cost per unit to 1 decimal place.) Fixed Cost Formula Variable Cost per unit Y = per unit Y = Required 1 Required 2 Required 3 Redo the company's income statement at the 7,000-unit level of activity using the contribution format. Morrisey & Brown, Ltd. Income Statement For the Month Ended September 30 Variable expenses 0 0 Fixed expenses 0 S 0 SecuriCorp operates a fleet of armored cars that make scheduled pickups and deliveries in the Los Angeles area. The company is implementing an activity-based costing system that has four activity cost pools: Travel, Pickup and Delivery, Customer Service, and Other. The activity measures are miles for the Travel cost pool, number of pickups and deliveries for the Pickup and Delivery cost pool, and number of customers for the Customer Service cost pool. The Other cost pool has no activity measure because it is an organization-sustaining activity. The following costs will be assigned using the activity-based costing system: Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost $ 1,180,000 610,000 490,000 520,000 380,000 680,000 $ 3,860,000 The distribution of resource consumption across the activity cost pools is as follows: Travel 50% 70% 60% Pickup and Delivery 35% 5% 15% Customer Service 10% 0% Other 5% 25% 25% Totals 100% 100% 100% Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses 0% 0% 0% 20% 5% 90% 30% 60% 10% 50% 35% 100% 100% 100% Required: Complete the first stage allocations of costs to activity cost pools. Pickup and Delivery Customer Service Travel Other Totals s 0 0 Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses 0 0 0 0 Total cost S 0 S 0 S 0 S 0 S