nSilver Paints manufactures paints products. Their best selling colors in the outdoor paints category are Grey, Beige & Black. The capacity at the plant is 200 paint containers per week. nThe 3 best selling colors use the same basic raw materials but require different ratios of additives. nGrey requires 4 gallons of additive A and 2 gallon of additive B per container, nBeige requires 2 gallons of additive A and 2 gallons of additive B per container, nBlack requires 2 gallon of additive A and 1 gallons of additive B per container. nThe supply of both of these additives is quite limited. Each week, this product line is allocated only 550 gallons of additive A per week and 380 gallons of additive B. nThe profit margin of each product: Grey $75, Beige $73, Black $70 Question: How many of each of the 3 colors should be produced each week?

nSilver Paints manufactures paints products. Their best selling colors in the outdoor paints category are Grey, Beige & Black. The capacity at the plant is 200 paint containers per week. nThe 3 best selling colors use the same basic raw materials but require different ratios of additives. nGrey requires 4 gallons of additive A and 2 gallon of additive B per container, nBeige requires 2 gallons of additive A and 2 gallons of additive B per container, nBlack requires 2 gallon of additive A and 1 gallons of additive B per container. nThe supply of both of these additives is quite limited. Each week, this product line is allocated only 550 gallons of additive A per week and 380 gallons of additive B. nThe profit margin of each product: Grey $75, Beige $73, Black $70 Question: How many of each of the 3 colors should be produced each 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

Shoes Ltd. manufactures three items: Sneakers, Takkies and Sandals. The table below contains information regarding these products: Sneakers (R/ unit) Takkies (R/ unit) Sandals (R/ unit) Material cost 60 75 40 Labour cost 24 68 42 Variable overhead cost 7 12 16 Fixed overhead cost 36 23 11 Selling price per unit 870 990 650 Volume of production 12 000 28 500 31 200 Fixed overheads are allocated to products based on direct labour hours. Direct labour hours are constrained and therefore limited to 140 000 hours. The direct labour rate is R25 per hour. w Required: Q.3.1 Calculate the contribution margin per labour hour and then rank the products in order of profitability. Q.3.2 Calculate the number of units of each product that needs to be manufactured to
8. Cebrero Company makes 6,000 bottles of avocado shake every day. Each bottle size up to 50 gramsand contains 50% content mixture of avocados. How many kilos of avocado does the company needsevery day to suffice the production?
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
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.
please provide excel calcuations as well
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
29) XYZ Company The XYZ Company uses 175 handles per day. The company operates 300 days per year. It costs $2.00 to carry one handle in inventory for one year. When handle inventory is low, an order is sent to the fabrication department to manufacture more handles. Fabrication can produce handles at a rate of 1500 per day and send the handles over to assembly while production is in progress. The setup for each production run costs $500. In order to calculate the EOQ, the XYZ company utilizes the __________ model. Group of answer choices a) Basic EOQ b) Production Quantity c) Optimal Production
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
See the screenshot below.
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…
Explain briefly a) Efficient Production b) Inefficient Production c) What causes NPV to increase
1. Explain *four* the "reduction of inventory" when the company reduces the number of warehouses. 2. Explain the impact on customer service level when only *four* warehouses are now serving the entire ASEAN region? 3. Explain where the *four* distribution centre should be located and why.