EXCEL PROJECT (M113) Project #1 MATRIX ALGEBRA - PRODUCTION AND COST A firm produces three types of computers (small, medium, and large). Demand for the computers is such that 100 small, 200 medium, and 300 large computers must be scheduled for production to satisfy orders. This can be represented by a row matrix called PRODUCTION. Note. See pages 2-8 & 2-9 in text. PRODUCTION = 100 200 small medium 300 large Certain units of direct materials and direct labor go into the production of each of these computers. This can be expressed as follows: UNITS = 2 4 6 direct materials 1 3 5 small computers medium computers large computers direct labor The unit cost of direct materials and direct labor is given by the following matrix: COST = $2000 direct materials (per unit) $3000 direct labor (per unit) Continued Page - 1 (page 1 of 2 pages) fn M113PROD&COST Problem #1 Use the data to set up a Production Requirement Matrix that represents the total number of units of direct materials and direct labor needed to meet production requirements. For the sake of uniformity call this matrix TOTAL UNITS. See text pg Chpt 2-9 Problem #2 Set up a TOTAL COST MATRIX that reflects the firm's total cost of direct materials and direct labor. For the sake of uniformity call this matrix TOTAL COST. See text pg Chpt 2-9 Pg-2