Question

In: Accounting

Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold...

Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows:

1

Price per unit

$60,000.00

2

Cost of goods sold

28,000.00

3

Gross profit per unit

$32,000.00

In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to three major nonmanufacturing activities: customer service, project bidding, and engineering support. The engineering support is in the form of engineering changes that are placed by the customer to change the design of a product. The budgeted activity costs and activity bases associated with these activities are:

1

Activity

Budgeted Activity Cost

Activity Base

2

Customer service

$31,500.00

Number of service requests

3

Project bidding

74,000.00

Number of bids

4

Engineering support

120,750.00

Number of customer design changes

5

Total costs

$226,250.00

Activity-base usage and unit volume information for the three customers is as follows:

Gough Industries

Breen Inc.

The Martin

Group

Total

Number of service requests 36 28 116 180
Number of bids 50 40 95 185
Number of customer design changes 18 35 108 161
Unit volume 30 16 4 50
Required:
1. Determine the activity rates for each of the three nonmanufacturing activity pools. Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries.
2. Determine the activity costs allocated to the three customers, using the activity rates in (1). Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries.
3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and income from operations associated with each customer. Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. Be sure to complete the statement heading. Colons (:) will automatically appear if required. Enter all amounts as positive numbers, except for a negative income from operations.
Labels
December 31
For the Year Ended December 31
Selling and administrative activities
Amount Descriptions
Breen Inc.
Cost of goods sold
Customer service
Engineering support
Gough Industries
Gross profit
Income from operations
Other income (expense)
Plantwide factory overhead rate
Product cost distortion
Project bidding
Revenues
The Martin Group
Total selling and administrative activities

1. Determine the activity rates for each of the three nonmanufacturing activity pools. Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries.

1

per serv. req.

2

per bid

3

per design change

2. Determine the activity costs allocated to the three customers, using the activity rates in (1). Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries.

1

Activity Costs

2

3

4

3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and income from operations associated with each customer. Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. Be sure to complete the statement heading. Colons (:) will automatically appear if required. Enter all amounts as positive numbers, except for a negative income from operations.

Arctic Air Inc.

Customer Profitability Report

1

Gough Industries

Breen Inc.

The Martin Group

2

3

4

5

6

7

8

9

10

Solutions

Expert Solution

1.

1 Customer service $175 per serv. req.
2 Project bidding $400 per bid
3 Engineering support $750 per design change

Working:

Customer service = $31500/180 = $175

Project bidding = $74000/185 = $400

Engineering support = $120750/161 = $750

2.

1 Activity Costs
2 Gough Industries $39800
3 Breen Inc. $47150
4 The Martin Group $139300

Working:

Activity Rates Gough Industries Breen Inc. The Martin Group
Activity-base usage Activity Cost $ Activity-base usage Activity Cost $ Activity-base usage Activity Cost $
Customer service 175 36 6300 28 4900 116 20300
Project bidding 400 50 20000 40 16000 95 38000
Engineering support 750 18 13500 35 26250 108 81000
Total Activity Costs $ 39800 47150 139300

3.

Arctic Air Inc.
Customer Profitability Report
For the Year Ended December 31
1 Gough Industries Breen Inc. The Martin Group
2 Revenues 1800000 960000 240000
3 Cost of goods sold 840000 448000 112000
4 Gross profit 960000 512000 128000
5 Selling and administrative activities
6 Customer service 6300 4900 20300
7 Project bidding 20000 16000 38000
8 Engineering support 13500 26250 81000
9 Total selling and administrative activities 39800 47150 139300
10 Income from operations 920200 464850 -11300

Related Solutions

Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial...
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Price $60,000 per unit Cost of goods sold (28,000) Gross profit $32,000 per unit In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to...
Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following...
Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Month Units Shipped Total Shipping Expense January 30 $ 1,800 February 60 $ 2,300 March 40 $ 1,700 April 50 $ 2,000 May 70 $ 2,300 June 80 $ 2,700 July 20 $ 1,200 Required: Using the high-low method, calculate the equation of a cost line for the shipping expense for this company (Y...
as follows:         Sales (160,000 units)        $960,000         Cost of goods sold           
as follows:         Sales (160,000 units)        $960,000         Cost of goods sold              640,000         Gross margin                     320,000         Operating expenses          260,000         Operating income              $60,000 Kramer is developing the 2016 budget. In 2016 the company would like to increase selling prices by 12.5%, and as a result expects a decrease in sales volume of 10%. All other operating expenses are expected to remain constant. Assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. a)...
Cost of goods sold:
ABC Corporation reported the following data for the month of January: Inventories: Beginning Ending Raw materials 46,000 34,000 Work in process 31,000 29,000 Finished goods 27,000 55,000 Additional information: Raw materials purchases 79,000 Direct labor cost 93,000 Manufacturing overhead cost incurred 54,000 Indirect materials included in manufacturing overhead cost incurred 8,000 Manufacturing overhead cost applied to Work in Process 57,000 Calculate cost of goods sold during the month of January?
Labels and Amount Descriptions Cost of Goods Sold Budget X Instruction Sleep Tight, Inc. manufactures comforters....
Labels and Amount Descriptions Cost of Goods Sold Budget X Instruction Sleep Tight, Inc. manufactures comforters. The estimated inventories on January 1 for finished goods, work in process, and materials were $38,000, $32,000, and $28,000, respectively. The desired inventories on December 31 for finished goods, work in process, and materials were $43,000, $34,000, and $22,000, respectively. Direct materials purchases were $570,000, direct labor was $220,000 for the year, and factory overhead was $145,000. Required: Prepare a cost of goods sold...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 50 units at $98 Mar. 10 Purchase 70 units at $110 Aug. 30 Purchase 10 units at $118 Dec. 12 Purchase 70 units at $120 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $124 Mar. 10 Purchase 50 units at $136 Aug. 30 Purchase 20 units at $142 Dec. 12 Purchase 90 units at $144 There are 60 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $104 Mar. 10 Purchase 60 units at $114 Aug. 30 Purchase 10 units at $122 Dec. 12 Purchase 90 units at $128 There are 40 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $100 Mar. 10 Purchase 70 units at $108 Aug. 30 Purchase 30 units at $114 Dec. 12 Purchase 60 units at $120 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 30 units at $118 Mar. 10 Purchase 70 units at $126 Aug. 30 Purchase 30 units at $134 Dec. 12 Purchase 70 units at $140 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT