Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Understand the flexible budget and responsibility report. You create a visualization to show your company's flexible budget and how it is linked to controllable or
Understand the flexible budget and responsibility report. You create a visualization to show your company's flexible budget and how it is linked to controllable or noncontrollable costs for the manufacturing manager. However, when you look at the visualization, it seems that all the costs are a flat line across different activity levels. Based on this information, 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 hawe it already, search for "Power BI download" in your internet browser, or click here for a free download. Part 1 When the activity level is 9,000 , what is the total fixed costs? $90,000 $60,000 $80,000 $70,000 Attempts: 0 of 3 used Part 2 When the activity level is 6,000 , what is the total variable costs? $56,000 $64,000 $40,000 $48,000 If the company's actual total variable costs for activity level 5,000 is $50,000, is the difference favorable or unfavorable and by how much amount? Favorable $10,000 Favorable $15,000 Unfavorable $20,000 Unfavorable $10,000 Understand the flexible budget and responsibility report. You create a visualization to show your company's flexible budget and how it is linked to controllable or noncontrollable costs for the manufacturing manager. However, when you look at the visualization, it seems that all the costs are a flat line across different activity levels. Based on this information, 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 hawe it already, search for "Power BI download" in your internet browser, or click here for a free download. Part 1 When the activity level is 9,000 , what is the total fixed costs? $90,000 $60,000 $80,000 $70,000 Attempts: 0 of 3 used Part 2 When the activity level is 6,000 , what is the total variable costs? $56,000 $64,000 $40,000 $48,000 If the company's actual total variable costs for activity level 5,000 is $50,000, is the difference favorable or unfavorable and by how much amount? Favorable $10,000 Favorable $15,000 Unfavorable $20,000 Unfavorable $10,000
Step 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