Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Interest Theory

Authors: Leslie Jane, James Daniel, Federer Vaaler

3rd Edition

9781470465681

Students also viewed these Accounting questions