Homework Help is Here – Start Your Trial Now!
Business
Accounting
1 Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing 2 3 E14.2a - Using Excel to Allocate Support Department Costs Using the Direct Method PROBLEM 5 The Screamin' Eagles Company makes wheels and wings for ground transport vehicles and drones. In 6 addition to the key manufacturing departments, Screamin' Eagles needs two key support services, provided 7 by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on 8 the square footage of space each department occupies. The IT department allocates its costs to other 9 departments based on the amount of time the IT employees spend assisting the other departments. The 10 cost information of all four departments, along with their usage information for both allocation bases, is as 11 follows: 12 13 14 15 16 17 18 19 20 21 22 23 Initial cost Square feet occupied IT labor hours used Support Departments Maintenance Operating Departments Wheels Wings IT Totals $ 125,000 $80,000 $415,000 $ 650,000 $1,270,000 1,200 2,000 1,000 2,400 2,850 5,600 2,150 11,200 6,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Allocate the support department costs using the direct method to determine the total costs for which each operating department should be accountable. Initial cost Allocations: Maintenance IT Total Support Departments Maintenance $ 125,000 $80,000 $ (125,000) (80,000) $ Operating Departments Wheels Wings Totals 415,000 $ 650,000 $1,270,000 37,500 87,500 45,600 34,400 498,100 $ 771,900 $1,270,000

1 Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing 2 3 E14.2a - Using Excel to Allocate Support Department Costs Using the Direct Method PROBLEM 5 The Screamin' Eagles Company makes wheels and wings for ground transport vehicles and drones. In 6 addition to the key manufacturing departments, Screamin' Eagles needs two key support services, provided 7 by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on 8 the square footage of space each department occupies. The IT department allocates its costs to other 9 departments based on the amount of time the IT employees spend assisting the other departments. The 10 cost information of all four departments, along with their usage information for both allocation bases, is as 11 follows: 12 13 14 15 16 17 18 19 20 21 22 23 Initial cost Square feet occupied IT labor hours used Support Departments Maintenance Operating Departments Wheels Wings IT Totals $ 125,000 $80,000 $415,000 $ 650,000 $1,270,000 1,200 2,000 1,000 2,400 2,850 5,600 2,150 11,200 6,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Allocate the support department costs using the direct method to determine the total costs for which each operating department should be accountable. Initial cost Allocations: Maintenance IT Total Support Departments Maintenance $ 125,000 $80,000 $ (125,000) (80,000) $ Operating Departments Wheels Wings Totals 415,000 $ 650,000 $1,270,000 37,500 87,500 45,600 34,400 498,100 $ 771,900 $1,270,000

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter25: Segment Income Statement (dept)
Section: Chapter Questions
Problem 2R
See similar textbooks
icon
Related questions
Question
C Home Insert Draw Page Layout 4 Cut [Copy ✓ AutoSave 12345 Paste A Format B Calibri (Body) B I U v Ready Initial cost Square feet occupied IT labor hours used C V V Formulas Data Review View X Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A1 : fx Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing Enter Answer + 12 D 1 Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing Accessibility: Investigate Support Departments Maintenance V V A^ A 2,000 1,000 E14.2a - Using Excel to Allocate Support Department Costs Using the Direct Method PROBLEM 5 The Screamin' Eagles Company makes wheels and wings for ground transport vehicles and drones. In 6 addition to the key manufacturing departments, Screamin' Eagles needs two key support services, provided 7 by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on 8 the square footage of space each department occupies. The IT department allocates its costs to other 9 departments based on the amount of time the IT employees spend assisting the other departments. The 10 cost information of all four departments, along with their usage information for both allocation bases, is as 11 follows: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 E F Operating Departments Wheels Wings IT Totals $ 125,000 $80,000 $ 415,000 $ 650,000 $1,270,000 1,200 2,400 5,600 2,850 2,150 G Automate Acrobat 11,200 6,000 H ab Wrap Text v Merge & Center v I J K Initial cost Allocations: Maintenance IT Tell me Total Text X Excel AssignmentChapter14_Question2 → $ % V L ←.0 .00 →.0 M Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Support Departments Maintenance $ 125,000 $ (125,000) Conditional Format Cell Formatting as Table Styles Allocate the support department costs using the direct method to determine the total costs for which each operating department should be accountable. IT 80,000 $ (80,000) V N $ O 37,500 45,600 Operating Departments Wheels Wings Totals 415,000 $ 650,000 $1,270,000 498,100 $ Insert Delete Format P 87,500 34,400 771,900 $ 1,270,000 Q R Σ Autosum v ↓↓Fill v Clear v S T APO Sort & Filter U V Find & Select V Sensitivity W Analyze Data X 13 Al Y Comments Create PDF and share link Z Share AA Restart Now AB BOD + 100%
Transcribed Image Text:C Home Insert Draw Page Layout 4 Cut [Copy ✓ AutoSave 12345 Paste A Format B Calibri (Body) B I U v Ready Initial cost Square feet occupied IT labor hours used C V V Formulas Data Review View X Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A1 : fx Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing Enter Answer + 12 D 1 Function: SUM; Formulas: Add; Multiply; Divide; Cell Referencing Accessibility: Investigate Support Departments Maintenance V V A^ A 2,000 1,000 E14.2a - Using Excel to Allocate Support Department Costs Using the Direct Method PROBLEM 5 The Screamin' Eagles Company makes wheels and wings for ground transport vehicles and drones. In 6 addition to the key manufacturing departments, Screamin' Eagles needs two key support services, provided 7 by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on 8 the square footage of space each department occupies. The IT department allocates its costs to other 9 departments based on the amount of time the IT employees spend assisting the other departments. The 10 cost information of all four departments, along with their usage information for both allocation bases, is as 11 follows: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 E F Operating Departments Wheels Wings IT Totals $ 125,000 $80,000 $ 415,000 $ 650,000 $1,270,000 1,200 2,400 5,600 2,850 2,150 G Automate Acrobat 11,200 6,000 H ab Wrap Text v Merge & Center v I J K Initial cost Allocations: Maintenance IT Tell me Total Text X Excel AssignmentChapter14_Question2 → $ % V L ←.0 .00 →.0 M Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Support Departments Maintenance $ 125,000 $ (125,000) Conditional Format Cell Formatting as Table Styles Allocate the support department costs using the direct method to determine the total costs for which each operating department should be accountable. IT 80,000 $ (80,000) V N $ O 37,500 45,600 Operating Departments Wheels Wings Totals 415,000 $ 650,000 $1,270,000 498,100 $ Insert Delete Format P 87,500 34,400 771,900 $ 1,270,000 Q R Σ Autosum v ↓↓Fill v Clear v S T APO Sort & Filter U V Find & Select V Sensitivity W Analyze Data X 13 Al Y Comments Create PDF and share link Z Share AA Restart Now AB BOD + 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost allocation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS