Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you show how the excel formulas are done for the excel sheet Activity-based Costing Student Name: Section Number: Activity Base Number of setups Number

Can you show how the excel formulas are done for the excel sheet

image text in transcribed

Activity-based Costing Student Name: Section Number: Activity Base Number of setups Number of purchase orders Number of Inspections Number of components Activity Base Usage Data Purchase orders 760 140 900 Inspections 1,200 300 1,500 Components 500 200 700 Unit Volume 2,000 2,000 4,000 5 6 7 Activity Cost Data 8 9 Activity Activity Cost 10 Production Setup $ 44,000.00 11 Procurement $ $ 13,500.00 12 Quality Control $ 97,500.00 13 Materials Management $ 84,000.00 14 Total 239,000.00 15 16 17 18 Product Type Setups 19 Custom 290 20 Standard 110 21 Total 400 22 23 24 A) Activity Rates 25 Production Setup 26 FORMULA1 27 28 B) Unit Costs 29 Activity Base 30 Activity Usage 31 Production Setup FORMULA5 32 Procurement FORMULAS 33 Quality Control FORMULA11 34 Materials Management FORMULA14 35 Total Unit Cost 36 Unit Volume 37 Unit Cost 38 39 Answer Section Procurement FORMULA2 Quality Control Materials Management FORMULA3 FORMULA4 Custom Units Standard Units = Activity Rate FORMULA6 FORMULAS FORMULA12 FORMULA15 Activity Cost FORMULA7 FORMULA 10 FORMULA13 FORMULA 16 FORMULA17 FORMULA18 FORMULA19 Activity Base Usage FORMULA17 FORMULA20 FORMULA23 FORMULA26 Activity Rate FORMULA18 FORMULA21 FORMULA24 FORMULA27 Activity Cost FORMULA19 FORMULA22 FORMULA25 FORMULA28 FORMULA29 FORMULA30 FORMULA31

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Governmental and Nonprofit Entities

Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus

16th Edition

78110939, 978-0078110931

More Books

Students also viewed these Accounting questions