Please solve a,b with explanations

Problem 5 The Buenos Wood and Zamba Furniture shop creates and fabricates tables, sofas and chairs in its factory site in Northern California. The factory use three main resources to make furniture namely wood, labor and upholstery. The resource requirements for each piece of furniture and the total resources available are as follows: Resource Requirements Funiture Sofas Wood (lbs) 7 Upholstery (yds) Labor (hrs) 4 5 Tables 12 0 7 Chairs 6 9 5 The total available resources for wood is 2250, upholstery is 1000 and labor is 240 hours. The furniture is produced on a weekly basis and stored in in a warehouse until the end of the week before it is shipped out. The warehouse can only provide a space of 650 pieces of furniture. Each sofa ears a profit of $ 400, each table earns $ 275 and each chair earns $ 190. Build the business model using Excel (5 points) A. The general manager wants to find the optimum number of furnitures to make per week to maximize the profit. (2 points) B. The general manager wants to find the optimum number of furnitures to make per month (4 weeks) to maximize the profit. Show this in another sheet using solver. (3 points)