Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. 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 $35/L.
To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, 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.
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, then set up the Excel spreadsheet and use Solver to compute the optimal production mix.
Step by stepSolved in 8 steps with 4 images
- Use the inventory table and the gross profit inventory method to estimate the ending inventory and cost of goods sold if a 40% gross profit is realized on sales and net sales are $115,990. Date of purchase Units Cost per Total Retail price Total retail purchased unit cost per unit value Beginning inventory 41 $830 $34,030 $985 $40,385 February 5 20 $1,750 $35,000 $2,115 $42,300 February 19 15 $975 $14,625 $1,996 $29,940 March 3 28 $470 $13,160 $610 $17,080 Goods available for sale 104 $129,705 Units sold 81 Ending inventory 23 The estimated cost of goods sold is $arrow_forwardNeed help with parts a and b. Please give explanations for answer, thank you!arrow_forwardYou've purchased a 1 liter bottle of Coffee Liqueur for $19.95. You serve the liqueur in 1.5 oz. drinks. 1) How many drinks can be obtained from the bottle? drinks 2) What is the cost per drink? $ 3) If you want the beverage cost percent to be 18%, how much should you be charging for each cocktail? $ per drinkarrow_forward
- What are the supplementary materials needed by a clothing brand that produces plus sizesarrow_forwardA recipe calls for 24 oz. of fresh blueberries, which are purchased in 1-pint containers. If a cup of blueberries weighs 7 oz, how many pints should you buy?arrow_forward1. Suppose you are the producer of a product with a manufacturer's suggested retail price of $1000. Assume that this is the actual retail price. In your distribution channel, the retailer typically demands a margin of 30% off the retail price it charges. The wholesaler demands a 20% margin on the price at which he sells to the retailer. As the manufacturer, your cost of goods sold is $400. a. What price does the retailer pay? b. What price does the wholesaler pay? c. What is the manufacturer's contribution in dollars per unit? c. What is the manufacturer's contribution margin? 2. Suppose your fixed costs include $200,000 in advertising and $300,000 in overhead? a. What is the manufacturer's breakeven in terms of units? b. What is the manufacturer's breakeven in terms of dollars?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.