qattachments_5dfc4f51392bc973ca04de16ffff3da5d7a3563e.xlsx
Chapter 6: Applying Excel
Data
Manufacturing overhead
Selling and administrative overhead Manufacturing overhead
Selling and administrative overhead
Total activity OfficeMart orders:
Customers
Orders
Number of filing cabinets ordered in total
Selling price
Direct materials
Direct labor $500,000
$300,000
Assembling Processing Supporting
Units
Orders
Customers
50%
35%
5%
10%
45%
25%
1,000
250
100
units
orders customers Other
10%
20% 1 customer
4 orders
80 units
$595
$180
$50 Enter a formula into each of the cells marked with a ? below
Review Problem: Activity-Based Costing
Perform the first stage allocations Manufacturing overhead
Selling and administrative overhead
Total cost
Compute the activity rates
Activity Cost Pools
Assembling units
Processing orders
Supporting customers Assembling
Units
?
?
? Processing Supporting
Orders
Customers
?
?
?
?
?
? Total Cost
?
?
? Total Activity
? units
? orders
? customers Compute the overhead cost attributable to the OfficeMart orders
Activity Cost Pools
Activity Rate
Assembling units
? per unit
Processing orders
? per order
Supporting customers
? per customer Determine the product margin for the OfficeMart orders under a traditional cost system
Manufacturing overhead
? Total
?
?
? ?
?
? Activity Rate
? per unit
? per order
? per customer Activity
? units
? orders
? customer Determine the customer margin for the OfficeMart orders under Activity-Based Costing
Sales
?
Costs:
Direct materials
?
Direct labor
?
Unit-related overhead
?
Order-related overhead
?
Customer-related overhead
?
?
Customer margin
? Page 1 Other ABC Cost
?
?
? qattachments_5dfc4f51392bc973ca04de16ffff3da5d7a3563e.xlsx
Total activity
Manufacturing overhead per unit
Sales
Costs:
Direct materials
Direct labor
Manufacturing overhead
Traditional costing product margin ? units
? per unit
?
?
?
? Page 2 ?
?

 

• 1497933001-ch_6_Noreen_Kero.xlsx

SuperTutor

(15)

Status NEW Posted 20 Jun 2017 04:06 AM My Price 20.00

-----------

Attachments

file 1497933005-Solutions file.docx preview (56 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer