Question

In: Operations Management

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 the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue?

  1. Formulate an LP model for this problem
  2. Create the spreadsheet model and use Solver to solve the problem.

Solutions

Expert Solution

Let,

x1 =number of country tables to make and x2 = number of contemporary tables to make

Objective is to maximize revenue => Z = Max 395x1+515x2

subject to,

(Router) 2.5x2 +3x2 <= 1000
(Sander) 3.5x1 + 5.5x2 <= 2000
(Polisher) 2x1 + 1x2 <= 1500

(Min country) 0.75x1-0.25x2 >= 0

(Min contemporary)-0.38x1+0.62x2 >= 0

x1,x2 >= 0
Solving in solver we get,

Optimal solution :

Country table : 86.95652174 (Answer is 87 is rounding is required)
Contemporary table : 260.8695652 (Answer is 261 if rounding is required)

maximized revenue = 168695.6522

Solver screenshot

Solver formula

Solver window


Related Solutions

1) Baltimore Furniture Inc. owns two factories, each of which produces three types of tables –...
1) Baltimore Furniture Inc. owns two factories, each of which produces three types of tables – the deluxe, medium and the standard. The company has a contract to supply tables to a newly built hotel in downtown Washington DC comprising of at least 12 deluxe tables, 8 medium tables and 24 standard tables. Each factory produces a certain number of tables during each hour it operates. Factory 1 produces 6 deluxe tables and 2 medium tables. Factory 2 produces 2...
  A furniture manufacturer produces two types of display cabinets Type A and Type B Each month...
  A furniture manufacturer produces two types of display cabinets Type A and Type B Each month x of type A and y of type B are produced. Profit on type A is 300SR and profit on type B is 150SR. The following constraints control monthly production : (i)              Not more than 50 display cabinets of type A and 40 display cabinets of type B can be made (ii)            To show a profit at least 60 display cabinets in all must...
A furniture manufacturer specializes in wood tables. The tables sell for $ 140 per unit and...
A furniture manufacturer specializes in wood tables. The tables sell for $ 140 per unit and incur $ 49 per unit in variable costs. The company has $ 14,560 in fixed costs per month. The company desires to earn an operating profit of $ 8,190 per month. ​(Abbreviation used; CM​ = contribution​ margin.) 10. Calculate the required sales in units to earn the target profit using the equation method. 11. Calculate the required sales in units to earn the target...
Part A Furniture Specialties is a company that make two types of dining tables: Simple and...
Part A Furniture Specialties is a company that make two types of dining tables: Simple and Futuristic. There are two types of direct materials: Pine and Mahogany woods. Direct manufacturing labour workers are hired on an hourly basis; no overtime is worked. In terms of manufacturing overhead costs, there are two manufacturing overhead cost pools and two cost drivers. The two manufacturing overhead cost pools are manufacturing operations overhead and machine setup overhead. The cost drivers for manufacturing overhead are:...
A Furniture Company produces chairs and tables from two resources- labor and wood. The company has...
A Furniture Company produces chairs and tables from two resources- labor and wood. The company has 125 hours of labor and 45 board-ft. of wood available each day. Demand for chairs is limited to 5 per day. Each chair requires 7 hours of labor and 3.5 board-ft. of wood, whereas a table requires 14 hours of labor and 7 board-ft. of wood. The profit derived from each chair is $325 and from each table, $120. The company wants to determine...
5. The Pinewood Furniture Company produces chairs and tables from two resources—labor and wood. The company...
5. The Pinewood Furniture Company produces chairs and tables from two resources—labor and wood. The company has 80 hours of labor and 36 board-ft. of wood available each day. Demand for chairs is limited to 6 per day. Each chair requires 8 hours of labor and 2 board-ft. of wood, whereas a table requires 10 hours of labor and 6 board-ft. of wood. The profit derived from each chair is $400 and from each table, $100. The company wants to...
*Show all step of calculation and detail There are two types of bonds available in the...
*Show all step of calculation and detail There are two types of bonds available in the market: a 4-year bond A with annually paid coupon rate of 30% selling at a yield to maturity of 30%. and a 4-year zero-coupon bond B selling at a yield to maturity of 30%. Both types have a par value of $1,000 and assume that the number of the bonds can be sold in proportional to the dollar amounts invested. i) What is the...
Please show step by step work in a spreadsheet or excel so I can follow along:...
Please show step by step work in a spreadsheet or excel so I can follow along: A federal agency responsible for enforcing laws governing weights and measures routinely inspects packages to determine whether the weight of the contents is at least as great as that advertised on the package. A random sample of 30 containers whose packaging states that the contents weigh 8 ounces was drawn. The weight of each package in ounces can be found in the sheet entitled...
Show with graphs. In a two country model with two goods and two factors, both countries...
Show with graphs. In a two country model with two goods and two factors, both countries have the same technology and equal endowments of labour. Although tastes are homothetic in each country, the ratio of capital- intensive to labour intensive consumption is lower for the foreign than for the home country, at any common set of product prices. If the home country exports capital-intensive good in this equilibrium, which country must have the smaller endowment of capital?
5.The Pinewood Furniture Company produces chairs and tables from two resources—labor and wood. The company has...
5.The Pinewood Furniture Company produces chairs and tables from two resources—labor and wood. The company has 80 hours of labor and 36 board-ft. of wood available each day. Demand for chairs is limited to 6 per day. Each chair requires 8 hours of labor and 2 board-ft. of wood, whereas a table requires 10 hours of labor and 6 board-ft. of wood. The profit derived from each chair is $400 and from each table, $100. The company wants to determine...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT