Purchase Solution

Maximizing profit on the sale of widgets

Not what you're looking for?

Ask Custom Question

You can sell widgets for $50/Y, where Y is the number of widgets you sell. In other words, the more widgets you sell, the lower the price. It costs $1.5Y to make Y widgets. Using Excel, how many widgets do you make to maximize your profits?

Purchase this Solution
Solution Summary

In Excel, the solution is demonstrated and solved.

Solution Preview

Please see the attached excel spreadsheet.

This problem, ...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

View More Free Quizzes
Related BrainMass Solutions

  • Analyzing the Given Cost Data

    5) Draw a graph of marginal revenue (the increase in revenue from the sale of an additional unit) vs. number of widgets produced.

  • The profit maximization

    Would a lump-sum profits tax affect the profit-maximizing quantity of output? How about a tax assessed on each unit of output? 3. Universal Widget produces high-quality widgets at its plant in Gulch, Nevada for sale throughout the world.

  • Breakeven Point

    THERE IS ADEQUATE CAPACITY TO MANUFACTUR AND SALE THESE WIDGETS. 5. PROFIT ON THIS ORDER ONLY IF THE SALES PRICE IS $24.00. ______________________________ 6.

  • Maximizing Profits for a Widget Monopoly

    If marginal cost is constant at $20 and fixed cost is $100, what is the profit-maximizing level of output? (Choose one of the specific levels of output from the schedule.) What is the level of profit?

  • Cost volume profit questions - break even

    THERE IS ADEQUATE CAPACITY TO MANUFACTUR AND SALE THESE WIDGETS. 5. PROFIT ON THIS ORDER ONLY IF THE SALES PRICE IS $24.00. ______________________________ 6.

  • FIFO (First In, First Out) and Wedges

    Anything that is sold, is the oldest remaining inventory for costing purposes. The average costing method, on the other hand, assumes costs of goods sold is based on the average cost of the goods available for sale during the period.

  • Important Information About Supply and Demand Changes

    You are being given data on supply and demand for the whole market, and are being asked what effect that has on you as a small part of that market.

  • deadweight loss

    What is GreatReception's profit when producing at the profit-maximizing output ? ($9800, $9100, $4200, or $4900) a. What is the total consumer surplus when GreatReception operates as a monopolist? ($9800, $7350, $6900, or $2450) c.

  • 5 Problems

    Indicate the profit-maximizing quantity (and price) on your graph. (c) Calculate Bob's profit as this level of output. Show your work.

View More Related Solutions