Use excel

Problem 2 The following information pertains to Delicious Bakery Company: GIVEN: Janitorial Dept. Cafeteria Dept. Mixing Dept.Baking Dept. Square feet 400 800 3000 2000 Number of employees 10 20 60 1001 Department cost (SAR) 600,000 1,000,000 3,000,000 4,000,000 Required: Allocate Janitorial and Cafeteria department costs to mixing and baking departments using the Direct method. Use square feet for allocating janitorial costs and number of employees for allocating cafeteria department costs