2014 Royal Kona Tour Information
Tour
Price per passenger
Fixed Costs (annul)
boat deprecisation
boat maintenance
insurance
share of hotel costs
advertasing
Variable cost (per trip)
fuel
tour guide cost
passanger food
dockung fees
Numbers of trip per year
Grant Maurer
HW #5A
2/15/2017
1. The highest cost per ad belongs to the Time publication at $146,420 per ad and the lowest
audience per ad belongs to the Sports Illustrated publication with 3 million per ad. One
way to find both of these values is to use
Grant Maurer
QBA HW 4
2/8/2017
1. According to the data from the excel table, the state with the highest amount of consumer
goods rental establishments is Tennessee with 877. The state that earned the lowest amount
of revenue in this category is Wisconsin
Q1: What was the Royal Konas most profitable boat tour in 2011, and how much was that
profit?
The Royal Konas most profitable boat tour was the Sunset, ending with $224,258.40 in profit.
This is shown in the shaded area below.
2011 Royal Kona Tour Informa
Q1: What percent of survey respondents expect to buy a decorative faucet, and what percent of
respondents expect to buy from a showroom?
17.2% of respondents expect to buy a decorative faucet, and 15.6% of respondents expect to buy
from a showroom.
decora
Q1: Assume that the typical delivery requires one hour of courier labor and that DashMail
assigns couriers quickly enough to make deliveries in less than two hours. What is the marginal
profit associated with this typical delivery if James is paying regul
Q1: How many companies are represented in this industry peer data?
35 companies are represented.
Q2: What is the mean price among the stocks analyzed?
The mean price is $21.06 per share, shown below.
Price per share
Mean
21.06428571
Q3: What are the mean
Q1: What state has the highest number of consumer goods rental establishments, and what is
this number? Which state earned the lowest amount of revenue in this category, and how much
was it?
Tennessee has the highest number of consumer goods rental establ
Grant Maurer
HW #5
2/15/2017
1. In terms of mean thickness, all three machines seem to have relatively close outputs. But
in terms of Standard deviation, Press number 2 is significantly lower than press 1 and 2.
2. The press with the largest thickness ran
Grant Maurer
QBA HW #7
2/22/2017
1. The marginal profit for a delivery if James is paying regular wages is $24.68 dollars and the
equation to find this is =(B1-(B3*B4)-B3-B5). If James is paying overtime wages, the his marginal
profit would be $17.64 and
Publications
Time
Newsweek
Forbes
Reader's Digest
People
Sports Illustrated
Number of Ads Placed
Total Cost
Percent of Total Total Audience (Millions)
30 $4,329,002.55
0.333000196
295.6565049795
0
$12,997.83
0.000999833
0.8809628433
0
$0.00
0
0
63 $4,328,
Grant Maurer
QBA HW 6
2/22/2017
1. The expected loss for 1000 people attending the conference is -66,075 dollars.
2. The expected profit or loss for all levels of attendance are as follows:
3. The breakeven point in number of registrants is 1,490.26 or ju
Grant Maurer
QBA HW 3
2/8/2017
1. What was Royal Konas most profitable boat tour in 2015, and how much was the profit?
Royal Konas most profitable boat tour during 2015 was the Sunset tour, which made the
business a profit of $235,800.
2. What boat tour m
Grant Maurer
QBA HW #1
2/1/2017
1. The total cost of nuts for each ladder is $1.44 which consists of 32 nuts at $.05 each. Then for
the total cost of bolts, it would equal $17.60, which consists of 32 bolts at $.55 each.
Parts
Rungs
Sides
Feet
Nuts
Bolts
Grant Maurer
QBA HW #2
2/1/2017
1. According to cell E11 in my excel worksheet, is will cost $8,840.00 in development work needed
to include dynamic links to customer databases.
2. For the security function that Joe can purchase, the high cost amount Evel
High hourly wage: ($)
Low hourly wage: ($)
109
89
Yes
Main development
Include company product catalog:
non-dynamic online version
dynamic online version
Include dynamic links to:
supplier databases
customer databases
Provide enhanced security
Train Pet D
2015 Royal Kona Tour Information
Tour
Price per passenger
Fixed Cost (annual)
boat depreciation
boat maintenance
insurance
share of hotel costs
advertising
Variable Costs (per trip)
fuel
tour guide cost
passenger food
docking fees
Number of trips per year
Q1: What is the amount of yearly expenses that needs to be covered?
$61,200 is the amount of yearly expenses. This is shown in the table below.
Total monthly expenses
Total yearly expenses
5100
61200
Q2: Based on your work so far, what amount of insurance
Q1: Compare the exams total, projects total, and homework total score for Joe Fellers, Dan
Juslen, and Sara Owens. Which student received the highest Exam score, Project score, and
Homework score? Along with your answer, provide a table with headings that
Q1: What is the expected profit or loss if 1000 people attend the conference?
The expected loss is $71,290 if 1000 people attend the conference. This amount is shown in the
shaded cell.
Total Revenue ($)
Total Cost ($)
Profit ($)
241910
313200
-71290
Q2:
Homework #: 13
Date: 1/7/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: Across all 1830 jobs, what were the job_time mean and standard deviation?
Across all 1830 jobs the job time mean was 299.72 and the standard deviation is 47.79 for the
job t
Homework #: 12
Date: 1/7/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: What percent of subjects rated the highly crunchy cereal with a score of three or
more?
79% of the subjects rated the highly crunchy cereal with a score of three or more as
Homework #: 1
Date: 1/3/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: What is the total cost of nuts for each ladder and what is the total cost of bolts for
each ladder?
The total cost of nuts for each ladder is $1.44 and the total cost for bol
Homework #: 4
Date: 1/7/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: What state has the highest number of consumer goods rental establishments, and
what is this number? Which state earned the lowest amount of revenue in this category, and how
Homework #: 3
Date: 1/7/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: What was the Royal Konas most profitable boat tour in 2012, and how much was
that profit?
In 2012 the most profitable boat tour was the Sunset boat tour and the profit was $2