Required information [The following information applies to the questions displayed below.] Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx dataset using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel above. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.5). Gross margin: Net sales minus the cost of goods sold. Gross margin is the amount of revenue a company retains after deducting the direct costs of producing a good or service. Perform the Analysis Alternate Labs - On Your Own don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Answer the following questions based on the details provided. 1. How many SKU's are in the 0.4-0.425 bin? 2. How many SKU's are in the 0.425-0.45 bin? 3. How many SKU's are in the 0.45-0.475 bin? 4. How many SKU's are in the 0.475-0.5 bin? 5. How many SKU's are in the 0.5-0.525 bin? Question Answer

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter19: Variable Costing (varcost)
Section: Chapter Questions
Problem 5R: Click the Chart sheet tab. This chart is based on the problem data and the two income statements....
icon
Related questions
Question
Required information
[The following information applies to the questions displayed below.]
Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx dataset using your
tool of choice.
Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel above.
ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox,
Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel
spreadsheet.
Required
1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5.
2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.5).
Gross margin: Net sales minus the cost of goods sold. Gross margin is the amount of revenue a company retains after
deducting the direct costs of producing a good or service.
Perform the Analysis
Alternate Labs - On Your Own don't have step-by-step instruction or video support. Apply your experience from the
original lab. If needed, reference the text or eBook for instructions and steps from the original lab.
Answer the following questions based on the details provided.
1. How many SKU's are in the 0.4-0.425 bin?
2. How many SKU's are in the 0.425-0.45 bin?
3. How many SKU's are in the 0.45-0.475 bin?
4. How many SKU's are in the 0.475-0.5 bin?
5. How many SKU's are in the 0.5-0.525 bin?
Question
Answer
Transcribed Image Text:Required information [The following information applies to the questions displayed below.] Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx dataset using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel above. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.5). Gross margin: Net sales minus the cost of goods sold. Gross margin is the amount of revenue a company retains after deducting the direct costs of producing a good or service. Perform the Analysis Alternate Labs - On Your Own don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Answer the following questions based on the details provided. 1. How many SKU's are in the 0.4-0.425 bin? 2. How many SKU's are in the 0.425-0.45 bin? 3. How many SKU's are in the 0.45-0.475 bin? 4. How many SKU's are in the 0.475-0.5 bin? 5. How many SKU's are in the 0.5-0.525 bin? Question Answer
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L