The product manager for a new haircare product called “turbo” is evaluating breakeven points for her organization. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in a worksheet labeled “Haircare Data”. The equipment that is used to produce this product is leased for $25,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the turbo product.

1. What is the break-even point where profit is finally seen? (Ensure answer is in cell C:9)

2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label the axis. Start your production quantity with a minimum of 4800 units.

3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding workflow on this worksheet.

-The Vice-President from the same corporation in Problem 1, loves your analytical ability. She wants you to evaluate the breakeven point of all the Haircare products they manufacture together EXCEPT “viral”. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in the previous worksheet labeled “Haircare Data”. The equipment that is used to produce all the products except “viral” is leased for $115,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the select products.

1. What is the break-even point? (Ensure answer is in cell C:9)

2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label the axis. Your production quantity should be near/close to half the range of the X-axis.

3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding workflow on this worksheet.

  
 
 
 

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 D E Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Break- en Point F Results $0 $0 $0 #DIV/0! G H 1 Production Qty Total Revenue-UnitRevenue*ProductionQuantity Total Fixed Cost = IF (ProductionQuantity>0, Fixed Cost,0) Total Variable Cost = MarginalCost* ProductionQuantity Profit (loss) = TotalRevenue-(TotalFixed Cost+TotalVariableCost) Break-Even Point = FixedCost/(UnitRevenue-MarginalCost) Graph Points J Revenue Cost K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 D E Total Revenue Total Fixed Cost Total Variable Cost Profit (Loss) Break- en Point F Results $0 $0 $0 #DIV/0! G H 1 Production Qty Total Revenue-UnitRevenue*ProductionQuantity Total Fixed Cost = IF (ProductionQuantity>0, Fixed Cost,0) Total Variable Cost = MarginalCost* ProductionQuantity Profit (loss) = TotalRevenue-(TotalFixed Cost+TotalVariableCost) Break-Even Point = FixedCost/(UnitRevenue-MarginalCost) Graph Points J Revenue Cost K

Answer rating: 100% (QA)

PROBLEM 1 1 What is the breakeven point where profit is finally seen To calculate Product lease divided by Production quantity Thus Product lease 2500... View the full answer