Wiliams 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 Willams' 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. Williams'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. Howevet, 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 prices. Wiliams adds a 43 5 markup to product cost. This provides a $32 suggested selling price for the pressure valve, rounded to the nearest whole dollar. The marketing department, howevet, has set the current selling price at $30 to maintain market share. Production management believes that it can handle 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 clerical costs. If management accepts the order, Williams will manufacture and ship 30,000 pressure valves to Glasgow lindustries 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 (DL.Hs) 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 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 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 ccustomers would be precluded (at a selling price 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? Complete this question by entering your answers in the tabs below. Prepare an analysis showing the impact on operating income of accepting the Glasgow order. (Input all the values as positive numbers.)