(LO 5-3, LO 5-8) Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price...

Question:

(LO 5-3, LO 5-8) Download the “SkyDio Drone Sales Journal” dataset in Excel. Note the sales price and cost of each sale. In Excel, calculate the gross margin percentage (Sales Price – Cost)/Sales Price for each sale (or row in the sales journal). Use the descriptive statistics tool featured in Excel’s Analysis Toolpak (or relevant Excel functions) to compute the summary statistics to help determine the following. It may be helpful to perform this project after completing Lab 5-1.

Required:

What is the average gross margin percentage for all items sold?

What is the standard error of the gross margin percentage for all items sold?

What is the range of gross margin percentage for all items sold?

What is the lowest gross margin percentage for all items sold?

What is the count of sales transactions in the dataset?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 100% (QA)

Answered By

Ali Khawaja

my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce

4.00+ 1+ Reviews 10+ Question Solved

Related Book For book-img-for-question