please kindly use excel to solve these two questions and provide the formulas used an detailed explanation where appropriate. The course is project management

EXERCISES

$4\mathrm{.}1$ Your firm designs PowerPoint slides for computer training classes, and you have just received a request to bid on a special project to produce the slides for an $8-$session class. From previous experience, you know that your firm follows an $85$ percent learning rate. For this contract, it appears that the effort will be substantial, running $50$ hours for the first session. Your firm bills at a rate of $$\frac{100}{?}$ hour and the overhead is expected to run a fixed $$600$ per session. The customer will pay you a flat fixed rate per session. If your nominal profit margin is $20$ percent, what will be the total bid price, the per session price, and at what session will you break even?

$4\mathrm{.}2$ If unit $1$ requires $200$ hours to produce and the labor records for an Air Force project contract of $50$ units indicates an average labor content of $63\mathrm{.}1$ hours per unit, what was the learning rate? What total additional number of labor hours would be required for a follow$-$on Air Force contract of $50$ units? What would be the average labor content of this second contract? Of both contracts combined? If labor costs the vendor $$10/$hour on this second contract and the price to the Air Force is fixed at $$550$ each, what can you say about the profitability of the first and second contracts, and hence the bidding process in general?

Please,solve in excel and show the formulas you have used.Only in excel please.This is project management.Thank you.