Qat1

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...