ease provide steps in an excel worksheet

D E C Allocate service department costs using the reciprocal and step methods (Facilities first). GIVEN User Departments Service Departments Computer Facilities Info System Program Consulting Training 50,000 $ $ 75,000 $ 110,000 $ Direct Costs 25,000 85,000 Info Systems (hrs) 500 400 1,100 600 900 1 2 Facilities (Sq Ft) 200,000 400,000 60,000 800,000 3 4 Total Cost Step Method 5 16 Total Cost Reciprocal 17 18 19 20