A craftswoman produces two products: floor lamps and table lamps. Production of one floor lamp requires 75 minutes of her labor and materials that cost P250. Production of one table lamp requires 50 minutes of labor, and the materials cost P200. The craftswoman wishes to work no more than 40 hours each week, and her financial resources allow her to pay no more than P9,000 for materials each week. She can sell as many lamps as she can make and her profit is P390 per floor lamp and P330 per table lamp. 1. Identify the variables. Make a table of values. 2. Set up the objective function. 3. Give the constraints in mathematical expression. 4. Graph the constraints and identify the solution. 5. How many floor lamps and how many table lamps should she make each week to maximize her weekly profit? 6. What is that maximum profit per week?

A craftswoman produces two products: floor lamps and table lamps. Production of one floor lamp requires 75 minutes of her labor and materials that cost P250. Production of one table lamp requires 50 minutes of labor, and the materials cost P200. The craftswoman wishes to work no more than 40 hours each week, and her financial resources allow her to pay no more than P9,000 for materials each week. She can sell as many lamps as she can make and her profit is P390 per floor lamp and P330 per table lamp. 1. Identify the variables. Make a table of values. 2. Set up the objective function. 3. Give the constraints in mathematical expression. 4. Graph the constraints and identify the solution. 5. How many floor lamps and how many table lamps should she make each week to maximize her weekly profit? 6. What is that maximum profit per week?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
The Company has the oppotunity to introduce a new product. The sales manager believes that the firm could sell 5,000 units per year at 14 per unit for 5 years. The production manager has determined that machinery costing 60,000 and having a 5 year life and no salvage value could be required. The machinery will have an annual fixed cash operating costs of 4,000. Variable cost per unit will be 8. Straight-line depreciation is to be used for both book and tax purposes. The tax rate is 40% and the firm's cost of capital is 14%. What is the Net Present Value of the Investment?
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?
(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?
The local supermarket buys lettuce each day to ensure very fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $4 a box. The lettuce is sold for $10 a box and the dealer that sells old lettuce is willing to pay $1.50 a box. Past history says that tomorrow’s demand for lettuce averages 250 boxes, with a standard deviation of 34 boxes. How many boxes of lettuce should the supermarket purchase tomorrow?
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
(b) MNM Century Sdn Bhd is a building contractor in Johor who just won the tender to construct 20 units of low-mid-cost house in Pontian, Johor. Both client and contractor agreed that the term for payment is based on the unit completed. For each unit completed, the contractor will be paid one-off payment worth RM 100,000. The contractor have to choose whether to use the traditional method or innovative IBS system in order to maximize their profit. The details for both construction methods are shown in Table 1. Table 1 Innovative IBS Description Traditional Method System Total construction duration 24 months 12 months Working days/week 6 days 5 days Cost Factors Fixed cost RM 200,000 RM250,000 Site staff salary (total, monthly) RM20,000 RM25,000 Labour cost (Average, daily) RM80 x 5 рах RM120 x 5 pax M&E labour cost (per unit) RM2,000 RM2,000 Material cost per unit RM 30,000 RM 20,000 (i) Demonstrate the best method between the two options from economic perspective? (ii) Based on your…
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
A department store sells a certain handkerchief for Php40 per piece. The store averages sales of 80 pieces each week. The store manager's past experience leads him to believe that for each Php2 increase in the price of the handkerchief, one less piece would be sold each week. What price would result in Php3,648 weekly sales?
Neverland Company, a retailer, plans to sell 15,000 units of Product X during the month of August. If the company has 2,500 units on hand at the start of the month, and plans to have 2,000 units on hand at the end of the month, how many units of Product X must be purchased from the supplier during the month? * 17,000 15,000 14,500 15,500
Joint Products Choi Company manufactures two skin care lotions, Smooth Skin and Silken Skin,from a joint process. The joint costs incurred are $420,000 for a standard production run that generates 180,000 pints of Smooth Skin and 120,000 pints of Silken Skin. Smooth Skin sells for $2.40 perpint, while Silken Skin sells for $3.90 per pint.Required1. Assuming that both products are sold at the split-off point, how much of the joint cost of each production run is allocated to Smooth Skin using the relative sales value method?2. If no separable costs are incurred after the split-off point, how much of the joint cost of each productionrun is allocated to Silken Skin using the physical measure method method?3. If separable processing costs beyond the split-off point are $1.40 per pint for Smooth Skin and $0.90 perpint for Silken Skin, how much of the joint cost of each production run is allocated to Silken Skin usinga net realizable value method?4. If separable processing costs beyond the…