Can i please get question B anawer.

Use the following estimated information for the Barkery to perform the analyses: Revenues-$295,000 Cost of goods sold-60% of revenues Salaries and wages = 10% of revenues Additional costs: Operating Costs- $24,000 Depreciation $1,050 Bad debts expense-1% of 90% of revenues Interest expense- $420 schedules REQUIRED: On the basis of the facts as given above, prepare the following using a spreadsheet software package A. The Barkery would like to be more profitable. Use Goal Seck in Excel to determine the following changes. Each situation is independent of the others. 1. How much would the cost of goods sold percentage need to be for net 2e Assume original perceniages, how much would the salaries percentage income to be $80,000? need to be for net income to be $80,000? B. GO BACK TO THE ORIGINAL DATA Use Solver in Excel to determine the following assuming these constraints (COGS not more than 75% or less than 50%. Salaries not more than 20% or less than 5%; 1. Assuming both must change, what percentages would the COGS and 2. What is the maximum net income The Barkery can achieve with the 3. What is the minimum net income The Barkery can achieve with the the salaries percentages have to be in order to get $80,000 net income? above constraints? above constraints? C. GO BACKT0THEORGINALDATA following: Use SolverinExcel to determine the l. Assuming COGS : 60% and Salaries revenues have to be to earn $80,000 net income? l020, how much would 2. Assuming COGS-50% and Salaries-15%, how much would revenues have to be to earn $80,000 net income