Please provide step by step clear answers and do it in Excel please. Many thanks!

Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 20 percent capacity cushion is best. Demand Forecast Component A Time Standard Processing Setup (hr/unit) (hr/lot) 0.05 1.0 Lot Size (units/lot) 60 75 Pessimistic Expected 15,000 17,000 9,000 12,000 Optimistic 27,000 B 0.20 4.2 17,000 0.05 8.7 100 16,000 24,000 40,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next whole number.) Demand Forecast Requirement (M) Capacity Pessimistic machines Expected machines Optimistic machines