Question: Say a firm has a profit function from making X and Y as Profit 1X+6Y With constraint C11X+4Y10 Q1 - Use Excel Solver to find

Say a firm has a profit function from making X and Y as Profit 1X+6Y With constraint C11X+4Y10 Q1 - Use Excel Solver to find the X and Y that maximizes profit. What are the X,Y, and profit values? Q2 - If you take the X and Y values from Q1 and round dowh any decimal value to a whole number and plug into the profit function here, what is profit (I am not asking you to round profit in Q1) ? Q3 - Use Excel Solver again to find the values of X and Y that maximize profit, this time adding the constraint that the values for X and Y must be integers. What are the X and Y values and what is the profit here. Q4 True or false: the profit in Q2 is higher than in Q3? Attach your Excel file. Say a firm has a profit function from making X and Y as Profit 1X+6Y With constraint C11X+4Y10 Q1 - Use Excel Solver to find the X and Y that maximizes profit. What are the X,Y, and profit values? Q2 - If you take the X and Y values from Q1 and round dowh any decimal value to a whole number and plug into the profit function here, what is profit (I am not asking you to round profit in Q1) ? Q3 - Use Excel Solver again to find the values of X and Y that maximize profit, this time adding the constraint that the values for X and Y must be integers. What are the X and Y values and what is the profit here. Q4 True or false: the profit in Q2 is higher than in Q3? Attach your Excel file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

1) Find all real solutions of: 4 2 2 x + x =3 2 x 4 + x23=0 4 2 2 2 x 2 x +3 x 3=0 x ( 21)=0 2 x 2 ( x 21)+ 3 ( 2 x2 +3 ) ( x 21 ) =0 ( 2 x2 +3 ) =0 2 2 x =3 3 x 2= 2 3 x= 2 3 x= i 2 2) Given the...

Bus309: Excel 7. A toy manufacturer makes stuffed kittens and puppies that have relatively lifelike motions. There are three different mechanisms which can be installed in these "pets." These toys...

this is a fixed cost problem Hart Manufacturing makes three products. Each product requires manufacturing operations in B 2 . 0 0 1 . 0 0 2 . 5 0 C 0 . 2 5 0 . 2 5 0 . 2 5 During the next production...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Solve a, b, c, and d It's been a year since Cellar Door opened and in spite of the global economic conditions, Cellar Door at Orange Wines has somehow defied the odds and has quickly become a...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

ADM 2302 -Assignment #1 Problem 1 (15 points) The price of oil has been dropping significantly recently. This urges fund managers to adjust their investment portfolios. In particular, many fund...

BUSM Consider a household whose utility is determined by its consumption in periods 0 and 1. Let c0 and c1 denote the consumption in periods 0 and 1, respectively. The utility of this household can...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Russell Corporation had the following activities: Recorded depreciation of $5,000. Received cash from the sale of common stock, $20,000. Purchased $10,000 of equipment with cash. Paid $4,000...

Question 2 Download the SGEMM GPU kernel performance dataset from the below link. https://archive.ics.uci.edu/ml/datasets/SGEMM+GPU+kernel+performance Perform exploratory data analysis and identify...

9 Draw triangle ABC. Use compasses to draw the perpendicular bisector of BC. Show your construction lines on your drawing. Check the accuracy of your drawing with a protractor and a ruler. 8.4cm A B...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...