Pricing Products and Distribution Channels

Pricing Products and Distribution Channels

Pricing Products and Distribution Channels" Please respond to the following:

From the case study, suggest the pricing strategy that you believe will be the most effective for the QTG division of PepsiCo. Evaluate the degree to which each of PepsiCo’s distribution channels effectively leverages the corporation’s core competencies. Provide a rationale for your response.
* From the scenario, evaluate the capacity of the most common distribution channels available for the new product launch to provide consumers with easier access to the product. Speculate on the extent to which Golds Reling, Inc. could use each channel to meet profit goals. Choose the most beneficial distribution strategies, and suggest two (2) ways in which this selection could potentially affect consumer adoption of the new product. Provide a rationale for your response. 

ASHFORD OMM622 WEEK 3 ASSIGNMENT

ASHFORD OMM622 WEEK 3 ASSIGNMENT

Assignment
To complete the following assignment, go to this week's Assignment link in the left navigation.

    Income Statement - Ford Motor Company

    In a two- to three-page paper (excluding the title and reference pages), explain the purpose of an income statement and how it reflects the firm’s financial status. Include important points that an analyst would use in assessing the financial condition of the company. Also, analyze Ford Motor Company’s income statement from its 2012 Annual Report.

    Your paper must be formatted according to APA style as outlined in the Ashford Writing Center, and it must include citations and references for the text and at least two scholarly sources from the Ashford University Library.

    Carefully review the Grading Rubricfor the criteria that will be used to evaluate your assignment.

MIS 111 ABP-4 – Fall 2013

MIS 111 ABP-4 – Fall 2013

Name:  	Lastname, Firstname
NetID:		 (Blackboard Username)

 


Section 1:  Website hosting and design
Website URL (MUST be hosted on u.arizona.edu):
u.arizona.edu/ns
What web authoring tool did you use?

The web authoring tool that I used was Adobe Dreamweaver CS6


Section 2:  Application of Information Systems Discussion
Information systems are a core unit in any organization. They are important because they help organizations and businesses to manage work in areas like employee monitoring and evaluation, transmitting information and coordinating activities in the work place. They are also core because they offer dealers, marketers, suppliers and manufacturers with a value chain. Information systems are used in:
1. Health sector – Information systems are applied in health sectors. There use range from records storage, diagnosis, treatment etc. Overall, a well-functioning Health Information system is an integrated attempt to gather, process, report and utilize health information, data and knowledge to initiate policy and decision making, research, personal and general health outcomes.
2. Education – Information system are applied in the education sector such as universities, colleges and high schools. Overall, information systems from an education perspective are used to manage and keep track of student enrollment, fee payments, examinations and any other activities involving the student.
3. Business and organizations – From a business perspective, information systems are used in collecting, processing and generating reports to aide managers in decision making. They also help in keeping track of employees, production, purchases and sales as well as any transactions of the business. 	
Section 3:  Information Systems in Hiring
JOB 1
Title: 
Project Manager
Functional area:
Project management
Discussion:
The project manager is responsible with planning, implementing and evaluating projects based on some fixed timelines and budgets. Moreover, he is responsible with managing projects, reporting to the stakeholders and guaranteeing quality control throughout the project lifecycle.
JOB 2
Title: 
Information System Manager
Functional area:
Management and accountability of the information system within an organization
Discussion:
An information systems manager is accountable for the information systems within an organization, supervising implementation, making sure backup systems function effectively and efficiently, procuring hardware equipments and software products, offering the IT infrastructures for an organization and formulating organizational policies concerned with eminence standards and tactical planning. Job titles for an information system may vary. For instance, one might be referred to as a functional manager or a systems manager

Section 4:  Marketing Analysis
Transportation companies
According to Google ad word keyword tool, the phrase “Transportation companies” has an average monthly search of 1600 hence making it a competitive keyword. Apparently, upon searching on Google, Norfolk Southern Corp Company never appeared in the first 10 pages. This may be as a result of poor marketing and SEO strategies.
Railway Transporters
According to Google Ad word tool, the phrase “Railway Transporter” has monthly search results of 40. This keyword has low searches hence making it less competitive keyword. The advantage of using less keyword with low search is because they are less competitive as compared to keywords with high searches. Upon searching the keyword in Google, Norfolk Southern Corp did not appear in the first.
Transportation Services

According to Google ad word keyword tool, the phrase “Transportation Services” has an average monthly search of 2,900 which qualifies it as a competitive keyword. Apparently, upon searching on Google, Norfolk Southern Corp Company appeared in the 23rd page. The site can best be marketed for this keyword by conducting Search Engine Optimization for their website.

GRAND CANYOU MGT655 WEEK 8 ASSIGNMENT-Supply Chain Problem

GRAND CANYOU MGT655 WEEK 8 ASSIGNMENT-Supply Chain Problem

Details:

Complete Objective Questions 12 and 17 at the end of chapter 16 in the textbook.

Use Microsoft Excel for all computations. Ensure that the Excel file includes the associated cell computations. This information is needed in order to receive full credit on this assignment.

Each problem is to be placed into separate worksheets and all problems are to be placed into one file. For example, the single Excel file should contain one worksheet named 12 and another named 17

Case Study #1: Planning and Organizing-Management Plan for Cyber Software Inc

Case Study #1: Planning and Organizing-Management Plan for Cyber Software Inc

Case Study #1: Planning and Organizing

Students will read the case study that focuses on mission and vision, organizational structure and change and organizational culture and respond to the following requirements.

You have been hired as a consultant to help Joseph Jackson solve his organizational problems. You are to create a mini-management plan that structures the entire company. The mini-management plan will include a mission and vision, structure and culture.

Resource that will help you develop the mini-management plan:

How to Make a Management Plan

http://ctb.ku.edu/en/table-of-contents/leadership/effective-manager/management-plan/main

Required Elements to Include in the Management Plan:

• Create mission and vision statements that align with what Joseph Jackson envisions for his company and explain why these statements are appropriate for Cyber Software, Inc;

• Create an organizational structure that aligns with the vision of Joseph Jackson

? Explain why the structure is the most appropriate structure for Cyber Software, Inc;

? Explain why the other structures were not selected.

? Illustrate the structure with an organizational chart with names, job titles, and direct reports;

? Develop profiles (bio that focuses on the jobs held including current position) for the management team (Be creative);

• Discuss in detail the culture Joseph Jackson will create for his new organizational structure and how he will make those changes;

• How will the changes in the organizing facet of the P-O-L-C framework prevent future mishaps;

• In completing this assignment students are to use critical thinking and use the jargon learned in the course. In doing so, students must use facts from the case study and make connections with concepts ideas and theories identified in the eBook.

Required Formatting of the Management Plan:

• This paper should be double-spaced, 12-point font, and between 5-7 pages in length excluding the title page and reference page.

• Title page with your name, the course name, the date, and the instructor’s name.

• An introductory paragraph, a summary paragraph and the use of headings are required;

• Use APA formatting for in-text citations and reference page. You are expected to paraphrase and not use quotes other than in identifying the mission statement and vision statement.

• Write in the third person;

• Submit paper in the Assignment Folder.

Use this case study for Case Study #1: Planning and Organizing

Cyber Software, Inc Case Study

Planning and Organizing

Cyber Software, Inc. is a medium size manufacturer of cyber protection software products. The company has gross sales of 20 million dollars. Expenses are approximately 8 million dollars leaving an after tax profit of 10 million dollars per annum. Some of their major clients include local retail businesses as well as state and municipal governments. One medium sized client is the Baltimore City Government. Yesterday, the city found that their website was hacked and credit card information provided to pay water, sewer, real estate tax, and parking tickets was accessed. It was suspected that the hacking was part of the recent attacks by Russian cyber thieves.

Joseph Jackson is the CEO and owner of the corporation. Fortunately for Jackson the company was able to respond quickly and only 275 people were affected by the hacking. However, this was a wake up call for Jackson. He knew that if he was to continue growing the business he would have to develop better software as well as fast clean up procedures for the victims. Jackson felt it was imperative that the company always remain on the cutting edge of the industry so that his customers felt safe and trusted the company’s work. He took pride in the fact that the company has been capable of keeping his client’s information safe. In reaction to the break in at the City, and wanting to keep their business moving forward, Jackson decided that he would set up a separate division to work on new program development and a third division to focus on victim clean up and damage control. The third division he thought would provide a good selling point to potential new clients as none of his competitors offered this service.

The new development division required the hiring of four new program developers with extensive cyber security background. They all had good skills and some had actual experience in helping to uncover a few cyber thieves in the Target incident. They were creative and motivated to help protect people from having their property stolen. Knowing the nature of programmers Jackson did not structure the new development division so their progress or program approach was left to the programmers. In fact Jackson, in general, tried to keep the company as a whole free from a bureaucratic or structured environment. A year into the project the four programmers began to diverge so much in their programming approach that it became extremely expensive and in some ways they were wasting resources by covering similar ground. Nobody could agree as to which course was most effective.

In the client customer service division two programmers were hired as well as two experienced credit specialists, and two paralegals. Further, the division’s lack of structure has allowed a few strong personalities to emerge and the individuals cannot seem to get along. Like the new development division, customer service seems to be spinning their wheels in developing standard procedures and credit protection help for victims.

Also, both divisions were pulling people from their existing clients to help work on the project. Jackson knew that interfacing with ongoing work would help but it was ad hoc and disturbing existing work. Jackson could see that he would have to rethink his position on structure and “free” work environment if the company was to continue to grow.

It was time for an organizational structure and plan. A review of the budget revealed that the company could afford to allocate $1,500,000 to the operation of the two divisions before they have a sellable product. Existing salaries and expenses are at $750,000. This means that they have one year to get viable projects on the market.

I am needing help with Experiment 2 – Creating a…

I am needing help with Experiment 2 – Creating a…

Animals

Lab 10
Invertebrates & Vertebrates
113

114

Lab 10: Invertebrates & Vertebrates

Concepts to explore:
x
x
x
x
x

Characteris?cs of animals
Heterotrophs
Symmetry
Invertebrates
Vertebrates

Introduc?on
The kingdom Animalia comprises millions of species, ranging from the snail to the hippopotamus, the
ant to the elephant, the cen?pede to the human. Though there are notable di?erences in body shape
and func?on, almost are mo?le, mul?cellular eukaryotes, with dis?nct ?ssue structures that perform
specialized func?ons (i.e., heart, stomach) and almost all par?cipate in sexual reproduc?on. Unlike
plants, animals cannot produce energy from sunlight and, as heterotrophs, acquire energy by consum?
ing organic material (other plants and animals).
Useful characteris?c for classify animals is symmetry, or the balanced division of their form. Radial
Symmetry, as is seen in star?sh, is a division origina?ng in the center and protruding outwards that
produces even and balanced sec?ons. This is similar to the divisions that are made when a pie is cut
into many even pieces. In Bilateral Symmetry, as is seen in a beetle, the object can be divided into two
mirror images by a center line that runs through the en?re object. Asymmetry occurs when there can
be no even division, as is seen in a sponge.
Animals are classi?ed into two categories based on structure.

x

Invertebrates are organisms that lack an endoskeleton, such as the jelly?sh, insects, or worms.
They make up over 98% of all animal species.

x

Vertebrates possess an endoskeleton (an internal skeletal structure) and spinal column, like
you or your dog. An endoskeleton is a signi?cant adap?ve advantage that enables vertebrates
to occupy di?erent ecological niches (roles).

There are over 35 phyla in the Animal Kingdom. The vast majority fall within the following eight, seven
of which are invertebrates.

x

Phylum Porifera consists of sponges, considered to be the oldest of the animal phyla (Figure 1).
As sta?onary ?lters, sponges play an important role in aqua?c systems, feeding on par?cles

115

Lab 10: Invertebrates & Vertebrates
and bacteria in the water. Water enters the sponge through
several large canals and millions of small pores. Their asymmet?
ric body is a loose assembly of cells (no ?ssues) that support a
skeleton of collagen ?bers and spicules. Sponges reproduce
both sexually and asexually.

Figure 1: Porifera

x

The phylum Cnidaria includes jelly?sh,
corals, sea anemones, and hydras (Figure 2).
They were the ?rst to develop nerves and muscles and typically alternate
between two body forms: the free?swimming medusa and the sta?onary
polyp. Both body types consist of three layers of ?ssue surrounded by ten?
tacles with s?nging cells containing ?ny, toxic harpoons that can be used in
either defense or o?ense. They have radial symmetry (if you cut it in half,
each half will look like the other), with a hollow body cavity to digest food.
Figure 2:Cnidaria

x

The phylum Platyhelminthes includes freshwater planaria, colorful marine polycads, para?
si?c tapeworms and ?ukes. They are some of the simplest bilaterally symmetrical organ?
isms with a de?ned head and tail, and a centralized nervous system containing a brain and
nerves. They lack both a body cavity and circulatory system, but do have a tubular mouth,
an excretory system and a highly branched diges?ve system. Clusters of light?sensi?ve cells
make up their eyespots. They are hermaphrodi?c, capable of both sexual and asexual re?
produc?on.

x The phylum Annelida is represented by marine worms (polychaetes), earthworms and leech?
Figure 3: Annelida

x

es (Figure 3). They are bilaterally symmetric with a segmented body cavity
o?en represented by a tube within a tube design. Each segment has ?ny
hairs called setae which help the organism to move. Segmenta?on was
an important development that provides dis?nct regions to specialize in
di?erent tasks. A one?way diges?ve tract, closed?circulatory system, and
central nervous system also di?eren?ate this invertebrate. Annelids play
a signi?cant ecological role by reworking soil and sediments.

The phylum Arthropoda, the most diverse and numerous of
the Animal Kingdom, includes insects, crustacean, spiders, mil?
lipedes, and cen?pedes (Figure 4). All arthropods have seg?
mented bodies and are covered in a hard, ?exible exoskeleton.
Their muscles from their jointed appendages a?ach to the in?
side of this protec?ve cover. Many species, such as dragon?ies
that start as larvae and develop into winged adults, exhibit
Figure 4: Arthropoda

116

Lab 10: Invertebrates & Vertebrates

Some sandy beaches may harbor
32,000 burrowing annelids per
square meter, which collec?vely
may ingest and excrete 3 metric
tons of sand per year!

mul?ple life cycles. Their open body cavity which contains ?s?
sues, organs and a complete diges?ve tract.

xThe phylum Mollusca includes clams, snails, slugs and the octo?

pus (Figure 5). Though
there is a great deal of di?
versity within this phylum,
all mollusks have so? bodies, many of which are cov?
ered by a hard calci?ed shell. The shell is secreted by
a layer of ?ssue called the mantle. A muscular foot
provides locomo?on and grasping. A coarse, ?le?like
organ (the radula) allows most mollusks to drill into
Figure 5: Mollusca
their prey or snag ?sh. Many hunt by propelling water
through a siphon either for locomo?on or to capture food. A mantle cavity houses gills and
one?way diges?ve system.

x

The phylum Echinodermata includes sea stars, sea lilies,
sea urchins, sea cucumbers, and over 6,000 other salt wa?
ter species (Figure 6). Instead of bilateral or radial sym?
metry, echinoderms exhibit ?ve part symmetry in their
bodies. Their hard, ?exible bodies are composed of small
calcium plates that are o?en spiny and covered by a thin
skin. Inside is a complete diges?ve system and a special
Figure 6: Echinodermata
?uid??lled system that operates tube feet (which some?
?mes grow back if lost) which allow them to move, feed, and respire.

x

Vertebrates (Figure 7), along with tunicates and lancelets, fall into a
subphylum of the phylum Chordata.

x

Tunicates are invertebrates that look like sponges but have
a bony, vertebral column with a dorsal nerve cord which
develops into a spinal cord and brain; a common feature
they share with vertebrates.

x

Their internal skeleton allows them to grow without the
need to molt (as in arthropods).
Figure 7: Vertebrates

x

Chordates have gill cle?s (the structures located behind
the mouth and in front of the esophagus), bilateral symmetry, segmented muscles,
and a protec?ve layer (feathers, scales, hair, fur, etc.,).

x Two main groups of the subphylum vertebrata include ?shes and tetrapods (amphibians,
rep?les, birds, and mammals).

117

Lab 10: Invertebrates & Vertebrates
x

Fish are found in the water, lay so? eggs, are cold blooded and use gills to breathe.

x

Amphibians are found in both water and on land, lay so? eggs, are cold blooded,
and breathe using, gills, lungs an through their skin.

x

Rep?les live almost en?rely on land, lay somewhat hard shelled eggs, are cold
blooded and breathe through lungs.

x

Birds are found on land (and in the air), lay hard shelled eggs, are warm blooded,
and breathe through lungs.

x

Mammals are normally found on land, give live birth, are warm blooded and
breathe through lungs. Mammals are also characterized by the presence of hair on
their bodies and their ability to produce milk in sweat glands (mammary glands) for
their young. There are roughly 5,000 species of mammals.

Arguably the most dominant vertebrate is Homo sapien
(you). Humans are thought to be the longest living
mammals, though other species, such as the elephant
and whale are also long?lived. Though there are obvious
di?erences between human beings and other mammals,
there are also many similari?es. In the following labs we
will look at human systems as a model for what is found
in many vertebrates.

Many heart valve replacements are actually
porcine valves. The cells are removed but
the architecture of the ?ssue remains. The
cardiac physiology between man and pig is
so similar that the parts can be made
interchangeable!

Experiment 1: Symmetry in Animals
Look at the objects listed below, which can be found in your lab kit, and decide what type of symmetry
they posses. Explain why you chose the type of symmetry you did.
1. Goggles/Safety Glasses

2. Petri dish

118

Lab 10: Invertebrates & Vertebrates

3. Wash bo?le with curled straw

4. Top of a liquid bo?le

5. Balloon

119

Lab 10: Invertebrates & Vertebrates
Experiment 2: Crea?ng a Phylum Key
1. The phylum characteris?c table contains all of the main features of the eight main phyla. Your job is
to organize and iden?fy which characteris?cs belong to which phyla in the key. The number of lines
in the key represents the number of characteris?cs that fall into each phylum.

Table 1: Phylum Characteris?c Table

1

2

3

4

5

A

Bilateral phy?
lum with seg?

Most have a
calcium con?

Five part sym?
metry

Specialized
cell, but no

Mantle of ?s?
sue covering

B

Hollow body
cavity for food

Setae used for
movement

Jaws and skulls
part of evolu?
?on

Complete di?
ges?ve tract

The ?rst to
have jointed
legs

The ?rst phy?
lum to ?y

Some have
s?nging cells

Tube feet

First muscle
and nerves

Internal skele?
ton

Three ?ssue
layers, no
body cavity
Water ?ows
through canals
of body
Body design is
a tube within a
tube

C

Parasites

D

More complex
because of
more DNA

E

All live in the
sea

Simple animals
with bilateral
symmetry

Entrance and
exit the same
in the diges?

All have verte?
bral column

Champions of
varia?ons in
appendages

F

Has the most
species

Have spines
covered with a
thin skin

Some sta?on?
ary polyps

Some are mo?
bile medusa

Some propel
using their
siphon

G

Muscular foot
used to move

Sta?onary ani?
mal

Tubular mouth
at the mid?
body

Humans

Hard but ?exi?
ble bodies
with small

H

Spicules are
the skeleton

Radula used to
feed

No symmetry

Exoskeleton

Their burrow?
ing has a?ect?
ed the global

120

Lab 10: Invertebrates & Vertebrates
Table 2: Phylum Taxonomic Key

Porifera

Cnidaria

Platyhel?
minthes

Annelida

Arthropoda

Mollusca

Echinodermata

Chordata

Experiment 3: Taxonomy
Iden?fy which phylum each of the following organisms belongs in. Next to each, list the criteria
used in your determina?on.
1.

Figure 8

121

Lab 10: Invertebrates & Vertebrates
2.
Figure 9

3.

Figure 10

4.
Figure 11

5.
Figure 12

6.

Figure 13

122

Lab 10: Invertebrates & Vertebrates
The following lab exercise is intended to be an add?on for the Invertebrate Lab. Unless your teacher
has speci?cally requested that dissec?on materials be included within your kit, you will NOT have the
supplies to perform the next two experiments.

Experiment 4: Invertebrate Dissec?on
The star?sh is not a ?sh at all, rather an invertebrate that possesses no internal skeleton. Members of
the phylum Echinodermata, star?sh are unique in that they are deuterostomes (instead of proto?

Materials
Preserved star?sh
Dissec?ng tray
Dissec?ng tools
Magnifying lens

Note: When performing a dissec?on, remember these important safety notes:

x
x

Dissect with the scalpel or scissor blade cu?ng away from you (and your lab partner).
If you develop an allergic reac?on to the preserving ?uid, contact your healthcare
provider. Also, inform your instructor and inform him/her of your situa?on.

x

Contact your local waste management company for instruc?ons for the proper dis?
posal of your specimen.

x

Wash your hands, dissec?on tools, and all work surfaces with soap and water when
?nished with the dissec?on.

stomes like earthworms, grasshoppers, clams, etc.). Deuterostomes exhibit incomplete segmenta?on,
and a brain and spinal cord above the gut, among of other di?erences with protostomes. Star?sh have
no front or back, and can move in any direc?on without turning.

Procedure
1. Examine the external anatomy of the star?sh. The side in which the mouth is located is called
the oral surface (ventral side). The opposite side is called the aboral surface (dorsal side). See
Figure 14 for reference.

123

Lab 10: Invertebrates & Vertebrates

Figure 14: The aboral (le?) and oral (right) surfaces of the star?sh.

2. Run your gloved ?nger over the surface and note the texture. Use the magnifying glass to ex?
amine the spiny skin in detail.
3. Along with the s?? spines, you may also see small, hair?like gills used by the star?sh to take in
oxygen.
4. Pedicellaria are ?ny pincers that look like pliers that are used to grip small objects.
5. Place the star?sh ventral side up and note the tube feet that run down the arms, or rays, of the
star?sh. They will be located on either side of the groove that runs from the ?p of each ray to
the center.
6. Find the mouth in the center of the star?sh.
7. On the oral surface of each arm are open ambulacral grooves extending from the mouth to the
?p of each arm. Locate the abulacral groove running from the center down each ray.
8. Using the magnifying lens, examine the tube feet with protruding suckers on either side of the
abulacral groove.
9. Flip the star?sh so the dorsal side is facing up.
10. Note the eyespots at the ?p of each arm, which allows the star?sh to sense and respond to
light. To see the eyespots, and spread the tube feet at the ?p of the ray and examine it closely
with the magnifying lens.
11. The ?at central disk is at the center, and ?ny, hollow, ?nger?like gills cover the body of the star?
?sh.
12. The opening of the water?vascular system is called the madreporite. It is a large, bu?on?like

124

Lab 10: Invertebrates & Vertebrates

13.
14.
15.

16.

17.

18.
19.

20.
21.
22.
23.

24.

structure on the central disk.
The anus is in the center of the disk.
Using a scalpel, cut one inch from the ?p of one of the rays. Study the cross sec?on of the
stump.
Note the ossicles (part of the endoskeleton) on the dorsal surface, the largest of which called
the ambulacral ossicles, which support the ambulacral groove and provide a?achment for the
tube feet.
Remove the skin from the top of this ray using dissec?ng scissors or scalpel. Do the same for
another ray, and also cut a circular lap of skin from the central disk being careful to keep it as
shallow of an incision as possible.
Note the feathery?looking diges?ve glands called the pyloric caeca. These glands make en?
zymes that help digest food in the stomach, located under the central disk. The thin sac lying
just above the stomach is the intes?ne. From there, the rectal pouches store small amounts of
wastes before leaving through the anus on the dorsal side of the star?sh.
Remove the pyloric caeca from one ray, and observe the gonads underneath.
Remove the gonads to visualize the water vascular system. This is an internal water pressure
system. Water enters the system through the madreporite, passes through a series of canals
un?l it reaches the tube feet. When the ampulla contracts, water is forced into the tube foot,
extending it and allowing it to grab on to a surface.
Running the length of each ray is a lateral canal, to which tube feet are a?ached.
In the central disk, the ?ve lateral canals connect to the ring canal.
Note the stone canal connec?ng the ring canal to the madreporite, where water enters. These
canals are di?cult to locate without disrup?ng them, but see if you can iden?fy them.
With a magnifying lens, examine the inside wall of the ray to see the suppor?ng ridges, the
bulb?like ampullae, ?ny sacs that create suc?on of the tube feet. You may also no?ce ?ny
openings in the inner wall. These pores connect with a ?ll tube and are part of the external gills
that help the star?sh to breathe.
As with any biological scraps, it is best to contact your local waste management company for
proper disposal procedure.

Ques?ons
1. What are some common animal traits that a star?sh does not possess?

125

Lab 10: Invertebrates & Vertebrates
Experiment 5: Vertebrate Dissec?on
Frogs are a member of the Amphibia class of vertebrates. In many respects, the anatomy of the frog is
similar to human anatomy. Thus, the study of frog anatomy is a useful tool for science students.
As amphibians, frogs may live some of their adult life on land, but return to water to reproduce.

Materials
Preserved Grassfrog
Flashlight
Dissec?on tray (Styrofoam)
Dissec?on tools
Dissec?ng pins
Toothpick
3 in. Fishing line

Figure 15: The dorsal (above) and ventral (below) sides of the frog. Cut lines are shown
on the picture below (green).

126

Lab 10: Invertebrates & Vertebrates

Note: To determine the sex of your frog, examine the
?ngers on its foreleg (arm). A male frog typically ex?
hibits thick pads below the thumbs.

Procedure
1. Place the frog dorsal (back) side up in the dissec?ng tray. Observe the external anatomy of the
skin. Don’t forget to use your sense of touch in this observa?on (with gloved hands of course)!
2. Locate the following features:

x
x
x

External nares (nostrils)

x
x
x
x
x
x

Internal nares

x

Fat bodies: Located just inside the abdominal wall, these long, thin organs are yellow
or orange in color. You may remove these structures if they obstruct your view of un?
derlying organs

Two tympani (eardrums)

Two eyes, each with three lids (the third lid is a transparent covering on the eye)
3. Measure the length of the frog and record this measurement in Table 3.
4. Break a toothpick so that you have a 1in piece. Place this in the frog’s mouth to prop it open so
you can observe the structures of the frog’s mouth.
5. Using the ?ashlight, locate the following features:

6.
7.
8.
9.

10.
11.
12.

Eustachian tubes
Opening of the esophagus
Glo?s
Tongue

Two kinds of teeth; maxillary teeth help the frog to grip while vornerine teeth point
inward.
Use forceps to grab the tongue and locate where it a?aches to the ?oor of the mouth.
Insert the end of the ?shing line into one of the Eustachian tubes and watch the tympanum on
the dorsal side of the frog. This system allows air pressure to be equalized in the frog’s head.
Place the frog in the dissec?on tray ventral (belly) side?up, and pin the arms and legs to the
tray to stabilize the specimen.
Using forceps and dissec?ng scissors, cut along the midline of the body star?ng at the cloaca
(the urogenital opening) as shown in Figure 15. Make shallow cuts so internal organs are not
damaged when cu?ng through the muscle and breastbone.
Make horizontal cuts near the arms and legs, as shown in Figure 15.
Pin the ?aps to the dissec?ng tray to expose the internal organs. Note: If your specimen is fe?
male, you may need to remove the eggs and enlarged ovary to view the internal organs.
Using a probe and forceps, li? the internal organs around so you can locate the following or?
gans:

127

Lab 10: Invertebrates & Vertebrates
x

Peritoneum: Directly under the body wall, this a?ached membrane of thin ?ssue
forms a lining around the internal organs. There are various membranes that hold the
organs in place, called mesenteries, which are also part of the peritoneum.

x

Liver: A three?lobed organ that sits high in the body cavity. It is the largest organ visi?
ble, and is dark brown in color.

x

Heart: A triangular structure that sits above the liver. Note the thin sac (called the peri?
cardial sac) that covers this organ and the vessels extending from it. The pericardial sac
can be cut to expose the heart.

x
x

Lungs: Two spongy organs located beneath the liver.
Gall bladder: This bright green organ can be visualized by spreading apart the lobes of
the liver.

x

Esophagus: A tube that transports food from the mouth to the stomach. Insert your
probe into the frog’s mouth and observe where it leads.

x

Stomach: Under the le? side of the liver, this bag?like diges?ve organ is the ?rst site of
chemical diges?on in the frog.

x

Small intes?ne: A long coiled tube that serves as a conduit for food and the place
where nutrient absorp?on into the bloodstream takes place. No?ce the blood vessels
running through this organ.

x

Large intes?ne: A widening of the small intes?ne signals the start of the large intes?
?ne. This may be located underneath the small intes?nes.

x

Spleen: Located in the middle of the body cavity, this dark red, spherical organ stores
blood. You may need to li? the stomach and small intes?nes to see.
13. Using dissec?ng scissors, remove the stomach from the body cavity. Cut it open to inves?gate
any remains from the frog’s last meal.
14. Remove the small intes?nes from the body cavity. Measure the length of the small intes?nes
and record in Table 3.
Table 3: Observa?onal Measurements of Frog (Remember to Assign Units Where Appropriate!)

Length of frog

Length of small intes?nes

Contents of stomach

15. Con?nue to locate the following organs:

x

Kidneys: Dark, bean?shaped organs that ?lter wastes from the blood. You may have to
li? the intes?nes to see them, as they are towards the back of the body cavity.

x

Testes (for male specimens): Located above the kidneys, these round organs are typi?
cally light in color.

x
x

Oviducts (for female specimens): Curly tubes around the kidneys.

Bladder: A bag?like organs that stores urine. Try to trace the tubes from the kidneys to
the bladder.
16. As with any biological scraps, it is best to contact your local waste management company for

128

Lab 10: Invertebrates & Vertebrates
proper disposal procedure.

Ques?ons
1. Classify the specimen you just dissected, star?ng with Kingdom and ending with Species.

2. Describe the appearance of ?ve organs you found in the frog.

129

20 multiple choice questions

20 multiple choice questions

Multiple Choice

Identify the choice that best completes the statement or answers the question.

____ 1. Microsoft® Excel, Quattro Pro and Lotus 1-2-3 contain built-in optimizers called

a.
	

what-if engines.

b.
	

calculators.

c.
	

solvers.

d.
	

risk analyzers.

____ 2. In the Solver dialog box simple upper and lower bounds for decision variables are specified by

a.
	

referring directly to the decision variable cells.

b.
	

requiring the addition of the bounds above and below the variable cells.

c.
	

resolving the problem with the bounds added.

d.
	

incorporating the bounds in the objective function.

____ 3. Which button in the Solver parameters window is used to enter new constraints to a model?

a.
	

Guess

b.
	

Add

c.
	

Change

d.
	

Delete

____ 4. Models which are setup in an intuitively appealing, logical layout tend to be the most

a.
	

Reliable

b.
	

Modifiable

c.
	

Auditable

d.
	

Organized

____ 5. Numeric constants should be

a.
	

embedded in formulas.

b.
	

placed in individual cells

c.
	

placed in separate workbooks.

d.
	

entered manually every time a model is solved.

____ 6. The Auditing tool in Excel is useful for

a.
	

verifying the equations in a spreadsheet model.

b.
	

toggling between absolute and relative cell referencing.

c.
	

executing the Excel spreadsheet layout Wizard.

d.
	

naming cells and cell ranges for easier modifiability.

____ 7. The Guess button on the Solver Parameters box

a.
	

returns a heuristic solution to the problem.

b.
	

returns a guess as to the decision variable cells.

c.
	

determines the Target cell based on specified decision variable cells.

d.
	

always works correctly.

____ 8. What action is required to make Solver solve a specified problem?

a.
	

Type go in cell A1.

b.
	

Click the Solve button in the Solver Parameters dialog box.

c.
	

Click the Close button in the Solver Parameters dialog box.

d.
	

Click the Guess button in the Solver Parameters dialog box.

____ 9. Problems which have only integer solutions are called

a.
	

discrete programming problems

b.
	

integer programming problems

c.
	

discrete programming problems

d.
	

infeasible programming problems

____ 10. How many decision variables are there in a transportation problem which has 5 supply points and 4 demand points?

a.
	

4

b.
	

5

c.
	

9

d.
	

20

____ 11. How many constraints are there in a transportation problem which has 5 supply points and 4 demand points? (ignore the non-negativity constraints)

a.
	

4

b.
	

5

c.
	

9

d.
	

20

____ 12. A heuristic solution is

a.
	

used by Solver when the Guess button is used.

b.
	

guaranteed to produce an optimal solution.

c.
	

used by Solver if Standard GRG Nonlinear method is selected.

d.
	

a rule-of-thumb for making decisions.

____ 13. Which of the following describes Data Envelopment Analysis (DEA).

a.
	

DEA finds the most effective company among some set of companies.

b.
	

DEA determines if a company is converting inputs to outputs as effectively as possible.

c.
	

DEA determines how effective a company converts inputs to outputs compared to other companies.

d.
	

DEA compares how effective a company converts inputs to outputs compared to a benchmark composite of all companies.

Scenario 3-2

The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces only a limited demand. There are also a limited number of wiring, assembly and inspection hours available in each month. The data for this problem is summarized in the following table.

Computer

Model
	

Profit per

Model ($)
	

Maximum

demand

for product
	

Wiring

Hours

Required
	

Assembly

Hours

Required
	

Inspection

Hours

Required

Plain
	

30
	

80
	

.4
	

.5
	

.2

Fancy
	

40
	

90
	

.5
	

.4
	

.3

	

	

Hours

Available
	

50
	

50
	

22

Let
	

X1 = Number of Plain to produce

	

X2 = Number of Fancy to produce

MAX:
	

30 X1 + 40 X2

Subject to:
	

.4 X1 + .5 X2? 50 (wiring hours)

	

.5 X1 + .4 X2? 50 (assembly hours)

	

.2 X1 + .2 X2? 22 (inspection hours)

	

X1? 80 (Plain computers demand)

	

X2? 90 (Fancy computers demand)

	

X1, X2? 0

	

A
	

B
	

C
	

D
	

E

1
	

	

Byte Computer Company
	

	

	

2
	

	

	

	

	

3
	

	

Plain
	

Fancy
	

	

4
	

Number to make:
	

	

	

	

Total Profit:

5
	

Unit profit:
	

30
	

40
	

	

6
	

	

	

	

	

7
	

Constraints:
	

	

	

Used
	

Available

8
	

Wiring
	

0.4
	

0.5
	

	

50

9
	

Assembly
	

0.5
	

0.4
	

	

50

10
	

Inspection
	

0.2
	

0.3
	

	

22

11
	

Plain Demand
	

1
	

	

	

80

12
	

Fancy Demand
	

	

1
	

	

90

____ 14. Refer to Scenario 3-2. What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute total profit?

a.
	

=B4*C4+B5*C5

b.
	

=SUMPRODUCT(B4:C4,B5:C5)

c.
	

=SUM(B5:C5)

d.
	

=SUM(E8:E10)

____ 15. Refer to Scenario 3-2. Which cells should be changing cells in this problem?

a.
	

B4:C4

b.
	

E5

c.
	

D8:D10

d.
	

E8:E10

____ 16. Refer to Scenario 3-2. Which cells should be the constraint cells in this problem?

a.
	

B4:C4

b.
	

E5

c.
	

D8:D12

d.
	

E8:E12

Scenario 3-4

A financial planner wants to design a portfolio of investments for a client. The client has $300,000 to invest and the planner has identified four investment options for the money. The following requirements have been placed on the planner. No more than 25% of the money in any one investment, at least one third should be invested in long-term bonds which mature in seven or more years, and no more than 25% of the total money should be invested in C or D since they are riskier investments. The planner has developed the following LP model based on the data in this table and the requirements of the client. The objective is to maximize the total return of the portfolio.

Investment
	

Return
	

Years to Maturity
	

Rating

A
	

6.45%
	

9
	

1-Excellent

B
	

7.10%
	

8
	

2-Very Good

C
	

8.20%
	

5
	

4-Fair

D
	

9.00%
	

8
	

3-Good

Let
	

X1 = Dollars invested in A

	

X2 = Dollars invested in B

	

X3 = Dollars invested in C

	

X4 = Dollars invested in D

MAX:
	

.0645 X1 + .071 X2 + .082 X3 + .09 X4

Subject to:
	

X1 + X2 + X3 + X4 ? 300000

	

X1? 75000

	

X2? 75000

	

X3? 75000

	

X4? 75000

	

X1 + X2 + X4? 100000

	

X3 + X4? 75000

	

X1, X2, X3, X4 ? 0

	

A
	

B
	

C
	

D
	

E
	

F
	

G
	

H

1
	

	

Amount
	

Maximum
	

	

Years to
	

7+ years?
	

	

Good or

worse?

2
	

Bond
	

Invested
	

25.0%
	

Return
	

Maturity
	

(1-yes, 0-no)
	

Rating
	

(1-yes, 0-no)

3
	

A
	

$0
	

$75,000
	

6.45%
	

9
	

1
	

1-Excellent
	

0

4
	

B
	

$0
	

$75,000
	

7.10%
	

8
	

1
	

2-Very Good
	

0

5
	

C
	

$0
	

$75,000
	

8.20%
	

5
	

0
	

4-Fair
	

1

6
	

D
	

$0
	

$75,000
	

9.00%
	

8
	

1
	

3-Good
	

1

7
	

Total

Invested:
	

$0
	

Total:
	

$0
	

Total:
	

$0
	

Total:
	

$0

8
	

Total

Available:
	

$300,000
	

	

	

Required:
	

$100,000
	

Allowed:
	

$75,000

____ 17. Refer to Scenario 3-4. Which cells are changing cells in the accompanying Excel spreadsheet?

a.
	

B3:B6

b.
	

B7:I7

c.
	

C7

d.
	

E7

Scenario 3-5

A company is planning production for the next 4 quarters. They want to minimize the cost of production. The production cost is stable but demand and production capacity vary from quarter to quarter. The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand. Quarterly inventory holding cost is 3% of the cost of production. The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month. There are currently 5,000 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter.

	

Quarter
	

	

	

	

1
	

2
	

3
	

4

Unit Production Cost
	

$ 300
	

$ 300
	

$ 300
	

$ 300

Units Demanded
	

2,000
	

9,000
	

12,000
	

11,000

Maximum Production
	

8,000
	

7,000
	

8,000
	

9,000

Let
	

Pi = number of units produced in quarter i, i=1, ..., 4

	

Bi = beginning inventory for quarter i

MIN:
	

300 P1 + 300 P2 + 300 P3 + 300 P4 +

	

9(B1 + B2)/2 + 9(B2 + B3)/2 + 9(B3 + B4)/2 + 9(B4 + B5)/2

Subject to:
	

4000? P1? 8000

	

3500? P2? 7000

	

4000? P3? 8000

	

4500? P4? 9000

	

3000? B1 + P1 - 2000? 12000

	

3000? B2 + P2 - 9000? 12000

	

3000? B3 + P3 - 12000? 12000

	

3000? B4 + P4 - 11000? 12000

	

B2 = B1 + P1 - 2000

	

B3 = B2 + P2 - 9000

	

B4 = B3 + P3 - 12000

	

B 5 = B4 + P4 - 11000

	

Pi, Bi? 0

	

A
	

B
	

C
	

D
	

E
	

F

1
	

	

	

Quarter
	

	

	

2
	

	

	

1
	

2
	

3
	

4

3
	

Beginning Inventory
	

	

5,000
	

11,000
	

9,000
	

5,000

4
	

Units Produced
	

	

8,000
	

7,000
	

8,000
	

9,000

5
	

Units Demanded
	

	

2,000
	

9,000
	

12,000
	

11,000

6
	

Ending Inventory
	

	

11,000
	

9,000
	

5,000
	

3,000

7
	

	

	

	

	

	

8
	

Minimum Production
	

	

4,000
	

3,500
	

4,000
	

4,500

9
	

Maximum Production
	

	

8,000
	

7,000
	

8,000
	

9,000

10
	

	

	

	

	

	

11
	

Minimum Inventory
	

	

3,000
	

3,000
	

3,000
	

3,000

12
	

Maximum Inventory
	

	

12,000
	

12,000
	

12,000
	

12,000

13
	

	

	

	

	

	

14
	

Unit Production Cost
	

	

$300
	

$300
	

$300
	

$300

15
	

Unit Carrying Cost
	

3.0%
	

$9.00
	

$9.00
	

$9.00
	

$9.00

16
	

	

	

	

	

	

17
	

Monthly Production Cost
	

	

$2,400,000
	

$2,100,000
	

$2,400,000
	

$2,700,000

18
	

Monthly Carrying Cost
	

	

$72,000
	

$90,000
	

$63,000
	

$36,000

19
	

	

	

	

	

	

20
	

	

	

	

	

Total Cost
	

$9,861,000

____ 18. Refer to Scenario 3-5. What formula should be entered in cell C6 in the accompanying Excel spreadsheet to compute ending inventory?

a.
	

=C3-C4+C5

b.
	

=C3+C4-C5

c.
	

=C3-(C4-C5)

d.
	

=C5-C4-C3

____ 19. Refer to Scenario 3-5. What formula should be entered in cell C18 in the accompanying Excel spreadsheet to compute the monthly carrying costs?

a.
	

=C15*C3+C6

b.
	

=C15*(C3+C6)

c.
	

=C15*C3/2

d.
	

=C15*(C3+C6)/2

____ 20. Refer to Scenario 3-5. Which cells are changing cells in the accompanying Excel spreadsheet?

a.
	

C4:F4

b.
	

C9:F9

c.
	

F20

d.
	

C12:F12