: We recommend downloading the most recent versions of Tableau Reader and/or Power BI Desktop. Both...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
: We recommend downloading the most recent versions of Tableau Reader and/or Power BI Desktop. Both are free to use. You may use either the Tableau file or Power BI file for this assignment. Both file types contain the same visualizations. Tableau file Power BI file Download the Excel data file and complete the question below. Power Mountain Bars is a producer of energy bars. They currently produce three products. The following information has been provided: Product Peanut Butter Chocolate Coconut Pecan Almond Cranberry Selling Price $3.50 $3.85 $4.10 Variable Cost $1.50 $1.90 $1.60 Direct Labor Hours per Unit 0.08 0.09 0.12 Sales Demand 1.500 1,000 2.500 Your goal is to determine how many units of each product should be produced to achieve the maximum total contribution margin. Direct labor is a constrained resource and there is only 400 direct labor hours available per month. You use the Solver function in Excel to determine what product-mix generates the maximum total contribution margin. The results are as follows: Product Peanut Butter Chocolate Coconut Pecan Almond Cranberry 1. You will present your analysis to management. Your approach is to create a dashboard with the following visualizations: Contribution Margin for Peanut Butter Chocolate - This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. 2. Units Produced 3. 1,500 1,000 1,583 Contribution Margin for Coconut Pecan - This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. Contribution Margin for Almond Cranberry- This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. 3. 4. 5. 6. Contribution Margin for Almond Cranberry-This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. Total Labor Hours by Labor Hours per Unit - This is a dual axis bar chart showing the total labor hours required for units produced and the direct labor hours per unit for each energy bar. The total labor hours are represented as bars and the labor hours per unit are represented as a line. Sales Demand vs Units Produced - This is a clustered bar chart showing the sales demand and the units produced for each energy bar. Profitability Measures by Product - This is a clustered bar chart showing the total revenue, total variable cost, and contribution margin for each energy bar. What data relationship exists with the contribution margin per unit? : We recommend downloading the most recent versions of Tableau Reader and/or Power BI Desktop. Both are free to use. You may use either the Tableau file or Power BI file for this assignment. Both file types contain the same visualizations. Tableau file Power BI file Download the Excel data file and complete the question below. Power Mountain Bars is a producer of energy bars. They currently produce three products. The following information has been provided: Product Peanut Butter Chocolate Coconut Pecan Almond Cranberry Selling Price $3.50 $3.85 $4.10 Variable Cost $1.50 $1.90 $1.60 Direct Labor Hours per Unit 0.08 0.09 0.12 Sales Demand 1.500 1,000 2.500 Your goal is to determine how many units of each product should be produced to achieve the maximum total contribution margin. Direct labor is a constrained resource and there is only 400 direct labor hours available per month. You use the Solver function in Excel to determine what product-mix generates the maximum total contribution margin. The results are as follows: Product Peanut Butter Chocolate Coconut Pecan Almond Cranberry 1. You will present your analysis to management. Your approach is to create a dashboard with the following visualizations: Contribution Margin for Peanut Butter Chocolate - This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. 2. Units Produced 3. 1,500 1,000 1,583 Contribution Margin for Coconut Pecan - This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. Contribution Margin for Almond Cranberry- This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. 3. 4. 5. 6. Contribution Margin for Almond Cranberry-This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The selling price per unit is also displayed in the center. Total Labor Hours by Labor Hours per Unit - This is a dual axis bar chart showing the total labor hours required for units produced and the direct labor hours per unit for each energy bar. The total labor hours are represented as bars and the labor hours per unit are represented as a line. Sales Demand vs Units Produced - This is a clustered bar chart showing the sales demand and the units produced for each energy bar. Profitability Measures by Product - This is a clustered bar chart showing the total revenue, total variable cost, and contribution margin for each energy bar. What data relationship exists with the contribution margin per unit?
Expert Answer:
Answer rating: 100% (QA)
The contribution margin per unit is the difference between the selling price per unit and the variable cost per unit It is a measure of how much each unit of product contributes to the companys overal... View the full answer
Related Book For
International Business and the New Realities
ISBN: 978-0136090984
2nd Edition
Authors: S. Tamer Cavusgil, Gary Knight, John R. Riesenberger
Posted Date:
Students also viewed these accounting questions
-
The following information has been provided by D. Adams who, operating as a sole trader in Carlton, runs a small architect's practice, Adams Architects. Cash at bank...
-
A manager wants to know how many units of each product to produce on a daily basis in order to achieve the highest contribution to profit. Production requirements for the products are shown in the...
-
The following information has been provided in millions for Alpha Plc: 2018 2019 2020 2021 2200 2500 3000 Operating Income (OI) Net Operating Assets (NOA) Return on Net Operating Assets (RNOA) 5600...
-
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for the fiscal year ended May 31, 2018: Instructions 1. Prepare a multiple-step income statement. 2....
-
Who should determine and prioritize the critical applications? How is this done? How frequently is it done?
-
Write a program that prompts the user to enter two strings and displays the largest common prefix of the two strings. Here are some sample runs: Enter the first string: Welcome to C++ Enter the...
-
Assume that the number of asbestos particles in a squared meter of dust on a surface follows a Poisson distribution with a mean of 1000 . If a squared meter of dust is analyzed, what is the...
-
A manager of boiler drums wants to use regression analysis to predict the number of worker-hours needed to erect the drums in future projects. Data for 36 randomly selected boilers have been...
-
Pelican Paint Maufacturers, Inc. uses process costing for its mixing department. It mixed 5 , 0 0 0 units of paint during the period and has 6 0 0 are still being processed ( ending WIP ) in the...
-
Katie is a trader. On 1 October 204 she had the following balances in her ledger: $ Capital .................................................. 15000 Inventory...
-
Solve the system of equation by Gauss-Jacobi method 27x+6y -z = 85 6x +15y + 2z = 72 x+6y + 542 = 110
-
JDBC is standard Java Database Connectivity, and the JDBC API can be considered the Java Database Connectivity Application Programming Interface.(True/False)
-
When establishing a database connection, the DriverManager.getConnection() method is a better method than the Driver.connect() method. (True/False)
-
Prepare a three-minute presentation, using an outline, about one strategy for managing speech anxiety. You may include sources in the speaking tool or from your own research. Before delivering the...
-
To prepare for an upcoming presentation, create a storyboard. Use software, a PowerPoint template, or paper and sticky notes. Draw pictures and write a few words to capture what you would create on...
-
When using a CallableStatement object to run a stored procedure, you need to register the __________ parameters by using the _____________ method. a. IN/OUT, getParameters() b. IN,...
-
A stock sells for $50 today. Next year there is a 10% chance the stock will sell for $25 and a 90% chance the stock will sell for $75. The one-year risk-free rate is 10%. (a) What is the current...
-
A condenser (heat exchanger) brings 1 kg/s water flow at 10 kPa quality 95% to saturated liquid at 10 kPa, as shown in Fig. P4.91. The cooling is done by lake water at 20C that returns to the lake at...
-
What are ownership-specific advantages, location specific advantages, and internalization advantages?
-
What national conditions contribute to the success of economic integration?
-
1. What are the roles of comparative and competitive advantages in Hyundais success? Illustrate your answers by providing specific examples of natural and acquired advantages that Hyundai employs to...
-
You are to open the books of F. Polk, a trader, via the journal to record the assets and liabilities, and are then to record the dialy transactions for the month of May. A trial balance is to be...
-
Show the journal entries necessary to record the following items: 2017 Apr 1 Bought office furniture on credit from Durham Brothers Ltd 1,400. 4 We take goods costing 270 out of the business...
-
You are to show the journal entries necessary to record the following items which occured in 2016: (a) May 1 Bought a motor bike on credit from Lakeside Garage for 5,500. (b) May 3 A debt of 347...
Study smarter with the SolutionInn App