Question: answer only question 3 and 4 please. Your company makes hand sanitizer in two lines: Moisturizing+, and Standard Soap. On the market. Moisturizing+ retails for

answer only question 3 and 4 please.
answer only question 3 and 4 please. Your company
Your company makes hand sanitizer in two lines: Moisturizing+, and Standard Soap. On the market. Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs S35/L. To make IL of Moisturizingt, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of Standard Soap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. 1. Assume that demand is high and you can sell all your hand sanitizer at the current level of resources. Write down the linear program to determine the optimal production mix. 2. Set up the Excel spreadsheet and use Solver to compute the optimal production mix. 3. You find a new supplier who can sell you an unlimited supply of lotion, soap, and SpecialX at the same costs. a) Which constraints should you removed from your LP from Q1? b) Set up the corresponding LP in Excel and run Solver. c) Take a screenshot of Solver's solution (PrtSen on your keyboard). Interpret Solver's response. Does it makes sense to follow Solver's suggested production mix? 4. Suppose you want to market Moisturizing+ as a limited edition product. You decide that at most 10% of all hand sanitizer sold in retail are from the Moisturizing+ product line. Write a constraint to reflect this restriction on your production mix. You do not need to find the new solution in Excel

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!