i need the answer in excel sheet and the steps

The following is yearly information on two main sources for the company profit: Row material Labor cost Unit made Demand cost PRODUCT A $30 $100 3000 1850 PRODUCT B $45 $78 2500 2100 price 250 170 The fixed cost is estimated to be $1000 annually. Based on the above information find the following: 1. The company yearly profit 2- Use goal seek to find the following a. At what PRODUCT B demand both products will generate the same revenue? b. How much they should produce from each Product A and B, to reach a profit of $500,00, if the demand of them is equal to 75 of the production and Product A should be 50% of Product B. 3. If the company will sell the same amount from Product A and Product B which represents 65% for Product A and 76% for Production B, how much they should produce from both the get profit of $750,000