2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 23. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A 1 Chapter 7: Applying Excel 2 3 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 8 Manufacturing overhead 9 Selling and administrative overhead 10 Total activity 11 12 13 OfficeMart orders: 14 Customers Data Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor 20 B $500,000 $300,000 Assembling Units 50% 10% 1,000 units с Processing Orders 23 rders 80 units $595 $180 $50 1 customer 35% 45% 250 orders D Supporting Customers 5% 25% 100 customers E Other 10% 20% F (a) What is the customer margin under activity-based costing when the number of orders increases to 23? (Enter a loss as a negative amount.) Customer margin under activity-based costing (b) What is the product margin under the traditional costing system when the number of orders increases to 23? (Enter a loss as a negative amount.) Product margin under the traditional costing system $ 10,800 3. OfficeMart has found an error in its data. The percentage of selling and administrative overhead attributable to processing orders should be changed to 30% from 45% and the percentage attributable to supporting customers should be changed to 40% from 25%. A 1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 8 Manufacturing overhead 9 Selling and administrative overhead 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 20 B $500,000 $300,000 Assembling Units 50% 10% 1,000 units C Processing Orders 23 orders 80 units $595 $180 $50 1 customer 35% 30% 250 orders D Supporting Customers 5% 40% 100 customers E Other 10% 20% F (a) Based on new number of orders in Requirement 2, what is the customer margin under activity-based costing when the data are corrected? (Enter a loss as a negative amount.) Customer margin under activity-based costing (b) Based on new number of orders in Requirement 2, what is the product margin under the traditional costing system when the data are corrected? (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 23. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A 1 Chapter 7: Applying Excel 2 3 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 8 Manufacturing overhead 9 Selling and administrative overhead 10 Total activity 11 12 13 OfficeMart orders: 14 Customers Data Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor 20 B $500,000 $300,000 Assembling Units 50% 10% 1,000 units с Processing Orders 23 rders 80 units $595 $180 $50 1 customer 35% 45% 250 orders D Supporting Customers 5% 25% 100 customers E Other 10% 20% F (a) What is the customer margin under activity-based costing when the number of orders increases to 23? (Enter a loss as a negative amount.) Customer margin under activity-based costing (b) What is the product margin under the traditional costing system when the number of orders increases to 23? (Enter a loss as a negative amount.) Product margin under the traditional costing system $ 10,800 3. OfficeMart has found an error in its data. The percentage of selling and administrative overhead attributable to processing orders should be changed to 30% from 45% and the percentage attributable to supporting customers should be changed to 40% from 25%. A 1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead 5 Selling and administrative overhead 6 7 8 Manufacturing overhead 9 Selling and administrative overhead 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 20 B $500,000 $300,000 Assembling Units 50% 10% 1,000 units C Processing Orders 23 orders 80 units $595 $180 $50 1 customer 35% 30% 250 orders D Supporting Customers 5% 40% 100 customers E Other 10% 20% F (a) Based on new number of orders in Requirement 2, what is the customer margin under activity-based costing when the data are corrected? (Enter a loss as a negative amount.) Customer margin under activity-based costing (b) Based on new number of orders in Requirement 2, what is the product margin under the traditional costing system when the data are corrected? (Enter a loss as a negative amount.) Product margin under the traditional costing system
Expert Answer:
Related Book For
Money Banking and Financial Markets
ISBN: 978-0078021749
4th edition
Authors: Stephen Cecchetti, Kermit Schoenholtz
Posted Date:
Students also viewed these accounting questions
-
Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 10. (Prior to completing this requirement, change...
-
I changed the number or filing cabinets ordered in total from 80 to 160. Which brought the ABC to 7640 and the Traditional costing product margin to -21600. A) Why has the customer margin under...
-
4 cubed + 10 X 20 + 8 squared 23
-
On April 1 of the current taxable year, Mr. Lasing Gho died leaving Php 25, 000, 000 of net distributable estate. He also left behind Tessie, his legitimate wife; Rhealyn, his legally adopted...
-
Recall Problem 5.1.9 where glass sheets have a N(3.00, 0.122) distribution. (a) What is the probability that three glass sheets placed one on top of another have a total thickness greater than 9.50...
-
Why is it less risky to steal online? Explain some of the ways criminals deceive consumers and merchants.
-
Xie Company identified the following activities, costs, and activity drivers for 2017. The company manufactures two types of go-karts: deluxe and basic. Required 1. Compute a single plantwide...
-
E-mail messages sent over the Internet are broken up into electronic packets that may take a variety of different paths to reach their destination where the original message is reassembled. Suppose...
-
4. (50 points) The goal of this simulation study is to study the relative performance of uniform search, golden section search, and parabolic interpolation (algorithms 1-3 from class notes). Fix m...
-
Colt Company reports pretax financial income of $143,000 in 2019. In addition to pretax income from continuing operations (of which revenues are $295,000), the following items are included in this...
-
According to Statistics Canada, most small businesses operate: Multiple Choice in the goods-producing sector. in the service sector. as retail businesses. as wholesalers. as construction firms.
-
How important is it that management empowers employees from a cultural and production standpoint?
-
Please rewrite this letter with any and all punctuation you feel is necessary and required. July 5 2022 Manager, Faculty Affairs ABC County College To whom it concerns I am writing to offer my...
-
Questions: How can a new manager that is working with international employees ensure she is providing reviews in an appropriate manner? What methods can a manager employ in her preparation for the...
-
Brian needs major financing for the educational software company he has founded. He is offering an equity stake of 5% in exchange for an investment of $500,000. How, why and what amount is Brian...
-
Consequences of poor management of a specified operations area such as process selection, capacity, or supply chain for the below mentioned specified service organisations? How they can be overcome?...
-
A taxpayer received an investment property from a former spouse as a result of a divorce. The former spouse had purchased the property for $100,000 several years before they got married, and the fair...
-
Record the following selected transactions for March in a two-column journal, identifying each entry by letter: (a) Received $10,000 from Shirley Knowles, owner. (b) Purchased equipment for $35,000,...
-
As an employee, would you prefer to participate in a defined-benefit pension plan or a defined-contribution pension plan? Explain your answer.
-
The European Central Bank (ECB) has translated its primary objective of price stability into an explicit, quantitative goal of keeping euro-area annual inflation close to, but below, 2 percent over...
-
Financial intermediation is not confined to bank lending but is also carried out by non-bank firms such as mutual fund companies. How do mutual funds help overcome information problems in financial...
-
How would you map out the benefits of HRP identified in the above analysis against the regulation, control and shape phases of Ulrichs (1987) model of transitions in SHRP (see Table 7.4)? You might...
-
Find the indicated critical value. z 0.03
-
Find the indicated critical value. z 0.05
Study smarter with the SolutionInn App