The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining

Question:

The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to Ferris Corporation. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet.

Required:

1. Check your worksheet by doubling the units ordered in cell B16 to 160. The customer margin under activity-based costing should now be $7,640 and the traditional costing product margin should be $(21,600). If you do not get these results, find the errors in your worksheet and correct them.

a. Why has the customer margin under activity-based costing more than doubled when the number of units ordered is doubled?

b. Why has the traditional costing product margin exactly doubled from a loss of $10,800 to a loss of $21,600?

c. Which costing system, activity-based costing or traditional costing, provides a more accurate picture of what happens to profits as the number of units ordered increases? Explain.

The Excel worksheet form that appears below is to be

2. Let's assume that Office Mart places different orders next year, purchasing higher-end filing cabinets more frequently, but in smaller quantities per order. Enter the following data into your worksheet:

The Excel worksheet form that appears below is to be

a. What is the customer margin under activity-based costing?
b. What is the product margin under the traditional cost system?
c. Explain why the profitability picture looks much different now than it did when Office Mart was ordering less expensive filing cabinets less frequently, but in larger quantities per order.
3. Using the data you entered in part (2), change the percentage of selling and administrative overhead attributable to processing orders from 45% to 30% and the percentage attributable to supporting customers from 25% to 40%. That portion of the worksheet should look like this:

The Excel worksheet form that appears below is to be

a. Relative to the results from part (2), what has happened to the customer margin under activity-based costing? Why?
b. Relative to the results from part (2), what has happened to the product margin under the traditional cost system? Why?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Accounting

ISBN: 978-1259307416

16th edition

Authors: Ray Garrison, Eric Noreen, Peter Brewer

Question Posted: