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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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

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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education