Question

In: Accounting

Required information [The following information applies to the questions displayed below.] Marin Company produces two software...

Required information

[The following information applies to the questions displayed below.]

Marin Company produces two software products (Cloud-X and Cloud-Y) in two separate departments (A and B). These products are highly regarded network maintenance programs. Cloud-X is used for small networks and Cloud-Y is used for large networks. Marin is known for the quality of its products and its ability to meet dates promised for software upgrades.

Department A produces Cloud-X, and department B produces Cloud-Y. The production departments are supported by two support departments, systems design and programming services. The sources and uses of the support department time are summarized as follows:

From To Total Labor Hours
Design Programming Department A Department B
Design - 5,000 1,000 9,000 15,000
Programming 400 - 600 1,000 2,000

The costs in the two service departments are as follows:

Design Programming
Labor and materials (all variable) $ 89,000 $ 59,400
Depreciation and other fixed costs 63,400 4,000
Total $ 152,400 $ 63,400

Required:

1. Determine the total support costs allocated to each of the producing departments using (a) the direct method, (b) the step method (design department goes first), and (c) the reciprocal method? (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.)

Required:

1. Determine the total support costs allocated to each of the producing departments using (a) the direct method, (b) the step method (design department goes first), and (c) the reciprocal method? (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.

Solutions

Expert Solution

Direct method
Department Design Programming Department A Department B
Direct overhead            152,400              63,400                          -                            -  
Allocated Design In Proportion of 1000 : 9000 respectively (1000+9000=10000) (For Department A = 152400*1000/10000)         (152,400)                15,240              137,160
Allocated Programming In Proportion of 600 : 1000 respectively (600+1000=1600) (For Department A = 63400*600/1600)            (63,400)                23,775                39,625
Total cost after departmental allocation using direct method                       -                         -   $            39,015 $          176,785
Step method
design department goes first
Department Design Programming Department A Department B
Direct overhead            152,400              63,400                          -                            -  
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively (5000+1000+9000=15000) (For Department A = 152400*1000/15000)         (152,400)              50,800                10,160                91,440
Total                       -              114,200                10,160                91,440
Allocated Programming In Proportion of 600 : 1000 respectively (600+1000=1600) (For Department A = 114200*600/1600)         (114,200)                42,825                71,375
Total cost after departmental allocation using Step method                       -                         -   $            52,985 $          162,815
Reciprocal method
Department Design Programming Department A Department B
Direct overhead      152,400.00        63,400.00                          -                            -  
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively (152,400.00)        50,800.00          10,160.00          91,440.00
Total                       -        114,200.00          10,160.00          91,440.00
Allocated Programming In Proportion of 400 : 600 : 1000 respectively        22,840.00 (114,200.00)          34,260.00          57,100.00
Total        22,840.00                       -            44,420.00        148,540.00
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively      (22,840.00)          7,613.33             1,522.67          13,704.00
Total                       -            7,613.33          45,942.67        162,244.00
Allocated Programming In Proportion of 400 : 600 : 1000 respectively          1,522.67        (7,613.33)             2,284.00             3,806.67
Total          1,522.67                       -            48,226.67        166,050.67
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively        (1,522.67)              507.56                101.51                913.60
Total                       -                507.56          48,328.18        166,964.27
Allocated Programming In Proportion of 400 : 600 : 1000 respectively              101.51            (507.56)                152.27                253.78
Total              101.51                       -            48,480.44        167,218.04
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively            (101.51)                33.84                     6.77                   60.91
Total                       -                  33.84          48,487.21        167,278.95
Allocated Programming In Proportion of 400 : 600 : 1000 respectively                   6.77              (33.84)                   10.15                   16.92
Total                   6.77                       -            48,497.36        167,295.87
Allocated Design In Proportion of 5000 : 1000 : 9000 respectively                (6.77)                   2.26                     0.45                     4.06
Total                       -                     2.26          48,497.81        167,299.93
Allocated Programming In Proportion of 400 : 600 : 1000 respectively                   0.45                (2.26)                     0.68                     1.13
Total cost after departmental allocation using Reciprocal method                       -                         -   $            48,498 $          167,301

we can stop the same process when the Balance left in service Departments become negligible.


Related Solutions

Required information [The following information applies to the questions displayed below.] Marin Company produces two software...
Required information [The following information applies to the questions displayed below.] Marin Company produces two software products (Cloud-X and Cloud-Y) in two separate departments (A and B). These products are highly regarded network maintenance programs. Cloud-X is used for small networks and Cloud-Y is used for large networks. Marin is known for the quality of its products and its ability to meet dates promised for software upgrades. Department A produces Cloud-X, and department B produces Cloud-Y. The production departments are...
Required information [The following information applies to the questions displayed below.] Dowell Company produces a single...
Required information [The following information applies to the questions displayed below.] Dowell Company produces a single product. Its income statements under absorption costing for its first two years of operation follow. 2016 2017 Sales ($46 per unit) $ 1,104,000 $ 2,024,000 Cost of goods sold ($31 per unit) 744,000 1,364,000 Gross margin 360,000 660,000 Selling and administrative expenses 287,000 322,000 Net income $ 73,000 $ 338,000 Additional Information Sales and production data for these first two years follow. 2016 2017...
Required information [The following information applies to the questions displayed below.] Dowell Company produces a single...
Required information [The following information applies to the questions displayed below.] Dowell Company produces a single product. Its income statements under absorption costing for its first two years of operation follow. 2018 2019 Sales ($44 per unit) $ 1,012,000 $ 1,892,000 Cost of goods sold ($29 per unit) 667,000 1,247,000 Gross margin 345,000 645,000 Selling and administrative expenses 291,750 336,750 Net income $ 53,250 $ 308,250 Additional Information Sales and production data for these first two years follow. 2018 2019...
Required information [The following information applies to the questions displayed below.] Data Performance, a computer software...
Required information [The following information applies to the questions displayed below.] Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the...
Required information [The following information applies to the questions displayed below.] The Fields Company has two...
Required information [The following information applies to the questions displayed below.] The Fields Company has two manufacturing departments, forming and painting. The company uses the weighted-average method of process costing. At the beginning of the month, the forming department has 27,000 units in inventory, 70% complete as to materials and 30% complete as to conversion costs. The beginning inventory cost of $56,100 consisted of $40,000 of direct materials costs and $16,100 of conversion costs. During the month, the forming department...
Required information [The following information applies to the questions displayed below.] Henna Co. produces and sells...
Required information [The following information applies to the questions displayed below.] Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 50,000 units of each product. Sales and costs for each product follow. Product T Product O Sales $ 2,000,000 $ 2,000,000 Variable costs 1,600,000 250,000 Contribution margin 400,000 1,750,000 Fixed costs 125,000 1,475,000 Income before taxes...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Required information [The following information applies to the questions displayed below.]    This firm has two...
Required information [The following information applies to the questions displayed below.]    This firm has two offices—one in Paris and one in Italy. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Paris Italy Sales $ 1,125,000 100.0 % $ 225,000 100 % $ 900,000 100 % Variable expenses 607,500 54.0 % 67,500 30 % 540,000 60 % Contribution margin...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT