solve the question and just below is attached table about figure

Question no 2

Question Help Haal Future, Inc, Spends 60% of its sales dollar in the supply chain and finds its current profit of $10,000 inadequate The bank is insisting on an ved profil picture prior to approval of a loan for some new equipment Hau would like to improve the profit into $25,000 so he can obtain the bank's approval for the loan Current Situation Sales 5100 000 Cost of matenal 360,000 (6096) Production costs $20.000 (209) Fixed cost $10.000 11095) Prots $10.000 (1095) a) What percentage Improvement is tooded in the supply cwo strategy for pronto improve to 525.000? What is me cost of matonal with a $25 000 pont? A decrease in thatenal supply chain costs is required to yield n profit of $25,000 for a new matonal cost of (Enter your responses a whole numbers Bij Whale prietenit is needed in the sales strategy for profit toimite lo 525 0002 What must sales te for profit to improve to 525,000? as increase in sales as required to yield a proti ot S25,000 for a new level of sains of Enter your responses as whole numbers) Enter your answer each of the answer boxes Sales Cost of material Current Situation $100,000 $60,000 (60%) i ded in th st of materia Please copy and paste data from text area below. Selected delimiter: Tab ain) costs (Enter your or profit to ir ses as whol eded in th Current situation Percent of sales Sales 100,000 yield a pricost of material 60,000 60 Production cost 20,000 20 Fixed cost 10,000 10 Profit 10,000 10 Done answer boxes Mattress Wholesalers, Inc is constantly try to reduce very in supply chan Listew cost of goods sold was 5751 milion and wentary wis 1 milion This year costs of goodskis sa 51 milion and investoritetet is $157 milion What we of supply last year? westrowd response to www places b) What is its weeks of supply this yrat? weeks frawd your response of decimal places) cils Matiess Wassers making progress nitsitrenilory reduction Tort? Sant the number cover the supply Mass Wholesalers is making in its inventory reduction effort ng cinsed intod Erder your answer in each of the answer boxes O RE 3 Mattress Wholesalers, Inc is constantly trying to reduce inventory in its supply chain Last year, cost of goods sold was $7.51 million and inventory was $152 million This year, costs of goods sold is $8.58 million and inventory investment is $1.57 million a) What was its weeks of supply last year? weeks (round your response to two decimal places) b) What is its weeks of supply this year? weeks (round your response to two decimal places) c) Is Mattress Wholesalers making progress in its inventory reduction effort? Since the number of weeks that cover the supply has Mattress Wholesalers is making in its inventory-reduction effort. progress negative progress no progress