Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer all questions Again, all questions not only one Question 32 What is average of dally profit, if Fullerton Bakery makes 8lbs, of cookles
please answer all questions
Again, all questions not only one
Question 32 What is average of dally profit, if Fullerton Bakery makes 8lbs, of cookles every day? (Enter number only, 2 decimal places) Question 33 What is standard deviation of dally profit, if Fullerton Bakery makes 8Ibs. of cookies every day? (Enter number only, 2 decimal places) Question 34 If Fullerton Bakery makes 8 ibs of cooklies every day, what percent of days it will have less than $5 proft? (Enter number only, one dedimal place. For example, for 5.1% enter 5.1 ) Fullerton Bakery advertises fresh baked cookles which it sells for $3.50 per lb. The demand per day for cookles follows normal distribution with mean 8lbs. and standard deviation 1lb. If the cookies are not sold at the end of the day, it donates remaining cookles to Food Charily. Cookles cost bakery $2.00 per lb. Bakery has asked you to help them in calculating profit per day if they produce 8lbs. of cookles every day. Answer following questions with 1000 trials simulation. You can use formulas or generate random numbers using Data Analysis. If Fullerton Bakery makes 8 lbs of cookies every day, what percent of days It will have less than $5 profit? (Enter number only, one decimal place. For example, for 5.1% enter 5.1) Question 35 How many lbs of cookles per day should be produced to get highest per day profit? Question 30 What formula will you use in Excel to generate demand? NORMINN(RANDQ, meanstd dev) a+RANDOT(b-a) where a and b are lower and upper limit RANDBETWEEN(ab) where a and b are lower and upper limit vookup lunction Question 31 If production is P and demand is D then sales S can be calculated as follows: s=D SeP S= MIN(PD) 5= maxped)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started