Question: Give me another example please don't use the previous one and solve by using Excel put the data on excel.Thanks on 1- (Use hypothetical cost
on 1- (Use hypothetical cost data figures) for your dream company and complete a BREAK EVEN POINT analysis for this company. 1.Explain in simple terms the dream company you want to built: Such as "What is the objective of the company and what product you want to sell? (i.e, you c want sell electric cars that doesn't pollute the environment, or you want to set up solar roof panels for the customers and use Tesla batteries to store the power and sell the extra power produced, given that government is funding this initiatives for now) ii. What is the estimated market size (number of units: demand for your product ). ili. What is the monthly RENT, property maintenance cost, Management and other administrative salaries, license fees and interest cost on borrowed money? How much is your Estimated F.C. - ? (What is the total fixed costs at your production plant/term? Define F.C. and feel free to include other fixed costs) iv-How much each product will cost you to produce or buy (direct labor cost/unit + direct raw material cost, i.e. assume tesla batteries on average is 8K) Estimated VC-?$ (What is the variable cost for your product? and (Define VC) Calculate Total Cost/term: (Suggested term is month) What is the S.P. Selling Price and Total Revenue/term? Explain Total Revenue, total cost and Total Proht functions and calculate B.E.P Break Even Point. Build the spread sheet and the graphs - EXPLAIN THE RESULTS to show your understanding of the BEP concept. - Discuss the Break Even Analysis for your company: For example , How many panels (or electric cars) you need to sell to break even? When do you start making profit? V. What do you expect the worst case and best case and most likely case will be what do you think the probabilities of occurrence of each case, Do you recommended the start of this company. Discuss CARE m. on 1- (Use hypothetical cost data figures) for your dream company and complete a BREAK EVEN POINT analysis for this company. 1.Explain in simple terms the dream company you want to built: Such as "What is the objective of the company and what product you want to sell? (i.e, you c want sell electric cars that doesn't pollute the environment, or you want to set up solar roof panels for the customers and use Tesla batteries to store the power and sell the extra power produced, given that government is funding this initiatives for now) ii. What is the estimated market size (number of units: demand for your product ). ili. What is the monthly RENT, property maintenance cost, Management and other administrative salaries, license fees and interest cost on borrowed money? How much is your Estimated F.C. - ? (What is the total fixed costs at your production plant/term? Define F.C. and feel free to include other fixed costs) iv-How much each product will cost you to produce or buy (direct labor cost/unit + direct raw material cost, i.e. assume tesla batteries on average is 8K) Estimated VC-?$ (What is the variable cost for your product? and (Define VC) Calculate Total Cost/term: (Suggested term is month) What is the S.P. Selling Price and Total Revenue/term? Explain Total Revenue, total cost and Total Proht functions and calculate B.E.P Break Even Point. Build the spread sheet and the graphs - EXPLAIN THE RESULTS to show your understanding of the BEP concept. - Discuss the Break Even Analysis for your company: For example , How many panels (or electric cars) you need to sell to break even? When do you start making profit? V. What do you expect the worst case and best case and most likely case will be what do you think the probabilities of occurrence of each case, Do you recommended the start of this company. Discuss CARE m
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
