Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How would I fix the first page? I made mistakes. The second page is the directions. Thanks GlyPro Corporation Departmental Expense Allocation Spreadsheet For Month
How would I fix the first page? I made mistakes. The second page is the directions. Thanks
GlyPro Corporation Departmental Expense Allocation Spreadsheet For Month ended May 31 Allocation of Expenses to Depts Expense Service Depts Production Depts Allocation Account IT Admin Assembly Packaging Base Balance Dept Dept Dept Dept $ 506,310 $ 76,050 $ 82,470 $ 254,970 $ 92,820 assets 4,960 1,404 281 2,246 1,029 sq ft 8,220 184 689 5,511 1,837 $ 519,490 77,637 83,440 262,727 95,686 Direct expenses Indirect insurance exp Indirect utilities exp Total dept expenses Service dept expenses IT Dept Admin Dept machine hrs 660.00 clock hrs 720.00 $ 519,490 $ 78,297 $ 84,160 $ 440.00 220.00 480.00 240.00 263,647 $ 96,146 operating depts All the info in this report is dollars. Do NOT mix machine hours + clock hours with dollars. Figure the percentage that the 2 production hours consume of machine hours for IT Dept expenses ($77,637) and clock hrs for Admin Dept expenses ($83,440) and apportion them to Assembly + Packaging. did for insurance + utilities, do that; otherwise, dollars can be apportioned with a giant formula in the appropriate cells, as was shown in class. Allocate direct expenses to all 4 departments. Allocate service department expenses to the 2 production department Directions: Insurance expense: Machine Hrs IT Admin Assembly Packaging Total $4,960 Assets $ 75,000 $ 15,000 $ 120,000 $ 55,000 $ 265,000 Cost IT Dept % 28% 1404 Assembly 6% 281 Packaging 45% 2246 Total 21% 1029 100% $4,960 440 220 660 Utilities expense: % IT Admin $8,220 Sq Feet 800 3,000 24,000 8,000 35,800 2% 8% Cost Administrative Dept Clock Hrs 184 Assembly 480 689 Packaging 240 5511 Total 720 67% Assembly Packaging Total 22% 1837 100% $8,220Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started