Question

In: Statistics and Probability

Table Rock Tables, manufactures two popular tables, a country style table and a contemporary style table....

Table Rock Tables, manufactures two popular tables, a country style table and a contemporary style table. The manufacturing process for both tables requires the use of three types of machines. The time to produce the tables on each machine given in the following table:

Machine   Country Table Contemporary Table Total Time Available

Router 1.5 2 1000
Sander 3.0 4.5 2000
Polisher 2.5 1.5 1500

The earns a profit of $350 on the Country table, and $450 on the Contemporary table. The marketing department requires that the company make exactly twice as many Country tables as Contemporary tables. Table Rock City Tables want to determine the product mix to maximize profit.

Please Use Excel


Solutions

Expert Solution

ANSWER:

The linear programming problem is

The steps in solver are

Solution is

c 380
m 190
Z 218500
950 <= 1000
1995 <= 2000
1235 <= 1500
380 = 380

Formula are

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU


Related Solutions

Create a query in Access that uses two tables, the Patient table and the Session table. Add
Create a query in Access that uses two tables, the Patient table and the Session table. Add the LastName, FirstName, and SessionDate fields to the query grid. Run the query. How many records are displayed? Delete the join line between the field lists in Query Design View. Rerun the query. How many records are now displayed? Why are the results different? You do not need to save the queries. 
Quindo Table Company manufactures tables for schools. The 2015 operating budget is based on sales of...
Quindo Table Company manufactures tables for schools. The 2015 operating budget is based on sales of 44,000 units at $50 per table. Budgeted variable costs are $30 per unit, while fixed costs total $660,000. Actual sales were 46,000 units at $60 each. Actual variable costs were $33 per unit and fixed costs totaled $627,000. Required: Prepare a variance analysis report with both flexible-budget and sales-volume variances.                                                                  Quindo Table Company                                                                          Variance Analysis      Actual Results Flexible Variances Flexible Budget...
XYZ Company manufactures tables. A standard cost card for the manufacture of one table shows the...
XYZ Company manufactures tables. A standard cost card for the manufacture of one table shows the following: Standard Cost per Table: Direct material: 4 sq. ft. @ $3/sq. ft. $12 Direct labor: 2 hours @ $8/hr 16 Total prime costs $28 In November, the company produced 1,000 tables. Actual production costs and quantities were: Direct material: 3,900 sq. ft. @ $3.10/sq. ft. $12 Direct labor: 2,300 hours @ $7.80/hr 16 Required: Calculate the price and quantity variances for direct material...
Tables: Create table Item(    &nbs... Bookmark Tables: Create table Item(                 ItemId           &nb
Tables: Create table Item(    &nbs... Bookmark Tables: Create table Item(                 ItemId                 char(5) constraint itmid_unique primary key,                 Decription           varchar2(30),                 Unitcost               number(7,2)); Create table Customer(                 custID                   char(5) constraint cid.unique primary key,                 custName          varchar2(20),                 address                                varchar2(50)); Create table Orderdata( orderID                char(5) constraint oid_uniq primary key,                 orderdate           date,                 shipdate              date,                 ItemId                  char(5) references Item.ItemId,                 No_of_items     number(4),                 Unitcost               number(7,2),                 Order_total        number(7,2),                 custID                   char(5) references customer.custID); Insert Into Item values(‘A123’,’Pencil’,2.5);...
A division of the Winston Furniture Company manufactures dining tables and chairs. Each table requires 40...
A division of the Winston Furniture Company manufactures dining tables and chairs. Each table requires 40 board feet of wood and 3 labor-hours. Each chair requires 16 board feet of wood and 4 labor-hours. The profit for each table is $50, and the profit for each chair is $40. In a certain week, the company has 3200 board feet of wood available and 520 labor-hours available. How many tables and chairs should Winston manufacture to maximize its profit? (Let x...
Implement a Cuckoo hash table in which two separate tables are maintained. Each table should have...
Implement a Cuckoo hash table in which two separate tables are maintained. Each table should have a fixed size of 13. Use the hash function h1(x) = x mod 13 for the first table, and h2(x)= 11 – (x mod 11) for the second table. Your program should read an input file, input.txt, consisting of one input per line, insert the input to the table in order, and print out the final content of the hash table in the provided...
The history of American popular musical styles such as Jazz and Rock and Roll is an...
The history of American popular musical styles such as Jazz and Rock and Roll is an exploration of the fusion of many earlier genres and styles. For each listening example make a list of major features. What features from each seem to be continued on in later musical styles and even in the music you might listen to today? West African Drumming: https://www.youtube.com/watch?v=6dFtlcqGW50 (Links to an external site.)Links to an external site. Stephen Foster -1851: https://www.youtube.com/watch?v=uQjGlyRm8ek (Links to an external...
List four contemporary ethical systems and identify one unique population or country where that contemporary ethical...
List four contemporary ethical systems and identify one unique population or country where that contemporary ethical system is portrayed. Describe how you would interact with a patient from that culture or population. Identify difficulties that may arise during this interaction.
SHOW STEP BY STEP SPREADSHEET MODEL A furniture manufacturer produces two types of tables – country...
SHOW STEP BY STEP SPREADSHEET MODEL A furniture manufacturer produces two types of tables – country and contemporary – using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Contemporary Total Machine Time Available Per Week Router 2.5 3.0 1,000 Sander 3.5 5.5 2,000 Polisher 2.0 1.0 1,500 Country tables sell for $395 and contemporary tables sell for $515.   Management has determined that at least 25% of...
PHP The database should have at least two tables with, at minimum, the following fields: Table...
PHP The database should have at least two tables with, at minimum, the following fields: Table customers: Fields: Table billing: Fields: customer_ID customer_ID customer_L_Name customer_L_Name customer_F_Name service customer_Title (Mr, Ms, Dr. etc,) customer_bill street_Address amt_paid city_State_Zip bill_date customer_Phone date_paid customer_Email Create a PHP page that will extract a customer’s bill amount and the amount paid. Then it will calculate the amount due. If the amount due is greater than 0, an email should be generated and sent to the customer...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT