Below are the total sales by month and the retail price of each product. Enter formula in Column I to answer the question in column K. You must type a formula and references to the data table. You cannot input a numerical answer, it must be a typed formula.

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...
icon
Related questions
Question
Below are the total sales by month and the retail price of each product. Enter formula in Column I to answer the question in column K.
You must type a formula and references to the data table. You cannot input a numerical answer, it must be a typed formula.
Data Table 1
Type the formula
Product
Jan
Feb
March
April
May
June
Instructions
HINT:
Baseballs
43
66
96
122
188
144
2,629.41 CORRECT
What is the total dollar sales from Baseballs?
Add all of the months and multiply by retail price
What is the total dollar sales from soccer balls?
13,513.24 CORRECT
3,243.50 ICORRECT
soccer balls
26
48
72
165
199
166
$
Add all of the months and multiply by retail price
Soft Balls
38
22
99
146
157
188
what is the total dollar sales from Soft Balls?
Add all of the months and multiply by retail price
Use values from Column I in your formula. 19 should be your total units for
soccer balls. Divide by the total units of baseballs, soccer balls, and soft
Enter Formula
What percentage of total sales are soccer balls?
balls found in Column I
Price Increase
47.32 Correct
Price of soccer ball if price is increased by 7%?
0.07
Retail Price
Baseballs Soccer balls Soft Balls
$ 3.99 $
19.99 $ 4.99
Increase Factor
15%
Data Table 2
Jan
Feb
March
April
May
June
Baseballs
659 Correct
676 Correct
43
66
96
122
188
144
Create totals for baseball
Use Data Table 2
soccer balls
26
48
72
165
199
166
Total for Soccer Balls
Use Data Table 2
Soft Balls
38
22
146
157
188
650 Correct
Total for soft balls
Use Data Table 2
66
What would the values be in for baseballs total (124) if you used the
increase factor in 18? Create an absolute reference for the formula in 127,
Use Data Table 2
Use Data Table 2
Enter Formula
then use fill handle for J28 and 29
Enter Formula
Use fill handle from cell 127 to drag down to 128
Enter Formula
Use fill handle from cell 128 to drag down to 129
Use Data Table 2
Transcribed Image Text:Below are the total sales by month and the retail price of each product. Enter formula in Column I to answer the question in column K. You must type a formula and references to the data table. You cannot input a numerical answer, it must be a typed formula. Data Table 1 Type the formula Product Jan Feb March April May June Instructions HINT: Baseballs 43 66 96 122 188 144 2,629.41 CORRECT What is the total dollar sales from Baseballs? Add all of the months and multiply by retail price What is the total dollar sales from soccer balls? 13,513.24 CORRECT 3,243.50 ICORRECT soccer balls 26 48 72 165 199 166 $ Add all of the months and multiply by retail price Soft Balls 38 22 99 146 157 188 what is the total dollar sales from Soft Balls? Add all of the months and multiply by retail price Use values from Column I in your formula. 19 should be your total units for soccer balls. Divide by the total units of baseballs, soccer balls, and soft Enter Formula What percentage of total sales are soccer balls? balls found in Column I Price Increase 47.32 Correct Price of soccer ball if price is increased by 7%? 0.07 Retail Price Baseballs Soccer balls Soft Balls $ 3.99 $ 19.99 $ 4.99 Increase Factor 15% Data Table 2 Jan Feb March April May June Baseballs 659 Correct 676 Correct 43 66 96 122 188 144 Create totals for baseball Use Data Table 2 soccer balls 26 48 72 165 199 166 Total for Soccer Balls Use Data Table 2 Soft Balls 38 22 146 157 188 650 Correct Total for soft balls Use Data Table 2 66 What would the values be in for baseballs total (124) if you used the increase factor in 18? Create an absolute reference for the formula in 127, Use Data Table 2 Use Data Table 2 Enter Formula then use fill handle for J28 and 29 Enter Formula Use fill handle from cell 127 to drag down to 128 Enter Formula Use fill handle from cell 128 to drag down to 129 Use Data Table 2
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 8 images

Blurred answer
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