lt content rid14021439 5 Tablesz 3 show the costs to produce

lt content rid-14021439. 5. Tablesz &3 show the costs to produce certain products and the quantity of items produced for the four quarters of the business year. a) create a 5x3 matrix (rows product and column cost type) containing the cost to produce each product in the three different cost types. b) create a sx4 matrix (rows-product and column quarter containing the amounts of each product produced in the four quarters c) Use the results in a) and b) to find the total amount spent on materials, labor and transportation to produce the given volume of products in each of the four quarters (ie, sum of costs for all products in each quarter). [Ans: 691000, 722000, 596000, 782000] Use the results in a) and b) to find the total amount spent of and transportation to produce the given volume of each product in the whole year (ie sum of the cost for each product in the four quarters). 624000, 357000, 630000, 649000, 531000) e) Find the total costs for materials labor and transportation for the whole year to produce the given volume of products (ie. overall cost). [Ans: 27910000 Table 2: The product cost for one unit(s) Product Material Labor Transportation 1 7000 3000 2000 2 3000 1000 3000 3 5000 4000 5000 2000 5000 4000 6000 2000 1000 Table 3: Quarterly production volumes Product Quarter 1 Quarter 2 Quarter 3 Quarter 12 15 11 5 13 16 18 Lab Page 5

Solution

Post one more question to get the last three answers

A) The 5X3 matrix is shown below

B) The 5X4 matrix is shown below

7000	3000	2000
3000	1000	3000
9000	4000	5000
2000	5000	4000
6000	2000	1000