2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 14. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A 1 Chapter 5: Applying Excel 2 3 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 Data 8 Manufacturing overhead 9 10 11 12 13 OfficeMart orders: 14 Customers 15 Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor Selling and administrative overhead Total activity $ $ Customer margin under activity-based costing $ 69 B $ $ $ 500,000 300,000 Assembling Units 50% 10% 1,000 units C Processing Orders 1 customer 14 orders 80 units 595 180 50 35% 45% 250 orders D Supporting Customers 5% 25% 100 customers E Other 10% 20% (a) What is the customer margin under activity-based costing when the number of orders increases to 14? (Enter a loss as a negative amount.)
2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 14. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A 1 Chapter 5: Applying Excel 2 3 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 Data 8 Manufacturing overhead 9 10 11 12 13 OfficeMart orders: 14 Customers 15 Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor Selling and administrative overhead Total activity $ $ Customer margin under activity-based costing $ 69 B $ $ $ 500,000 300,000 Assembling Units 50% 10% 1,000 units C Processing Orders 1 customer 14 orders 80 units 595 180 50 35% 45% 250 orders D Supporting Customers 5% 25% 100 customers E Other 10% 20% (a) What is the customer margin under activity-based costing when the number of orders increases to 14? (Enter a loss as a negative amount.)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![(b) What is the product margin under the traditional costing system when the number of orders increases to 14? (Enter a loss as a
negative amount.)
Product margin under the traditional costing system](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F08be8c2a-26bf-4448-b03e-e9a40efe2e8f%2Fba03583c-3785-40dc-a7bf-d988fa5d63d8%2Fslpqfms_processed.png&w=3840&q=75)
Transcribed Image Text:(b) What is the product margin under the traditional costing system when the number of orders increases to 14? (Enter a loss as a
negative amount.)
Product margin under the traditional costing system
![2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the
number of orders from 4 to 14. (Prior to completing this requirement, change all worksheet figures back to their original amounts.)
1 Chapter 5: Applying Excel
2
Data
A
3
4 Manufacturing overhead
5 Selling and administrative overhead
6
7
8 Manufacturing overhead
Selling and administrative overhead
9
10 Total activity
11
12
13 OfficeMart orders:
14 Customers
15 Orders
16 Number of filing cabinets ordered in total
17 Selling price
18 Direct materials
19 Direct labor
Customer margin under activity-based costing $
69
B
$ 500,000
$ 300,000
Assembling
Units
$
$
$
50%
10%
1,000
units
с
Processing
Orders
1 customer
14 orders
80 units
595
180
50
35%
45%
250
orders
D
Supporting
Customers
5%
25%
100
customers
E
Other
(a) What is the customer margin under activity-based costing when the number of orders increases to 14? (Enter a loss as a negative
amount.)
10%
20%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F08be8c2a-26bf-4448-b03e-e9a40efe2e8f%2Fba03583c-3785-40dc-a7bf-d988fa5d63d8%2F8sim3zd_processed.png&w=3840&q=75)
Transcribed Image Text:2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the
number of orders from 4 to 14. (Prior to completing this requirement, change all worksheet figures back to their original amounts.)
1 Chapter 5: Applying Excel
2
Data
A
3
4 Manufacturing overhead
5 Selling and administrative overhead
6
7
8 Manufacturing overhead
Selling and administrative overhead
9
10 Total activity
11
12
13 OfficeMart orders:
14 Customers
15 Orders
16 Number of filing cabinets ordered in total
17 Selling price
18 Direct materials
19 Direct labor
Customer margin under activity-based costing $
69
B
$ 500,000
$ 300,000
Assembling
Units
$
$
$
50%
10%
1,000
units
с
Processing
Orders
1 customer
14 orders
80 units
595
180
50
35%
45%
250
orders
D
Supporting
Customers
5%
25%
100
customers
E
Other
(a) What is the customer margin under activity-based costing when the number of orders increases to 14? (Enter a loss as a negative
amount.)
10%
20%
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education