Description
Hello,
Please answer the attached Excel Spreadsheets then save and upload them with the completed answers.
After saving the Excel Spreadsheet please refer to the word document for instructions to complete the word documents. You will have to utilized the attached spreadsheets to answer the questions from the word documents.
Please let me know if you have any questions, and thanks in advance.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
20170417234307chap_7.xlsx
Chapter 7: 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.350
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
$ 250.000
30.000
$ 280.000
Total Cost
$280.000
$310.000
$100.000
Processing
Orders
$ 175.000
135.000
$ 310.000
$ 310.000
Supporting
Customers
$ 25.000
75.000
$ 100.000
Total Activity
1.000 units
250 orders
100 customers
Compute the overhead cost attributable to the OfficeMart orders
Activity Cost Pools
Activity Rate
Assembling units
$280 per unit
Processing orders
$1.240 per order
Supporting customers
$1.000 per customer
Other
$ 50.000
60.000
$ 110.000
Activity Rate
$280 per unit
$1.240 per order
$1.000 per customer
Activity
80 units
4 orders
1 customer
Determine the customer margin for the OfficeMart orders under Activity-Based Costing
Sales
$
47.600
Costs:
Direct materials
$
14.400
Direct labor
4.000
Unit-related overhead
$22.400
Order-related overhead
$4.960
Customer-related overhead
$1.000
46.760
Customer margin
$
840
Determine the product margin for the OfficeMart orders under a traditional cost system
Manufacturing overhead
$500.000
Total activity
1.350 units
Manufacturing overhead per unit
$370,37Page
per1unit
Total
500.000
300.000
$ 800.000
$
ABC Cost
$22.400
$4.960
$1.000
20170417234307chap_7.xlsx
Sales
Costs:
Direct materials
Direct labor
Manufacturing overhead
Traditional costing product margin
$
$
47.600
$
48.030
(430)
14.400
4.000
29.630
Page 2
20170417234328chapter_8.xlsx
Chapter 8: Applying Excel
Data
Year 2 Quarter
2
3
60.000
100.000
1
40.000
Budgeted unit sales
• Selling price per unit
• Accounts receivable, beginning balance
• Sales collected in the quarter sales are made
• Sales collected in the quarter after sales are made
• Desired ending finished goods inventory is
• Finished goods inventory, beginning
• Raw materials required to produce one unit
• Desired ending inventory of raw materials is
• Raw materials inventory, beginning
• Raw material costs
• Raw materials purchases are paid
and
• Accounts payable for raw materials, beginning balance
$...