$\backslash$table$[[\backslash$table$[[(4)],[1.$ a$.$ Average order$],[$manufacturing lead$],[$time$,140$ hours.$]],\backslash$table$[[19-33]],\backslash$table$[[$Manufacturing lead times, relevant revenues, and relevant costs. The Brandt$],[$Corporation makes wire harnesses for the aircraft industry. Brandt is uncertain about when$],[$and how many customer orders will be received. The company makes harnesses only after$],[$receiving firm orders from its customers. Brandt has recently purchased a new machine to$],[$make two types of wire harnesses, one for Boeing airplanes $($B$7)$ and the other for Airbus$],[$Industries airplanes $($A$3).$ The annual capacity of the new machine is $6,000$ hours. The fol$-],[$lowing information is available for next year:$]]],[,\backslash$table$[[$Annual$],[$Average$],[$Number$],[$of$],[$Orders$]],\backslash$table$[[$Manufacturing$],[$Time$],[$Required$]],\backslash$table$[[$Selling Price per Order$],[$If Average Manufacturing Lead Time$],[$per Order Is$]],\backslash$table$[[$Variable$],[$Cost$],[$per$],[$Order$]],\backslash$table$[[$Inventory$],[$Carrying$],[$Cost$],[$per Order$],[$per Hour$]]],[$Customer$,$Less than $200$ Hours,More than $200$ Hours$],[$B$7,125,40$ hours,$$15,000,$$$14,400,$$$10,000,$$$0\mathrm{.}50],[$A$3,10,50$ hours,$13,500,12,960,9,000,0\mathrm{.}45],[,,\backslash$table$[[$REQUIRED$],[1.$ Calculate the average manufacturing lead times per order $($a$)$ if Brandt manufactures only B$7],[$and $($b$)$ if Brandt manufactures both B$7$ and A$3.],[2.$ Even though A$3$ has a positive contribution margin, Brandt's managers are evaluating$],[$whether Brandt should $($a$)$ make and sell only B$7$ or $($b$)$ make and sell both B$7$ and A$3.],[$Which alternative will maximize Brandt's operating income? Show your calculations.$],[3.$ What other factors should Brandt consider in choosing between the alternatives in$],[$requirement $2?]]]]$ please show by using excel. thank you