Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions