+ Reply to Thread
Results 1 to 5 of 5

help creating a vba macro to maximize profit

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    FL, USA
    MS-Off Ver
    2010
    Posts
    4

    help creating a vba macro to maximize profit

    XYZ Company has a product (GreenWidgets) that is price sensitive. When the price of the product is $600, they will sell 50 GreenWidgets. They wish to know if they are maximizing profits at that price or if there is another price that will yield more profit. They believe that each $50 increase in price will result in one less GreenWidget being sold. How many GreenWidgets will be sold to maximize profit and what will that profit be?

    Write a VBA program that prompts the user to enter:

    a. the current product price that results in 50 GreenWidgets being sold.
    b. the increase in price that results in one less GreenWidget being sold.
    c. Your outputs should be the number of GreenWidgets sold to maximize profit and what the maximum profit at that number of sales would be.

    Can this be done by writing a for loop?

    Thanks!


    Andres

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: help creating a vba macro to maximize profit

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    07-12-2016
    Location
    FL, USA
    MS-Off Ver
    2010
    Posts
    4

    Re: help creating a vba macro to maximize profit

    Dude thank you so much!

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: help creating a vba macro to maximize profit

    Hope you get a good grade in his class, daffodil
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: help creating a vba macro to maximize profit

    I went to art school, so grades were never my strong suit..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-24-2014, 01:46 PM
  2. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  3. 1. consecutive days of profit and of losses 2. biggest profit loss since date
    By xbohemianx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2013, 12:57 PM
  4. Hardware to maximize macro run speed
    By DaveF in forum Excel General
    Replies: 4
    Last Post: 05-25-2012, 07:39 PM
  5. Excel Formula - Creating Profit Splits
    By curtjer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2012, 12:06 AM
  6. Macro to maximize rsq value for a set of data
    By mkerkstra77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2010, 03:07 PM
  7. Maximize one Form Cause Maximize the Other Forms
    By herukuncahyono in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2009, 01:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1