Explain each step using excel and solver and also share each formula used like production units/ purchased units.

KINDLY SHOW EACH SINGLE FORMULA

3.4 TDTech is a manufacturer of portable 3D scanners. Each unit of the scanner is equipped with a tripod and requires 10 worker hours to produce. The company has 50 hourly employees. Each of them can work a maximum of 160h/ month. The average hourly pay is $22 per employee. The material cost for producing one unit of scanner (including the tripod) is $500. The company is now considering purchasing the tripod from a supplier at a cost of $70 each. This would reduce the material cost for producing one unit of scanner to $480 and cut the production time to eight worker hours. Will TDTech be better off by purchasing tripods from the supplier instead of making it in-house? .5 Refer to Exercise 3.4, the demand for TDTech in the next 6 months is shown as follows: The inventory holding cost for a unit of scanner is $10 per month. No backlogs are allowed. No employees will be hired or laid off during the planning horizon. Should TDTech consider purchasing tripods from the supplier? If yes, when should TDTech purchase tripods and in what quantity? 3.4 TDTech is a manufacturer of portable 3D scanners. Each unit of the scanner is equipped with a tripod and requires 10 worker hours to produce. The company has 50 hourly employees. Each of them can work a maximum of 160h/ month. The average hourly pay is $22 per employee. The material cost for producing one unit of scanner (including the tripod) is $500. The company is now considering purchasing the tripod from a supplier at a cost of $70 each. This would reduce the material cost for producing one unit of scanner to $480 and cut the production time to eight worker hours. Will TDTech be better off by purchasing tripods from the supplier instead of making it in-house? .5 Refer to Exercise 3.4, the demand for TDTech in the next 6 months is shown as follows: The inventory holding cost for a unit of scanner is $10 per month. No backlogs are allowed. No employees will be hired or laid off during the planning horizon. Should TDTech consider purchasing tripods from the supplier? If yes, when should TDTech purchase tripods and in what quantity