ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN: 9780190931919
Author: NEWNAN
Publisher: Oxford University Press
expand_more
expand_more
format_list_bulleted
Question
Mountain Cycle specializes in making custom mountain bikes. The company founder, P. J. Steffan, is having a hard time making the business profitable. Knowing that you have great business knowledge and solid financial sense, P. J. has come to you for advice.
- J. would like you to determine how many bikes Mountain Cycle needs to sell per year to break even. Using Goal Seek in Excel, solve using the following by using the AYK24_Data.xlsx file
- Fixed cost equals: $ 70,000
- Unit cost equals: $ 1,500
- Bike
price equals: $ 3,500
Requirement:
1.Goal Seek
- Create formula for break even
- Set up goal seek function
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
Similar questions
- The technique used in management accounting to determine the change in profit associated with the cost or benefit of the next (or the marginal) unit is calledarrow_forwardEconomics Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Do not provide Excel Screet shot rather use tool table Answer completely.arrow_forwardTo earn full credit your graphs must include the following specific graphs: Find the graph for short run economic loss for the firm. Find the graph for short run economic profit for the firm. Find the graph for long run – normal profit for the firm. Make sure the graphs show the area of economic profit or loss.arrow_forward
- Homework (Ch 09) * MindTap - Cengage Learning x + atic/nb/ui/evo/index.html?deploymentld=58830023220612202193347127562&elSBN=9781337622349&id=D908491136&snapshotld=19375308& CENGAGE MINDTAP Homework (Ch 09) Suppose Ginny gives haircuts on Saturdays to make extra money. She is the only person in town cutting hair on Saturdays and therefore has some market power. Assume that she does not incur fixed costs, and the only significant variable cost to Ginny is her time. As she gives more haircuts, Ginny must increasingly forgo other valuable Saturday activities. For example, if she gives one haircut, she forgoes reading the paper after breakfast. If she gives two haircuts, she gives up reading the paper and sleeping an extra half-hour. Ginny's clients are a varied group willing to pay between $16.00 and $28.00 for a haircut. Assume that Ginny cannot price discriminate, i.e., charge different clients different prices. If Ginny charges $28.00 per haircut, she will have one client per week; if…arrow_forwardPlease do fast ASAP fastarrow_forwardSuppose that you want to open a new business or purchase an existing one. Describe that business. What good or service would you provide? Where would you be located? What would be some explicit costs of starting the business? What would be some implicit costs?arrow_forward
- Have there been any instances of unethical behavior at Apple? was there a reason for doing this and how corporate governance may have prevented itarrow_forwardQuestion 8 page 28 Janet spends $20,000 per year on painting supplies and storage space. She recently received two job offers from a famous marketing firm- one offer were for $100,000 per year, and the other was for $90,000. However, she turned both jobs down to continue a painting career. If Janet sells 25 paintings per year at a price of $8,000 each: a. What are her accounting profits? Show your steps leading to your answer b. What are her economic profits? Show your work!arrow_forwardThe total profit from the sale of q sweatshirts is: P(q) = 5q – 0.005q2 – 450. a. Calculate the additional profit earned when 450 sweatshirts are sold. ________ b. Calculate the additional profit earned when 750 sweatshirts are sold.arrow_forward
- recently won the lottery and is pursuing his dream to be a photographer. Dick's wife, Janine, is a real estate agent; she believes she has found an old warehouse in the industrial part of town that could be turned into their headquarters. The owner of the warehouse, Jordan, is retiring and open to the idea of selling or renting the space. How might the business be structured? What might be some of the legal issues that could arise in operating the business and selling the product? What are some of the agreements that might be needed?arrow_forwardCOVID-19 Lockdown Price FreezeYou have been appointed as the Marketing Manager of Makro, Massmart CEO Mitchell Slape hasassigned you tasks and requires you to write a report that will be presented at the next Massmart Boardmeeting. You are encouraged to conduct further research on the company.Background issues1Massmart . is a South African firm that owns local brands such as Game, Makro, Builder's Warehouse,Cambridge Food and Cash & Carry stores.2Massmart announces a price freeze in all their brands for the duration of the 21-day nationwidelockdown. This will involve. suspending price adjustments that were scheduled, as part of the normalcourse of business, before the lockdown was announced. Fresh produce, which is procured daily fromfresh produce markets around the country, is the only category that is not included in this announcement.3Commenting on the decision, Massmart CEO Mitchell Slape said: “This is an unprecedented time forSouth Africa and the. world. As we all come to…arrow_forwardYou are in charge of improving utilization of resources at a restaurant that is taking only online orders for delivery to the specific addresses. There are three kind of orders received: vegetarian, non-vegetarian and gluten free. For every vegetarian order, the chopping and dicing section, the deli-cheese section, the stir fry kitchen, and marination are used. For non-vegetarian orders; the chopping and dicing section, the deli-meat section, the marination section, and the non-veg kitchen is used. In addition to this 50% of non-vegetarian dishes go through the grilling section while the other 50% go through the baking (oven) section. Gluten free dishes go through the chopping and dicing section and the stir fry kitchen only. The typical order size consists of 25 non-veg orders, 12 veg orders and 5 gluten free orders. Marination of vegetarian dishes take 5 minutes while that of non-vegetarian dishes 1 hour. Chopping and dicing for 10 vegetarian/gluten-free dishes take an hour, while…arrow_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