Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ SKU , Description,Sales Price,Cost ] , [ FLI - 1 6 H , T 1 6 0 0 M FCS Hotas,

\table[[SKU,Description,Sales Price,Cost],[FLI-16H,T1600M FCS Hotas,97.3,52.53],[FLI-TMX,TMX Force Feedback Racing,159.84,87.3],[FLI-HOX,T-Flight Hotas X Flight Stick,39.99,20.53],[FLI-HO4,T-Flight Hotas 4 Flight Stick,34.65,19.76],[PED-FCS,T16000M FCS,39.19,23.36],[FLI-HO1,T-Flight Hotas One,59.99,30.17],[COM-FCS,T16000M FCS Flight Pack,172.35,89.15],[PED-TFR,TFRP Rudder,69.99,41.18],[WHL-TMX,TMX Pro Racing Wheel,249.99,147.62],[PED-T80,T80 Ferrari 488 GTB Edition,94.99,52.58],[PED-T3P,FB T3PA-Pro 3-Pedal Add-OI,129.99,66.14],[PCG-HOW,Hotas Warthog PC,462.81,266.04],[PED-FER,Ferrari Racing Wheel Red L,79.99,43.51],[PED-T3A,T3PA Add-On,69.99,36.4],[FLI-16M,T 16000M Space SIM Duo St,117.83,69.36],[WHL-T30,T300RS Officially Licensed P,319.99,170.61],[FLI-USB,USB Joystick,21.99,12.06],[PED-TPR,TPR Pedals - Windows,497.38,284.93],[WHL-T3S,VG T300RS Racing Wheel S,159.99,92.63],[FLI-THR,TWCS Throttle,59.99,35.18],[FLI-STX,T-Flight Stick X PS3,39.99,21.04],[WHL-TGT,T-GT Racing Wheel (PS4/PC,614.91,354.66],[WHL-T3P,T300RS Racing Wheel,426.41,231.54]]
Required information
[The following information applies to the questions displayed below.]
Lab Insight: Complete the Alt Lab by using steps similar to original Lab 2-3 in the text. Open Excel, Tableau or Power BI, and connect to Excel File Alt_Lab_2-3_Data.xlsx below. Thrustmaster sells game controllers, joysticks, and steering wheels for PC, XBox, Nintendo, and Playstation consoles. A summary of the company's sales is included in the dataset.
Required:
Calculate gross margin by customer.
Create a histogram (showing relatively frequency in the dataset) of the gross margin percentages using bins of 0.025 size, beginning at 0.425 to 0.525.
Data: Alt Lab 2-3 Data.xIsx
Perform the Analysis: Refer to Lab 2-3 in the text for your software version instructions and steps for each of the lab parts.
Answer the following questions based the details provided.
\table[[Question,Answer],[1. What is the gross margin (dollars) for SKU WHL-T3P?(Enter with 2 decimal places.),$
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert F. Meigs, Jan R. Williams, Mark S. Bettner, Susan F. Haka, Sue Haka

11th Edition

0072516682, 978-0072516685

More Books

Students also viewed these Accounting questions

Question

What enterprise application integration and Web services are?

Answered: 1 week ago

Question

Explain the process of MBO

Answered: 1 week ago