please answer all requirements

Willams Company, located in southern Wisconsin, manufactures a variety of industrial valves and pipe fittings that are sold to customers in nearby states. Currently, the company is operating at about 70% capacity and is earning a satisfactory return on investment. Glasgow industries Limited of Scotland has approached management with an offer to buy 120,000 units of a pressure valve Glasgow Industries manufactures a valve that is almost identical to Williams' pressure valve; however, a fire in Glasgow Industries' valve plant has shut down its manufacturing operations. Glasgow needs the 120,000 valves over the next 4 months to meet commitments to its regular customers; the company is prepared to pay $21 each for the valves. Willams's product cost for the pressure valve, based on current attainable standards, follows: Additional costs incurred in connection with sales of the pressure valve are sales commissions of 5% and freight expense of $1 per unit. However, the company does not pay sales commissions on special orders that come directly to management. Freight expense will be paid by Glasgow. In determining selling ptices, Wallams adds a 40% markup to product cost. This provides a $32 suggested selling price for the pressure valve, rounded to the nearest whole dollar. The marketing department, however, has set the current selling price of $30 to maintain market share. Production management believes that it can handie the Glasgow industries order without disrupting its scheduled production. The order would, however, require additional fixed factory overhead of $12,000 per month in the form of supervision and clencal costs. If management accepts the order, Williams will manufecture and ship 30,000 pressure valves to Glasgow industries each month for the next 4 months. Shipments will be made in weekly consignments, FOB shipping point. Required: 1. Determine how many additional direct labor hours (DLHs) will be required each month to fill the Glasgow order. 2. Prepare an analysis showing the impact on operating income of accepting the Glasgow order. 3. Calculate the minimum unit price that Willams' management could accept for the Glasgow order without reducing operating income 4. To prove your answer to Requirement 3, use the Goal Seek function in Excel to calculate the minimum unit selling price for the If management accepts the order. Williams will manufacture and ship 30,000 pressure valves to Glasgow industries each month for the next 4 months. Shipments will be made in weekly consignments, FOB shipping point. Required: 1. Determine how many additional direct labor hours (DLHH) will be required each month to fill the Glasgow order. 2. Prepare an analysis showing the impact on operating income of accepting the Glasgow order. 3. Calculate the minimum unit price that Williams' management could accept for the Glasgow order without reducing operating income 4. To prove your answer to Requirement 3, use the Goal Seek function in Excel to calculate the minimum unit selling price for the special sales order. 5. Suppose now that if the Glasgow order were accepted, sales of 5.000 units per month to regular customers would be precluded (at a selling pice of $30 per unit). All other facts are as given in this problem. What is the revised breakeven selling price per unit for the Glasgow special sales order? 8 Answer is not complete. Complete this question by entering your answers in the tabs below. Determine how many additional direct labor hours (DUHs) will be required each month to fill the Glasgow order