80.2K

Verified Solution

Link Copied!

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%
9	Selling and administrative overhead	10%	45%	25%	20%
10	Total activity	1,000	250	100
11		units	orders	customers
12
13	OfficeMart orders:
14	Customers	1	customer
15	Orders	16	orders
16	Number of filing cabinets ordered in total	80	units
17	Selling price	$595
18	Direct materials	$180
19	Direct labor	$50
20

(a) What is the customer margin under activity-based costing when the number of orders increases to 16? (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 16? (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 a check mark for correct answers and double click to empty the box for the wrong answers.)

	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 decrease.
	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.
	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.

Answer & Explanation Solved by verified expert

See Answer