A company manufactures and sells three types of doors: steel, wood, and aluminium.Labor, energy and capital requirements along with profit margins are reported in thefollowing table:SteelWoodAluminumLabor(Hours)9128Energy(Units)201416Capital($)905070Profit Margin($)453552The manager of the company has decided to sell more wood doors than the combinedtotal steel and aluminum doors sold. Due to demand constraint, steel doors sold cannotexceed 30. The company has available 600 hours of labor, 450 units of energy and$40,000 of capital. The objective of the company is to maximize total profit.1. Identify the decision variables.2.Identify and formulate the objective function.3. Identify and formulate the constraints.4. Formulate the above business problem as a Linear Programming Model.

A linear programming model is a way to perform optimization by making few assumptions. It is the…

Answered: A company manufactures and sells three…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Determine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
1. A hotel tries to reduce the perishability of its services by selling last minute inventory at a highly discounted price. This technique presents threats to a company’s: A. Brand image B: Variability of services C: Relationships with suppliers D: Human resources turnover 2. Sometimes, hotel and airline companies upgrade guests to higher-end services. For such services, there are not a lot of word-of-mouth, reviews, or pictures available. For example, a hotel may upgrade a guest who paid for a regular room to a suite in order for the guest to experience an upscale product that the customer does not purchase often, but may purchase in the future. This situation, where a guest may experience an unfamiliar upscale service for the first time, is likely to result in a __________ in the __________ of services. A: increase, intangibility B: reduction, intangibility C: reduction, variability D: increase, variability 3. In hospitality and travel industries, customers and frontline…
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far. Item % of Revenue Selling Price $1.20 $2.00 $1.00 $1.00 Variable Cost Soft Drink $0.60 24 25 $0.90 $0.30 Wine Coffee 31 Candy $0.35 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You ostimate labor cost to be $260.00 (5 booths with 2 people each) Even if nothing is sold, your labor cost will be $280.00, so you decide to consider this a fixed cost Booth rental, which is a contractual cost at $80.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-oven point in dollars for the St. Cloud Theatre Company = $(round your response to two decimal places).
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.20 $2.00 $1.25 $1.20 Variable Cost $0.60 $0.95 $0.35 $0.25 % of Revenue 26 24 30 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $633.640 (round your response to two decimal places).
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $2.00 $1.00 $0.75 Variable Cost $0.65 $0.90 $0.30 $0.25 % of Revenue 25 24 31 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $60.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $ 1138.92 (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for wine =…
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $1.75 $1.50 $0.75 Variable Cost $0.70 $1.00 $0.35 $0.35 % of Revenue 24 25 29 22 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $250.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $250.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $60.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $ (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for w servings (round…
[The following information applies to the questions displayed below.] Harbortown Marine Products (HMP) manufactures and sells various fixtures for boat cabins. One fixture uses a specialized fitting that is not used in any other HMP product. The management of HMP has considered outsourcing the fitting for several years but has never identified a suitable supplier. HMP has collected the following data on the cost of the fitting: Materials Labor Manufacturing overhead Total Rivard Fittings, a local auto supplier, contacts HMP and tells them that because of the loss of one of Rivard's customers, there is enough capacity to produce up to 5,000 units of the fitting monthly. Rivard has offered to sell HMP any quantity (up to 5,000 units monthly) at a price of $20 per fitting. $ 6.40 4.80 14.40 $ 25.60 If Rivard supplies all of the 3,000 fittings currently produced by HMP, HMP will avoid all of the variable overhead associated with the fitting and one-third of the fixed overhead. Management…
The Quality Hotel has 309 rooms. On December 10th they sold 265 rooms. In addition, they had 1 comp. Total room revenue for the day was $50,080. On this day there were 4 rooms out of inventory (OOI) due to renovations. Calculate the following for December 10th, carrying your final answers out to the 100th place: Occupancy Percentage ADR (Average Daily Rate) RevPAR (Revenue per Available Room)
U-RIDE, Inc. currently produces the electric engines that are used in golf carts made and sold by the Company. Electco has offered to sell the electric engines to U-RIDE at a price of $277 each. Current production information follows: Unit-level material and labor 2$ 230 Facility-level depreciation of manufacturing equip. Product-level engine production supervisor's salary Annual facility-level utilities $ 6,100/month $ 3,100/month $20,500 Buying the engines will free up manufacturing capacity that could be used to make a new economy line golf cart that would produce an additional $11,600 profit per year. U-RIDE is currently operating profitably producing and selling 3,100 engines annually. Based on this information, which of the following is true? Multiple Choice The $111,600 is not relevant because it is an estimate. Buying the units would increase U-RIDE's cost by $35 per unit. of 10
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Item Soft Drink Wine Coffee Candy Selling Price $1.00 $2.00 $1.50 $1.00 Variable Cost $0.65 $0.90 $0.30 $0.25 % of Revenue 25 26 30 19 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You estimate labor cost to be $300.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $300.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company = $957.69 (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for wine =…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS