Contemporary Mathematics for Business & Consumers
8th Edition
ISBN: 9781305585447
Author: Robert Brechner, Geroge Bergeman
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 21.I, Problem 7RE
To determine
To graph: A pie chart of total six-month sales of the four territories by use of the table.
January | February | March | April | May | June | |||||||
Standard | Deluxe | Standard | Deluxe | Standard | Deluxe | Standard | Deluxe | Standard | Deluxe | Standard | Deluxe | |
Northwest | $123,200 | $86,400 | $115,800 | $73,700 | $133,400 | $91,100 | $136,700 | $92,600 | $112,900 | $65,300 | $135,000 | $78,400 |
Northeast | $214,700 | $121,300 | $228,400 | $133,100 | $246,600 | $164,800 | $239,000 | $153,200 | $266,100 | $185,000 | $279,300 | $190,100 |
Southwest | $88,300 | $51,000 | $72,100 | $45,700 | $97,700 | $58,300 | $104,000 | $67,800 | $125,000 | $78,300 | $130,400 | $74,500 |
Southeast | $143,200 | $88,700 | $149,900 | $91,300 | $158,400 | $94,000 | $127,700 | $70,300 | $145,700 | $79,400 | $162,000 | $88,600 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
%24
%24
T
%24
3.
3.
2.
5
2.
2.
2.
R
%24
3.
23
316 Business &
PIC
Spreadsheet Assignment
2012 Value
2013 Value
2014 Value
1=North
Country
Region
2011 Value
and South
Canada
1.
$16,290.00
$15,395.00
$16,863.00
$17,064.00
America
$ 2,611.00
$ 2,606.00
$ 2,202.00
$ 2,875.00
2-Asia &
$ 741.00
2$
$10,790.00
$ 1,108.00 $ 1,053.00
$ 833.00
zea
Hong Kong
East
$ 8,109.00
$ 8,897.00
$ 9,310.00
3=Europe
Israel
$ 5,133.00
$ 4,469.00
$ 5,226.00
$ 6,367.00
$ 4,286.00
$ 2,482.00
$ 4,291.00
$ 2,520.00
China
$ 4,459.00
$ 5,033.00
2.
India
$ 2,748.00
$ 2,026.00
2.
United Arab Emirates
$ 1,517.00
$ 1,636.00
$ 2,013.00
$ 1,921.00
Japan
$ 2,519.00
$2,254.00
$ 2,089.00
$1,902.00
2.
Netherlands
$ 2,187.00
$ 1,505.00
$1,491.00
$ 1,279.00
2.
Taiwan
$ 1,248.00
763.00
844.00
744.00
905.00
24
761.00
846.00
Turkey
739.00
Thailand
24
502.00
467.00
517.00
Saudi Arabia
597.00
572.00
24
Australia
987.00
$ 1,017.00
2$
$ 6,498.00
932.00
Switzerland
$ 5,007.00
$10,042.00
$ 8,744.00
3.
United Kingdom
$ 6,514.00
$ 6,549.00…
Excel 3 - Activity 2 - Imbedded Pie Charts
1. Open the Excel 3 Activity 2 Weekly Sales Pie Chart file from the shared drive.
2. Save the file as 21 Activity Activity2
3. to your student drive in your Excel 3 folder.
4. Update the header and footer in class format.
5. Update your document properties.
6. Highlight the cells A3:A7 and using the CTRL key, highlight 13:17.
7. Insert a 3D ple chart from the Insert menu and move and resize it so it goes from the top of A10
to the bottom of 125.
8. Remove the legend by going to the Layout tab, click on the
Legend button and choose none.
9. Add data labels to the outside of each pie plece, Band
category names by
a. Click on the Layout tab
b. Click on Data Labels
m
Cumlish (United Chakr
50₂
Spread
c. Choose More Data Label Options at the bottom of the menu.
d. Click on Category Name
e. Remove the check from Value
f. Click on Percentage
g. Leave the check on Leader Lines
h. Click on Outside End in Label Position
1. Click on Close
THAI HO
10.…
Construct simple aggregative price index from the following data :
Commodities
Prices in 2015
Prices in 2016
I
15.00
18.00
II
5.00
8.00
III
2.25
4.00
IV
6.00
7.00
Chapter 21 Solutions
Contemporary Mathematics for Business & Consumers
Ch. 21.I - Use Table 21-1 to answer the following questions...Ch. 21.I - Use Exhibits 21-1 and 21-2 to answer the following...Ch. 21.I - Prob. 3TIECh. 21.I - Prob. 4TIECh. 21.I - Prob. 5TIECh. 21.I - Prob. 6TIECh. 21.I - Prob. 7TIECh. 21.I - Prob. 8TIECh. 21.I - Prob. 9TIECh. 21.I - Prob. 10TIE
Ch. 21.I - Prob. 1RECh. 21.I - TABLE 21-1 Magnum Enterprises Six-Month Sales...Ch. 21.I - Prob. 3RECh. 21.I - Prob. 4RECh. 21.I - TABLE 21-1 Magnum Enterprises Six-Month Sales...Ch. 21.I - Prob. 6RECh. 21.I - Prob. 7RECh. 21.I - BUSINESS DECISION: CHOOSING A CHART
8. You have...Ch. 21.II - Prob. 11TIECh. 21.II - Prob. 12TIECh. 21.II - Prob. 13TIECh. 21.II - Prob. 14TIECh. 21.II - Prob. 15TIECh. 21.II - Prob. 1RECh. 21.II - Prob. 2RECh. 21.II - Prob. 3RECh. 21.II - Prob. 4RECh. 21.II - Prob. 5RECh. 21.II - Prob. 6RECh. 21.II - Prob. 7RECh. 21.II - Prob. 8RECh. 21.II - Prob. 9RECh. 21.II - Prob. 10RECh. 21.II - Determine the mode of the following sets of...Ch. 21.II - Prob. 12RECh. 21.II - Prob. 13RECh. 21.II - Prob. 14RECh. 21.II - Prob. 15RECh. 21.II - Prob. 16RECh. 21.II - Prob. 17RECh. 21.II - The following numbers represent the gallons of...Ch. 21.II - You are the owner of The Dependable Delivery...Ch. 21.II - Prob. 20RECh. 21.III - Prob. 17TIECh. 21.III - Prob. 18TIECh. 21.III - Prob. 1RECh. 21.III - You are the sales manager of the Esquire...Ch. 21.III - Prob. 3RECh. 21.III - BUSINESS DECISION: RELATIVE FREQUENCY...Ch. 21 - 1. The systematic process of collecting,...Ch. 21 - 2. Statistical procedures that deal with the...Ch. 21 - A collection of related data arranged for ease of...Ch. 21 - Prob. 4CRCh. 21 - 5. The horizontal axis of a line chart is known as...Ch. 21 - Prob. 6CRCh. 21 - To construct a pie chart, we multiply each...Ch. 21 - Prob. 8CRCh. 21 - 9. The _______ is the midpoint value of a set of...Ch. 21 - Prob. 10CRCh. 21 - Prob. 11CRCh. 21 - Prob. 12CRCh. 21 - Prob. 13CRCh. 21 - Prob. 14CRCh. 21 - 1. The following data represent the monthly sales...Ch. 21 - Prob. 2ATCh. 21 - Prob. 3ATCh. 21 - You have just been hired as the quality control...Ch. 21 - 5. You are the human resource director for Apollo...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- Month Number of Tables Produced EA 10. LO 2.3 This cost data from Hickory Furniture is for the year 2017. Factory Utility Expenses January 550 $2,063 February 710 2,663 March 650 2,438 April 470 1,823 May 512 1,920 June 625 2,344 July 805 3,019 August 750 2,813 September 675 2,531 October 525 1,969 November 875 3,281 December 685 2,569 A. Using the high-low method, express the company's utility costs as an equation where X represents number of tables produced. B. Predict the utility costs if 800 tables are produced. C. Predict the utility costs if 600 tables are produced. D. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.arrow_forwarda) 15% 1994-2000 14% 2000-200624%1994-2006 b) $5000 1992-1995 $1.8 1995-2000 $200 1992-1998arrow_forwardAssume that a company wants to separate a mixed cost into its variable and fixed elements for cost estimation purposes. It provided the following information: Uni ts Mixed Month Produced Cost $11, 045 $11, 870 $11, 560 January 1, 050 February 1, 150 March 1, 100 1, 250 $12, 100 $10, 800 $12, 210 $10, 970 $11, 005 April May 950 June 1, 280 July 990 August 1, 010 The regression equation used for estimating the total mixed cost for a given level of activity is closest to:arrow_forward
- The following data were taken from the annual reports of Big Bang Inc., a manufacturer of fireworks, and Orange Inc., a manufacturer of computers. Big Bang, Inc. Orange, Inc. Cost of goods sold $830,000 $11,540,000 Inventory, end of year 190,000 320,000 Inventory, beginning of year 240,000 290,000 What is the inventory turnover for Big Bang and Orange. a. Big Bang, Inc.: 3.86Orange, Inc.: 37.84 b. Big Bang, Inc.: 3.86Orange, Inc.: 9.65 c. Big Bang, Inc.: 94.55Orange, Inc.: 37.84 d. Big Bang, Inc.: 94.55Orange, Inc.: 9.65arrow_forwardRegion Product Type Item Projected Sales 2022 (in millions) Americas Legacy B 18.6 Americas Legacy B 1.4 Americas Legacy B 9.4 Americas Legacy B 11.6 Americas Legacy B 7.1 Americas Legacy B 8.6 Americas Legacy B 6.9 Americas Legacy B 9.4 Americas Legacy B 8 Americas Legacy B 12.4 Americas Legacy B 16.3 Americas Legacy B 12.4 Americas Legacy B 5.7 Americas Legacy B 8.1 Americas Legacy B 14.6 Americas Legacy B 3.2 Americas Legacy B 13.1 Americas Legacy B 6.5 Americas Legacy B 6.6 Americas Legacy B 14 Americas Legacy B -1.6 Americas Legacy B -5.5 Americas Legacy B 10.5 Americas Legacy B 9.7 Americas Legacy B 5.9 Americas Legacy B 9 Americas Legacy B 7.9 Americas Legacy B 4.4 Americas Legacy B 8.2 Americas Legacy B 2.9 Americas Legacy B 10.6 Americas Legacy B 7.8 Americas Legacy B 5.2 Americas Legacy B 14.4 Americas Legacy B 4.1 Americas Legacy B 7.7 Americas Legacy B 2.6 Americas Legacy B 10.1 Americas Legacy B…arrow_forwardNas corporation's manager in the stamping department have been studying the overhead cost and the relatioship machine hours. Data from the most recent 12 months Month Overhead Machine hours January 5,030 2,730 February 1,600 600 March 7,210 3,403 April 4,560 2,200 May 6,880 3,411 June 6,520 2,586 July 6,230 3,364 August 5,570 2,411…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Discrete Mathematics and Its Applications ( 8th I...MathISBN:9781259676512Author:Kenneth H RosenPublisher:McGraw-Hill EducationMathematics for Elementary Teachers with Activiti...MathISBN:9780134392790Author:Beckmann, SybillaPublisher:PEARSON
- Thinking Mathematically (7th Edition)MathISBN:9780134683713Author:Robert F. BlitzerPublisher:PEARSONDiscrete Mathematics With ApplicationsMathISBN:9781337694193Author:EPP, Susanna S.Publisher:Cengage Learning,Pathways To Math Literacy (looseleaf)MathISBN:9781259985607Author:David Sobecki Professor, Brian A. MercerPublisher:McGraw-Hill Education
Discrete Mathematics and Its Applications ( 8th I...
Math
ISBN:9781259676512
Author:Kenneth H Rosen
Publisher:McGraw-Hill Education
Mathematics for Elementary Teachers with Activiti...
Math
ISBN:9780134392790
Author:Beckmann, Sybilla
Publisher:PEARSON
Thinking Mathematically (7th Edition)
Math
ISBN:9780134683713
Author:Robert F. Blitzer
Publisher:PEARSON
Discrete Mathematics With Applications
Math
ISBN:9781337694193
Author:EPP, Susanna S.
Publisher:Cengage Learning,
Pathways To Math Literacy (looseleaf)
Math
ISBN:9781259985607
Author:David Sobecki Professor, Brian A. Mercer
Publisher:McGraw-Hill Education
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License