Answered You can hire a professional tutor to get the answer.

QUESTION

A mail order company is planning a direct mail campaign. The fixed cost of designing the special catalog is $20,0. The variable cost of printing and...

Can someone please help me get this set up in excel? I do not know where to start...

A mail order company is planning a direct mail campaign. The fixed cost of designing the special catalogis $20,0flfl. The variable cost of printing and mailing the catalogs mailing is uniformlv distributedbetween $0.30 and SEED per copy. The proportion of customers who respond and place an order [response rate] is expected to follow adiscrete distribution given below. Response rate distribution When a customer responds and places an order the dollar value of the orders is expected follow anormal distribution with a mean of 51bit! and a standard deviation of $15. The variable cost of each of these orders is expected to follow uniform distribution between WW: and 35% of the dollar amount ofeach order. a. Setup a Monte Carlo simulation model for the total profit for a single mailing campaign with lflflfiflfl as the number of catalogs printed and mailed. Use native Excel functions such asVLCICIKUP and NDRMJNV. etc., wherever appropriate. b. Using the DatafTable approach run 1oo replications and prepare a summary of the replicationresults. c. Prepare a histogram and box-plot for replication results.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question