Please do not give image format Molecular Products produces three chemicals: B, C, and D. The company begins by purchasing chemical A for a cost of$650 per 100 liters. For an additional cost of $320 and the use of three hours of skilled labor, 100 liters of A can betransformed into 40 liters of C and 60 liters of B. Chemical C can either be sold or processed further. It costs $130 and onehour of skilled labor to process 100 liters of C into 60 liters of D and 40 liters of B. For each chemical, the selling price per100 liters and the maximum amount (in 100s of liters) that can be sold are listed in the file P04_93.xlsx. A maximum of 200labor hours is available. Determine how Molecular can maximize its profit.a. What is the optimal amount of chemical A the company should purchase? If needed, round your answer to a wholenumber.litersb. What is the optimal amount of chemical C the company should reprocess? If needed, round your answer to a wholenumber._______litersc. What is the optimized profit to the company? If needed, round your answer to a whole number. $_MolecularProducts dataNote: all units ofproduct are in100s of litersProductSelling pricesMaximum salesBс30$1,250 $1,640 $2,680D6040

We enter this information into the following modeling spreadsheet, using the given rangenames: Where…

a. What is the optimal amount of chemical A the company should purchase? If needed, round your answer to a whole number. liters b. What is the optimal amount of chemical C the company should reprocess? If needed, round your answer to a whole number. ______liters c. What is the optimized profit to the company? If needed, round your answer to a whole number. $_

a. What is the optimal amount of chemical A the company should purchase? If needed, round your answer to a whole number. liters b. What is the optimal amount of chemical C the company should reprocess? If needed, round your answer to a whole number. ______liters c. What is the optimized profit to the company? If needed, round your answer to a whole number. $_

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

Q. 2 Express your views on "purchase and procurement are closely related process in e-business". Differentiate between buy-side and sell-side with necessary examples.
40- Loss of information during the time of transmission falls under ____ a. External barrier b. Internal barrier c. Personal barrier d. Organizational barrier
_______ The duty to do a job or perform a task
Only typed answer
A Moving to another question will save this response. Question 14 Giant Beanstalks is a company based in Maryland that processes and cans vegetables. It has contracts with several large farms in Riverdale, 80 miles away from the factory, that agree to sell their produce to Giant Beanstales. The companys products are available to the public only through Greenleaf, a grocery chain with 38 stores in the country. O a intensive distribution O b. selective distribution Oc inclusive distribution O d. exclusive distribution O e. extensive distribution
38- The particular importance of combining online and offline channels lay in the additional advantages that are related to Internet-based service offering benefits as well as to the specific cost structure of the Internet. Select one: a. False b. True
Pls. Make an information request letter
Question 1- Define offer with illustration. Your answer Question 2 - Provide TWO (2) reasons for Postal Rule. Your answer Question 3 - Briefly explain TWO(2) rules on revocation of acceptance. Your answer Question 4 - State the position of past consideration under the English Law. (. Your answer
4 The term audit is derived from the Latin word “Audire”. What does the term “Audire” mean? a. To check b. To communicate c. To certify d. To hear
2 Sort Lists Create, edit, and format charts Utilise Financial Functions (PMT) and (FV) Question 1 [44 marks] Cape Produce is a fruit and vegetable retail shop based in the Western Cape province. With 15 branches in the region, their main branch is in the Cape Town city center. The branch has experienced a decline in demand for most of its products. The business has neglected marketing efforts in the past three years due to the COVID-19 pandemic, which impacted sales and profitability. You have been employed to lead the Sales department and implement marketing promotions. Before you strategise any marketing campaign, you must understand how the business performs. Background You have been provided with the attached Cape Produce Sales data in an Excel sheet. Answering these questions will provide a marketing promotion planning basis. Required: Note: add columns to the provided data table to calculate discounts and sales. Complete all calculations using formulas in Excel. Use the provided…
Return to content Question 3 of 50 Dave is responding to a tweet from a customer that reads, "Your technician arrived 30 minutes late! I've got better things to do than wait around all day." The prewritten apology template reads, "We regret any inconvenience this may have caused." What is the best way for Dave to rewrite the apology to make it more sincere? "We're sorry for the delay, but we hope you understand that our technicians work hard to provide quality service." "We regret any inconvenience caused by our technician arriving late. We take being on time seriously and we'll strive to serve you better in the future." > Respond using the prewritten template. ☐ "Sorry you had to wait! We'll make sure it doesn't happen again." ch (English) About Become an Instructor Help Privacy & Terms ^ Accessibility Apps O OOO JUN 22 útv ZA a A DII 8 F5 F6 F7 F8 F9 F10 Previous Next #4 F11
What is the procedure for information collection on literature review for research study on solid waste management at a recycling company?