Submitted by: Submitted by DMohame3
Views: 10
Words: 824
Pages: 4
Category: Business and Industry
Date Submitted: 05/10/2016 10:19 PM
Please enter your name and WGU
Note: In order to get credit for you
Student book Task 1
Quantitative Analysis for Business
QAT1
Assignment 309.3.1-01 - Version 3.1
If you see "####" in the worksheet fields: T
"zoom" sliding bar (bottom right of window f
Answers should be rounded to two decimal places (nearest cent). Scroll down to unlocked cells to show work.
For CONSISTENCY of technique the 1st interval should start at 1 and probabilities should not be reordered.
Don't forget the remaining task prompts that ask for the selling price and your calculation. Assume that the company wan
Show work below:
Materials Table:
COST
33.00
35.00
38.00
39.00
PROBABLITY
0.02
0.13
0.25
0.60
CUMULATIVE PROBABLITY
0.02
0.15
0.40
1.00
Labor Table:
COST
22.00
23.00
24.00
25.00
28.00
PROBABLITY
0.02
0.23
0.02
0.56
0.17
CUMULATIVE PROBABLITY
0.02
0.25
0.27
0.83
1.00
Labor Table:
COST
3.00
4.00
6.00
PROBABLITY
0.29
0.59
0.12
CUMULATIVE PROBABLITY
0.29
0.88
1.00
A2:
The random interval tables were used by calculating the cost and probability to create the random number inter
B:
Materials: Selling price per unit would be: $58.00
Labor: Selling price per until would be $44.83
Utilities: Selling price per until would be $24.25
Total Selling price cost per unit is $127.08
B1: I added the $20 markup profit to each average cost per unit to get the selling price in Part B1
Then after getting the selling price average for each model I added them together to get the tota
our name and WGU ID number in the boxes below.
to get credit for your work it is critical that you enter your student number correctly.
Student Name:
Student Number:
in the worksheet fields: The worksheet places the "####" symbol in a cell when the number in the cell is too large to display properly for t
(bottom right of window for most workbook apps) to increase the zoom to 100% or larger. The numbers should...