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

Michael Jordan specially orders a 10 foot mattress from Sleepy's without a written agreement. This contract is not enforceable. 3. Explain your answer to question 2.
Pls help ASAP
37- Inventory management is expensive for the retailer due to ________________________. a. small transactions to small number of customers b. large transactions to a large number of customers c. large transactions to a small number of customers d. small transactions to a large number of customers
Please answer this question: 1. Traveling requisition used for one time capital purchases. A. False B. True 2. Invitation for bid is used to buy when: A. The specifications are designed for one supplier. B. The buyer has wants a competition on the best offer, C. There is complete monopoly. D. The buyer prefers a specific supplier. 3. Spend analysis is the process of determining how much to pay for service A. False B. True
Accounting
3. The marketing manager of a large truck manufacturer was surprised to learn that the price list generated by his department had little relation to the price that were actually charged to customers. The company's finance department often change the prices to conform to profit goals before the prices reached the company's sales force. The salespeople often gave customers discount to raise their sales volume. The operations manager made price adjustments to accommodate delays in promised shipping times. a. Is this desirable or undesirable for the company? Defend your answer. b. What can be done about this situation?
Question9 Under the modified accrual basis of accounting: a. Revenues are recognized at the time an exchange transaction occurs. b. Expenses are recognized when an obligation occurs for costs incurred in providing services. c. Expenditures are recognized as the cost of an asset expires or is used up in providing governmental services. d. Revenues are recognized when current financial resources become measurable and available to pay current-period obligations.
H5. Gabriella was in the business of purchasing sculptures from Brazil and selling them in Toronto at her boutique. On one consignment listed at $2,400, she received trade discounts of 9.00%, 7.00%, and 8.00%. The overhead expenses were 16.00% of her costs and she wanted to make a profit of 34.00% on cost. a. What is the regular selling price of the sculptures? b. Calculate the profit she will make if she decides to markdown the selling price by 16.00%. c. Calculate the maximum rate of markdown that she can offer so that she breaks even on the sale.
A4) Finance 15. Which of the following are restrictions on use of property? (i) Council zoning regulations (ii) How accessible the property is to public transport (iii) Clauses in the property title (iv) Locality aesthetic environment Select one: a. (i) & ( iii) only b. (i), (iii) & (iv) c. all of them
Pls help ASAPon both pls
Pls help ASAP
am. 103.