Question as attached

Q2. The office manager of a large law rm needs to replace the aging and out-ofstyle office furniture in their Singapore ofces. The rm has decided to purchase 2,000 new desk/chair/credenza furniture sets for all offices in Singapore. The company has received bids from four different furniture companies who are willing to supply the furniture sets, as follows: I Tim Woodworks has bid to deliver up to 1,000 furniture sets at a cost of $2,500 per set and with a one-time delivery charge of $10,000. I Millworks has bid to supply up to 1,200 furniture sets at a cost of $2,450 per set and With a one-time delivery charge of $20,000. 0 ABC Designs has bid to deliver up to 800 furniture sets at a cost of $2,5 10 per set but with no delivery charge. 0 Lim Artisan has bid to deliver up to 1,100 furniture sets at a cost of $2,470 per set and with a one-time delivery charge of $13,000. Construct a discrete optimization model to determine how many furniture sets to purchase from each of these four potential suppliers. In answering this question, you need to provide a mathematical model rst and solve it using Excel solver. Both must be submitted