solution
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Purpose
You will create an effective recommendation (analytical) report based on the following scenario from our ongoing Jane and Javier story:
Review the report scenario, and write an effective recommendation report. Make sure to include the following:
Note: invent any details you need that you don’t have in the scenario. This may be easiest if you look up details for real spas/golf courses to include in your report. There isn’t a right or wrong choice. You need to provide adequate data to explain why you choose one option over the other.
Rexes tables and chairs is a manufacturer of wooden outdoor furniture. The three main products are picnic tables, benches and party tables. Due to recent increases in demand, the company wants to upgrade its manufacturing process. In order to do so, they must rent the appropriate equipment at a weekly fixed cost of $2000 for picnic tables, $2,500 for benches, and $3500 for party tables.
The labor and material requirements for each product are shown in the following tables, along with the variable cost to manufacture.
|
Picnic tables |
Bench es |
Party Tables |
|
|
Labor hours |
4 |
3 |
12 |
|
Lumber (sq ft) |
12 |
8 |
16 |
|
Selling price per unit |
$135 |
$100 |
$170 |
|
Variable cost per unit |
$95 |
$70 |
$120 |
The plant capacity for each product is as follows: 3,000 picnic tables, 4,000 benches, and 2,000 party tables.
Rexes has 2,500 labor hours and 8,000 sq ft of lumber available each month to produce the three products.
Write the integer programming formulation to determine the numbers of each product to be produced that would Maximize total profit.
Find a Doctor (FaD), is a small startup that helps people find a physician that best meets their needs (location, insurance accepted, etc.). During a relatively slow time for them, they have 5 staff members in a call center taking calls from customers. On average, one call arrives every 6 minutes with a standard deviation of 6 minutes. Each staff member spends 18 minutes with each customer on average, with a standard deviation of 27 minutes.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.