Question: Please use excel for this question and show me your excel data. I will give the high rate. Leary Chemical manufactures three chemicals: A, B,

Please use excel for this question and show me your excel data. I will give the high rate.

Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $4 and yields 3 units of A, 1 of B, and 1 of C. Running process 2 for an hour costs $1 and produces 1 unit of A and 1 of B. To meet customer demands, at least 10 units of A, 5 of B, and 3 of C must be produced daily. Please determine a daily plan of running process 1 and 2 that minimizes the cost of meeting Leary Chemical's daily demands. 1. Please formulate the LP of this problem 2. Please use Excel to solve the LP and write down the optimal solution and optimal objective value (see the file ICE_2_Excel.xlsx attached) . B D E F G H x1 x2 Directions: 1. Write the LP model in the spreadsheet and solve it in Solver 2. Keep the solver solution and submit the Excel file variables cost objective function sum of Left-hand side right-hand side constraints

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

ICE 2 Directions: The ICE 2 must be submitted electronically to Canvas by Friday, July 17 at 11:59pm, EDT. Late work will not be accepted. The submission of ICE2 should include a pdf file (write the...

please solve this two questions and show me the excel of the second one. I will give the high rate! Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two...

please answer questions by 10:30pm QUESTION 3 stion Completion Status: You have joined a factory that manufactures a chemical additive. There are three new proposed processes that you can use. Your...

Please use excel solver to answer number 2. Provide detailed excel solver steps. Thank you Leary Chemical manufactures three chemicals: A, B, and C. These chemicals are produced via two production...

the data is too big in excel, i didn't post all. please use excel to explaine how to solve those question. Thanks! B2 1 E A F G H 1 Job time 2 3 4 5 Day 01 01 01 01 01 01 01 01 01 6 7 Mean 299.8579...

A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs...

SHOW ALL WORKINGS ! Please use excel for all graphs Attached are pictures of the original graph But please use the numbers attached here as all the 8s and 2s were changed . 1. Daudi owns and manages...

PLEASE USE EXCEL Scenario One A new client of yours, Ray Marquez, wants to open a kiosk at the local mall selling smoothies, specifically fruit smoothies, protein smoothies, green smoothies (kale,...

MKT500 Discussion Board 9 "Trending Now" The lectures that correspond to the topic is attached for your information. Thank You MKT500 Discussion Board 9 \"Trending Now\" Marketing Research Response...

I am working on the Dupont Buyout Case study, I see documents uploaded by by Jameszs- I am wondering how he arrived at the answers in the tables he provided. Is there an excel spread sheet that I can...

1. What percentage of the worlds assets is estimated to be in real estate? a. 40% b. 30% C. 90% d. 50% 2. What is the estimated value of the stock of commercial property available to institutional...

The issued and fully paid share capital of Angli Inc remained unchanged at the following amounts since the date of incorporation until the financial year ended 31 March 2004: 1,200,000 ordinary...

During a review of the financial statements of a nonpublic entity, the CPA finds that the financial statements contain a material departure from generally accepted accounting principles. If...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...