Question

In: Advanced Math

Please provide step by step solution in excel (with formulas) Breaking Even Mountain Cycle specializes in...

Please provide step by step solution in excel (with formulas) Breaking Even Mountain Cycle specializes in making custom mountain bikes. The company founder, PJ Steffan, is having a hard time making the business profitable. Knowing that you have great business knowledge and solid financial sense, PJ has come to you for advice. Project Focus PJ 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: Fixed cost equals $65,000 Variable cost equals $1,575 Bike price equals $2,500

Solutions

Expert Solution




Hence Breakeven Bike quantity = 70.27 = 71 (rounding off to the nearest biggest integer)


Related Solutions

Please provide a step-by-step solution, with "Given:", "Find:", and "Solution:" format, for the problem below. Please...
Please provide a step-by-step solution, with "Given:", "Find:", and "Solution:" format, for the problem below. Please be sure to include any tables, values, and references required to arrive at the solution you provide so that the process may be repeated for other values. Horizontal Formwork Design Given: 6 in structural steel-concrete floor slab. Use ¾ in Class I plyform parallel to the span for the sheathing and Southern Yellow Pine #2 for the rest of the lumber. Joists will be...
Please provide a step-by-step solution, with "Given:", "Find:", and "Solution:" format, for the problem below. Please...
Please provide a step-by-step solution, with "Given:", "Find:", and "Solution:" format, for the problem below. Please be sure to include any tables, values, and references required to arrive at the solution you provide so that the process may be repeated for other values. Vertical Formwork Design Given: Design formwork for a 6-ft-high wall. The concrete is to be placed at a rate of 2 ft/hr and will not be vibrated. Concrete temperature is expected to be 50˚F. Use standard weight...
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma...
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma mater, Will Anderson has come up with a scheme to stay around for 5 more years: He has decided to bid on the fast-food concession rights at the football stadium. He feels sure that a bid of $60,000 will win the concession, which gives him the right to sell food at football games for the next 5 years. He estimates that annual operating costs...
Please provide me a solution step by step. Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even...
Please provide me a solution step by step. Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (19,500 units × $30 per unit) $ 585,000 Variable expenses 409,500 Contribution margin 175,500 Fixed expenses 180,000 Net...
Please provide step be step solution At a depth of 7km in the ocean,the pressure is...
Please provide step be step solution At a depth of 7km in the ocean,the pressure is 71.6Mpa assume a specific weight at the surface 10.03kn/m3 and average bulk modulus of elasticity of 2.34Gpa for that pressure range find (a) the change in specific volume between the surface and 7km (b) specific volume at 7km (c) the specific weight at 7km
Please provide a step by by step solution Please key these names in alphabetical index filing...
Please provide a step by by step solution Please key these names in alphabetical index filing order accordint to the ARMA rules James Danforth, Jr. Burns Travel Agency Strathcona County Water Department Norton R. Henson Sister Marie O’Doul The Lone Ranger Riding Supplies The Jefferson Party House El Rancho Inn Cecil Young-Jones RCT Manufacturers Administrative Management Society Hotel Baker Triple-Star Enterprises Miss Robert’s Charm School Acadia University, Wolfville, Nova Scotia Bob Guerin William T. Au Thomas Kaplan, M.D. Irene McGregor...
please provide me work book(Excel) with formulas in Excel to value options based on block sholes...
please provide me work book(Excel) with formulas in Excel to value options based on block sholes model
please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City....
please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City. Like many city newspapers, the TimesObserver is suffering through difficult financial times. The circulation manager is studying other papers in similar cities in the United States and Canada. She is particularly interested in what variables relate to the number of subscriptions to the paper. She is able to obtain the following sample information on 25 newspapers in similar cities. Ignore the data in the...
1) (note: Please also provide the excel formulas used to solve it )  You work for a...
1) (note: Please also provide the excel formulas used to solve it )  You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...
Please provide a step by step solution Key the names in indexing order using the ARMA...
Please provide a step by step solution Key the names in indexing order using the ARMA rules. In the upper right corner of each card, key the corresponding number for each name James R. Larsen Bob O’Donald Helen Vandermallie Martha Odell-Ryan Sister Catherine George Harris, Ph.D. Mrs. Georgia Harris Father Jenkins Ty Chen Martha Odellman Allens Swap Shop J. T. Larson Herbert Vander Mallie George Harris, M.D. Mary Allen’s Beauty Shop Marshall Field & Company Georgia Harris Allens’ Print Shop...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT