Question: PROBLEM 1 (Version A): The sales manager for PopBoys is developing a new lubricant for high-power engines. The product called Fuel Tool is being evaluated

 PROBLEM 1 (Version A): The sales manager for PopBoys is developinga new lubricant for high-power engines. The product called "Fuel Tool" is

PROBLEM 1 (Version A): The sales manager for PopBoys is developing a new lubricant for high-power engines. The product called "Fuel Tool" is being evaluated for a breakeven point. She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in a worksheet labeled "PopBoys Auto Data". The equipment that is used to produce this product is leased for $10,000/ year. Using the data, create a pivot table that extracts the marginal costs and revenue for the turbo product. ROUND TO THE NEAREST CENT. DO NOT HYPERLINK VALUES FROM THE PIVOT TABLE. Enter the data. 1. Find the break-even point where profit is finally seen? Also, ensure answer is in cell C:9. Calculate the total revenue, fixed costs, total variable cost and profit(Loss) in column F cells provided. Use formulas. 2. Create a chart showing the crossover of Revenue and Cost. Make sure to appropriately label axis as Break Even. Start your production quantity chart range as 19002600 in 100 equal values starting in cell H13. USE FORMULAS TO CALCULATE COST and REVENUE. You need to add revenue and cost formulas and values. Be professional

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!