Std. Devijacija Excel Pomoc

[DoBesvijesti]

Ljudi,

Nadam se da nije frka sto je tema na ovom podforumu, no mislim da cu ovdje naci najvise strucnjaka.

Imam jednu molbu. Vec 7 dana pokusavam da rijesim jedan zadatak, ali mi nikako ne ide. Jedan od razloga je taj sto nikada nisam imala dodira sa ovom materijom, i puko iscitavanje literature koja je dostupna na netu, nije dovoljno da bi se ovo svarilo.

Potrebno mi je da mi neko objasni kako da ovaj zadatak postavim u excelu i kako da izracunam standardnu devijaciju ili kako se vec zove, da bih mogla odgovoriti na ova pitanja. Eh, posto ja excel koristim jednom godisnje, stvarno nemam blage veze odakle da pocnem, pa bi mi svaka pomoc dobro dosla.

Zadatak je na engleskom jeziku, i nadam se da to nije problem.

Question 1:
A famous high-end department store must decide on the quantity of a high-priced women’s handbag to procure in Italy for the upcoming holiday season. The unit cost of the handbag to the store is $68.50 and the handbag will sell for $150. Any handbags not sold at the end of the season are purchased by a discount firm for $20. In addition, the store accountants estimate that there is a cost of $0.40 for each dollar tied up in inventory, as this dollar invested elsewhere could have yielded a gross profit. Assume that this cost is attached to unsold bags only.

a) Suppose that the sales of bags are equally likely to be anywhere from 100 to 300 handbags during the season. Based on this, how many bags should the store purchase? (Hint: this means that the correct distribution of demand is uniform. You can use either a discrete or a continuous uniform distribution).

b) A detailed analysis of past data shows that the number of bags sold is better described by a normal distribution, with mean 200 and standard deviation 25. Now what is the optimal number of bags to be purchased?

c) The expected demand was the same in parts (a) and (b), but the optimal order quantities differed. What accounted for this difference?
For the rest of the question, assume that the demand is normally distributed with mean 200 and standard deviation 25.
d) The Italian bag supplier approaches the department store with the following deal: they will charge $60 per bag instead of $68.50 and buy any bags left unsold at the end of the season for $30. Should the store accept this deal? Why? What are the profits of the supplier and the retail store?

e) What if the supplier offers to sell each bag for $25 to the store but wants a share of 35% of the revenue generated from bags sold at the end of the season? Is this offer acceptable to the store? What are the profits of the supplier and the retail store?

f) If you know that the Italian supplier produces each bag for $13, what is the centralized solution?

Ili, ako neko zna uopce kako uraditi ovaj zadatak, puno bi mi pomogao.