NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

4.8/5

solution

A DM Woodwork (DMW) makes two types of desks- business and residential. DMW makes $400 profit on each business desk and $200 profit on each residential desk. The manufacturing process is divided into three departments. The following table provides information on the manufacturing time in each department for each type of table with the total time available in each department for the next week:
Departments
Business Desk (hours)
Residential desk (hours)
Total time available (hours)
Carving
1/4
2/9
240
Gluing
2
2
1800
Painting
1/2
1/3
375
Also, DMW recently contracted with QU and needs to manufacture 200 business desks by the end of the next week.
Because of the part restrictions, DMW prefers to make at least twice the number of residential desks as business desks.
To maximize the profit, how many business and residential desks DMW will manufacture in the next week? Use linear programming model by creating an Excel Spreadsheet and use Excel Solver to find the answer.Run the sensitivity analysis and interpret the dual value for the carving department.

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.

WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!