Formulate the problem and use Excel Solver to fill in the table. Fractional answers are permissible (carry 2 or 3 places beyond decimal point).

A1 SFSU ID#last4(1 digit per cell) The 5 different profit scenarios Profit/bearProfit/bunn 4 Lastname Firstname 36 52 26 6 A shop can make bunnies and bears from 7 fabric and thread. Demand for bears is no more 8 than four. Available yards of fabric are 9 Available yards of thread are 10 Each bear takes 11 Each bunny takes 12 13 14 A 15 16 17 18 19 20 21 20 18 E 10 2 yds of fabric and 3 yds of fabric and 2 yds of thread 1 yds of thread Extra Extra Max Bears Fabric in Thread in BearsBunnies Fabric in Thread in #Made Bears Brears Profit |#Made Bunnies Bunnies Bunnies Fabric Thread Profit Profit For each profit scenario, how would things change if you had one more yard of fabric? For each profit scenario, how would things change if you had one more yard of thread? For each profit scenario, how would things change if demand could be as high as 5 bears? For each profit scenario, how would things change if profit/bear increased by one?, decreased by one? For each profit scenario, how would things change if profit/bunny increased by one?, decreased by one? 23 24 25 26 27 28 29 30 31 32 A1 SFSU ID#last4(1 digit per cell) The 5 different profit scenarios Profit/bearProfit/bunn 4 Lastname Firstname 36 52 26 6 A shop can make bunnies and bears from 7 fabric and thread. Demand for bears is no more 8 than four. Available yards of fabric are 9 Available yards of thread are 10 Each bear takes 11 Each bunny takes 12 13 14 A 15 16 17 18 19 20 21 20 18 E 10 2 yds of fabric and 3 yds of fabric and 2 yds of thread 1 yds of thread Extra Extra Max Bears Fabric in Thread in BearsBunnies Fabric in Thread in #Made Bears Brears Profit |#Made Bunnies Bunnies Bunnies Fabric Thread Profit Profit For each profit scenario, how would things change if you had one more yard of fabric? For each profit scenario, how would things change if you had one more yard of thread? For each profit scenario, how would things change if demand could be as high as 5 bears? For each profit scenario, how would things change if profit/bear increased by one?, decreased by one? For each profit scenario, how would things change if profit/bunny increased by one?, decreased by one? 23 24 25 26 27 28 29 30 31 32