File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do &, Share & Cut 2 AutoSum - A Calibri - 11 - A A ab Wrap Text General Fill - Copy Paste BIU - - A - Merge & Center - $ . % 9 00 .0 Conditional Format as Cell Insert Delete Format Clear - Sort & Find & Share Upload Format Painter Formatting . Table - Styles . Filter . Select ~ Alignment Number Styles Cells Editing Box Clipboard Font B4 X D G H M N P Q R 4 5 Minnesota Manufacturing & Mining Company (3M) has two service departments, Human Resources (HR) Department and IT. 6 3M has two other production departments, Assembly and Finishing. The usage of the two service departments' output for the year is as follows: 7 8 User of Service Provider of Service 9 V HR IT 10 HR 15% 11 IT 10% 12 Assembly 60% 50% 13 Finishing 30% 35% 14 15 The budgeted costs in the two service departments for the year are as follows: 16 17 HR $180,000 18 IT $230,000 19 20 Required: 21 Use the step-down (sequential) method to allocate the budgeted costs of the HR and IT departments to Assembly and Finishing. 3M allocates the costs of the HR Department first. (Do not round intermediate calculations, but round end answers to the nearest dollar) 22 23 24 Assembly Finishing ar #1 # 2 #3 #4 #5 #6 #7 + Ready O Downlo. wFinal Exa.. X 611 FT F. 440F ~ ( 4) Type here to search Sign In |