# Mba662 hw1 anderson & blount (a&b) woodworks makes tables and chairs

MBA662 HW1

Anderson & Blount (A&B) Woodworks makes tables and chairs from 30-inch wide mahogany sheets that it purchases the linear foot. It can purchase whatever mahogany it desires for \$10 per linear foot up to 2250 linear feet per week. Each table requires 9 linear feet and each chair 3 linear feet (including waste). Each chair also utilizes a soft cushion. Up to 500 cushions can be purchased each week for \$25 each. Other required hardware (supports, braces, nuts, bolts, etc.) averages \$45 for each table and \$25 for each chair. A&B sells the tables to retailers for \$300 each and each chair for \$150 each.

The 10 craftsmen employed by A&B are salaried workers. Their wages of \$800 each per week as well as the \$5000 per week in rent, insurance and utility costs are all considered fixed costs. To produce a table requires 1 hour of a craftsmen’s time, whereas each chair requires only 36 minutes. Each craftsman averages 37.5 productive work-hours per week. Company policy mandates that the ratio of chairs to tables must be between 4 to 1 and 6 to 1.

a.             Develop a linear programming model for A&B. The objective function should maximize its gross weekly profit (gross revenue less the variable costs of wood, cushions and other materials). Express the feasible region by the non-negativity constraints and a set of five functional constraints (wood and cushion availability, the minimum and maximum chair to table ratios, and the maximum weekly production time).

b.             Apply graphical analysis to draw (to scale) each constraint and identify the resulting feasible region.

—————————

Continuing from HW1 on A&B Woodworks and given the correct formulation in HW1 solution.

a)       Use the method of line of same profit to find the optimal solution graphically.

b)       Use Excel Solver to produce the optimal solution and sensitivity report, Copy a screenshot of the sensitivity report in your HW, and answer the following questions.

1-      What is the optimal gross weekly profit?

2-      2. What is the optimal net weekly profit (gross weekly profit less the fixed labor, rent, insurance and utility costs)?

3-      3. Determine and interpret the shadow prices for: i. linear feet of mahogany ii. cushions iii. production hours

We offer the best custom writing services. We have done this question before; we can also do it for you…

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.