Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
ll SMART LTE 5:58 PM 39% Module 12 Acti... COCA-XOLA BOTTLERS INC Stock Report As of May 2020 Beginning Price per Item Code Category Description Purchased Total Sales Total Price Stock Piece bev10 bevo1 bev04 bev06 softdrinks softdrinks 7-up coke 25 105 130 12.00 P1,560.00 P1,920.00 P3,150.00 10 150 160 12.00 juice orange 55 120 175 18.00 softdrinks рepi pineapple 11 60 71 12.00 P852.00 bev03 bev07 bev09 bev05 juice 40 130 170 18.00 P3,060.00 softdrinks softdrinks softdrinks royal softdrinks pop 50 55 12.00 P660.00 rootbeer 55 265 320 12.00 P3,840.00 70 110 180 12.00 P2,160.00 sprite tang bev02 25 140 165 12.00 P1,980.00 bev08 juice 56 101 157 18.00 P2,826.00 TOTAL SALES P22,008.00 МAX MIN P3,840.00 P660.00 COUNT 10

ll SMART LTE 5:58 PM 39% Module 12 Acti... COCA-XOLA BOTTLERS INC Stock Report As of May 2020 Beginning Price per Item Code Category Description Purchased Total Sales Total Price Stock Piece bev10 bevo1 bev04 bev06 softdrinks softdrinks 7-up coke 25 105 130 12.00 P1,560.00 P1,920.00 P3,150.00 10 150 160 12.00 juice orange 55 120 175 18.00 softdrinks рepi pineapple 11 60 71 12.00 P852.00 bev03 bev07 bev09 bev05 juice 40 130 170 18.00 P3,060.00 softdrinks softdrinks softdrinks royal softdrinks pop 50 55 12.00 P660.00 rootbeer 55 265 320 12.00 P3,840.00 70 110 180 12.00 P2,160.00 sprite tang bev02 25 140 165 12.00 P1,980.00 bev08 juice 56 101 157 18.00 P2,826.00 TOTAL SALES P22,008.00 МAX MIN P3,840.00 P660.00 COUNT 10

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

1.    To get the TOTAL SALES, add beginning stock and purchased. 

2.    To get the TOTAL PRICE, multiply total sales, and price per piece.


3.    Get the highest total price using the MAX function.


4.    Get the lowest total price using the MIN function.


5.    Count the total price to get the number of items using the COUNT function.


6.    Sort the description from A-Z.
7.    Insert a line chart using only DESCRIPTION and TOTAL SALES.

ll SMART LTE 5:58 PM 39% Module 12 Acti... COCA-XOLA BOTTLERS INC Stock Report As of May 2020 Beginning Price per Item Code Category Description Purchased Total Sales Total Price Stock Piece bev10 bevo1 bev04 bev06 softdrinks softdrinks 7-up coke 25 105 130 12.00 P1,560.00 P1,920.00 P3,150.00 10 150 160 12.00 juice orange 55 120 175 18.00 softdrinks рepi pineapple 11 60 71 12.00 P852.00 bev03 bev07 bev09 bev05 juice 40 130 170 18.00 P3,060.00 softdrinks softdrinks softdrinks royal softdrinks pop 50 55 12.00 P660.00 rootbeer 55 265 320 12.00 P3,840.00 70 110 180 12.00 P2,160.00 sprite tang bev02 25 140 165 12.00 P1,980.00 bev08 juice 56 101 157 18.00 P2,826.00 TOTAL SALES P22,008.00 МAX MIN P3,840.00 P660.00 COUNT 10
Transcribed Image Text:ll SMART LTE 5:58 PM 39% Module 12 Acti... COCA-XOLA BOTTLERS INC Stock Report As of May 2020 Beginning Price per Item Code Category Description Purchased Total Sales Total Price Stock Piece bev10 bevo1 bev04 bev06 softdrinks softdrinks 7-up coke 25 105 130 12.00 P1,560.00 P1,920.00 P3,150.00 10 150 160 12.00 juice orange 55 120 175 18.00 softdrinks рepi pineapple 11 60 71 12.00 P852.00 bev03 bev07 bev09 bev05 juice 40 130 170 18.00 P3,060.00 softdrinks softdrinks softdrinks royal softdrinks pop 50 55 12.00 P660.00 rootbeer 55 265 320 12.00 P3,840.00 70 110 180 12.00 P2,160.00 sprite tang bev02 25 140 165 12.00 P1,980.00 bev08 juice 56 101 157 18.00 P2,826.00 TOTAL SALES P22,008.00 МAX MIN P3,840.00 P660.00 COUNT 10
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS