23. The Hummus R Us sales team has exceeded their annual sales goals, and as a result the manufacturing facility has exceeded maximum capacity. The
23. The Hummus R Us sales team has exceeded their annual sales goals, and as a result the manufacturing facility has exceeded maximum capacity. The manufacturing plant can only make 700 cvs of product, but they are facing a total demand of 1000cvs. Hummus R Us leadership is looking to outsource part of their manufacturing to We Are Hummus down the road. The costs associated with making hummus in house compared to outsourcing the work are shown in the below table. Because the purchasing team has already sourced raw materials, Hummus R Us would like to make no fewer than 700 cvs of product in house meaning they would like to use ALL of their capacity before outsourcing. Also, because of the expiration risk on the product, leadership would like to only make or buy the exact amounts specied by the sales team below. How would you spread out the work? (You MUST attach a spreadsheet showing your LP work for this problem to receive any credit.) 8 points Demand (cvs) les Price (cu Material Cost (per case) Labor Cost (per case) Outsourcing Cost (per case) Classic 250 $ 11.50 s Spicy 300 5 12.50 5 Garlic 450 5 13.50 5 A B C D E F G H 2 3 0.000 4 Constraints: 5 6 0.000 7 0.000 0.000 8 9 0.000 10 0.000 11 0.000 0.000 12 LHS Sign 13 RHS 14 15 16 17 18
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance