Williams Company, located in southern Wisconsin, manufactures a varlety 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 Ltd. 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. Williams's product cost for the pressure valve, based on current attainable standards, follows: B Direct materials Direct labor (0.5 hour per valve) Manufacturing overhead (1/3 variable) Total manufacturing cost $ 23 Additional costs incurred in connection with sales of the pressure valve are sales commissions of 5% and freight expense of Si 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 prices, Williams 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 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 Industries each month for the next 4 months Shipments will be made in weekly consignments, FOB shipping point. Required: 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 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