Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
The steps you will follow for this project are as follows: 1) Watch the video. 2) Open the prebuilt Tableau dashboard. 3) Review dashboard navigation
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c7b4fece2e_215669c7b4f3babb.jpg)
The steps you will follow for this project are as follows: 1) Watch the video. 2) Open the prebuilt Tableau dashboard. 3) Review dashboard navigation information. 4) Use the dashboard and these formulas to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) As you answer the questions, resize windows as needed to see all relevant data. This project only has one attempt. Review the dashboard before answering the questions. Assuming it has excess capacity, should the company accept the entire special order? A. No, the prices are less than the regular selling prices. B. Yes, the prices are higher than the regular selling prices. C. No, the prices do not cover all the costs for the sale. D. Yes, the prices do cover the variable costs, and the fixed costs remain unchanged. If the company accepts the special order for only the Roller Bags (R01, R02, R03) what will be the increase or decrease in the company's contribution margin in the West? A. $1,275 B. $11,150 C. $12,425 D. $18,000 How much is the gross profit on each C02 bag sold in the West? A. $30.00 B. $22.00 C. $75.00 D. $23.00 Which of the plants has the lowest Variable Cost per bag? A. West B. East C. Both are the same. D. Cannot be determined from the data given. Assume the company sold the following number of products in a recent period in the West: Formulas Gross Profit Per Bag = Select the Factory, then: Selling Price - Fixed MOH Per Bag - Variable Cost Per Bag Contribution Margin Per Bag = Select the Factory, then: Selling Price Per Bag - Variable Cost Per Bag Contribution Margin for a Model = Select the Factory, then: Contribution Margin Per Bag (See formula above) Units Sold Total Sales = Select the Factory, then: (Selling Price Per Bag, B01 Units Sold, B01) + (Selling Price Per Bag, B02 Units Sold, B02) + (Selling Price Per Bag, B03 Units Sold, B03) + (Selling Price Per Bag, C01 Units Sold, C01) + (Selling Price Per Bag, C02 Units Sold, C02) + (Selling Price Per Bag, R01 Units Sold, R01) + (Selling Price Per Bag, R02 Units Sold, R02) + (Selling Price Per Bag, R03 Units Sold, R03) Total Variable Costs = Select the Factory, then: ( Variable Cost Per Bag, B01 Units Sold, B01) +( Variable Cost Per Bag, B02 Units Sold, B02) + (Variable Cost Per Bag, B03 Units Sold, B03) + (Variable Cost Per Bag, C01 Units Sold, C01) + (Variable Cost Per Bag, C02 Units Sold, C02) + (Variable Cost Per Bag, R01 Units Sold, R01) + (Variable Cost Per Bag, R02 Units Sold, R02) + (Variable Cost Per Bag, R03 Units Sold, R03) Total Contribution Margin for all Units Sold = Select the Factory and review the Contribution Margin Per Bag formula above, then: (Contribution Margin Per Bag, B01 Units Sold, B01) + (Contribution Margin Per Bag, B02 Units Sold, B02) + (Contribution Margin Per Bag, B03 Units Sold, B03) + (Contribution Margin Per Bag, C01 Units Sold, C01) + (Contribution Margin Per Bag, C02 Units Sold, C02) + (Contribution Margin Per Bag, R01 Units Sold, R01) + (Contribution Margin Per Bag, R02 Units Sold, R02) + (Contribution Margin Per Bag, R03 Units Sold, R03) Special Order Selling Price per Unit = Select the Factory, then: Special Order Revenue of Model \# Special Order Quantity of Model \# Variable Cost of Special Order = Select the Factory, then: (Variable Cost per Bag, First Model \# Special Order Units, First Model \#) + (Variable Cost per Bag, Second Model \# Special Order Units, Second Model \#) + (Variable Cost per Bag, Third Model \# Special Order Units, Third Model \#) Increase (Decrease) in Contribution Margin = Select the Factory, then: (Special Order Revenue, First Model \# + Special Order Revenue, Second Model \# + Special Order Revenue, Third Model \#) - Variable Cost of Special Order (see formula above) How much were total variable costs? A. $24,235 B. $39,850 C. $368 D. $2,550 How much was the total contribution margin on the sale? A. $24,235 B. $237 C. $39,850 D. $15,615 Relevant Costs for Short-Term Decision Making Traveler's Best produces bags in two different factories. The Fixed MOH (Manufacturing Overhead) Per Bag costs in the two factories are slightly different due to regional cost differences. The Factory filter can be used to see the results from each one. The Special Order is an offer to purchase the company's goods and can also be used as a filter. The steps you will follow for this project are as follows: 1) Watch the video. 2) Open the prebuilt Tableau dashboard. 3) Review dashboard navigation information. 4) Use the dashboard and these formulas to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) As you answer the questions, resize windows as needed to see all relevant data. This project only has one attempt. Review the dashboard before answering the questions. Assuming it has excess capacity, should the company accept the entire special order? A. No, the prices are less than the regular selling prices. B. Yes, the prices are higher than the regular selling prices. C. No, the prices do not cover all the costs for the sale. D. Yes, the prices do cover the variable costs, and the fixed costs remain unchanged. If the company accepts the special order for only the Roller Bags (R01, R02, R03) what will be the increase or decrease in the company's contribution margin in the West? A. $1,275 B. $11,150 C. $12,425 D. $18,000 How much is the gross profit on each C02 bag sold in the West? A. $30.00 B. $22.00 C. $75.00 D. $23.00 Which of the plants has the lowest Variable Cost per bag? A. West B. East C. Both are the same. D. Cannot be determined from the data given. Assume the company sold the following number of products in a recent period in the West: Formulas Gross Profit Per Bag = Select the Factory, then: Selling Price - Fixed MOH Per Bag - Variable Cost Per Bag Contribution Margin Per Bag = Select the Factory, then: Selling Price Per Bag - Variable Cost Per Bag Contribution Margin for a Model = Select the Factory, then: Contribution Margin Per Bag (See formula above) Units Sold Total Sales = Select the Factory, then: (Selling Price Per Bag, B01 Units Sold, B01) + (Selling Price Per Bag, B02 Units Sold, B02) + (Selling Price Per Bag, B03 Units Sold, B03) + (Selling Price Per Bag, C01 Units Sold, C01) + (Selling Price Per Bag, C02 Units Sold, C02) + (Selling Price Per Bag, R01 Units Sold, R01) + (Selling Price Per Bag, R02 Units Sold, R02) + (Selling Price Per Bag, R03 Units Sold, R03) Total Variable Costs = Select the Factory, then: ( Variable Cost Per Bag, B01 Units Sold, B01) +( Variable Cost Per Bag, B02 Units Sold, B02) + (Variable Cost Per Bag, B03 Units Sold, B03) + (Variable Cost Per Bag, C01 Units Sold, C01) + (Variable Cost Per Bag, C02 Units Sold, C02) + (Variable Cost Per Bag, R01 Units Sold, R01) + (Variable Cost Per Bag, R02 Units Sold, R02) + (Variable Cost Per Bag, R03 Units Sold, R03) Total Contribution Margin for all Units Sold = Select the Factory and review the Contribution Margin Per Bag formula above, then: (Contribution Margin Per Bag, B01 Units Sold, B01) + (Contribution Margin Per Bag, B02 Units Sold, B02) + (Contribution Margin Per Bag, B03 Units Sold, B03) + (Contribution Margin Per Bag, C01 Units Sold, C01) + (Contribution Margin Per Bag, C02 Units Sold, C02) + (Contribution Margin Per Bag, R01 Units Sold, R01) + (Contribution Margin Per Bag, R02 Units Sold, R02) + (Contribution Margin Per Bag, R03 Units Sold, R03) Special Order Selling Price per Unit = Select the Factory, then: Special Order Revenue of Model \# Special Order Quantity of Model \# Variable Cost of Special Order = Select the Factory, then: (Variable Cost per Bag, First Model \# Special Order Units, First Model \#) + (Variable Cost per Bag, Second Model \# Special Order Units, Second Model \#) + (Variable Cost per Bag, Third Model \# Special Order Units, Third Model \#) Increase (Decrease) in Contribution Margin = Select the Factory, then: (Special Order Revenue, First Model \# + Special Order Revenue, Second Model \# + Special Order Revenue, Third Model \#) - Variable Cost of Special Order (see formula above) How much were total variable costs? A. $24,235 B. $39,850 C. $368 D. $2,550 How much was the total contribution margin on the sale? A. $24,235 B. $237 C. $39,850 D. $15,615 Relevant Costs for Short-Term Decision Making Traveler's Best produces bags in two different factories. The Fixed MOH (Manufacturing Overhead) Per Bag costs in the two factories are slightly different due to regional cost differences. The Factory filter can be used to see the results from each one. The Special Order is an offer to purchase the company's goods and can also be used as a filter
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started