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

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

orchestra answered 1 year ago

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...

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.

Develop a table top style exercise Your assignment is to develop a tabletop style exercise on...

Develop a table top style exercise Your assignment is to develop a tabletop style exercise on an infectious disease outbreak. This should be done in a PowerPoint presentation or a similar software presentation software. Your content should cover many of the recent learnings from the COVID-19 pandemic.

Game Description: The popular rock-paper-scissors game is usually played between two people in which each player...

Game Description: The popular rock-paper-scissors game is usually played between two people in which each player simultaneously chooses either a rock or a paper or scissors (usually with an outstretched hand). The rule of the game is simple: rock crushes scissors, scissors cut paper, and paper wraps rock. If both the players choose the same object, then it ends in a tie. Problem Description: You have to play the rock-paper-scissors game against the computer for 100 times. You receive the...

SquerDeal Mfg manufactures tables and desks, which are sold in sets of 4 chairs to tables...

SquerDeal Mfg manufactures tables and desks, which are sold in sets of 4 chairs to tables to bussiness, school, and public facilities. They reported the fallowing financial information for last year: Direct Labor 20,000hrs @$15/hr, production Manager Salary $80,000, Factory Rent $60,000, Equipment Maintenance$5,000(considered a variable expense), Equipment Depreciation $25,000, Production for the year 35,000 units, Total Revenue $12,000,000, Total table and chairs set sold during the period 30,000, Operating Income under absorption costing (after non-production expenses) $5,000,000 what would...

Question