Instructions Assignment Excel Assignment 1 Spring 2021 ACC 208 Due 3/24/21 at 11:59 pm There are two purposes to this assignment. The first purpose is to better understand and practice the calculations covered in Chapter 5. The second purpose is to practice formulas and cell referencing in Excel. On the Assignment worksheet, columns A through F contain data, and columns J through O contain tables that you are to fill in. Fill in each cell highlighted in yellow with a formula only. For example, formulas should contain cell references to the data or an arithmetic operation such as a sum or multiplication. There should be no manually entered amounts in any cell in columns through P. This assignment is worth 40 points -- 20 points for correct cell inputs and 20 points for the proper use of formulas. Each instance of a manually entered amount in a yellow highlighted cell will incur a 2 point deduction Instructions Assignment Assignment Data Estimated manufacturing overhead Estimated selling and administrative overhead 1. Perform the first stage at S550.000 $400.000 Manufacturing overhead Seling and administrative ove Total Other Manufacturing overhead Seling and administrative overhead Total estimated activity Assembling Processing Units Orders 435 35% 12% 415 4,100 1.525 order Supporting Customer 14 395 975 Gustomer 21% 14% 2. Compute the activity rates Activity Cool Pools Assembling units Processing onder Supporting customers Compute the overhead co Activity Cost Pool Assembling units Processing onder Supporting customers Olot Alvy 1.customer JO Office Martorders Customers) Orders Number of filing cabinets ordered in hotel Average selling priceperunt Direct materiale per unit Direct labor per un Total Company Activity 975 stomers 1.525 orders 4.100 un 1625 5600 $285 $95 & Determine the customer Sales Costa Director Direct labor Unt-related overhead Order related overhead Customer elled overhead Total costs Customer margin & Determine the product me Manufacturing overhead Manufacturing overhead per Costs Direct materiale Director Manufacturing overhead Totalcos Traditional conting product 6. Determine the net operatiu &c. Activity-based costing Sales Costs Direct materials Director Unded overhead Order-related overhead Customer related overhead Other overhead Total costs Net operating income 8. Traditional costing Sales revenue Cost of goods sold Direct mail Director Manufacturing overhead Total cost of goods sold Grosmarin Selling and adeve Traditional costing netoper 1. Perform the first stage allocations Asserving Units Supporting Customers Other Order Total Manufacturing overhead Selling and administrative overhead Total Other porting om IS 33% 975 21% Activity perut por Dersom 2 Compute the activity rates Activity Coat Pools Total Cow Total Activity Asembling units units Processing orders onders Supporting customers customers 2. Compute the overhead cost attributable to the Oceart orders Activity Coat Poole Activity Asembling its pert Processing orders per order Supporting customers per customer Company ABC Coat orders Customer 975 customers 1.525 Orders 4,000 5025 5.250 $95 Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales Costs: Direct mail Dired labor Unirealed overhead Order-related overhead Customer related overhead Total con Customer margin S. Determine the product margin for the Office for orders under a traditional costing system Manufacturing overhead porn Marutacturing overhead per unit Sales Costs Direct materials Direct labor Manufacturing overhead Totalco Traditional costing product in & Determine the net operating Income for ALL sale under both ABC and traditional coating systems 6a. Activity based costing Costs Direct me Director Una related overhead Order-related overheid Customer related overhead One overhead Total Net operating income 6. Traditional costing Sales revenue Cost of goods so Direct mai Direct labor Manufacturing overhead Total cost of goods sold Gross margin Soling and administrative overhead Traditional costing net operating income Instructions Assignment Excel Assignment 1 Spring 2021 ACC 208 Due 3/24/21 at 11:59 pm There are two purposes to this assignment. The first purpose is to better understand and practice the calculations covered in Chapter 5. The second purpose is to practice formulas and cell referencing in Excel. On the Assignment worksheet, columns A through F contain data, and columns J through O contain tables that you are to fill in. Fill in each cell highlighted in yellow with a formula only. For example, formulas should contain cell references to the data or an arithmetic operation such as a sum or multiplication. There should be no manually entered amounts in any cell in columns through P. This assignment is worth 40 points -- 20 points for correct cell inputs and 20 points for the proper use of formulas. Each instance of a manually entered amount in a yellow highlighted cell will incur a 2 point deduction Instructions Assignment Assignment Data Estimated manufacturing overhead Estimated selling and administrative overhead 1. Perform the first stage at S550.000 $400.000 Manufacturing overhead Seling and administrative ove Total Other Manufacturing overhead Seling and administrative overhead Total estimated activity Assembling Processing Units Orders 435 35% 12% 415 4,100 1.525 order Supporting Customer 14 395 975 Gustomer 21% 14% 2. Compute the activity rates Activity Cool Pools Assembling units Processing onder Supporting customers Compute the overhead co Activity Cost Pool Assembling units Processing onder Supporting customers Olot Alvy 1.customer JO Office Martorders Customers) Orders Number of filing cabinets ordered in hotel Average selling priceperunt Direct materiale per unit Direct labor per un Total Company Activity 975 stomers 1.525 orders 4.100 un 1625 5600 $285 $95 & Determine the customer Sales Costa Director Direct labor Unt-related overhead Order related overhead Customer elled overhead Total costs Customer margin & Determine the product me Manufacturing overhead Manufacturing overhead per Costs Direct materiale Director Manufacturing overhead Totalcos Traditional conting product 6. Determine the net operatiu &c. Activity-based costing Sales Costs Direct materials Director Unded overhead Order-related overhead Customer related overhead Other overhead Total costs Net operating income 8. Traditional costing Sales revenue Cost of goods sold Direct mail Director Manufacturing overhead Total cost of goods sold Grosmarin Selling and adeve Traditional costing netoper 1. Perform the first stage allocations Asserving Units Supporting Customers Other Order Total Manufacturing overhead Selling and administrative overhead Total Other porting om IS 33% 975 21% Activity perut por Dersom 2 Compute the activity rates Activity Coat Pools Total Cow Total Activity Asembling units units Processing orders onders Supporting customers customers 2. Compute the overhead cost attributable to the Oceart orders Activity Coat Poole Activity Asembling its pert Processing orders per order Supporting customers per customer Company ABC Coat orders Customer 975 customers 1.525 Orders 4,000 5025 5.250 $95 Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales Costs: Direct mail Dired labor Unirealed overhead Order-related overhead Customer related overhead Total con Customer margin S. Determine the product margin for the Office for orders under a traditional costing system Manufacturing overhead porn Marutacturing overhead per unit Sales Costs Direct materials Direct labor Manufacturing overhead Totalco Traditional costing product in & Determine the net operating Income for ALL sale under both ABC and traditional coating systems 6a. Activity based costing Costs Direct me Director Una related overhead Order-related overheid Customer related overhead One overhead Total Net operating income 6. Traditional costing Sales revenue Cost of goods so Direct mai Direct labor Manufacturing overhead Total cost of goods sold Gross margin Soling and administrative overhead Traditional costing net operating income