Hi, I need help with #4. Please show all work. Thank you in advance!

Case 1-3 Case 4-6 Supcrior currently produces and selb 15,000 sets of binolucass cach month. Manafacturing capacity is 20,000 sets per month. REOTIRED: be made? Show the calculations, using the functionality of Excel, to support your answers. You may insert extri lines in the spreadsheet as needed. 4 A South American distributor proposes a special order for 6,000 sets of binoculars for $250 per set. The distributor would cover the transportation costs. but $1,000 of additional administrative coses would be incurred to fill the order. In this case, overtims production is not possible. Case 13 Case 4-6 Saperior Views is a mamufacturer of bnoculars. Its high-cnd product is available online and is also sold at select retail outlets. The binoculars sell for an average price of $310. Superior currenty produces and sells 15,000 sets of binolucars cach moeth. Manufacturing capacity is 20,000 sets per month. The distribution costs are to transpoet prodikt to retail outlets