• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Econ help (Excel solver)

Status
Not open for further replies.

FenderBender12

Junior Member
So I'm trying to maximize Utility given U=10x^.25y^.75

Px = 2
Py = 2
Income = 100
So my cells look like this

U=formula above across the cells
A=10
x= endogenous variable
alpha = .75
y = endogenous
beta = .25

so basically using solver I put the U cell for max by changing cells x and y (the two end. variables) but I'm stuck on one little thing. The budget constraint. Now, the budget constraint NEEDS to be able to be adjustable (I have it setup so that it can be) so that I can simply drop the prices of x and y in their native cells so I can quickly figure out max U when the prices change.

ANY help at all would be greatly appreciated!
 
Status
Not open for further replies.
Back
Top