Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a preliminary analysis on last year's sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. Products Available Paper Pens Sticky Notes Envelopes Units Ordered Total Sales Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? East Midwest South West Region Price per Unit 23.00 per case per box 7.00 10.50 per package 3.50 per box Which rep has the highest total sales for each region? Region Rep Name East Midwest South West $ $ $ $ What is the total annual sales for each region? Region Product East Midwest South West Total Sales Total Using the data above, create a pie chart to determine the sales percentage for each region. Sales Percentage Total Sales Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a preliminary analysis on last year's sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. Products Available Paper Pens Sticky Notes Envelopes Units Ordered Total Sales Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? East Midwest South West Region Price per Unit 23.00 per case per box 7.00 10.50 per package 3.50 per box Which rep has the highest total sales for each region? Region Rep Name East Midwest South West $ $ $ $ What is the total annual sales for each region? Region Product East Midwest South West Total Sales Total Using the data above, create a pie chart to determine the sales percentage for each region. Sales Percentage Total Sales
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
The finance or accounting director has asked you to report on the funds and financial status of your government entity (pretend he or she is your boss). Your boss will present the information to...
-
The audit senior has asked you to perform analytical procedures to estimate the reasonableness of recorded depreciation expense of the delivery vehicles of a client. Changes in the account occurred...
-
A major real estate developer has asked you to determine the effect of the interval between house sales, and the initial house sales price on second or final sales price with adjustments for the four...
-
Desgin a class diagram for Blackboard System. The diagram should also include: Generalization Relationships Association Relationships Aggregation/Composition Relationships Multiplicity please draw 1...
-
A point source of light is 80.0 cm below the surface of a body of water, find the diameter of the circle at the surface through which light emerges from the water.
-
Use the finite universe method to prove that the following symbolized arguments are invalid. 1. 2. 3. 4. 5. 1. (x)(Ax Bx) 2. (x)(Ax Cx) 1 ()( ) 1. ()(v Bx) ()
-
According to an article in Business Week, T.J. Izzo had a great idea after a bad back almost forced him to give up golf. His problem was carrying a golf bag, not swinging a club. So he designed a...
-
Given the circuit shown in Fig. 19-36, use the words increase, decrease, or stays the same to complete the following statement: (a) If R7 increases, the potential difference between A and E____....
-
The second order ordinary differential equation dy dy +3+4Y sin(t) ===== dt2 dt is defined over the domain 0 t 6, and is to be solved numerically subject to the initial conditions X(0) = 0, dy(0)/dt...
-
Suppose your company introduces a referral incentive for existing customers. Namely, cus- tomers can get a $500 discount on their customer service subscription for each customer lead that they refer...
-
Inc. is a US corporation. The corporate tax rate is currently 21%. In the last three-years, its average gross receipts were $768 million. In 2023, it earned the following: Revenue of $873 million...
-
What is a System Deployment Concept? Identify examples of its UCs.
-
What topics should a ConOps, at a minimum, include?
-
What is the purpose of the System Operations Model and how does it aid development of the ConOps?
-
Which System/Product Life Cycle Phases may not be covered by the ConOps and why?
-
What System/Product Life Cycle Phases are covered by the ConOps?
-
Given the following information for Ww Corp., calculate the depreciation expense: sales = $96,471; costs = $52,484; addition to retained earnings = $679; dividends paid = $949; interest expense =...
-
What are the key dimensions of critical thinking 2. Watch the NBC Learn video on Diet Scams. What types of claims are made in this video Are they valid Elaborate on your responses. Discuss this video...
-
What three conclusions about control risk can be reached based on internal control evaluation? What are the implications of each on the audit approach selected?
-
Distinguish between forensic accounting and fraud auditing.
-
What is an audit internal control questionnaire?
-
Griffin Metals Co. has provided the following data: The selling price is expected to be \($300\) per tonne for the first six months and \($310\) per tonne thereafter. Variable costs per tonne are...
-
Highjinks Corporation's sales department has estimated revenue of 250,000 for your division. 60% of this will be achieved in the first half-year and 40% in the remaining half-year. Variable operating...
-
The total cost of goods sold for June is a. $103,500 b. $128,800 c. 57,500 d. $232,300
Study smarter with the SolutionInn App