11-A 1. Can someone show me how to do this problem?

Will rate a thumb up for good response thanks so much (Please highlight final answer thx)

Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $42,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $47,000 so he can obtain the bank's approval for the loan. Sales Cost of material Production costs Fixed cost Profit Current Situation $140,000 $63,000 (45%) $28,000 (20%) $7,000 (5%) $42,000 (30%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $47,000? What is the cost of material with a $47,000 profit? A decrease of % in material (supply-chain) costs is required to yield a profit of $47,000, for a new material cost of $. (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.) b) What percentage improvement is needed in the sales strategy for profit to improve to $47,000? What must sales be for profit to improve to $47,000? An increase of % in sales is required to yield a profit of $47,000, for a new new level of sales of $. (Enter your response for the percentage increase to one decimal place and enter your response for the new sales as a whole number.)