please help with requirements 1-3

ET5-21 (similar to Best Books an online book retalec has two cperating departments-corporate sales and consumer sales-and two support nformation systems. Each sales department conducts merchandising and marketing operations independently. Best Books uses number of emplayees to alocate human resources costs and processing time to allocate information systems costs. The follawing data are available for September 2017: n resources and Click the icon to view the data) Read the requirements Requirement 1. Allocate the support departments costs to the operating departments using the direct method (Do not round intermediary calculations. Only round the amount you input in the cell to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0 for any zero balances. Abbrevistions used HR Human resources; Info Information) Support Departments Operating Departments Info. Systems Corporate Consumer HR Tetal Costs incurred Alecation of HR costa Alocation of Info. System costs Total budgeted costs of operating departments Data Table Support Departments Human Information Corporate Consumer Resources Systems Sales Budgeted costs incurred before any interdepartment cost allocstions Support work supplied by human rescurces departmen 000 220.000 970,000465,000 Budgeted number of employees Support work supplied by information aystems department 20 50 30 Budgeted processing time in minutes 440 2,000 1,560 Print Done