Homework Help is Here – Start Your Trial Now!
Business
Accounting
G H K. L M Activity Production Setup Procurement Quality Control Materials Management Activity Cost %24 2$ 2$ 2$ 2$ Activity Base Number of setups 44,000.00 13,500.00 Number of purchase orders 97,500.00 Number of Inspections Number of components 84,000.00 Total 239,000.0O Activity Base Usage Data Product Type Custom Standard Total Setups Purchase orders Inspections 1,200 Components 500 Unit Volume 290 760 2,000 110 140 300 200 2,000 400 900 1,500 700 4,000 Answer Section A) Activity Rates Production Setup Procurement Quality Control Materials Management FORMULA1 FORMULA2 FORMULA3 FORMULA4 B) Unit Costs Custom Units Standard Units Activity Base Usage Activity Base Usage Activity Cost Activity Rate FORMULA18 Activity Rate Activity Cost Activity Production Setup Procurement Quality Control Materials Management Total Unit Cost Unit Volume Unit Cost FORMULA5 FORMULA6 FORMULA7 FORMULA17 FORMULA19 FORMULA8 FORMULA9 FORMULA10 FORMULA20 FORMULA21 FORMULA22 FORMULA25 FORMULA24 FORMULA27 FORMULA11 FORMULA12 FORMULA13 FORMULA23 FORMULA14 FORMULA15 FORMULA16 FORMULA26 FORMULA28 FORMULA17 FORMULA29 FORMULA18 FORMULA30 FORMULA19 FORMULA31

G H K. L M Activity Production Setup Procurement Quality Control Materials Management Activity Cost %24 2$ 2$ 2$ 2$ Activity Base Number of setups 44,000.00 13,500.00 Number of purchase orders 97,500.00 Number of Inspections Number of components 84,000.00 Total 239,000.0O Activity Base Usage Data Product Type Custom Standard Total Setups Purchase orders Inspections 1,200 Components 500 Unit Volume 290 760 2,000 110 140 300 200 2,000 400 900 1,500 700 4,000 Answer Section A) Activity Rates Production Setup Procurement Quality Control Materials Management FORMULA1 FORMULA2 FORMULA3 FORMULA4 B) Unit Costs Custom Units Standard Units Activity Base Usage Activity Base Usage Activity Cost Activity Rate FORMULA18 Activity Rate Activity Cost Activity Production Setup Procurement Quality Control Materials Management Total Unit Cost Unit Volume Unit Cost FORMULA5 FORMULA6 FORMULA7 FORMULA17 FORMULA19 FORMULA8 FORMULA9 FORMULA10 FORMULA20 FORMULA21 FORMULA22 FORMULA25 FORMULA24 FORMULA27 FORMULA11 FORMULA12 FORMULA13 FORMULA23 FORMULA14 FORMULA15 FORMULA16 FORMULA26 FORMULA28 FORMULA17 FORMULA29 FORMULA18 FORMULA30 FORMULA19 FORMULA31

Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter11: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 11.18E
See similar textbooks
icon
Related questions
Question
The instructions for this practice worksheet are in the first picture (2 word document) - the second picture has the excel worksheet to input answers. I’m having a difficult time understanding how to do this - thank you!
EMicrg9e ot Center Insert Dele lohal Format as Formatting Table - Styles 00 Cll Clipboard Font - Alignment Number Styles Cel B7 Activity Cost Data A B D H 8 K L 9. Activity Production Setup Procurement Activity Cost %24 24 24 Activity Base Number of setups 10 44,000.00 11 13,500.00 97,500.00 Number of purchase orders Number of Inspections Number of components 12 Quality Control Materials Management Total 13 2$ 84,000,00 14 239,000.00 15 16 Activity Base Usage Data 17 18 Product Type Setups Purchase orders Inspections Components Unit Volume 19 Custom 290 760 1,200 500 2,000 20 Standard Total 110 140 300 200 2,000 21 400 900 1,500 700 4,000 22 23 Answer Section 24 A) Activity Rates 25 Production Setup Procurement Quality Control Materials Management 26 FORMULA1 FORMULA2 FORMULA3 FORMULA4 27 B) Unit Costs 28 29 Custom Units Standard Units Activity Base Usage Activity Base Usage Activity Rate FORMULA18 30 Activity Rate Activity Cost Activity Cost Activity Production Setup 32 %3D 31 FORMULA5 FORMULA6 FORMULA7 FORMULA17 FORMULA19 FORMULA22 Procurement 33 Quality Control Materials Management 35 FORMULA8 FORMULA9 FORMULA10 FORMULA2O FORMULA21 FORMULA11 FORMULA12 FORMULA13 FORMULA23 FORMULA24 FORMULA25 34 FORMULA14 FORMULA15 FORMULA16 FORMULA26 FORMULA27 FORMULA28 FORMULA17 FORMULA29 Total Unit Cost Unit Volume Unit Cost 36 FORMULA18 FORMULA30 FORMULA19 FORMULA31 37 38 39 Sheet1 + P Type here to search 99+
Transcribed Image Text:EMicrg9e ot Center Insert Dele lohal Format as Formatting Table - Styles 00 Cll Clipboard Font - Alignment Number Styles Cel B7 Activity Cost Data A B D H 8 K L 9. Activity Production Setup Procurement Activity Cost %24 24 24 Activity Base Number of setups 10 44,000.00 11 13,500.00 97,500.00 Number of purchase orders Number of Inspections Number of components 12 Quality Control Materials Management Total 13 2$ 84,000,00 14 239,000.00 15 16 Activity Base Usage Data 17 18 Product Type Setups Purchase orders Inspections Components Unit Volume 19 Custom 290 760 1,200 500 2,000 20 Standard Total 110 140 300 200 2,000 21 400 900 1,500 700 4,000 22 23 Answer Section 24 A) Activity Rates 25 Production Setup Procurement Quality Control Materials Management 26 FORMULA1 FORMULA2 FORMULA3 FORMULA4 27 B) Unit Costs 28 29 Custom Units Standard Units Activity Base Usage Activity Base Usage Activity Rate FORMULA18 30 Activity Rate Activity Cost Activity Cost Activity Production Setup 32 %3D 31 FORMULA5 FORMULA6 FORMULA7 FORMULA17 FORMULA19 FORMULA22 Procurement 33 Quality Control Materials Management 35 FORMULA8 FORMULA9 FORMULA10 FORMULA2O FORMULA21 FORMULA11 FORMULA12 FORMULA13 FORMULA23 FORMULA24 FORMULA25 34 FORMULA14 FORMULA15 FORMULA16 FORMULA26 FORMULA27 FORMULA28 FORMULA17 FORMULA29 Total Unit Cost Unit Volume Unit Cost 36 FORMULA18 FORMULA30 FORMULA19 FORMULA31 37 38 39 Sheet1 + P Type here to search 99+
12 A A Aa - 外们 AaBbCcDd AaBbCcDd AaBbC AaBbCcC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd O Find BIU * abe X x A - ay - 1 Normal 1 No Spac. Heading 1 Heading 2 * Rep Title Subtitle Subtle Em. Emphasis Intense E.. Font Sele Paragraph 3 I 4 5 I 6. 7 . 1. I 2. . Styles Editin Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #2 Inputs Activity Cot D Section Number A Cont 50.000.00 60.000.00 120,000.00 50.000.00 280.000 00 Activty Prodction Setup Procur ement Quality Control Materials Munagement Total Actity Bane Number of seups Nmber of purchae orders Nmter of Innpections Namter of components Activty BaeU D Data set #1 Preduct Type Cuntom Standard Total Purchane orders 700 100 800 Setupe Inspecions 1,000 500 1600 Components 400 400 Unit Volume 500 3.000 2.000 200 Inputs: Activity Coet Data Section Number Check figure (custom per unit cost): Activity Production Setup Procurement Quality Control Materials Man agement Activity Cost 44.000.00 13.500.00 Activity Base Number of setups Number of purchase orders Number of Inspections Number of components 64.40 97.500.00 84,000.00 239,000.00 Total Data set #3 Activity Bane Unge Data Product Type Setups Purchase orders 760 Inspections Components 500 Inputs Uhit Volume 290 Custom Standard Total 1.200 300 2.000 2.000 4,000 110 Activity Cost Data Section Number 140 900 200 700 400 1500 Activity Co 80,000.00 Activity Prodection Setup Procurement Quality Control Materials Management Total Activity Base Number of setups Number of purchaseorders Number of Inapections 40.000.00 Number of components Check figure (custom per unit cost): 90.000.00 100,000 00 90.65 310,000 00 Activity Bane Uge Data Product Type Setupa Purchase orders 700 500 Components 400 Uhit Volume 3,000 Inmpection Custom Standard Total 500 200 700 1,000 900 1.900 400 4.000 1200 7.000 Check figure (custom per unit cost): 24 60.76 o search O CE (99+
Transcribed Image Text:12 A A Aa - 外们 AaBbCcDd AaBbCcDd AaBbC AaBbCcC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd O Find BIU * abe X x A - ay - 1 Normal 1 No Spac. Heading 1 Heading 2 * Rep Title Subtitle Subtle Em. Emphasis Intense E.. Font Sele Paragraph 3 I 4 5 I 6. 7 . 1. I 2. . Styles Editin Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #2 Inputs Activity Cot D Section Number A Cont 50.000.00 60.000.00 120,000.00 50.000.00 280.000 00 Activty Prodction Setup Procur ement Quality Control Materials Munagement Total Actity Bane Number of seups Nmber of purchae orders Nmter of Innpections Namter of components Activty BaeU D Data set #1 Preduct Type Cuntom Standard Total Purchane orders 700 100 800 Setupe Inspecions 1,000 500 1600 Components 400 400 Unit Volume 500 3.000 2.000 200 Inputs: Activity Coet Data Section Number Check figure (custom per unit cost): Activity Production Setup Procurement Quality Control Materials Man agement Activity Cost 44.000.00 13.500.00 Activity Base Number of setups Number of purchase orders Number of Inspections Number of components 64.40 97.500.00 84,000.00 239,000.00 Total Data set #3 Activity Bane Unge Data Product Type Setups Purchase orders 760 Inspections Components 500 Inputs Uhit Volume 290 Custom Standard Total 1.200 300 2.000 2.000 4,000 110 Activity Cost Data Section Number 140 900 200 700 400 1500 Activity Co 80,000.00 Activity Prodection Setup Procurement Quality Control Materials Management Total Activity Base Number of setups Number of purchaseorders Number of Inapections 40.000.00 Number of components Check figure (custom per unit cost): 90.000.00 100,000 00 90.65 310,000 00 Activity Bane Uge Data Product Type Setupa Purchase orders 700 500 Components 400 Uhit Volume 3,000 Inmpection Custom Standard Total 500 200 700 1,000 900 1.900 400 4.000 1200 7.000 Check figure (custom per unit cost): 24 60.76 o search O CE (99+
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Documentation techniques
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
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS