Please only solve part B using excel

Problem 5-11 (Static) A manager must decide which type of machine to buy, A, B, or C. Machine costs are as follows: Machine B C C Cost $ 40,000 $ 30,000 $ 80,000 Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Product 1 2 3 4 4 Annual Demand 16,000 12,000 6,000 30,000 3 3 4 5 2 B 4 4 6 2 2 3 4 4 1 Click here for the Excel Data File a. Assume that only purchasing costs are being considered. Which machine would have the lowest total cost, and how many of that machine would be needed? Machines operate 10 hours a day, 250 days a year. (Round up your answers to the next whole number.) Answer is complete and correct. A . Total processing time in minutes per machine: : 186,000 208,000 122,000 B Answer is complete and correct. A B Number of each machine needed and total cost 20$ 80,000 2 $ 60,000 1 80,000 2 B machines 000 Buy b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $10 each, B machines have an hourly operating cost of $11 each, and C machines have an hourly operating cost of $12 each. Which machine would be selected, and how many of that machine would be needed, in order to minimize total cost while satisfying capacity processing requirements? (Do not round intermediate calculations and round your answers to the nearest whole number.) Total cost for each machine A B B Buy machines