Question

In: Accounting

2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your...

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 11. (Prior to completing this requirement, change all worksheet figures back to their original amounts.)

A

B

C

D

E

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

Chapter 5: Applying Excel
Data
Manufacturing overhead $500,000
Selling and administrative overhead $300,000
Assembling Units Processing Orders Supporting Customers Other
Manufacturing overhead 50% 35% 5% 10%
Selling and administrative overhead 10% 45% 25% 20%
Total activity 1,000 250 100
units orders customers
OfficeMart orders:
Customers 1 customer
Orders 11 orders
Number of filing cabinets ordered in total 80 units
Selling price $595
Direct materials $180
Direct labor $50

(a) What is the customer margin under activity-based costing when the number of orders increases to 11? (Enter a loss as a negative amount.)

(b) What is the product margin under the traditional costing system when the number of orders increases to 11? (Enter a loss as a negative amount.)

(c) Which of the following statements are true? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

If a customer orders more frequently, but orders the same total number of units over the course of a year, the customer margin under activity based costing will decrease.unanswered

  • If a customer orders more frequently, but orders the same total number of units over the course of a year, the product margin under a traditional costing system will decrease.unanswered
  • If a customer orders more frequently, but orders the same total number of units over the course of a year, the customer margin under activity based costing will be unaffected.unanswered
  • If a customer orders more frequently, but orders the same total number of units over the course of a year, the product margin under a traditional costing system will be unaffected.unanswered

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

B

C

D

E

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

Chapter 5: Applying Excel
Data
Manufacturing overhead $500,000
Selling and administrative overhead $300,000
Assembling Units Processing Orders Supporting Customers Other
Manufacturing overhead 50% 35% 5% 10%
Selling and administrative overhead 10% 30% 40% 20%
Total activity 1,000 250 100
units orders customers
OfficeMart orders:
Customers 1 customer
Orders 11 orders
Number of filing cabinets ordered in total 80 units
Selling price $595
Direct materials $180
Direct labor $50

(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.)

(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.)

Solutions

Expert Solution

QUESTION 2

a). Activity-based costing

Cost allocation:

Accounting units Processing units Supporting customers Other Total
Manufacturing 250000 175000 25000 50000 500000
S&A 30000 135000 75000 60000 300000
Total 280000 310000 100000 110000 800000

Activity rates

Assembling units = 280000 / 1,000 units = $280 per unit
Processing orders = 310000 / 250 orders = $1240 per order
Supporting customers = 100000 / 100 customers = $1000 per customer

Sales(80 x 595) 47600
Costs: Direct material(80 x 180) 14400
Direct Labor(80 x 50) 4000
Assembling units(80 x 280) 22400
Processing units(11 x 1240) 13,640
Supporting documents(1 x 1000) 1000
Activity-based consumer margin (7840)

b) Traditional based

Manufacturing Overhead per unit = 500000 / 1000 orders = 500 per unit

Sales(80 x 595) 47600
Costs: Direct material(80 x 180) 14400
Direct Labor(80 x 50) 4000
Manufacturing overheads(80 x 500) 40000
Activity-based consumer margin (10800)
c) Option A and D are correct
If a customer orders more frequently, but orders the same total number of units over the course of a year, the customer margin under activity-based costing will decrease.
If a customer orders more frequently, but orders the same total number of units over the course of a year, the product margin under a traditional costing system will be unaffected.

Question 3

a). Activity based costing

Cost alloaction:

Accounting units Processing units Supporting cutomers Other Total
Manufacturing 250000 175000 25000 50000 500000
S&A 30000 90000 120000 60000 300000
Total 280000 265000 145000 110000 800000

Activity rates

Assembling units = 280000 / 1,000 units = $280 per unit
Processing orders = 265000 / 250 orders = $1060 per order
Supporting customers = 145000 / 100 customers = $1450 per customer

Sales(80 x 595) 47,600
Costs: Direct material(80 x 180) 14,400
Direct Labor(80 x 50) 4,000
Assembling units(80 x 280) 22400
Processing units(11 x 1060) 11,660
Supporting documents(1 x 1450) 1,450
Activity based consumer margin (6,310)

b) Traditional based

Manufacturing Overhead per unit = 500000 / 1000 orders = 500 per unit

Sales(80 x 595) 47,600
Costs: Direct material(80 x 180) 14,400
Direct Labor(80 x 50) 4,000
Manufacturing overheads(80 x 500) 40,000
Activity-based consumer margin (10,800)

Related Solutions

Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet...
Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 16. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A B C D E F 1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead $500,000 5 Selling and administrative overhead $300,000 6    7 Assembling Units Processing Orders Supporting Customers Other 8 Manufacturing overhead 50% 35% 5% 10%...
Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet...
Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 8. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Chapter : Applying Excel Data Manufacturing overhead $500,000 Selling and administrative overhead $300,000 Assembling Units Processing Orders...
If someone keeps everything else in their data the same but decides to use an alpha...
If someone keeps everything else in their data the same but decides to use an alpha of .10 instead of .05 explain exactly if/how each the following would change (i.e., increase/decrease/stay the same) and briefly explain why for each [10 line maximum] : • critical rejection region • chance of making a Type I error • change of make a Type II error • the width of a confidence interval • the effect size
Everything else being the same, what is the effect of an increase in interest rates on...
Everything else being the same, what is the effect of an increase in interest rates on the price level? Discuss the process of adjustment to the new equilibrium.
Which of the following will probably NOT result in an improved current account balance (assuming everything else remains constant)?
6 Which of the following will probably NOT result in an improved current account balance (assuming everything else remains constant)? a. a decrease in a country's national income level b. a decrease in a country's rate of inflation c. an increase in government restrictions in the form of tariffs or quotas d. an appreciation of a country's currency 2 points7 Under a managed float exchange rate system, the Fed may attempt to stimulate the U.S. economy by ____ the dollar. Such...
If the number of discouraged searchers increases, everything else remaining the same, then the Answers: employment...
If the number of discouraged searchers increases, everything else remaining the same, then the Answers: employment rate decreases. unemployment rate increases. labour force participation rate decreases. labour force participation rate increases. employment rate increases.
1. If fixed costs increased and everything else the same , the contribution margin would increase...
1. If fixed costs increased and everything else the same , the contribution margin would increase cannot tell remain the same decrease 2. Part of the cost is variable and part is fixed variable cost mixed cost fixed cost constant cost 3. What would cause the break-even point to increase? variable costs go up variable costs go down Fixed price go down contribution margin goes up 4. Which would you find on an absorption costing income statement? Contribution margin fixed...
Assume that we observe both imports and exports declining in a particular economy. Everything else remaining...
Assume that we observe both imports and exports declining in a particular economy. Everything else remaining the same: Select one: a. we would expect no change in aggregate demand but aggregate supply should fall. b. it is impossible to determine what will happen. c. we would expect no change in aggregate demand but aggregate supply should rise. d. we would expect aggregate demand to rise. e. we would expect aggregate demand to fall.
When the price of gasoline rises by 40 percent, but your salary remains the same, it...
When the price of gasoline rises by 40 percent, but your salary remains the same, it is an example of a decline in your: standard of living purchasing power GDP index cost of living index gross economic income
How do I make this code print the st variable rounded to 2 decimal places? Everything...
How do I make this code print the st variable rounded to 2 decimal places? Everything I have tried gives me an error. print('Enter output filename') name=input() print('Enter principal amount') p=float(input()) print('Enter term length (month)') n=int(input()) print('Enter annual interest') i=float(input()) j=i/12 m=p*j/(1-(1+j)**-n) file = open(name, "w") title = ["Month, ", "Total Accured interest, ", "Loan Balance \n"] file.writelines(title) first_row=["0",",","$","0.00",",","$",p," \n"] s1=' '.join([str(elem) for elem in first_row]) file.writelines(s1) t=0 for j in range(n): tai=(p*i/12) t=t+tai p=(p-m)+tai st="" ls=[j+1,",","$",t,",","$",p,"\n"] st=''.join([str(elem) for elem...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT