Question

In: Accounting

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 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 8 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 8? (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 8? (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 35% from 45% and the percentage attributable to supporting customers should be changed to 35% from 25%.

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

(c) Which of the following statements are true about what happens when the percentage of selling and administrative overhead attributable to processing orders declines and the percentage of selling and administrative overhead attributable to supporting customers increases by the same amount? (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.)

When the percentage of selling and administrative overhead attributable to processing orders declines and the percentage of selling and administrative overhead attributable to supporting customers increases by the same amount, costs are shifted from the processing orders cost pool to the supporting customers cost pool.unanswered

When the percentage of selling and administrative overhead attributable to processing orders declines and the percentage of selling and administrative overhead attributable to supporting customers increases by the same amount, costs will be shifted from customers who order more frequently to those who order less frequently.unanswered

When the percentage of selling and administrative overhead attributable to processing orders declines and the percentage of selling and administrative overhead attributable to supporting customers increases by the same amount, the customer margins of those who order more frequently will increase relative to the customer margins of those who order less frequently.

Solutions

Expert Solution

As per policy, we cannot able to post solution more than one question.

As per policy, we cannot able to post solution more than one question.

Assembling Units

Processing Orders

Supporting Customers

Other

Manufacture overhead (cost allocated 50:35:5:10)

250,000

175000

25000

50000

Selling and administrative overhead (cost allocated to 10:45:25:20 respectively.)

30000

135000

75000

60000

Total cost

280,000

310,000

100,000

110,000

Total activity

1,000

250

100

Cost driver rate (total cost / total activity)

$       280.00

$   1,240.00

$ 1,000.00

Selling price per unit

595

Less: direct material

180

Less: direct labor

50

Contribution margin per unit

365

Number of unit sold

80

Contribution margin (365*80)

29200

Less:

Assembling Units (280*80 units)

-22400

Processing Orders (1240*8 orders)

-9920

Supporting Customers

-1000

Customer margin under activity based costing (loss)

-4120

Correct statement

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

Number of order increase which impact on cost of processing order increase. Resulting customer margin under activity based costing is decreased.

Selling price per unit

595

Less: direct material

180

Less: direct labor

50

Less: manufacture overhead per unit (500000/1000)

500

Product margin per unit under traditional costing

-135

Selling and administration cost should not considered for product cost under traditional costing

total product margin = (-135)*1000 = (-135000)


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%...
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...
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
You are considering between two loans. Assume everything between these two loans is the same except...
You are considering between two loans. Assume everything between these two loans is the same except for the interest rate. Loan A offers 5.5% compounded weekly. Loan B offers 5.64% compounded semiannually. Which loan is better and why? Loan A because the actual rate is 5.65% is lower than Loan B’s actual rate. Loan A because 5.5% is lower than Loan B’s 5.64%. Loan B because the actual rate is 5.72% is higher than Loan A’s actual rate. Loan B...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT