Reference no: EM13850218
You manufacture WIDGETs. Your old machine broke.
You can buy Machine #1 for $ 5000. Using machine #1, each widget will cost $ 10 to make.
You can buy Machine #2 for $ 2000. Using machine #2, each widget will cost $ 15 to make.
I would like to determine the breakeven point for A and B using TWO different methods.
On sheet1, we will use GOAL-SEEK. On sheet2, we will use graphs.
Here is an outline for sheet1:
|
A
|
B
|
|
# of units
|
|
|
Cost to make B2 units using machine #1
|
|
|
Cost to make B2 units using machine #2
|
|
|
Breakeven Point
|
|
|
|
|
Hint: BEP is where both costs are equal. In general, when P=Q, then P-Q = 0.
On sheet2, create the following grid
|
A
|
B
|
C
|
D
|
|
|
# units
|
Machine #1 cost
|
Machine #2 cost
|
Which is cheaper
|
|
|
300
|
|
|
|
|
|
400
|
|
|
|
|
|
500
|
|
|
|
|
|
600
|
|
|
|
|
|
700
|
|
|
|
|
|
800
|
|
|
|
|
Compute the cost to produce 300 units using machine #1 and then by machine #2, and using an =IF statement, tell me which machine is cheaper.
Do the same for 400, 500, 600, 700, 800 units.
As you can see, #2 is cheaper for smaller quantities and #1 is cheaper for larger quantities.
Please create a line graph showing the two costs intersecting. Please have quantity as the x axis and dollars as the y axis.
|
Are all solids able to conduct an electric current
: Are all solids able to conduct an electric current? Explain
|
|
Write a response paper summarizing your thoughts
: Write a response paper summarizing your thoughts and feedback related to these articles. APA: Ethical Principles of Psychologists and Code of Conduct and Ethical Considerations in Writing Psychological Assessment Reports.
|
|
Relationship between beak size and percent of thistle
: When given the relationship between beak size and percent of thistle seeds in the stomach is positive linear,given the relationship between beak size and percent of sunflower seeds in the stomach is negative linear.What's the relationship between the..
|
|
According to an article in the maclean''s magazine
: According to an article in the Maclean's magazine, "Cable, satellite and wireless companies may be charging illegal late fees. Companies may calculate a compounded late-fee rate of two percent a month. However, because they charge even if a customer ..
|
|
Compute the cost to produce 300 units using machine 1
: Compute the cost to produce 300 units using machine #1 and then by machine #2, and using an =IF statement, tell me which machine is cheaper
|
|
The theory of constraints relate to continuous improvement
: How might the theory of constraints be implemented in a Lean organization. How about in an Activity Based Management organization. How does the Theory of Constraints relate to continuous improvement
|
|
Streisand signed a recording contract
: Around January 1, 1993, Barbara Streisand signed a recording contract with Sony Corporation for $2 million each year for 10 years. Suppose the first payment of $2 million was made on the day of signing the deal and all other payments to her were
|
|
Analyze the level of foreign aid that canada gives
: Suppose you want to analyze the level of foreign aid that Canada gives to developing countries each year. You are told that Canada's aid depends on the population of these countries, their level of poverty, and how good governance is in these countri..
|
|
What are some key terms in health information technology
: What are some key terms in health information technology? List and define two. What organizations safeguard health policies? List at least two organizations and a policy they safeguard. Provide a brief description of the U.S. Food Drug Administration..
|