Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need assistance with this problem Goal Programming Coffee Creek manufacturing company produces both bowls and mugs. Each bowl generates $10 in profit while each

i need assistance with this problem
image text in transcribed
Goal Programming Coffee Creek manufacturing company produces both bowls and mugs. Each bowl generates $10 in profit while each mug produces $6 in profit. Bowls require 1/2 hour in labor to make while mugs require 1.0 hours. Bowls require 3 lbs of raw material clay for each bowl produced while mugs require 2lbs of raw material clay for each mug produced. The company has two full-time artisans that can provide 40 hours each of labor in producing bowls and mugs. In sum, the company has 80 hours per week of labor capacity. The company has established the following goals in order of importance: 1) Minimize any underutilization of labor 2) In order to cover its financial obligations, Coffee Creek needs to generate at least $450 in total profit each week. 3) Given that space to store raw material in the store is limited, it is preferred that the company carry no more than 240lbs of raw material clay at any point in time. 4) If the three above goals are achieved, Coffee Creek would like to maximize its profits if possible Use an Excel spreadsheet to set up and solve this goal programming problem and then answer the questions below: Q1 - Is Coffee Creek able to achieve all four goals in this situation? Q2 - what is the optimal number of bowls that Coffee Creek should produce? Q3 - what is the optimal number of mugs that Coffee Creek should produce? Q4 - with this optimal solution, how much total profit will Coffee Creek generate per week? Q5 - with this optimal solution, how many pounds of clay raw material should be stored

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

Principles Of Managerial Finance

Authors: Chad J. Zutter, Scott Smart

16th Edition

0136945880, 978-0136945888

More Books

Students also viewed these Finance questions

Question

What are several methods for recruiting employees? AppendixLO1

Answered: 1 week ago

Question

=+b) Should the company send the fact-finding trip? Explain.

Answered: 1 week ago

Question

List at least three disadvantages to using a consultant.

Answered: 1 week ago

Question

How are arbitrators credentialed?

Answered: 1 week ago