{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T07:36:37-04:00", "answer_date": "2024-06-28 07:36:37", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4264507", "url": "\/study-help\/questions\/good-evening-in-this-question-i-dont-know-the-4264507", "question_creation_date_js": "2024-06-28T07:36:37-04:00", "question_creation_date": "Jun 28, 2024 07:36 AM", "meta_title": "[Solved] Good evening , In this question I don`t k | SolutionInn", "meta_description": "Answer of - Good evening , In this question I don`t know the 4th step\/question. I stared to work on it But I am not sure what form | SolutionInn", "meta_keywords": "good,evening,question,don,4th,step\/question,stared,work,formula,help,thank,assume", "question_title_h1": "Good evening , In this question I don`t know the 4th step\/question. I stared to work on it But I am not sure what formula", "question_title": "Good evening , In this question I don`t know the 4th step\/question.", "question_title_for_js_snippet": "Good evening , In this question I don t know the 4th step question I stared to work on it But I am not sure what formula I should use and how it goes Can you please help Thank you, In the following example, assume you own a small company that has developed a new exercise devicecalled The Strider that tells someone how far they have walked, how many calories they have burned and how many paces per mile they have tallied Assume the following facts The machine that makes the device was purchased for $11,500 The microprocessors, the plastic case materials and the labor needed to assemble it costs $15 for each device You have decided to sell the product directly to the consumer through a website promoted through ads The price you intend to charge each buyer for the Strider is $42 Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and Breakeven Point Go to the Excel Homework and click on the tab worksheet labeled Breakeven Analysis Create a breakeven analysis table for The Strider Note that the Breakeven Point is in units and should therefore be rounded You should set up the spreadsheet with the appropriate formulas to change the price, cost and sales volume quickly Answer the following questions 1 Whatareyourrevenues,totalexpensesandprofitifyousell10,000Striders 2 HowmanyStridersdoyouneedtosellat$42tobreakeven 3 Whatareyourrevenues,expensesandprofitifyousell15,000Stridersbylowering the price to $35 each 4 HowmanyStridersdoyouneedtosellat$42tomake$500,000inprofits (Findthe answer by using the formula to calculate the profit, i e , Profit Revenue Total Cost ) Type All Answers on your Excel Spreadsheet that you will submit Units sold $10,000 Sales price $42 00 Revenue $420,000 Fixed Cost $11,500 Variable cost per unit $15 00 Total Cost $161,500 Profits $ 258,500 Break even point $ 426 Units Sold $15,000 Sales price per unit $35 00 Revenue $525,000 Fixed Cost $11,500 Variable cost per unit $15 00 Total Cost $236,500 Profits $288,500 Break even point 575 4 th step Desirable Profit $500,000 Fixed Cost $11,500 Desired contribution $511,500", "question_description": "
Good evening ,<\/p>
<\/p>
In this question I don`t know the 4th step\/question. <\/strong>I stared to work on it But I am not sure what formula I should use and how it goes. Can you please help?<\/p> <\/p> Thank you,<\/p> <\/p> In the following example, assume you own a small company that has developed a new exercise devicecalled \"The Strider\"that tells someone how far they have walked, how many calories they have burned and how many paces per mile they have tallied. Assume the following facts. <\/p> The price you intend to charge each buyer for the \"Strider\" is $42. <\/p> Before you market the product, you decide to create a spreadsheet to estimate the revenues, costs, profits and \"Breakeven Point.\" Go to the \"Excel_Homework\" <\/strong>and click on the tab\/worksheet labeled \"Breakeven Analysis.\" <\/strong>Create a breakeven analysis table for \"The Strider\". <\/p> Note that the Breakeven Point is in units and should therefore be rounded. You should set up the spreadsheet with the appropriate formulas <\/strong>to change the price, cost and sales volume quickly. <\/p> Answer the following questions: <\/strong><\/p> 1. Whatareyourrevenues,totalexpensesandprofitifyousell10,000Striders? 2. HowmanyStridersdoyouneedtosellat$42tobreakeven? <\/strong><\/p> 3. Whatareyourrevenues,expensesandprofitifyousell15,000Stridersbylowering the price to $35 each? <\/strong><\/p> 4. HowmanyStridersdoyouneedtosellat$42tomake$500,000inprofits?(Findthe answer by using the formula to calculate the profit, i.e., Profit = Revenue - Total Cost.) <\/strong><\/p> Type All Answers on your Excel Spreadsheet that you will submit. <\/p> Units sold $10,000 <\/p> Sales price $42.00 <\/p> Revenue $420,000 <\/p> <\/p> Fixed Cost $11,500 <\/p> Variable cost per unit $15.00 <\/p> Total Cost $161,500 <\/p> Profits $ 258,500 <\/p> Break even point $ 426 <\/p> <\/p> Units Sold $15,000 <\/p> Sales price per unit $35.00 <\/p> Revenue $525,000 <\/p> <\/p> Fixed Cost $11,500 <\/p> Variable cost per unit $15.00 <\/p> Total Cost $236,500 <\/p> Profits $288,500 <\/p> Break even point 575 <\/p> <\/p> 4.th step <\/p> Desirable Profit $500,000 <\/p> Fixed Cost $11,500 <\/p> Desired contribution $511,500 <\/p> <\/p> <\/p> <\/p> <\/p> <\/p> <\/p> <\/p>",
"transcribed_text": "",
"related_book": {
"title": "Income Tax Fundamentals 2013",
"isbn": "1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516",
"edition": "31st Edition",
"authors": "Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill",
"cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/1124.jpg",
"uri": "\/textbooks\/income-tax-fundamentals-2013-31st-edition-9781285586618",
"see_more_uri": ""
},
"free_related_book": {
"isbn": "B0788WV22Q",
"uri": "\/textbooks\/2015-agricultural-productivity-decentralisation-and-competitiveness-analysis-for-provinces-and-regions-of-indonesia-1st-edition-b0788wv22q-288120",
"name": "2015 Agricultural Productivity Decentralisation And Competitiveness Analysis For Provinces And Regions Of Indonesia",
"edition": "1st Edition"
},
"question_posted": "2024-06-28 07:36:37",
"see_more_questions_link": "\/study-help\/questions\/business-banking-2021-September-12",
"step_by_step_answer": "The Answer is in the image, click to view ...",
"students_also_viewed": [
{
"url": "\/waller-co-paid-a-0286-dividend-per-share-in-2006",
"description": "Waller Co. paid a $0.286 dividend per share in 2006, which grew to $0.55 in 2012. This growth is expected to continue. What is the value of this stock at the beginning of 2013 when the required...",
"stars": 3
},
{
"url": "\/study-help\/theory-of-probability\/for-open-queueing-networks-a-state-and-prove-the-equivalent-1982970",
"description": "For open queueing networks (a) state and prove the equivalent of the arrival theorem; (b) derive an expression for the average amount of time a customer spends waiting in queues.",
"stars": 3
},
{
"url": "\/study-help\/questions-and-answers\/read-the-case-xyz-company-an-integrated-capital-budgeting-instructional",
"description": "Read the case XYZ Company: An Integrated Capital Budgeting Instructional Case and answer the following question: Should the replacement asset be purchased? That is, does it make economic (financial)...",
"stars": 3
},
{
"url": "\/study-help\/questions\/exercise-2011-part-level-submission-larkspur-company-sponsors-a-defined-9871932",
"description": "Exercise 20-11 (Part Level Submission) Larkspur Company sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the plan for the year 2020 in which no...",
"stars": 3
},
{
"url": "\/study-help\/questions\/in-this-exercise-you-will-be-assuming-the-role-of-268346",
"description": "In this exercise you will be assuming the role of an Account Manager working within our Personal Care Appliances category during Amazon Black Friday. You act as a general manager responsible for...",
"stars": 3
},
{
"url": "\/study-help\/questions-and-answers\/write-a-brief-note-on-ebusiness-write-the-examples-of",
"description": "Write a brief note on E-Business. Write the examples of the following e-business models c2c c2b b2c b2b. Why security is important with these 4 models. What is pure play and what is click and mortar.",
"stars": 3
},
{
"url": "\/study-help\/questions\/5-using-the-following-data-calculate-the-breakeven-point-and-1004410",
"description": "5. Using the following data, calculate the breakeven point and margin of safety in units: Selling Price = $50 Variable Cost =$40 Fixed Cost = $70,000 Budgeted Sales = 7,500 units",
"stars": 3
},
{
"url": "\/study-help\/questions\/megan-used-to-work-at-the-local-pizzeria-for-30000-1003752",
"description": "Megan used to work at the local pizzeria for $30,000 per year but quit in order to start her own deli. Last year, she paid $6,000 rent each month, $5,500 for employee payroll each month, and $1,500...",
"stars": 3
},
{
"url": "\/study-help\/questions\/using-a-motorcycle-system-create-a-list-of-functional-and-1004250",
"description": "Using a Motorcycle System, create a list of functional and physical terms, develop a functional hierarchy and a physical hierarchy for the Motorcycle System.",
"stars": 3
},
{
"url": "\/study-help\/questions\/after-also-looking-specifically-at-the-report-on-pages-11-1003872",
"description": "After also looking specifically at the report on pages 11 and 10, discuss the usefulness of the ESEA of 1965 as it relates to safety and security in the 2010's. Discuss the value of federal action...",
"stars": 3
},
{
"url": "\/study-help\/questions\/question-1-discuss-the-primary-factors-influencing-earths-climate-and-8020992",
"description": "Question 1: Discuss the Primary Factors Influencing Earth's Climate and How They Interact Question 2: Explain the Concept of Climate Models and Their Role in Predicting Future Climate Changes",
"stars": 3
}
],
"next_back_navigation": {
"previous": "\/study-help\/questions\/ace-inc-has-just-completed-its-yearend-financial-statements-and-4264506",
"next": "\/study-help\/questions\/415-a-family-has-n-children-with-probability-apnm-2-4264508"
},
"breadcrumbs": [
{
"name": "Study help",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers"
},
{
"name": "Business",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business"
},
{
"name": "Accounting",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting"
},
{
"name": "Good evening , In this question I don`t know the 4th step\/question.",
"link": "https:\/\/www.solutioninn.com\/study-help\/questions\/good-evening-in-this-question-i-dont-know-the-4264507"
}
],
"skill_details": {
"skill_id": "9",
"skill_name": "Accounting",
"parent_id": "1"
}
}1"
}
}