Question: A B D E H Product Pens, Black USB Drive, 4 GB Tablet Computers Backpacks, Student Protractors Headphones Batteries, AA August Sales in Price per

A B D E H Product Pens, Black USB Drive, 4 GB
A B D E H Product Pens, Black USB Drive, 4 GB
A B D E H Product Pens, Black USB Drive, 4 GB Tablet Computers Backpacks, Student Protractors Headphones Batteries, AA August Sales in Price per August Sales Cost per Units Unit in $$ Unit Profit 5000 $2.00 $10,000.00 $1.00 $ 5,000.00 800 $25.00 $20,000.00 $11.00 $ 11,200.00 150 $699.00 $104,850.00 $350.00 $ 52,350.00 500 $25.00 $12,500.00 $12.00 $ 6,500.00 300 $4.50 $1,350.00 $1.10 $ 1,020.00 150 $18.00 $2,700.00 $9.00 $ 1,350.00 2500 $1.25 $3,125.00 $0.60 $ 1,625.00 Inventory in Units End of August 60,000 2,000 400 250 150 400 5,000 Data Analysis Open up the attached Excel Spreadsheet and look at the sales data and Inventory data from an office supply store. This is for one months worth of sales, in complete sentences, submit on this document or on a word document at least 4 observations about the data. Here is an example: Store profit heavily depends on tablet computer sales, which account for more than 60% of the total. You cannot use this one in your answers) Look at sales, costs, and inventory. How much inventory is in stock vs sales for a month? There is a help video available before attempting the assignment. CH2 Data Analysis assignment.xlsx May 20 2020, 4:22 PM Submission status

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!