I ONLY NEED ANSWER FOR 3.5

BUT I WILL ATTACH 3.4 SO YOU CAN ANSWER 3.5

PLEASE SHOW STEPS :

I NEED STEPS OF HOW TO DO IT IN EXCEL

3.5 Refer to Exercise 3.4, the demand for TDTech in the next 6 months is shown as follows: Month 1 2 3 4 5 6 Demand 700 600 800 1000 900 800 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? PLEASE SHOW STEPS: I NEED STEPS OF HOW TO DO IT IN EXCEL 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 160 h/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 pur- chasing 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 mak- ing it in-house? I DO NOT GET THE ANSWER? What kind of information you need? Show transcribed image text View comments (1) Expert Answer o Anonymous answered this 6,321 answers Was this answer helpful? 11 We first tabulate the given data in Excel as shown below: No. of employees Max. hours per month Avg. hourly pay 50 160 per worker 22 per employee $