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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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 Analysis For Quantitative Finance

Authors: Daniele Ritelli, Giulia Spaletta

1st Edition

1351245104, 9781351245104

More Books

Students also viewed these Mathematics questions

Question

Describe the factors influencing of performance appraisal.

Answered: 1 week ago

Question

What is quality of work life ?

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago