A furniture company produces tables and chairs. Each table takes 4 hours of carpentry and 2hours of painting. Each chair requires 3 hours of carpentry and 1 hour painting. During thecurrent production period, 240 hours of carpentry time are available and 100 hours in paintingis available. Each table sold yields a profit of Php70.00 and each chair produced is sold for aPhp50.00 profit.How many chairs should be produced to maximize the profit?

Here as per the given Problem: Decision variable: Suppose, x= number of tables to be produced y =…

Answered: A furniture company produces tables and…

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

Khalifa want to accumulate OMR 200000 to buy farming land after subtracting all expenses, he need to spend , he can save OMR 25000 annually. How much time would require accumulating this amount , considering that the saving are compounded at the rate of 10% per annum.
GoodMed Drug Company produced an antibiotic that is supposed to treat several bacterial infections. However, its main objective is to capture the market of Goodwill Pharma Company's antibiotic, which has become the household antibiotic in the Philippines with a whopping 50% market share. Based on Good Med Drug Company's research, customers want a cheaper alternative for antibiotics. Thus, the company reduced the price to half of Goodwill Pharma The catch is that the efficiency of the antibiotics is inferior to that of Goodwill Pharma Mary Ann Ocampo, a seasoned medical representative, was appointed by GoodMed Drug Company to do a sales pitch of the antibiotics to its network of doctors. The Company promised her bonuses and other perks if she will be able to hit target. Mary Ann is currently in deep financial crisis as her daughter was ust recently diagnosed with leukemia and therefore, this is a timely opportunity or her to recover from her finances. However, at the back of her mind,…
Reli Company produced 10,000 units of their famous chocolate biscuits. The production incurred a total fixed cost of Php15,000 with a variable cost amounting to Php5. The new selling price of the biscuit is Php10. Compute for the break-even point in units. A) 300 3,000 30,000 D 300,000
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…
Labuan. The company recently purchase the new equipment that able to reducesthe labor jobs needed to produce the shopping carts. Prior to buying the newequipment, the company used five workers, who produced an average of 80 cartsper hour. Workers receive RM10 per hour, and machine cost was RM40 per hour.With the new equipment, it was possible to transfer one of the workers toanother department, and equipment cost increased by RM12 per hour whileoutput increased by four carts per hour.a) Compute labor productivity under each system.b) Compute the multifactor productivity under each system.c) Comment on the changes in productivity according to the two measures, andon which one you believe is the more pertinent for the situation.
The following data is extracted from the books of Gulf company, Fixed cost OMR 12.000. Selling price OMR.8 per unit and variable cost OMR 2 per unit. How many units will be sold in excess of the breakeven point if Gulf Company wishes to make a profit of OMR 6.000 ? a. 1,000 units b. 2,000 units C. 1.500 units d. 3.000 units
(d) The company only has 4 workstations available. If it only operates its 4stations, how many weeks does it need to meet the production requirements?(e) The company has other contracts it needs to satisfy. Working on themugs more than 4 weeks means it will have to cancel another contract,incurring a penalty of $4,500. Each new workstation costs the company$2,500. What should the company do: cancel the contract or buy therequired workstations?
1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
Old Pueblo Engineering Contractors creates six-month “rolling” schedules, which are recomputed monthly. For competitive reasons (it would need to divulge proprietary design criteria, methods, and so on), Old Pueblo does not subcontract. Therefore, its only options to meet customer requirements are (1) work on regular time; (2) work on overtime, which is limited to 30 percent of regular time; (3) do customers’ work early, which would costan additional $5 per hour per month; and (4) perform customers’ work late, which would cost an additional $10 per hour per month penalty, as provided by their contract. Old Pueblo has 25 engineers on its staff at an hourly rate of $30. The overtime rate is $45. Customers’ hourly requirements for the six months from January to June are January 5000 February 4000 March 6000 April 6000 May 5000 June 4000 Develop an aggregate plan using a spreadsheet. Assume 20 working days in each month. 12. Alan Industries is expanding its product line to include three…
A company manufacture and sells direct to consumers 10000 jars per month at Rs 1.25 per ja The company's normal production capacity is 20000 jars per month. An analysis of cost for 10000 jars shows :- Rs 1000 Direct Materials 2475 Direct Labour 140 Power 1030 Jars & Misc supplies 7955 Fixed Expenses 12600 The company has received an offer for export of 10000 jars per month at Rs. 0.75 a jar Write a short note on the advisability or otherwise of accepting the offer. uith dotoile ae nossible
c. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). MONTH PRODUCTION DAYS DEMAND FORECAST DEMAND PER DAY JAN 2022 16 150 ? FEB 2022 16 150 ? MAR 2022 23 250 ? APR 2022 21 250 ? MAY 2022 22 400 ? JUN 2022 22 500 ? JUL 2022 21 600 ? AUG 2022 20 750 ? SEP 2022 20 450 ? OCT 2022 20 250 ? NOV 2022 16 150 ? DEC 2022 16 150 ? TOTAL ? ? d. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number). e. Prepare a graph showing the monthly forecasts and average daily forecast (in units per day) for MPQ Limited.
Two 150 horsepower motors are being considered for the company's expansion, as presented in the table below (1 hp = 0.746 kw, Php10 per Kw-hour): Purchase price Useful life Market value Annual maintenance cost Efficiency Motor A MARR Php 200,000 Annual operational cost 15,000 10 years None 10,000 80% 10% per year Motor B Php 250,000 10 years 2,500 30,000 5,000 90% How many hours of operations can the company chose either motor A or motor B (the breakeven hours for both motors)? If the motor is to operate for less than and greater than the break-even hours for both motors, which motor should be chosen? 1. How many hours of operations can the company chose either motor A or motor B (the breakeven hours for both motors)? 2. If the motor is to operate for less than the break-even hours for both motors, which motor should be chosen? 3. If the motor is to operate for greater than the break-even hours for both motors, which motor should be chosen?

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