Homework #: 8
Date: 1/7/14
Section: 302C
Team Member: Sarah Buntrock
Question 1: Present and explain your formula. Your explanation should use simple language. You
should separate your formula into pa
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 co
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
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 fu
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
c
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 co
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 overt
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 pre
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
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
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
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 bre
Grant Maurer
Homework 12
3/29/2017
1. The percentage of kids who rated the cereal at 3 or higher was 76%.
2. Based on the mean crunchiness of both the high and low cereals, the mean rating was
4.27 fo
Grant Maurer
QBA HW 15
4/5/2017
1. The mean ROA was 4.59 and number of cases processed was 663.
2. The mean ROA now is 4.53 and the standard deviation is 10.68. The N size now is 641.
3. From the test
Grant Maurer
Homework 11
3/29/2017
1. The amount of companies or rows represented in this data set is 33.
2. The mean price of the stocks analyzed was 19.35.
3. The mean and median timeliness ratings
Grant Maurer
Homework 13
3/29/2017
1. Across all jobs, the mean was 299.87 and the standard deviation was 48.10.
2. It appears that across the three companies, the job time is increasing, so the techn
Grant Maurer
QBA HW 19
4/19/2017
1. The mean total weekly cost across both plants was $13,146.09.
2. As the number of hours goes up by 1 we have the equation y=6,737.40 + 15.75x, so if x
is 1, y or to
Grant Maurer
4/26/2017
QBA HW #20
1. SFGA should focus on two variables to improve their overall satisfaction. Those variables
are the pay and advancement variables. The overall mean of the pay variab
Grant Maurer
QBA HW 14
4/5/2017
1. The maximum purchase price was 15.20 and the standard deviation was 10.67.
2. We can cannot conclude that the mean purchase price of customers that eat at Koths rest
Grant Maurer
QBA HW 17
4/12/2017
1. The percentage of respondents that expect to buy a decorative faucet it 16.05% and the
percent of respondents who expect to buy from a showroom is 15.59%.
2. The fa
Grant Maurer
QBA HW 16
4/12/2017
1. The percentage of pads lasting more than 100,000 miles in 80.22% and the number of
brake produced by Rybarh was 372 of the 1800.
2. The amount of Rybarh brakes that
Grant Maurer
QBA HW #18
4/19/2017
1. The differences between the two correlations is that the var1/var3 correlation is a positive
correlation and the var1/var4 is a negative correlation. With that sai
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
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
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.