Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer the last two questions.. Home Insert Draw Page Layout Formulas Data Review View Help Break-Even Point 100.0000 For all questions assume flexible production
please answer the last two questions..
Home Insert Draw Page Layout Formulas Data Review View Help Break-Even Point 100.0000 For all questions assume flexible production capacity >> Sales forecast Confirmed orders similar Results S800 Break-Even Analysis Data Una Revenue Faced Cost 550 000 Merginal Cost $400 Postage per unit Fax Machine cost "New Sales" Forecast Confirmed future orders 100 Total Revenue Total Fixed Cost Total Variable Cost $360.000 $50,090 $164.000 Profit (Loss) $145,910 Break Even Point 102.2245 103.0000 Real break even Food for thought How wil a 10% discount on the last 100 products affect the break even analysis? If number of units sold increases by 155 units, how will it affect the break even number? Assignment 1 questions - solve each of the questions below as a separate functional model on this tab worksheet w you knew that a 25% discount on the last 200 units would cause the new sales to increase to a total of 430, would you do it? If you are the 40 discount on the last 200 units would cause the new sales to increase to a total of 430, would you do it? What is the maximum discount you would provide on the last 200 units if you wanted to mantan the same proft amount, but lower proft and higher market share? Break Even Analysis How would and increase or decrease in the capital costs for machinery real estate affect the break even point? How would it affect the discount you could offer? the captaicosts were to crease by 20%, what is the maximum discount you could offer on the last 200 products for new sales cast of 430 with same proft amount objective InClass Type here to search Home Insert Draw Page Layout Formulas Data Review View Help Break-Even Point 100.0000 For all questions assume flexible production capacity >> Sales forecast Confirmed orders similar Results S800 Break-Even Analysis Data Una Revenue Faced Cost 550 000 Merginal Cost $400 Postage per unit Fax Machine cost "New Sales" Forecast Confirmed future orders 100 Total Revenue Total Fixed Cost Total Variable Cost $360.000 $50,090 $164.000 Profit (Loss) $145,910 Break Even Point 102.2245 103.0000 Real break even Food for thought How wil a 10% discount on the last 100 products affect the break even analysis? If number of units sold increases by 155 units, how will it affect the break even number? Assignment 1 questions - solve each of the questions below as a separate functional model on this tab worksheet w you knew that a 25% discount on the last 200 units would cause the new sales to increase to a total of 430, would you do it? If you are the 40 discount on the last 200 units would cause the new sales to increase to a total of 430, would you do it? What is the maximum discount you would provide on the last 200 units if you wanted to mantan the same proft amount, but lower proft and higher market share? Break Even Analysis How would and increase or decrease in the capital costs for machinery real estate affect the break even point? How would it affect the discount you could offer? the captaicosts were to crease by 20%, what is the maximum discount you could offer on the last 200 products for new sales cast of 430 with same proft amount objective InClass Type here to searchStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started