Sarah Custard's is a pie shop that specializes in custard and fruit pies. It makes delicious...

 

Transcribed Image Text:

Sarah Custard's is a pie shop that specializes in custard and fruit pies. It makes delicious pies, and sells them at reasonable prices so that it can sell all the pies it makes in a day. Every dozen custard pies nets Sarah Custard's $15 and requires 12 pounds of flour, 50 eggs, 5 pounds of sugar and no fruit mixture. Every dozen fruit pies nets a $25 and uses 10 pounds of flour, 40 eggs, 10 pounds of sugar, and 15 pounds of fruit mixture. On a given day, the bakers at Sarah Custard's found that they had 150 pounds of flour, 500 eggs, 90 pounds of sugar, and 120 pounds of fruit mixture with which to make pies. a) Formulate and solve a linear program using excel solver that will give the optimal production schedule of pies for the day? b) What is the lowest selling price for custard pies that Sarah Custard's could charge while maintaining the optimal production schedule recommended in part (a)? Sarah Custard's is a pie shop that specializes in custard and fruit pies. It makes delicious pies, and sells them at reasonable prices so that it can sell all the pies it makes in a day. Every dozen custard pies nets Sarah Custard's $15 and requires 12 pounds of flour, 50 eggs, 5 pounds of sugar and no fruit mixture. Every dozen fruit pies nets a $25 and uses 10 pounds of flour, 40 eggs, 10 pounds of sugar, and 15 pounds of fruit mixture. On a given day, the bakers at Sarah Custard's found that they had 150 pounds of flour, 500 eggs, 90 pounds of sugar, and 120 pounds of fruit mixture with which to make pies. a) Formulate and solve a linear program using excel solver that will give the optimal production schedule of pies for the day? b) What is the lowest selling price for custard pies that Sarah Custard's could charge while maintaining the optimal production schedule recommended in part (a)?