
ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN: 9780190931919
Author: NEWNAN
Publisher: Oxford University Press
expand_more
expand_more
format_list_bulleted
Question
13 see picture to solve

Transcribed Image Text:Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet:
Input data
fixed cost
variable cost per unit 4.05
sell price per unit
21,000 Units
1,500
revenue =D2*B4
6.5
expenses=B2+(B3*D2)
profit
=D3-D4
Use Excel's Goal Seek to answer the following question. Assuming that demand is
fixed at 1,500 units, what is the sell price per unit that results in break even?
Enter only the numerical solution. Do not include a $ sign.
Your Answer:
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Similar questions
- Adam picked 240 oranges from his orchard. He packed them equally in 12 bags and sent them to the farmer's market. How many oranges does each bag contain?arrow_forwardFill in the table below, giving a numerical value for letters A, B, C, and D. TC AFC AVC 50 1 90 A B D 30 2.arrow_forwardQuestion 32 Which points represent a production level that could lead to unemployment? 12 10 Thousands of sedans 8 9 4 A 2 D B C 0- 0 2 4 6 8 10 12 Thousands of convertibles Full text description Selected answer will be automatically saved. For keyboard navigation, press up/down arrow keys to select an answer. Q Searcharrow_forward
- Which type of graph will be suitable for representing the above sales revenue by regionsarrow_forward8 Write an email (120-150 words) to ask for • information about an activity that you would like to do. Use an idea from the list or your own idea. Follow the content checklist and remember to use indirect questions. a course at a college or with a one-to-one tutor a sport / activity at a gym joining a volunteering group Checklist • how you heard about the course / activity/group ⚫ the days and times ⚫ the cost if you need any experience / skills • if you need any equipmentarrow_forwardPlease answer question Darrow_forward
- Whats a problem customers face with LCD Panels Battery issues?arrow_forwardTyped plz and asap please provide me a quality solution for better ratings and take care of plagiarism also ( please I need it asap I will up vote thanks )arrow_forwardTotal Total Total Product Fixed Variable (Blankets) Cost Cost 0 A 0 1 60 25 2 60 40 3 60 I 4 60 55 5 60 55 6 60 70 7 60 100 8 60 145 A What is the numerical value of B? A/ What is the numerical value of C? A/ Total Cost What is the numerical value of D? B 85 100 110 G 115 130 160 205 Average Average Average Variable Total Fixed Cost Cost cost - с 60 30 20 15 12 8.6 7.5 25 20 16.7 13.8 Ꭰ 11.7 14.3 18.1 E The table describes the short-run daily costs of the Baby Blanket Company. What is the numerical value of A? 85 36.7 28.8 J 21.7 22.9 25.6 Marginal Cost F H 15 10 0 15 30 45arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education


Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON

Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON

Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning

Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning

Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education