Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 2.3.2CP
Case Problem 3 Queen City
Cincinnati, Ohio, also known as the Queen City, has a population of approximately 298,000 and is the third largest city in the state of Ohio. The Cincinnati metropolitan area has a population of about 2.2 million. The city is governed by a mayor and a nine-member city council. The city manager, who is responsible for the day-to-day operation of the city, reports to the mayor and city council. The city manager recently created the Office of Performance and Data Analytics with the goal of improving the efficiency of city operations. One of the first tasks of this new office is to review the previous year's expenditures. The file QueenCity contains data on the previous year's expenditures, including the following:
Department The number of the department incurring the expenditure
Department Description The name of the department incurring the description
Category The category of the expenditure
Fund The fund to which the expenditure was charged
Expenditure The dollar amount of the expense
DATA file QueenCity Table 2.21 shows the first four entries of the 5427 expenditures for the year. The city manager would like to use this data to better understand how the city's budget is being spent.
Managerial Report
Use tabular and graphical methods of
2. A table that shows the amount of by department and the percentage of total expenditures by department. Combine any department with less than 1% into a category named "Other."
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Consider the town of Acaford with a population of 5,000 people. There are 1,000 high school students, 1,000 undergraduate students, 1,000 graduate
students, 1,000 economics professors, and 1,000 retired economists. Suppose that the total annual income in the economy is $100 million: Each high
school student earns $6,000 annually; each undergraduate earns $10,000 annually; each graduate student earns $25,000 annually; each professor
earns $55,000 annually; and each retiree earns $4,000 annually.
The following chart shows the income distribution for the town of Acaford.
60
50
40
30
20
10
High SchoolUndergrads Grads
Profs
Retirees
Suppose that the government sets the poverty line at an annual income of $18,000. The percentage of people with annual incomes below the poverty
line in Acaford is
20%, 40%, 60% 80%
Which of the following sequences correctly orders the people of Acaford from the bottom fifth to the top fifth of income distribution?
SHARE OF TOTAL INCOME (Percent)
2)
Consider the town of Acaford with a population of 5,000 people. There are 1,000 high school students, 1,000 undergraduate students, 1,000 graduate
students, 1,000 economics professors, and 1,000 retired economists. Suppose that the total annual income in the economy is $100 million: Each high
school student earns $6,000 annually; each undergraduate earns $10,000 annually; each graduate student earns $25,000 annually; each professor
earns $55,000 annually; and each retiree earns $4,000 annually.
The following chart shows the income distribution for the town of Acaford.
60
50
40
30
10
High SchoolUndergrads Grads
Profs
Retirees
Suppose that the government sets the poverty line at an annual income of $18,000. The percentage of people with annual incomes below the poverty
line in Acaford is
Which of the folld
80%
quences correctly orders the people of Acaford from the bottom fifth to the top fifth of income distribution?
40%
Retiree
ate students, undergraduates, high school students,…
The Donaldson Furniture Company
produces three types of rocking chairs:
the children's model, the standard model,
and the executive model. Each chair is
made in three stages:
cutting, construction, and finishing.
Stage
Cutting
Construction
Finishing
Children's Standard Executive
5 hr
4 hr
7 hr
3 hr
2 hr
5 hr
2 hr
2 hr
4 hr
The time needed for each stage of each chair is given in the chart. During a specific week
the company has available a maximum of 160 hours for cutting, 100 hours for construction,
and 78 hours for finishing. Determine how many of each type of chair the company should
make to be operating at full capacity.
The number of executive chairs the company should make is
The number of standard chairs the company should make is
The number of children's chairs the company should make is
Chapter 2 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 2.1 - The response to a question has three alternatives:...Ch. 2.1 - A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 - Prob. 4ECh. 2.1 - In alphabetical order, the six most common last...Ch. 2.1 - Nielsen Media Research provided the list of the 25...Ch. 2.1 - The Canmark Research Center Airport Customer...Ch. 2.1 - Prob. 8ECh. 2.1 - Nearly 1.8 million bachelor's degrees and over...Ch. 2.1 - VirtualTourist provides ratings for hotels...
Ch. 2.2 - Consider the following data. a. Develop a...Ch. 2.2 - Consider the following frequency distribution...Ch. 2.2 - Prob. 13ECh. 2.2 - Prob. 14ECh. 2.2 - Prob. 15ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - A doctor's office staff studied the waiting times...Ch. 2.2 - CBSSports.com developed the Total Player Ratings...Ch. 2.2 - Based on the tons handled in a year, the ports...Ch. 2.2 - The London School of Economics and the Harvard...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Entrepreneur magazine ranks franchises using...Ch. 2.2 - The following data show the year-to-date percent...Ch. 2.2 - Prob. 24ECh. 2.2 - Prob. 25ECh. 2.2 - The Flying Pig Half-Marathon (13.1 miles) had...Ch. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - The Daytona 500 is a 500-mile automobile race held...Ch. 2.3 - The following crosstabulation shows the average...Ch. 2.3 - Prob. 31ECh. 2.3 - The following crosstabulation shows the number of...Ch. 2.4 - Prob. 36ECh. 2.4 - Consider the following data on two categorical...Ch. 2.4 - Prob. 38ECh. 2.4 - Prob. 39ECh. 2.4 - Prob. 40ECh. 2.4 - Prob. 41ECh. 2.4 - Prob. 42ECh. 2.4 - The Northwest regional manager of an outdoor...Ch. 2 - Approximately 1.5 million high school students...Ch. 2 - Data showing the population by state in millions...Ch. 2 - A startup company's ability to gain funding is a...Ch. 2 - Prob. 49SECh. 2 - Prob. 50SECh. 2 - Western University has only one women's softball...Ch. 2 - Prob. 53SECh. 2 - Prob. 57SECh. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Prob. 2.1.2CPCh. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Case Problem 2Motion Picture Industry The motion...Ch. 2 - Prob. 2.2.2CPCh. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Darden Restaurants, Inc. (DRI) is the largest full-service restaurant company in the world. It operates over 2,200 restaurants under a variety of brand names, including Olive Garden, Bahama Breeze, and LongHorn Steakhouse. Panera Bread Company (PNRA) operates over 1,800 bakery-café locations across North America. It is one of the largest food service companies in the United States. The cost of food, beverage, and packaging and the beginning and ending inventory balances from recent annual reports for Darden and Panera are as follows (in millions): Darden Panera Cost of goods sold (food, beverage, and packaging) $2,039.7 $715.5 Inventories: Beginning of year 163.9 22.8 End of year 175.4 22.5 a. Compute the inventory turnover for both companies. Round all calculations to one decimal place. Inventory Turnover Darden Restaurants fill in the blank 1 Panera Bread fill in the blank 2 b. Compute the number of days’ sales in…arrow_forwardThe Donaldson Furniture Company produces three types of rocking chairs: the children's model, the standard model, and the executive model. Each chair is made in three stages: cutting, construction, and finishing. Stage Cutting Construction Finishing Children's Standard Executive 7 hr 5 hr 4 hr 3 hr 2 hr 5 hr 2 hr 2 hr 4 hr The time needed for each stage of each chair is given in the chart. During a specific week the company has available a maximum of 166 hours for cutting, 106 hours for construction, and 84 hours for finishing. Determine how many of each type of chair the company should make to be operating at full capacity. The number of executive chairs the company should make isarrow_forwardSouthwestern University (SWU), a large state college in Stephenville, Texas, enrolls close to 20,000 students. The school is a dominant force in the small city, with more students during fall and spring than permanent residents. Always a football powerhouse, SWU is usually in the top 20 in college football rankings. Since the legendary Phil Flamm was hired as its head coach in 2009 (in hopes of reaching the elusive number 1 ranking), attendance at the five Saturday home games each year increased. Prior to Flamm's arrival, attendance generally averaged 25,000 to 29,000 per game. Season ticket sales bumped up by 10,000 just with the announcement of the new coach's arrival Stephenville and SWU were ready to move to the big time! The immediate issue facing SWU, however, was not NCAA ranking. It was capacity. The existing SWU stadium, built in 1953, has seating for 54,000 fans. The following table indicates attendance at each game for the past 6 years. Southwestern University Football Game…arrow_forward
- 3. A magazine publishes a U.S. and a Canadian edition each week. There are 30,000 subscribers in the U.S. and 20,000 subscribers in Canada. Other copies are sold at newsstands. Postage and shipping costs average $80 per thousand copies in the U.S. and $60 per thousand copies in Canada. Surveys show that no more than 120,000 copies of each issue can be sold (including subscriptions) and that the number of copies of the Canadian edition should not exceed twice the number of copies of the U.S. edition. The publisher can spend at most $8400 a month on postage and shipping. If profit is $200 per thousand copies on the U.S. edition and $150 per thousand copies on the Canadian, how many copies of each should be printed to maximize profit, and what will that profit be?arrow_forward1. Morelia Corporation has two assembly plants (in LA and Atlanta) and three distribution centers (St. Louis, Chicago, and Sacramento). The LA plant can produce at most 10,000 units per month, while the Atlanta plant can produce at most 7000 units per month. The St. Louis center must receive at least 5000 units per month, the Chicago center must receive at least 4000 units per month, and the Sacramento center must receive at least 8000 units per month. The costs per unit for transportation from plants to centers are given below. Set up an LP, defining the variables and writing the objective function and all constraints. LA to St. Louis, $3.50 LA to Chicago, 5 LA to Sacramento, 3 Atlanta to St. Louis, 3.50 Atlanta to Chicago, 3.75 Atlanta to Sacramento, 5.50arrow_forwardOHaganBooks.com currently operates three warehouses: one in Washington, one in California, and the new one in Texas. Book inventories are shown in the following table. Sci-Fi Horror Romance Other Total Washington 10,000 12,000 12,000 30,000 64,000 California 8,000 12,000 6,000 16,000 42,000 Техas 15,000 15,000 20,000 44,000 94,000 Total 33,000 39,000 38,000 90,000 200,000 A book is selected at random. Compute the probability of the given event. it is either a sci-fi book or stored in Washington (or both) 335arrow_forward
- The Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered. The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…arrow_forwardKentville, a community of 10,000 people, resides next to a krypton mine, and there is a concern that the emission from the krypton smelter have resulted in adverse effects. Specifically, Kryptonosis seems to have killed 12 of Kentville’s inhabitants last year. A neighboring community, Lanesburg, has 25,000 inhabitants and is far enough from the smelter to not be affected by the emission. In Lanesburg, only three people last year died of Kryptonosis. Given that the number of deaths in Kentville and their causes last year were: Heart attack=7 Accidents=4 Kryptonosis=12 Other=6 What is the risk of dying of Kryptonosis in Kentville relative to non-contaminated locality?What is the risk of dying of Kryptonosis in Kentville relative to deaths due to other causes? How many times the chance of dying of Kryptonosis compared to dying of accidents ? How many times the chance of dying of Kryptonosis compared to Other causes?arrow_forwardAn organization estimated that in a particular year the population of a country spent $10.5 trillion in personal consumption. The major categories of these expenditures are durable goods($1.1trillion; for example, cars, furniture, recreational equipment), nondurable goods($2.1trillion; for example, food, clothing, fuel), and services($7.1trillion; for example, health care, education, transportation). Complete parts (a) through (e) below. a. What is the approximate annual per capita spending for personal consumption? Assume a population of 265million. (Round to the nearest dollar as needed.) b. What is the approximate daily per capita spending for personal consumption? (Round to the nearest dollar as needed.) c. On average about what percentage of personal spending is devoted to services? (Round to the nearest percent as needed.) d. Spending on health care was estimated to be$1.1 trillion in that year. About what percentage of all personal…arrow_forward
- Analyze and compare Darden Restaurants to Panera Bread Darden Restaurants, Inc. (DRI) is the largest full-service restaurant company in the world. It operates over 2,200 restaurants under a variety of brand names, including Olive Garden, Bahama Breeze, and LongHorn Steakhouse. Panera Bread Company (PNRA) operates over 1,800 bakery-café locations across North America. It is one of the largest food service companies in the United States. The cost of food, beverage, and packaging and the beginning and ending inventory balances from recent annual reports for Darden and Panera are as follows (in millions): Darden Panera Cost of goods sold (food, beverage, and packaging) $2,039.7 $715.5 Inventories: Beginning of year 163.9 22.8 End of year 175.4 22.5 a. Compute the inventory turnover for both companies. Round all calculations to one decimal place. Inventory Turnover Darden Restaurants fill in the blank 1 Panera Bread fill in the…arrow_forwardThe Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50, $39.00, and $36.25, respectively, while the annual production capacity at each plant is 18,000, 15,000, 25,000, and 20,000, respectively. Sentry's locks are sold to retailers through wholesale distributors in seven cities across the United States. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year. Unit Shipping Cost to Distributor in St. Louis Plants Tacoma San Diego Dallas Denver Tampa Baltimore Macon $2.50 $2.75 $1.75 $2.00 $2.10 $1.80 $1.65 Louisville $1.50 $1.85 $1.90 $2.25 $1.85 $1.90 $1.60 $1.00 $1.85 Detroit $2.30 $2.25 $1.25 $1.50 $2.00 $1.90 8,500 $1.75 12,600 Phoenix $0.90 $2.50 $2.65 $1.60 13,500 $2.00 Demand 14,500 18,000 15,000 9,000arrow_forwardA forest consists of two types of trees; young (between 0 and 3 m tall) and adults (more than 3 m). Each year, 20% of young trees die, 10% sell for $20 each, 30% remain between 0 and 3 m, and 40% grow taller than 3 m. Each year, 40% of adult trees sell for $50, 20% sell for $20, 30% remain in the forest, and 10% die. What percentage of the trees planted sell for $50?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY