HOME DATA VIEW * Cut Font Name Font Size . TabStop 2 Wrap Text E "Insert Column " Delete Column 3 Insert Row Delete Row Paste Copy Bida & us overline Merge Cell CLICK HERE TO SAVE YOUR WORK A24 A B C D E F G H 1 Saving your work for grading: 2 1. Press the yellow button above to save your work. 3 2. A link to your spreadsheet will be placed in the clipboard. 4 3. Click the Moodle tab and follow the instructions to paste your link for grading. 5 4. If you make changes to your spreadsheet, click the yellow button to save. 6 5. There is NO need to paste another link to your spreadsheet. 7 SAVE YOUR WORK PERIODICALLY 8 9 Broadway Department Store allocates the HR and IT department's costs to the sales departments of Shoes, and Clothing. 10 HR costs are allocated by number of employees, and IT costs are allocated by support minutes. 11 HR and IT also provide services to each other. Costs and other information for January were as follows: 12 13 HR IT Shoes Clothing 14 Department Costs $ 13,800 $ 6,400 $ 24,400 $ 40,000 5 Support minutes 3,000 4,500 7,500 16 Number of employees 3 5 12 17 18 Required: 19 Allocate service costs using the step-down method with the sequence of allocation based on highest percentage support conce 20 21 22 23