Share
Explore BrainMass

simulate the next six orders

A small supplier receives orders from three different companies for a certain price of electrical equipment. Forty-five percent of the orders come from Firm A, 35 percent from Firm B and the remainder from Firm C. Order sizes vary, depending on the firm involved. In the past orders were as follows:

REL FREQ
Order Size A B C
4 0.15 0.05 0.25
8 0.3 0.25 0.35
12 0.4 0.35 0.25
16 0.13 0.25 0.12
20 0.02 0.1 0.03

Using two digit numbers from rows 5 and 6 of the table on sheet two of the booklet simulate the next six orders:
Spreadsheet #2 are the random numbers.

Attachments

Solution Summary

The solution simulate the next six orders for statistical analysis.

$2.19