As a supervisor of a production department, you must decide the daily production totals of a certain product that has two models, the Deluxe and the Special. The profit on the Deluxe model is $12 per unit and the Special's profit is $10. Each model goes through two phases in the production process, and there are only 100 hours available daily at the construction stage and only 80 hours available at the finishing and inspection stage. Each Deluxe model requires 20 minutes of construction time and 10 minutes of finishing and inspection time. Each Special model requires 15 minutes of construction time and 15 minutes of finishing and inspection time. The company has also decided that the Special model must comprise at least 40 percent of the production total. Formulate this as a linear programming problem. Find the solution that gives the maximum profit. (a) (b)

As a supervisor of a production department, you must decide the daily production totals of a certain product that has two models, the Deluxe and the Special. The profit on the Deluxe model is $12 per unit and the Special's profit is $10. Each model goes through two phases in the production process, and there are only 100 hours available daily at the construction stage and only 80 hours available at the finishing and inspection stage. Each Deluxe model requires 20 minutes of construction time and 10 minutes of finishing and inspection time. Each Special model requires 15 minutes of construction time and 15 minutes of finishing and inspection time. The company has also decided that the Special model must comprise at least 40 percent of the production total. Formulate this as a linear programming problem. Find the solution that gives the maximum profit. (a) (b)

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

Flora Co sells bunches of fresh flowers which have a limited shelf life so forecasting sales demand is extremely important for maximising profits. Quarter 1 Quarter 1 contains a national holiday and as a result sales of a particular red flower are usually very high. Sales of the red flower will depend on market conditions. After the national holiday there will be no demand for the red flowers and they will be thrown away. Flora Co must decide whether to purchase 250 bunches, 400 bunches or 500 bunches of the red flowers from its supplier for re-sale to its customers. The following payoff table has been produced: Market conditions Poor Good Excellent Expected value Probability 0.20 0.25 0.55 Number of bunches to be bought from supplier 400 $900 $3,900 $3,900 250 $2,400 $2,400 $2,400 $2,400 $3,300 500 ($100) $2,900 $4,900 $3,400
Newsvendor model : A retailer orders sunscreens from Sweden. The firm wants to make a single purchase. Unit cost (?)(v) is $12 and sales price (?)(r) is $24. Unsold sunscreens will be salvaged (?)(s) at $8 each at the end of the summer. The management estimates that there is no significant goodwill cost (?=0)(g=0) for lost sales. Find critical ratio (?)(R). 0.75 0.33 0.25 4
A company needs to order raw material and demand is forecast to be normally distributed with a mean of 250 gallons and standard deviation of 100 gallons. One gallon of raw material produces one gallon of product and the product sells for $25/gallon. Raw material costs $10/gallon but the company must also spend $5/gallon for disposal of any UNUSED raw material. If demand is higher than production capacity, the company sells what it can make and loses the rest of demand. a) If they buy 400 gallons of raw material, how much should they expect to spend on disposal costs (in $)? b) To have a 92% probability of satisfying demand, how many gallons of raw material should be bought?
Show that Jσ_(ij)D_(ij)=T_(iL)F_(iL˙)=S(AB)E_(AB˙) [Hints: (a) to prove the first equation, use the relationship between F_(iL)˙ and L_(ij), and expand L_(ij) into symmetric and antisymmetric parts. Note the symmetry of σ_(ij). (b) To prove the second equation, first express E_(AB)˙ using F_(iL), then take the time derivative. Substitute into the definition of S_(AB )in index form and simplify.]
Clips, a competitor of Staples, is a national chain that provides office supplies to small businesses. Maya, who is the store manager at the Bethesda store, is also responsible for the store’s replenishment functions. Maya is interested in establishing a standard replenishment policy for some of her steady, non-seasonal products of which paperclips is one. Paperclips sell in small boxes that contain two hundred units. Maya estimates that Clips Bethesda sells 100 boxes of paperclips in a typical week and that the purchase price for Clips per box of paperclips is $2.00. The fixed ordering cost any time an order is placed is $20. Maya also estimates a nominal holding cost of $0.10 per box per week. (a) What is the optimal order quantity for paperclips at their Bethesda store?(b) Assuming 50 weeks in a year, how many times a year should the paperclips be ordered?
Daniel Grady is the financial advisor for a number of professional athletes. An analysis of the long-term goals for many of these athletes has resulted in a recommendation to purchase stocks with some of their income that is set aside for investments. Five stocks have been identified as having very favorable expectations for future performance. Although the expected return is important in these investments, the risk, as measured by the beta of the stock, is also important. (A high value of beta indicates that the stock has a relatively high risk.) The expected return and the betas for five stocks are as follows: Stock 1 2 3 4 5 Expected Return (%) 11.0 9.0 6.5 15.0 13.0 Beta 1.20 0.85 0.55 1.40 1.25 Daniel would like to minimize the beta of the stock portfolio (calculated using a weighted average of the amounts put into the different stocks) while maintaining an expected return of at least 11%. Since future conditions may change, Daniel…
blank one options: increases OR decreases OR remains unchanged Blank two options: increases OR decreases OR remains unchanged Blank three options: increases OR decreases OR remains unchanged
A cement mix company is renowned for providing high strength concrete additives - at high unit cost. It delivers two types of cement additives - Tuf and Rok. In making these additives the company adds two special products, Qikcem and Plascem. These additives contain two (2) basic ingredients: Lime and Flyash, in different proportions, as shown in the table below. Flyash [%] Lime Cost Special Products Qikcem (1) Plascem (2) Availability [kg/hr] 2600 3600 [%] [S/kg] 10 15 45 55 35 65 The cement additive, Tuf should not contain more than 70% of Lime and the cement additive, Rok must contain at least 45% of Flyash. The company can sell at most 800oerkg of its additive products (Tuf and Rok) per hour. There are other limitations and local requirements, as stated beklew: a) Due to the plant installed capacity and personnel requirements, no more than 6000 kg/hour of Tuf can be produced b) The plant has contracted to deliver at least 3500 kg/hour of Tuf c) The company is restricted, by local…
Reduces costs and their feasibility ranges are rooted in making changes in the right hand side of the constraint. Your answer: True False
Martin owns an older home, which requires minor renovations. However, the neighborhood where Martin lives mostly includes newly constructed luxury homes. Why might Martin's home increase in value? Based on the principle of substitution, the value of Martin's house will equal the value of the newly constructed homes in the neighborhood. ○ The value of Martin's home will decrease due to the new competition in the neighborhood. Based on the principle of regression, the newly constructed homes in the neighborhood will increase the home values of the entire neighborhood. Based on the principle of progression, the newly constructed homes in the neighborhood will increase the home values of the entire neighborhood.
The upper limit and lower limit condition can be tested through Select one: a. whatif function alone b. If within if function c. Single if function d. Countif with count function
An artist’s supply shop stocks a variety of different items to satisfy the needs of bothamateur and professional artists. In each case described, what is the appropriateinventory control model that the store should use to manage the replenishment of theitem described? Choose your answer from the following list and be sure to explain youranswer in each case:Simple EOQ Newsvendor model with service levelFinite production rate (Q, R) model with stock-out costEOQ with quantity discounts (Q, R) model with Type 1 service levelResource-constrained EOQ (Q, R) model with Type 2 service levelNewsvendor model Other type of modelSynthetic paint brushes are purchased from an East Coast supplier who charges$1.60 for each brush in orders of under 100 and $1.30 for each brush in orders of100 or greater. The store sells the brushes at a fairly steady rate of 40 per month for$2.80 each.