Operations Management questions

Question 3. (9 points) COST-VOLUME-PROFIT MODEL

A manufacturing company produces two types of phones. Each phone sells for $350 and costs $150. The company incurs a fixed cost of $20000 per day to lease their machines to manufacture the phones. Depending on the volume of production the company must also hire and schedule enough number of employees to carry out the production. The additional labor costs are $1000, $2200 and $3500 per day, when the production volume is 0 to 100 units, 0 to 150 units, and 0 to 200 units per day, respectively. The company forecasts the daily expected demand for its phones to be 160 units.

Don't use plagiarized sources. Get Your Custom Essay on
Operations Management questions
Just from $10/Page
Order Essay

a) (3 points) Compute the break-even point for each range of production volume separately.

b) (4 points) Which production volume range is the best for the company? Explain clearly why.

c) (2 points) Suppose the company has a production capacity of 100 units per day. (Use this information independent of the production volumes mentioned above). What is the capacity cushion (in %) if the company produces only as much as the forecasted demand? What is the implied capacity utilization (i.e., the capacity utilization when the company chooses to produce only as much as the demand)?

Question 4. (16 points) OPTIMAL PRODUCT MIX

A brewery sells three types of beer: Ipa, Ale and Lager. Producing a gallon of Ipa brings a profit of $40 and requires 3.5 lbs of hops, 5.5 lbs of barley and 2.5 lbs of yeast. Producing a gallon of Ale brings a profit of $55 per gallon and requires 5 lbs of hops, 7 lbs of barley and 4 lbs of yeast. Producing a gallon of Lager brings a profit of $45 per gallon and requires 3.5 lb of hops, 6 lbs of barley and 3 lbs of yeast. The brewery has 650 lbs of hops, 1000 lbs of barley and 500 lbs of yeast available in its inventory every week. You will formulate and solve a linear programming model to help the brewery determine the optimal mix of beer of each type (i.e., gallons of beer of each type to produce in order to maximize the total profit) in a week. Water is also used in producing all beer types, but water is plenty and available at no extra cost.


a)(3 points) What are the decision variables? How many decision variables are there? Clearly explain the decision variables in English and provide the mathematical notation used in the algebraic formulation of the decision problem.

b)(2 points) What is the objective function? Clearly explain the objective function in English and provide the mathematical formulation.

c)(2 points) What are the constraints of the problem? Clearly explain each constraint in English and provide the mathematical formulation.

d)(1 points) Are there any sign or type restrictions in your formulation? Why or why not? Clearly explain the sign and type restrictions (if any).

e)Prepare a spreadsheet to determine the optimal production mix of using Excel Solver.

i.(2 points) Provide a screenshot of your spreadsheet model. The screenshot should show all the cells involved in formulating the optimization problem. NOTE: Do not copy and paste your spreadsheet to your answer report as an Excel object. Instead, capture a screenshot in Excel and paste this as an image.

ii.(2 points) Provide a screenshot of your spreadsheet with the formula view. You can switch from normal view to formula view in Excel by clicking the CTRL and ~ keys on your keyboard simultaneously.

iii.(2 points) Prepare the Solver model by logging all the information to the Solver Parameters window in Excel. Provide a screenshot of the Solver Parameters window.

iv.(2 points) Solve the optimization problem using Excel Solver. What is the optimal solution, i.e. the optimal values of the objective function and the decision variables?

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool’s honor code & terms of service.

Get professional assignment help cheaply

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.

Why choose our academic writing service?

  • Plagiarism free papers
  • Timely delivery
  • Any deadline
  • Skilled, Experienced Native English Writers
  • Subject-relevant academic writer
  • Adherence to paper instructions
  • Ability to tackle bulk assignments
  • Reasonable prices
  • 24/7 Customer Support
  • Get superb grades consistently


Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Open chat
You can contact our live agent via WhatsApp! Via +1 817 953 0426

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code VICTORY