1. A company produces two colors of cloth, namely red and pink. In order to produce these colors, 2 special raw materials are being used by the company. The production data is given below: Meters of raw material per meter of Maximum daily availability Red Cloth Pink Cloth Raw Material 1 2 1 Raw Material 2 4 6 24 Profit per ton (1000) 4 5 According to the dealer, the daily maximum demand for red cloth is 2 meters and the daily demand for red cloth can't exceed that for pink cloth by more than 1 meter. The company wants to maximize its daily profit. a. Construct the LP Model of this problem. b. Find the optimal solution using Graphs. (graphing paper or desmos) c. Find the optimal solution using Excel Solver. (Sheet 1) d. Find the optimal solution using Algebraic Solution. e. Find the optimal solution using the Simplex Method. (Not in excel)

1. A company produces two colors of cloth, namely red and pink. In order to produce these colors, 2 special raw materials are being used by the company. The production data is given below: Meters of raw material per meter of Maximum daily availability Red Cloth Pink Cloth Raw Material 1 2 1 Raw Material 2 4 6 24 Profit per ton (1000) 4 5 According to the dealer, the daily maximum demand for red cloth is 2 meters and the daily demand for red cloth can't exceed that for pink cloth by more than 1 meter. The company wants to maximize its daily profit. a. Construct the LP Model of this problem. b. Find the optimal solution using Graphs. (graphing paper or desmos) c. Find the optimal solution using Excel Solver. (Sheet 1) d. Find the optimal solution using Algebraic Solution. e. Find the optimal solution using the Simplex Method. (Not in excel)

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

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 company manufactures hair dryers. It buys some of the components, but it makes the heatingelement, which it can produce at the rate of 800 per day. Hair dryers are assembled daily, 250 daysa year, at a rate of 300 per day. Because of the disparity between the production and usage rates,the heating elements are periodically produced in batches of 2,000 units.a. Approximately how many batches of heating elements are produced annually?b. If production on a batch begins when there is no inventory of heating elements on hand, howmuch inventory will be on hand two days later?c. What is the average inventory of elements, assuming each production cycle begins when thereare none on hand?d. The same equipment that is used to make the heating elements could also be used to makea component for another of the firm’s products. That job would require four days, includingsetup. Setup time for making a batch of the heating elements is a half day. Is there enough timeto do this job between production…
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
A town reports that it has 20 weeks-of-supply of road salt. What is its months-ofsupply? (Assume 4.33 weeks per month.)
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 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.
40. An import/export firm has leased 20,000 cubic feet of storage space to store six items that it imports from the Far East. The relevant data for the six items it plans to store in the warehouse are Space per Unit (feet) Annual Demand Item (units) Cost per Unit DVD 32-inch flat screen TV 1,600 Blank DVD's 800 $200.00 150.00 30.00 12 18 8,000 (box of 10) Blank CD's 12,000 18.00 2 (box of 50) Compact stereo Telephone 400 1,200 250.00 24 12.50 3 Setup costs for each product amount to $2,000 per order, and holding costs are based on a 25 percent annual interest rate. Find the optimal order quantities for these six items so that the storage space is never exceeded. (Hint: Use a cell location for the Lagrange multiplier and experiment with different values until the storage constraint is satisfied as closely as possible.)
Motorama TV estimates the annual demand for its TVsis (and will be in the future) normally distributed, with amean of 6,000 and standard deviation of 2,000. Motorama must determine how much production capacity it shouldhave. The cost of building enough production capacity tomake 1,000 sets per year is $1,000,000 (equivalent in presentvalue terms to a cost of $100,000 per year forever). Exclusiveof the cost of building capacity, each set sold contributes$250 to profits. How much production capacity shouldMotorama have?
8b) 7,000 drivers from Barrie drive southbound 5 days a week to see a billboard ad on Highway 400 (You cannot see the billboard going north). If we assume there are 200,000 total people in Barrie, what would the GRP per week for the billboard be for the target market of "the entire city of Barrie"?
(3marks) c. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of I16 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number have been produced. When not producing cakes, the bakery uses its personnel and facilities lor produciny other bakery tems Ihe selup cost lor a oduction run of cakes is 700 The cost of holdling frozen cakes in storage is 9 per Cake per year. the annual demand lor Ihuzen cakes, which Is contant over time, is G000 cakes. Determine the lollowing 1Optimal production run quantity ii. The maximum inventory ii. Total annual inventory costs iv. Optimal number of production runs per year V. Optimal cyele tinie (time between run starts)
Given this frequency distribution, what demand values would be associated with the following random numbers? (Do not round intermediate calculations.) Demand Frequency 16 1 10 2 28 3 46 Random Number Simulated Demand 0.1 0.5 0.9 1.
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…