Question: please solve this in excel and post the excel file or screenshot thanks The Alberta Chemical Company (ACC) makes two products, soap and shampoo, both

please solve this in excel and post the excel file or screenshot thanks
please solve this in excel and post the excel file or screenshot

The Alberta Chemical Company (ACC) makes two products, soap and shampoo, both in liquid form. The same two raw material inputs, glycerin and potash, and the same production line are used in the manufacture of each. Each production day, one ton of glycerin and two tons of potash are available. Each gallon of soap requires 8 pounds of glycerin and 32 pounds of potash, while a gallon of shampoo uses 12 pounds of glycerin and 19 pounds of potash. ACC's production day is 8 full hours (480 minutes). Its production line can turn out 25 gallons of soap, or 20 gallons of shampoo, per hour. Only one product can be made at a time, but the line is easily changed over at negligible cost from one item to the other. Forecasts indicate that demand for soap and shampoo far exceeds production capacity. The profit per gallon of soap is $30 and per gallon of shampoo is $36. Part A: Formulate a linear programming (LP) model that will maximize ACC's daily profit and solve in Excel. Part B: Suppose that the production of soap also yields a byproduct called Blyx. The manufacturing process yields 0.3 units of Blyx for every unit of soap. Up to 15 gallons of Blyx can be sold per day for canine shampoo at a profit of $10 per gallon. ACC must dispose of any excess of Bly x at a removal cost of $4 per gallon. Using X3= the number of gallons of Blyx produced up to 15 gallons, Q2 continued and X4= the number of gallons of Blyx produced over 15 gallons, modify the linear programming model for this

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 Accounting Questions!