Ex-2: Reddy mikks produces both interior and exterior paints from tow raw materials M1 and M2 the following table providers the basic data of the problem Exterior Interior point point M1 6. 4. 24 M2 1 6. Profit 4 A market survey indicates that the daily demand for interior point cannot exceed that for exterior point by more than 1 ton. Also the max daily demand for interior point is 2 ton. Reddy mikks wants to determine the best produced mix of interior and exterior points that maximize total daily profit A

Ex-2: Reddy mikks produces both interior and exterior paints from tow raw materials M1 and M2 the following table providers the basic data of the problem Exterior Interior point point M1 6. 4. 24 M2 1 6. Profit 4 A market survey indicates that the daily demand for interior point cannot exceed that for exterior point by more than 1 ton. Also the max daily demand for interior point is 2 ton. Reddy mikks wants to determine the best produced mix of interior and exterior points that maximize total daily profit A

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

4GE 10:01 A company has production costs of item and can produce 270 $15 per items for a total cost of $6,925. The company brings in a total of $3,995 in revenue from selling 85 of these items. Determine each of the following functions. Enter all answers below in slope-intercept form, using exact numbers. a. Find the company's linear revenue function. R(x) b. Find the company's linear profit function. P(x) Submit answer
Demand for stereo headphones and MP3 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 last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 36,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,700 hours of assembly time will be available next quarter. The profit contributions are $200…
Cell Name: $C$5 Qty Doors 24 0 Qty $D$5 Windows 48 0 $E$5 Qty Vents Using the sensitivity report below, by how much will profit increase if you add an additional unit of 'Finishing Used'? 120 60 48 Cell Name $F$9 Cutting Used 48 $F$10 Sanding Used 60 $F$11 Finishing Used O 440 Final Reduced Objective Allowable Value Cost Coefficient Increase 100 0 60 -220 500 Final Shadow Constraint Value Price 0 440 120 450 200 R.H. Side 100 60 60 550 220 Allowable Increase 1E+30 Allowable Decrease 20 275 75 1E+30 Allowable Decrease 52- 43.33333333 15 30
Utah Utensil has developed a new kitchen utensil. The firm has conducted significant market research and estimated the following pattern for sales of the new product: Year Expected Volume Expected Price per Unit 1 48,000 units $19 2 48,000 units $20 3 90,000 units $16 4 40,000 units $12 If the firm desires to net $3.50 per unit in profit over the life of the product, and selling and administrative expenses are expected to average $50,000 per year, what is the target cost to produce the new utensil?
Josh Smith, the materials manager at a retail store, has determined that a particular product experienced 5 turns last year, with an annual sales volume of $15 million. What was the average inventory value for this product last year? $2.5 million $2.75 million $3 million $5 million
Comprehensive model formulation exercise Q1: New product development Problem A Leisure Food Company plans to develop some new products. The following table shows relevant data for six potential foods which are under considera tion. The company wants to know which projects should be selected so asto maximize total pr ofits. There are some constrains for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be select ed simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fo urth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be select ed among project 3, 4, and 5. Please help this company to determine the optimal combinations of new products. Table 1 Data…
What relationship between x and y is suggested by the scattergram? OA a quadratic relationship with downward concavity OB. a linear relationship with positive slope OC. a linear relationship with negative slope D. a quadratic relationship with upward concavity
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
A regional distributor purchases discontinued appliances from various suppliers andthen sells them on demand to retailers in the region. The distributor operates 5 daysper week, 52 weeks per year. Only when it is open for business can orders bereceived. The following data are estimated for the mixer:Average daily demand (d) = 100 mixersStandard deviation of daily demand (d) = 30 mixersLead time (L) = 3 daysHolding cost (H) = $9.40/unit/yearOrdering cost (S) = $35/order 4 Cycle-service level = 92 percentSuppose that a periodic review (P) system is used at the distributor.a) Calculate the P (in workdays, rounded to the nearest day) that givesapproximately the same number of orders per year as the EOQ.b) It is time to review the item. On-hand inventory is 40 mixers; receipt of 440mixers is scheduled, and no backorders exist. How much should bereordered?c) What is the target inventory level, T?d) What is the total annual cost of the P system?
Q46 Mixing Company manufactured 2,500 units of its only product during 2022. The inputs for this production are as follows: 550 pounds of Material A at a cost of $2.50 per pound 400 pounds of Material H at a cost of $3.75 per pound 700 direct labor hours at $60 per hour The firm manufactured 3,920 units of the same product in 2021 with the following inputs: 700 pounds of Material A at a cost of $2.20 per pound 560 pounds of Material H at a cost of $3.50 per pound 600 direct labor hours at $58 per hour The partial operational productivity of Material A in 2021 is: Multiple Choice 5.60 units per pound. 0.44 units per pound. 4.67 units per pound. 5.18 units per pound. 0.51 units per pound.
2. Using the same data above, compute for the WMA using the below weights. Compute for the MAD, MSE and MAPEH. Weights Period 5 Last Month4 Two Months Ago3 Three Months Ago2 Four Months Ago1 Five Months Ago 3. Compare the Percentage Errors for the Moving Average and Weighted MovingAverage as computed in nos 1 and 2.