QUESTION 15
Which line coding technique represents logical “1s” as alternating voltage changes (e.g., 1,1 represented as +v, -v).
|
a. Non-return to zero (NRZ) |
||
|
b. Bipolar Alternative Mark Inversion (AMI) |
||
|
c. Manchester |
||
|
d. Bipolar with 8-zero substitution |
QUESTION 16
4B5B differs from line coding techniques in that is ensures that strings of consecutive “1s” and “0s” do not exist prior to being line coded. Select the correct statement(s) regarding 4B5B.
|
a. since 4B5B eliminates long string of logical “1s” and “0s”, simpler line coding techniques such as NRZ can be used. |
||
|
b. since one bit out of every five bits sent is not real information, the data link suffers from a 1/5 or 20% overhead cost (i.e., reduction in data throughput) |
||
|
c. only 80% of the data sent using 4B5B is real information |
||
|
d. all of the above are correct statements |
QUESTION 17
Analog-to-digital conversion (ADC) describes converting an analog signal into digital data. How is this accomplished?
|
a. analog signals are continuous and therefore can never be converted into a digital signal |
||
|
b. analog signals must undergo a line coding process |
||
|
c. analog signals mush be sampled and quantized |
||
|
d. analog signals are modulated onto digital carriers |
QUESTION 18
You want to capture a live music concert and covert it into digital format for transmission. The human ear has a frequency bandwidth of approximately 20,000 Hz. Select the best sampling rate and bit depth. (hint: use Nyquist and a bit-depth of 16)
|
a. fs=40,000 samples/s, Bit depth = 1 bit per sample |
||
|
b. fs=40,000 samples/s, Bit depth = 16 bit per sample |
||
|
c. fs=10,000 samples/s, Bit depth = 16 bit per sample |
||
|
d. fs=20,000 samples/s, Bit depth = 1 bit per sample |
QUESTION 19
When digitizing an analog signal, quantization errors will always be present regardless of bit-depth used.
True
False
QUESTION 20
What happens during an analog-to-digital conversion process, if you fail to follow the Nyquist formula?
|
a. signal aliasing occurs |
||
|
b. quantization errors are experienced |
||
|
c. nothing – your signal will be fine |
||
|
d. None of the above |
QUESTION 21
You digitize an analog signal that has a frequency bandwidth of 8kHz, using a bit depth of 4. What data rate must be supported?
|
a. 32 kpbs |
||
|
b. 64 kbps |
||
|
c. 128 kbps |
||
|
d. 256 kbps |
In: Computer Science
*Problem 1
|
The BackPack Company produces a line of backpacks. The manager, Jill Nicholas, is interested in using a level aggregate plan. Inventories and back orders will be used to handle demand fluctuations. She has asked you to develop such a plan. Use the following data to solve the problem:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Calculate the aggregate production rate: 5806 units(Round your answer to 0 decimal places, the tolerance is +/-1.) |
||||||
Calculate the appropriate workforce given the aggregate production rate: 436 employees(Round your answer to the nearest whole number, the tolerance is +/-1.) |
||||||
Show what would happen if this plan were implemented. (If the answer is void please enter 0, do not leave any fields blank.)
|
||||||||||||||||||||||||||||||||||||||||||||||
Calculate the costs of this plan. (Round your answers to 0 decimal places. Do not round your intermediate computations to calculate regular-time labor cost.)
|
||||||||||||||||||||
Evaluate the plan in terms of cost, customer service, operations, and human resources. |
||||||
In: Operations Management
Chapter 21 – A Better Way to Present Brad’s Case
Fundamentals of Case Management Practice, skills for the human services - 5th ed by Nancy Summers
Please read the following case study and answer the questions to the best of your ability.
Case 21.1: A Better Way to Present Brad's Case
When presenting a case at a service planning conference, your case summary should be brief and address only the most pertinent details of the case. The case summary should follow the six elements outlined in your textbook. Review the following case presentation by Cameron and answer the questions that follow.
Cameron: Uh, this is Brad who is failing in school. He was referred to us by the school. His mother is a single mom, works as a custodian at the Waverly Elementary School. Dad's not in the picture. Burt is failing in school…
Deliliah: I thought his name was Brad. How old is he?
Cameron: (Shuffling papers) Oh, right. It is Brad. Got him mixed up with another kid. Oh yeah. He is 14. So anyway, he is failing in school after his friend got shot. Random. He was walking to school and it was a stray bullet, so Brad is walking alone to school these days. The teachers feel he is having trouble with the loss—maybe feels a little vulnerable himself. That's about it.
Jamal: So, what else do you know about him?
Cameron: That's about it.
Alex: What grade is he in?
Cameron: Oh yeah. He's in 8th grade. Did well up until now.
Jamal: What's your impression of this kid?
Cameron: Oh, you know. An average 14-year-old. Likes football. Goes to the Y after school until Mom gets home.
1. What information is missing from Cameron's case presentation? Considering the six elements of a case presentation, which has he omitted?
2. Do you feel Cameron spent enough time with Brad to develop a sound impression of who Brad is? What about Cameron's presentation leads you to your conclusion?
3. Do you feel Cameron spent enough time with Brad's mother to understand their home life and how she sees Cameron's difficulties? What about Cameron's presentation leads you to your conclusion? What specific questions would you have about Brad's home life?
4. Does Cameron have a good grasp of the strengths in Brad's life? What potential strengths do you see that you would want to pursue further?
5. Overall, how would you rate and describe Cameron's presentation?
In: Psychology
QUESTION 37
Which of the following is an important question that is answered in a business plan?
| a. |
What are the trade restraint strategies used by businesses in the external environment? |
|
| b. |
What are the entrepreneur's goals and objectives? |
|
| c. |
How will the entrepreneur divest strategic business units? |
|
| d. |
What are the marketing strategies used by the entrepreneur's competitors? |
|
| e. |
What are the overhead costs of the entrepreneur's venture? |
QUESTION 38
Scientific management focuses on
| a. |
increasing overhead costs. |
|
| b. |
improving the performance of individual workers. |
|
| c. |
encouraging soldiering among employees. |
|
| d. |
analyzing the external rather than the internal environment of an organization. |
|
| e. |
increasing employee turnover. |
QUESTION 39
Which of the following positions would be considered a specialized management position?
| a. |
Accountant |
|
| b. |
Public relations manager |
|
| c. |
Marketing manager |
|
| d. |
Hospital administrator |
|
| e. |
Human resources manager |
QUESTION 40
Which of the following statements is true about the decision-making process?
| a. |
It exclusively applies to problem situations. |
|
| b. |
It requires that the nature of a particular situation be defined. |
|
| c. |
It typically involves only one individual and seldom applies to groups. |
|
| d. |
It seldom applies to situations that are positive. |
|
| e. |
It results in the generation of only one alternative. |
QUESTION 41
Emilio says, "Employees and situations are unique. Sometimes I get good results by trying one approach, sometimes I decide to do something completely different." Emilio's statement is best aligned with which of the following management views?
| a. |
Scientific management |
|
| b. |
The classical management perspective |
|
| c. |
The contingency perspective |
|
| d. |
Theory X |
|
| e. |
Administrative management |
QUESTION 42
A _____ is privately owned by one individual or a group of individuals and has sales and assets that are not adequate enough to meaningfully influence its environment.
| a. |
publicly held corporation |
|
| b. |
regulatory agency |
|
| c. |
non-profit organization |
|
| d. |
strategic business unit |
|
| e. |
small business |
QUESTION 43
Venus Corp. prohibits its employees from smoking in its premises. This is an example of a(n)
| a. |
standard operating procedure. |
|
| b. |
program. |
|
| c. |
entropy. |
|
| d. |
project. |
|
| e. |
rule. |
QUESTION 44
Which of the following is a determinate of an organization's culture?
| a. |
The extended benefits provided by an organization |
|
| b. |
Corporate success and shared experiences |
|
| c. |
The regulations for work performance set by an organization |
|
| d. |
The strategic partners of an organization |
|
| e. |
The products and services available for the functioning of an organization |
QUESTION 45
By recognizing the _____ aspect of decision making, the administrative model better reflects subjective considerations.
| a. |
classical |
|
| b. |
behavioral |
|
| c. |
sequential |
|
| d. |
groupthink |
|
| e. |
rational |
In: Operations Management
CHAPTER 9 CASE STUDY
GOLD STAR SHOES LTD.
Developing a Training Program
Gold Star Shoes Ltd. is a medium-sized manufacturer of leather and vinyl shoes located in Wilmington, Ontario. It was started in 1973 and currently employs about 500 persons in its Ontario plant and some 200 more in offices and warehouses throughout Canada.
“How can we develop a training program that will have a significant impact on our manufacturing staff?”
Jane Reynolds, special assistant in the personnel department, faced that challenge from a vice president of the largest division of Gold Star Shoes, manufacturing. Training had never been a high priority at Gold Star Shoes, having always been viewed as an expense item, not an investment. If skilled workers were needed, Gold Star Shoes preferred to raid other companies to save training costs. If raiding was not successful, a quick on-the-job training was provided by more experienced employees—limited to essential skills, since there was little incentive for the employees to be more involved.
However, when the vice president attended a convention of shoe manufacturers, he was surprised to learn how cost-efficient some other shoe producers were, especially in Italy and France. Although wages there were similar to the wages paid in Canada, the productivity of the Italian and French workers was significantly higher. The VP found that the Italian and French companies invested heavily in training, allowing them to use cross-trained, flexible staff.
The VP asked Reynolds to develop a training plan, suitable to improve the overall skill level of Gold Star Shoes’ employees. Reynolds vaguely remembered something about training from her few courses in human resource management quite some time ago, but she felt that it was not sufficient to develop a training program on her own. Besides, she knew nothing about the skill requirements in the manufacturing division.
She decided to ask Russ Summers, manager of the cutting operation, to chair a committee of first-line supervisors to assist her in the program development.
DISCUSSION QUESTIONS
|
1. |
You are Russ. Describe the steps you would recommend that Reynolds go through before actually designing the content of the training. |
|
2. |
What training methods would you suggest be used to train production workers? (First you might ask: What determines the methods?) |
|
3. |
How would you evaluate the training program to determine how effective it was? (What criteria would you use?) |
|
4. |
Do you think the first-line supervisors are the appropriate people to design the training program? Whom else would you add, if anyone, to this group? |
In: Operations Management
Case Study:
Numerous information systems are available within SAP ERP to support most of the processes that we will discuss in this book. Information systems (IS) can be divided into three broad categories: logistics information systems (LIS), financial information systems (FIS), and human resources information systems (HRIS). Logistics information systems support all of the logistics processes. Recall that logistical processes are concerned with acquiring, storing, creating, and distributing materials. The components of LIS include purchasing IS, sales IS, inventory control IS (IWM processes), quality management IS, plant maintenance IS, and shop floor IS (production processes). The financial information system supports reporting related to the general ledger (e.g., balance sheet, income statement, statement of cash flows), accounts receivable, and accounts payable. The HRIS is used to retrieve information about different HR components such as personnel, positions, and jobs.
Recall that information systems are part of the OLAP component of SAP ERP, and they utilize information structures to provide analytic capabilities. There are two types of information structures—standard and user-defined. Standard information structures are predefined in the SAP ERP system, and they collect the data needed to generate the most commonly used reports. SAP ERP also enables users to define their own structures, known as user defined information structures, to meet specific reporting requirements.
Finally, information structures enable users to conduct two types of analysis— standard and flexible. Standard analysis provides predefined analytics for data in standard information structures. This type of analysis is sufficient for most analytic requirements. When standard analysis is insufficient, users can conduct flexible analysis to customize the reporting. In contrast to standard analysis, flexible analysis allows users to define the content and format of the analysis. Specifically, it enables users to combine available characteristics and key figures as needed and to create new key figures using user-specified formulas. It also provides users with several layout options.
To summarize, the OLTP component of SAP ERP offers reporting in the form of work lists and online lists that are based on detailed transaction data.
In contrast, the OLAP component offers reporting via information systems, based on aggregated data in information structures. These capabilities are limited to data within the SAP ERP system. Today, however, companies need even more powerful reporting capabilities that combine data from multiple sources. This is the domain of business intelligence.
Q1. As an information systems project manager, on what bases would you select the modules and the functionalities of the enterprise systems to fit with your business needs and requirements?
Q2. Analyze the capabilities and the type of reporting you are seeking for your project and illustrate the right approach in selecting the suitable IS vendor for the project.
In: Operations Management
TourneSol Canada, Ltd. is a producer of high quality sunflower oil. The company buys raw sunflower seeds directly from large agricultural companies, and refines the seeds into sunflower oil that it sells in the wholesale market. As a by-product, the company also produces sunflower mash (a paste made from the remains of crushed sunflower seeds) that it sells into the market as base product for animal feed.
The company has a maximum input capacity of 150 short tons of raw sunflower seeds every day (or 54,750 short tons per year). Of course the company cannot run at full capacity every day as it is required to shut down or reduce capacity for maintenance periods every year, and it experiences the occasional mechanical problem. The facility is expected to run at 90% capacity over the year (or on average 150 x 90% = 135 short tons per day).
TourneSol is planning to purchase its supply of raw sunflower seeds from three primary growers, Supplier A, Supplier B, and Supplier C. Purchase prices will not set until the orders are actually placed so TourneSol will have to forecast purchase prices for the raw material and sales prices for the refined sunflower oil and mash. The contract is written such that TourneSol is only required to commit to 70% of total capacity up front. Any amounts over that can be purchased only as required for the same price. Historical prices for the last 15 years are in the table below (note that year 15 is the most current year).
|
Historical Price Data |
|||
|
Marketing Year |
Seed Average Price Index $/short ton |
Oil Average Price Index $/short ton |
Mash Average Price Index $/short ton |
|
1 |
127.7 |
317.8 |
63 |
|
2 |
192.4 |
465 |
87 |
|
3 |
242 |
662.2 |
105 |
|
4 |
242 |
668.2 |
111 |
|
5 |
274 |
791.3 |
124 |
|
6 |
242 |
732 |
108 |
|
7 |
290 |
951 |
134 |
|
8 |
347.2 |
1123 |
153 |
|
9 |
436 |
1297.3 |
193 |
|
10 |
422.8 |
1312 |
187 |
|
11 |
466 |
1416 |
193 |
|
12 |
582 |
1664 |
247 |
|
13 |
508 |
1317.4 |
242 |
|
14 |
428 |
1182.4 |
197 |
|
15 |
434 |
1334.4 |
210 |
Sunflower oil contains a number of fatty acids, some which are desirable in food products and others that are not. One desirable fatty acid is oleic acid. TourneSol produces high oleic oil for the wholesale market, and requires that the oleic acid content be a minimum of 77%. Sunflower oil also contains trace amounts of iodine. The market requires that that iodine content be a minimum of 0.78% and maximum of 0.88%
The oleic acid and iodine content for the sunflower seeds from the three suppliers is given in the table below.
|
Supplier |
Oleic Acid |
Iodine |
|
A |
72% |
0.95% |
|
B |
82% |
0.85% |
|
C |
65% |
0.72% |
For all three suppliers, it is expected that the average yield of oil from the seeds is 30%. There is no net loss of material, so the yield of mash from the same supply is expected to be 70%.
Because the oleic acid and iodine content varies across the three suppliers, so does the price. It is expected that the cost of supply from the suppliers will be a percentage of the market average price of seeds.
|
Supplier |
Cost as % of Average Market Price of Seed |
|
A |
85% |
|
B |
100% |
|
C |
90% |
The company faces an additional variable production cost of $10/short ton and an estimated fixed cost of $1,750,000 over the upcoming production period.
The company is asking you to provide a recommendation on the amount of raw material it should purchase from each supplier to minimize its cost of feedstock.
Management is also looking for an analysis on the profitability of the company in the next production cycle.
Formulate a linear program in Excel to minimize the cost of raw sunflower seeds. Use the average price of seeds forecasted from the previous step in order to determine supplier prices.
Perform a cost-volume-price analysis using the average cost per short ton average selling price per short ton.
In: Statistics and Probability
Generate comparative boxplots for: Male data between 2000 and 2015, Female data between 2000 and 2015, Both Sexes data between 2000 and 2015
Using the data from 2000, estimate the mean adult mortality rates for male, female and both sexes for the world population with 95% confidence.
Using the data from 2015, estimate the mean male, female and both sexes adult mortality rates for the world population with 95% confidence.
Estimate the mean difference (with 95% confidence) between: Male adult mortality rates of 2000 and 2015, Female adult mortality rates of 2000 and 2015, Both sexes adult mortality rates of 2000 and 2015
| 2000 | 2015 | ||||
| Male | Female | Both Sexes | Male | Female | Both Sexes |
| 88 | 56 | 73 | 64 | 42 | 53 |
| 91 | 48 | 70 | 70 | 34 | 52 |
| 96 | 67 | 88 | 75 | 47 | 68 |
| 99 | 57 | 78 | 74 | 44 | 59 |
| 99 | 54 | 76 | 75 | 41 | 58 |
| 99 | 56 | 78 | 71 | 39 | 55 |
| 100 | 80 | 92 | 74 | 59 | 69 |
| 102 | 61 | 82 | 78 | 50 | 64 |
| 104 | 57 | 80 | 70 | 37 | 54 |
| 106 | 68 | 87 | 80 | 53 | 66 |
| 110 | 71 | 96 | 98 | 58 | 81 |
| 113 | 88 | 107 | 81 | 57 | 75 |
| 119 | 91 | 106 | 91 | 65 | 78 |
| 119 | 49 | 84 | 99 | 45 | 72 |
| 124 | 94 | 110 | 93 | 79 | 88 |
| 126 | 68 | 98 | 78 | 48 | 63 |
| 127 | 64 | 96 | 85 | 45 | 65 |
| 128 | 96 | 112 | 111 | 83 | 98 |
| 132 | 69 | 101 | 93 | 55 | 74 |
| 132 | 97 | 115 | 98 | 71 | 85 |
| 135 | 70 | 103 | 110 | 53 | 82 |
| 138 | 92 | 115 | 113 | 70 | 92 |
| 142 | 62 | 103 | 104 | 51 | 78 |
| 145 | 63 | 105 | 102 | 49 | 76 |
| 145 | 83 | 114 | 128 | 77 | 103 |
| 146 | 70 | 110 | 98 | 51 | 74 |
| 150 | 128 | 139 | 79 | 43 | 61 |
| 157 | 100 | 127 | 124 | 74 | 98 |
| 160 | 104 | 138 | 110 | 70 | 99 |
| 160 | 89 | 125 | 130 | 72 | 102 |
| 174 | 89 | 131 | 145 | 88 | 116 |
| 177 | 169 | 173 | 151 | 105 | 129 |
| 179 | 94 | 137 | 153 | 80 | 116 |
| 179 | 74 | 127 | 131 | 60 | 95 |
| 180 | 137 | 155 | 137 | 97 | 114 |
| 181 | 133 | 156 | 154 | 108 | 130 |
| 183 | 140 | 160 | 104 | 86 | 95 |
| 187 | 101 | 144 | 131 | 80 | 106 |
| 190 | 102 | 149 | 167 | 79 | 123 |
| 195 | 147 | 172 | 166 | 126 | 146 |
| 196 | 174 | 185 | 181 | 151 | 166 |
| 199 | 93 | 142 | 165 | 78 | 118 |
| 200 | 79 | 139 | 185 | 68 | 127 |
| 208 | 158 | 183 | 167 | 109 | 138 |
| 210 | 166 | 188 | 204 | 147 | 176 |
| 213 | 157 | 186 | 181 | 129 | 156 |
| 218 | 87 | 153 | 166 | 67 | 117 |
| 226 | 99 | 163 | 187 | 83 | 137 |
| 231 | 133 | 182 | 185 | 97 | 142 |
| 240 | 109 | 175 | 191 | 74 | 133 |
| 241 | 145 | 192 | 193 | 100 | 145 |
| 241 | 137 | 189 | 237 | 132 | 184 |
| 242 | 143 | 192 | 188 | 105 | 147 |
| 242 | 103 | 175 | 202 | 76 | 138 |
| 243 | 140 | 192 | 174 | 104 | 139 |
| 247 | 140 | 194 | 192 | 105 | 148 |
| 248 | 142 | 197 | 216 | 123 | 170 |
| 250 | 140 | 198 | 205 | 116 | 161 |
| 251 | 194 | 224 | 216 | 142 | 181 |
| 252 | 198 | 224 | 217 | 164 | 190 |
| 261 | 184 | 222 | 240 | 158 | 198 |
| 265 | 176 | 221 | 234 | 138 | 188 |
| 273 | 163 | 219 | 272 | 145 | 211 |
| 274 | 210 | 243 | 217 | 154 | 186 |
| 281 | 223 | 250 | 225 | 156 | 188 |
| 287 | 280 | 284 | 236 | 199 | 220 |
| 293 | 300 | 296 | 239 | 219 | 229 |
| 296 | 105 | 200 | 244 | 87 | 165 |
| 298 | 246 | 272 | 252 | 202 | 227 |
| 298 | 193 | 246 | 256 | 173 | 215 |
| 305 | 309 | 307 | 266 | 267 | 266 |
| 307 | 132 | 218 | 262 | 105 | 178 |
| 314 | 239 | 274 | 209 | 143 | 174 |
| 314 | 121 | 218 | 177 | 61 | 119 |
| 322 | 116 | 218 | 226 | 82 | 153 |
| 326 | 219 | 274 | 307 | 136 | 222 |
| 329 | 286 | 308 | 274 | 224 | 249 |
| 337 | 275 | 305 | 270 | 211 | 240 |
| 354 | 296 | 325 | 265 | 215 | 241 |
| 356 | 135 | 247 | 294 | 98 | 196 |
| 372 | 321 | 346 | 283 | 234 | 258 |
| 374 | 293 | 335 | 312 | 236 | 275 |
| 382 | 329 | 355 | 340 | 283 | 312 |
| 402 | 359 | 380 | 351 | 313 | 332 |
| 410 | 378 | 394 | 377 | 338 | 357 |
| 412 | 170 | 292 | 279 | 118 | 198 |
| 430 | 378 | 404 | 378 | 333 | 356 |
| 431 | 401 | 416 | 288 | 245 | 267 |
| 437 | 379 | 408 | 362 | 308 | 335 |
| 466 | 450 | 457 | 311 | 245 | 279 |
| 473 | 446 | 461 | 414 | 377 | 397 |
| 524 | 333 | 426 | 313 | 152 | 227 |
| 577 | 499 | 536 | 425 | 326 | 373 |
| 594 | 582 | 588 | 398 | 330 | 365 |
| 641 | 654 | 647 | 298 | 212 | 256 |
| 654 | 575 | 614 | 360 | 242 | 303 |
| 655 | 675 | 665 | 359 | 313 | 336 |
| 712 | 433 | 593 | 289 | 222 | 255 |
| 443 | 158 | 307 | 325 | 118 | 222 |
| 301 | 145 | 225 | 231 | 102 | 166 |
| 256 | 220 | 238 | 187 | 143 | 165 |
In: Statistics and Probability
| Data Set 3 --Buena School District Bus Data | ||||||
| Bus Number | Maintenance | Age | Miles | Type | Bus-Mfg | Passenger |
| X1 | X2 | X3 | X4 | X5 | X6 | X7 |
| 135 | 329 | 7 | 853 | Diesel | Bluebird | 55 Passenger |
| 200 | 505 | 10 | 822 | Diesel | Bluebird | 55 Passenger |
| 40 | 466 | 10 | 865 | Gasoline | Bluebird | 55 Passenger |
| 387 | 422 | 8 | 869 | Gasoline | Bluebird | 55 Passenger |
| 326 | 433 | 9 | 848 | Diesel | Bluebird | 55 Passenger |
| 861 | 474 | 10 | 845 | Gasoline | Bluebird | 55 Passenger |
| 122 | 558 | 10 | 885 | Gasoline | Bluebird | 55 Passenger |
| 887 | 357 | 8 | 760 | Diesel | Bluebird | 6 Passenger |
| 686 | 329 | 3 | 741 | Diesel | Bluebird | 55 Passenger |
| 490 | 497 | 10 | 859 | Gasoline | Bluebird | 55 Passenger |
| 464 | 355 | 3 | 806 | Gasoline | Bluebird | 55 Passenger |
| 875 | 489 | 9 | 858 | Diesel | Bluebird | 55 Passenger |
| 883 | 436 | 2 | 785 | Gasoline | Bluebird | 55 Passenger |
| 57 | 455 | 7 | 828 | Diesel | Bluebird | 55 Passenger |
| 482 | 514 | 11 | 980 | Gasoline | Bluebird | 55 Passenger |
| 704 | 503 | 8 | 857 | Diesel | Bluebird | 55 Passenger |
| 731 | 432 | 6 | 819 | Diesel | Bluebird | 42 Passenger |
| 75 | 478 | 6 | 821 | Diesel | Bluebird | 55 Passenger |
| 600 | 493 | 10 | 1008 | Diesel | Bluebird | 55 Passenger |
| 358 | 461 | 6 | 849 | Diesel | Bluebird | 55 Passenger |
| 692 | 469 | 8 | 812 | Diesel | Bluebird | 55 Passenger |
| 43 | 439 | 9 | 832 | Gasoline | Bluebird | 55 Passenger |
| 500 | 369 | 5 | 842 | Gasoline | Bluebird | 55 Passenger |
| 279 | 390 | 2 | 792 | Diesel | Bluebird | 55 Passenger |
| 884 | 381 | 9 | 882 | Diesel | Bluebird | 55 Passenger |
| 977 | 501 | 7 | 874 | Diesel | Bluebird | 55 Passenger |
| 725 | 392 | 5 | 774 | Diesel | Bluebird | 55 Passenger |
| 982 | 441 | 1 | 823 | Diesel | Bluebird | 55 Passenger |
| 39 | 411 | 6 | 804 | Gasoline | Bluebird | 55 Passenger |
| 418 | 504 | 9 | 842 | Diesel | Bluebird | 55 Passenger |
| 984 | 392 | 8 | 851 | Diesel | Bluebird | 55 Passenger |
| 953 | 423 | 10 | 835 | Diesel | Bluebird | 55 Passenger |
| 507 | 410 | 7 | 866 | Diesel | Bluebird | 55 Passenger |
| 540 | 529 | 4 | 846 | Gasoline | Bluebird | 55 Passenger |
| 695 | 477 | 2 | 802 | Diesel | Bluebird | 55 Passenger |
| 321 | 450 | 6 | 856 | Diesel | Bluebird | 6 Passenger |
| 918 | 390 | 5 | 799 | Diesel | Bluebird | 55 Passenger |
| 101 | 424 | 4 | 827 | Diesel | Bluebird | 55 Passenger |
| 714 | 433 | 7 | 817 | Diesel | Bluebird | 42 Passenger |
| 768 | 494 | 7 | 815 | Diesel | Bluebird | 42 Passenger |
| 29 | 396 | 6 | 784 | Gasoline | Bluebird | 55 Passenger |
| 554 | 458 | 4 | 817 | Diesel | Bluebird | 14 Passenger |
| 699 | 475 | 9 | 816 | Gasoline | Bluebird | 55 Passenger |
| 954 | 476 | 10 | 827 | Diesel | Bluebird | 42 Passenger |
| 660 | 337 | 6 | 819 | Gasoline | Bluebird | 55 Passenger |
| 520 | 492 | 10 | 836 | Diesel | Bluebird | 55 Passenger |
| 814 | 426 | 4 | 757 | Diesel | Bluebird | 55 Passenger |
| 120 | 503 | 10 | 883 | Diesel | Keiser | 42 Passenger |
| 427 | 359 | 7 | 751 | Gasoline | Keiser | 55 Passenger |
| 759 | 546 | 8 | 870 | Diesel | Keiser | 55 Passenger |
| 10 | 427 | 5 | 780 | Gasoline | Keiser | 14 Passenger |
| 880 | 474 | 9 | 857 | Gasoline | Keiser | 55 Passenger |
| 481 | 382 | 3 | 818 | Gasoline | Keiser | 6 Passenger |
| 370 | 459 | 8 | 826 | Gasoline | Keiser | 55 Passenger |
| 989 | 380 | 9 | 803 | Diesel | Keiser | 55 Passenger |
| 162 | 406 | 3 | 798 | Gasoline | Keiser | 55 Passenger |
| 732 | 471 | 9 | 815 | Diesel | Keiser | 42 Passenger |
| 751 | 444 | 2 | 757 | Diesel | Keiser | 14 Passenger |
| 948 | 452 | 9 | 831 | Diesel | Keiser | 42 Passenger |
| 61 | 442 | 9 | 809 | Diesel | Keiser | 55 Passenger |
| 9 | 414 | 4 | 864 | Gasoline | Keiser | 55 Passenger |
| 365 | 462 | 6 | 799 | Diesel | Keiser | 55 Passenger |
| 693 | 469 | 9 | 775 | Gasoline | Keiser | 55 Passenger |
| 38 | 432 | 6 | 837 | Gasoline | Keiser | 14 Passenger |
| 724 | 448 | 8 | 790 | Diesel | Keiser | 42 Passenger |
| 603 | 468 | 4 | 800 | Diesel | Keiser | 14 Passenger |
| 45 | 478 | 6 | 830 | Diesel | Keiser | 55 Passenger |
| 754 | 515 | 14 | 895 | Diesel | Keiser | 14 Passenger |
| 678 | 428 | 7 | 842 | Diesel | Keiser | 55 Passenger |
| 767 | 493 | 6 | 816 | Diesel | Keiser | 55 Passenger |
| 705 | 403 | 4 | 806 | Diesel | Keiser | 42 Passenger |
| 353 | 449 | 4 | 817 | Gasoline | Keiser | 55 Passenger |
| 156 | 561 | 12 | 838 | Diesel | Thompson | 55 Passenger |
| 833 | 496 | 8 | 839 | Diesel | Thompson | 55 Passenger |
| 314 | 459 | 11 | 859 | Diesel | Thompson | 6 Passenger |
| 396 | 457 | 2 | 815 | Diesel | Thompson | 55 Passenger |
| 398 | 570 | 9 | 844 | Diesel | Thompson | 14 Passenger |
| 168 | 467 | 7 | 827 | Gasoline | Thompson | 55 Passenger |
| 671 | 504 | 8 | 866 | Gasoline | Thompson | 55 Passenger |
| 193 | 540 | 11 | 847 | Diesel | Thompson | 55 Passenger |
The attached MS-Excel file contains data on the contains data the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.
In: Accounting
| Data Set 3 --Buena School District Bus Data | ||||||
| Bus Number | Maintenance | Age | Miles | Type | Bus-Mfg | Passenger |
| X1 | X2 | X3 | X4 | X5 | X6 | X7 |
| 135 | 329 | 7 | 853 | Diesel | Bluebird | 55 Passenger |
| 200 | 505 | 10 | 822 | Diesel | Bluebird | 55 Passenger |
| 40 | 466 | 10 | 865 | Gasoline | Bluebird | 55 Passenger |
| 387 | 422 | 8 | 869 | Gasoline | Bluebird | 55 Passenger |
| 326 | 433 | 9 | 848 | Diesel | Bluebird | 55 Passenger |
| 861 | 474 | 10 | 845 | Gasoline | Bluebird | 55 Passenger |
| 122 | 558 | 10 | 885 | Gasoline | Bluebird | 55 Passenger |
| 887 | 357 | 8 | 760 | Diesel | Bluebird | 6 Passenger |
| 686 | 329 | 3 | 741 | Diesel | Bluebird | 55 Passenger |
| 490 | 497 | 10 | 859 | Gasoline | Bluebird | 55 Passenger |
| 464 | 355 | 3 | 806 | Gasoline | Bluebird | 55 Passenger |
| 875 | 489 | 9 | 858 | Diesel | Bluebird | 55 Passenger |
| 883 | 436 | 2 | 785 | Gasoline | Bluebird | 55 Passenger |
| 57 | 455 | 7 | 828 | Diesel | Bluebird | 55 Passenger |
| 482 | 514 | 11 | 980 | Gasoline | Bluebird | 55 Passenger |
| 704 | 503 | 8 | 857 | Diesel | Bluebird | 55 Passenger |
| 731 | 432 | 6 | 819 | Diesel | Bluebird | 42 Passenger |
| 75 | 478 | 6 | 821 | Diesel | Bluebird | 55 Passenger |
| 600 | 493 | 10 | 1008 | Diesel | Bluebird | 55 Passenger |
| 358 | 461 | 6 | 849 | Diesel | Bluebird | 55 Passenger |
| 692 | 469 | 8 | 812 | Diesel | Bluebird | 55 Passenger |
| 43 | 439 | 9 | 832 | Gasoline | Bluebird | 55 Passenger |
| 500 | 369 | 5 | 842 | Gasoline | Bluebird | 55 Passenger |
| 279 | 390 | 2 | 792 | Diesel | Bluebird | 55 Passenger |
| 884 | 381 | 9 | 882 | Diesel | Bluebird | 55 Passenger |
| 977 | 501 | 7 | 874 | Diesel | Bluebird | 55 Passenger |
| 725 | 392 | 5 | 774 | Diesel | Bluebird | 55 Passenger |
| 982 | 441 | 1 | 823 | Diesel | Bluebird | 55 Passenger |
| 39 | 411 | 6 | 804 | Gasoline | Bluebird | 55 Passenger |
| 418 | 504 | 9 | 842 | Diesel | Bluebird | 55 Passenger |
| 984 | 392 | 8 | 851 | Diesel | Bluebird | 55 Passenger |
| 953 | 423 | 10 | 835 | Diesel | Bluebird | 55 Passenger |
| 507 | 410 | 7 | 866 | Diesel | Bluebird | 55 Passenger |
| 540 | 529 | 4 | 846 | Gasoline | Bluebird | 55 Passenger |
| 695 | 477 | 2 | 802 | Diesel | Bluebird | 55 Passenger |
| 321 | 450 | 6 | 856 | Diesel | Bluebird | 6 Passenger |
| 918 | 390 | 5 | 799 | Diesel | Bluebird | 55 Passenger |
| 101 | 424 | 4 | 827 | Diesel | Bluebird | 55 Passenger |
| 714 | 433 | 7 | 817 | Diesel | Bluebird | 42 Passenger |
| 768 | 494 | 7 | 815 | Diesel | Bluebird | 42 Passenger |
| 29 | 396 | 6 | 784 | Gasoline | Bluebird | 55 Passenger |
| 554 | 458 | 4 | 817 | Diesel | Bluebird | 14 Passenger |
| 699 | 475 | 9 | 816 | Gasoline | Bluebird | 55 Passenger |
| 954 | 476 | 10 | 827 | Diesel | Bluebird | 42 Passenger |
| 660 | 337 | 6 | 819 | Gasoline | Bluebird | 55 Passenger |
| 520 | 492 | 10 | 836 | Diesel | Bluebird | 55 Passenger |
| 814 | 426 | 4 | 757 | Diesel | Bluebird | 55 Passenger |
| 120 | 503 | 10 | 883 | Diesel | Keiser | 42 Passenger |
| 427 | 359 | 7 | 751 | Gasoline | Keiser | 55 Passenger |
| 759 | 546 | 8 | 870 | Diesel | Keiser | 55 Passenger |
| 10 | 427 | 5 | 780 | Gasoline | Keiser | 14 Passenger |
| 880 | 474 | 9 | 857 | Gasoline | Keiser | 55 Passenger |
| 481 | 382 | 3 | 818 | Gasoline | Keiser | 6 Passenger |
| 370 | 459 | 8 | 826 | Gasoline | Keiser | 55 Passenger |
| 989 | 380 | 9 | 803 | Diesel | Keiser | 55 Passenger |
| 162 | 406 | 3 | 798 | Gasoline | Keiser | 55 Passenger |
| 732 | 471 | 9 | 815 | Diesel | Keiser | 42 Passenger |
| 751 | 444 | 2 | 757 | Diesel | Keiser | 14 Passenger |
| 948 | 452 | 9 | 831 | Diesel | Keiser | 42 Passenger |
| 61 | 442 | 9 | 809 | Diesel | Keiser | 55 Passenger |
| 9 | 414 | 4 | 864 | Gasoline | Keiser | 55 Passenger |
| 365 | 462 | 6 | 799 | Diesel | Keiser | 55 Passenger |
| 693 | 469 | 9 | 775 | Gasoline | Keiser | 55 Passenger |
| 38 | 432 | 6 | 837 | Gasoline | Keiser | 14 Passenger |
| 724 | 448 | 8 | 790 | Diesel | Keiser | 42 Passenger |
| 603 | 468 | 4 | 800 | Diesel | Keiser | 14 Passenger |
| 45 | 478 | 6 | 830 | Diesel | Keiser | 55 Passenger |
| 754 | 515 | 14 | 895 | Diesel | Keiser | 14 Passenger |
| 678 | 428 | 7 | 842 | Diesel | Keiser | 55 Passenger |
| 767 | 493 | 6 | 816 | Diesel | Keiser | 55 Passenger |
| 705 | 403 | 4 | 806 | Diesel | Keiser | 42 Passenger |
| 353 | 449 | 4 | 817 | Gasoline | Keiser | 55 Passenger |
| 156 | 561 | 12 | 838 | Diesel | Thompson | 55 Passenger |
| 833 | 496 | 8 | 839 | Diesel | Thompson | 55 Passenger |
| 314 | 459 | 11 | 859 | Diesel | Thompson | 6 Passenger |
| 396 | 457 | 2 | 815 | Diesel | Thompson | 55 Passenger |
| 398 | 570 | 9 | 844 | Diesel | Thompson | 14 Passenger |
| 168 | 467 | 7 | 827 | Gasoline | Thompson | 55 Passenger |
| 671 | 504 | 8 | 866 | Gasoline | Thompson | 55 Passenger |
| 193 | 540 | 11 | 847 | Diesel | Thompson | 55 Passenger |
The attached MS-Excel file contains data on the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.
a. Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel
c. Present your results in a table and a chart. Cut and paste your chart and table into MS-Word and attach your results.
In: Physics