70.2K

Verified Solution

Link Copied!

Break-Even Analysis You are in the process of understanding a product's cost composition. You notice that there are five major components: direct materials, direct labor, maintenance, equipment rental and factory security. These costs may or may not change with the production level. A visualization shows you the (unit) costs for these items when the production level is up to 10,000 units, 10.001 to 20,000 units. 20,001 to 30,000 units and 30,001 to 40,000 units. Given that 40,000 units is the largest possible capacity, the company is not able to go beyond 40,000 units. Based on this visualization, please answer the following questions. Click here to access a Tableau file, and here to access a Power BI file. (The Tableau and Power BI files contain the same data, you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download the most recent version of Tableau Reader, a free program that allows you to open Tableau visualizations. To get the most recent version, search for "Tableau Reader" in your internet browser or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already search for "Power BI download in your internet browser, or click here for a free download. It seems that per unit direct labor cost and equipment rental are all fixed fie, does not change with production levels). Is this true? E = 7 UT, I. 1 B T OF 20 ON Direct labor (per unit) Direct tense) Variable CVP Dashboard 20000 Maintenance (per un Director) Direct materials (per unit) 000 Maintenance for Direct labore Level in Units Dect materials per unit) 9000 Maintenance pert) Direct labortprint) Direct materials per COOL Maintenance (Dernit) W Fixed Content 00001 Factory out Entrental 20000 Luval in Factory 9000 Factory Security 9000 Top Factory O Words) Based on the formula in the textbook for calculating the break-even quantity, what is the break-even quantity it the expected selling price is $100 and the production level is expected to be at 15,000 level? 99 BUT T'I E E a O Word)

Answer & Explanation Solved by verified expert

See Answer