Question

In: Statistics and Probability

Two departments of a​ firm, A and​ B, need differing amounts of​ steel, wood, and plastic....

Two departments of a​ firm, A and​ B, need differing amounts of​ steel, wood, and plastic. The table below gives the amount of each product the departments need.

Company C Company D
Steel 600 560
Wood 280 190
Plastic 280 380

These three products are supplied by two​ suppliers, Company C and Company​ D, with the unit prices given in the table on the right.

Steel Wood Plastic
Department A 80 60 30
Department B 60 30 60

a) Use matrix multiplication to determine how much these orders will cost each department at each of the two suppliers. Enter the amounts into the cost matrix shown on the right.

Co. C Co. D

Dept. A ____ ____

Dept. B   ____ ____

b. From which supplier should each department make its​ purchase?

Which company should department A​ use? Company C or Company D?

Which company should department B​ use? Company C or Company D?

Solutions

Expert Solution

department A needs steel 80 units , wood 60 units , plastic 30 units

department B needs steel 60 units, wood 30 units, plastic 60 units

there are two suppliers C and D with cost per unit by supplier C is

steel- 600 , wood-280, plastic- 280

and cost per unit by supplier D is

steel-560 wood-190 plastic -380

a) let matrix X denotes the demand of the two departments of different raw materials with rows defining the departments and columns defining the raw materials needed

X=

matrix Y denotes the cost per units by suppliers with rows defining the raw materials and columns defining the suppliers

Y=

then the matrix XY would give the cost the departments have to pay to the suppliers with rows defining the departments and columns defining the suppliers

(1,1) element of XY is=80*600+60*280+30*280=73200

(1,2) element of XY is=80*560+60*190+30*380=67600

(2,1) element of XY is=60*600+30*280+60*280=61200

(2,2) element of XY is =60*560+30*190+60*380=62100

so,

Co. C Co. D

dept A 73200 67600

dept B 61200 62100

b)department A should use company D as it is cheaper

department B should use company C as it is cheaper.


Related Solutions

Suppose products A and B are made from plastic, steel, and glass, with the number of...
Suppose products A and B are made from plastic, steel, and glass, with the number of units of each raw material required for each product given by the table below. ​ Plastic Steel Glass Product A 3 1 0.50 Product B 5 0.50 2 ​ Because of transportation costs to the firm's two plants, X and Y, the unit costs for some of the raw materials are different. The table below gives the unit costs for each of the raw...
HSU Corporation has two service departments, Maintenance and Administration, and two producing departments A and B....
HSU Corporation has two service departments, Maintenance and Administration, and two producing departments A and B. The direct costs of each department for the last year is as follows: Administration                $   80,000 Maintenance                       60,000 Department A                      5,000 Department B                      20,000 Information on the proportion of services supplied and used is: User Departments Administration Maintenance Dept. A Dept. B Administration 10% 60% 30% Maintenance 30% 20% 50% Using the reciprocal method of service department cost allocation Administration costs allocated to Department B is: a. $24,000...
Warren Ltd. has two production departments, Building A and Building B, and two service departments, Maintenance...
Warren Ltd. has two production departments, Building A and Building B, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of June follow: Proportion of Services Used by    Department Direct Costs Maintenance Cafeteria Building A Building B   Building A $ 480,000   Building B 327,000   Maintenance 182,000 — 0.1 0.7 0.2   Cafeteria 178,000 0.7 — 0.2 0.1 Required: (a) Use the step method...
Question 2 Alexia Muchala Ltd has two production departments, A and B, and two service departments,...
Question 2 Alexia Muchala Ltd has two production departments, A and B, and two service departments, X and Y. The budgeted activity levels for June 2020 were thus: A 2000 hours N$ 80,000 B 12,000 hours N$ 48,000 The service departments are apportioned thus: X 70% to A 20% to B 10% to Y Y 50% to A 30% to B 20% to X During June 2020 the actual results were: A 2100 hours N$ 60,000 B 11,500 hours N$...
Zia Co. makes flowerpots from recycled plastic in two departments, molding and packaging. At the beginning...
Zia Co. makes flowerpots from recycled plastic in two departments, molding and packaging. At the beginning of the month, the molding department has 3,200 units in inventory, 70% complete as to materials. During the month, the molding department started 24,000 units. At the end of the month, the molding department had 4,800 units in ending inventory, 80% complete as to materials. Units completed in the molding department are transferred into the packaging department. Cost information for the molding department for...
Zia Co. makes flowerpots from recycled plastic in two departments, molding and packaging. At the beginning...
Zia Co. makes flowerpots from recycled plastic in two departments, molding and packaging. At the beginning of the month, the molding department has 4,200 units in inventory, 70% complete as to materials. During the month, the molding department started 29,000 units. At the end of the month, the molding department had 6,300 units in ending inventory, 80% complete as to materials. Units completed in the molding department are transferred into the packaging department. Cost information for the molding department for...
Hound Havens produces plastic doghouses as part of a continuous process through two departments: Molding and...
Hound Havens produces plastic doghouses as part of a continuous process through two departments: Molding and Finishing. Direct materials and conversion are added throughout the month in both departments, but at different rates. The information presented was compiled at the end of April. Molding Department Finishing Department Beginning Inventories (on April 1): Physical units in production carried forward from March 31 2,800 5,000 Costs: Transferred Molding costs carried forward from March 31 $ 125,000 Direct materials costs carried forward from...
Company A manufactures a high quality plastic pipe I two departments, cooking and molding. Materials are...
Company A manufactures a high quality plastic pipe I two departments, cooking and molding. Materials are introduced at various points during the work in the cooking department. After the cooking is completed, the materials are transferred into the molding department, in which pipe is formed. Materials are accounted for in the cooking department on a pound basis. Conversion cost are incurred evenly during the cooking process.                 Production data:                                 Pounds in process, May 1: 100% complete as to materials,...
Two identical metal spheres A and B are connected by a plastic rod.
Two identical metal spheres A and B are connected by a plastic rod. Both are initially neutral. 4.0×1012 electrons are added to sphere A, then the connecting rod is removed. a)Afterward, what is the charge of A? b)Afterward, what is the charge of B?  
A consulting firm has two departments, Corporate and Government. Computer support is common to both departments....
A consulting firm has two departments, Corporate and Government. Computer support is common to both departments. The cost of computer support is $14.24 million. The following information is given: Gigabytes of Storage Number of Consultants Corporate 95,400 130 Government 47,600 165 Required: What is the cost allocation if fixed computer costs of $10.23 million are allocated on the basis of number of consultants and the remaining costs (all variable) are allocated on the basis of the number of gigabytes of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT