$$please help me to do it in excel with graphs too thanks $!$

$1)$ An airline company must plan its fleet capacity and its long$-$term schedule of aircraft usage. For one flight segment, the average number of customers per day is $70,$ which represents a $65$ percent utilization rate of the equipment assigned to the flight segment. If demand is expected to increase to $84$ customers for this flight segment in three years, what capacity requirement should be planned? Assume that management deems that a capacity cushion of $25$ percent is appropriate.

$$

$$

$2)$ 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. Table $4\mathrm{.}2$ 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.

a$)$ How many machines are required to meet minimum $($pessimistic$)$ demand, expected demand, and maximum $($optimistic$)$ demand?

b$)$ How many machines are required if the operations manager decides to double lot sizes?

c$)$ If the operations manager has three machines and believes that the plant can reduce setup time by $20$percent through process improvement initiatives, does that plant have adequate capacity to meet all demand scenarios without increasing lot sizes? $$

$$

$$

$$

Table $4\mathrm{.}2$

Capacity Information for Macon Controls

Time Standard Demand Forecast

Processing $($hr$/$unit$)$

Setup $($hr$/$lot$)$

Lot Size $($units$/$lot$)$

Pessimistic Expected Optimistic A $0\mathrm{.}051\mathrm{.}06015,00018,00025,000$ B $0\mathrm{.}204\mathrm{.}58010,00013,00017,000$ C $0\mathrm{.}058\mathrm{.}212017,00025,00040,000$