Question

Production analysis

Prototypes of three gadgets were produced by Research and Development (R&D) teams that consisted of engineers, hardware technicians, and software technicians. It is standard practice for Acme’s R&D team members to focus on several projects at once as determined by the needs of the project and each team member’s specific expertise. To recover the Full Time Equivalents required for the production of each Gadget, Acme tracks the number of hours that engineers, hardware technicians and software technicians dedicate to each project by hours per FTE. The following data was collected during the production of the prototypes:

Gadget	Hours per Engineering FTE	Hours per Hardware Tech FTE	Hours per Software Tech FTE	Total Number of hours to produce prototypes of each Gadget Type	Number of prototypes produced
A	25	45	25	1,000	20,000
B	195	30	30	1,500	25,000
C	62	58	98	2,000	16,000

From the production data, determine the number of Engineer FTEs, Hardware Technician FTEs and Software Technician FTEs needed to create the prototypes of Gadget A, Gadget B and Gadget C. Using this information complete the table below.

Gadget	Engineering FTE/ Gadget	Hardware Technician FTE/ Gadget	Software Technician FTE/ Gadget
A
B
C

Answer 1

Answer:-

Given That:-

Prototypes of three gadgets were produced by Research and Development (R&D) teams that consisted of engineers, hardware technicians, and software technicians.From the production data, determine the number of Engineer FTEs, Hardware Technician FTEs and Software Technician FTEs needed to create the prototypes of Gadget A, Gadget B and Gadget C. Using this information complete the table below.

Given,

Let are engineering, hardware Tech and Software Tech employees respectively.

Then by given data

By matrix method,

AX = Y thus X = (ln Y A)XY

|X| =

  

|Y| = 1000

1500

2000

we use M Inverse function

Then we calculate X matrix

By Uisng MMULT

The solution is MMULT (Array A Inverse, Array Y)

Thank you for your supporting. Please upvote my answer...