Question: 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

Please solve a,b with explanations

Please solve a,b with explanations Problem 5 The

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!