Question: Assignment 13 (Chapter 19) This Assignment is worth 20 points 1. A retired couple supplement their income by making fruit pies, which they sell to

Assignment 13 (Chapter 19) This Assignment is

Assignment 13 (Chapter 19) This Assignment is worth 20 points 1. A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold at $4.50 to the grocer, and the grape pies are sold for $3.60. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh Ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1200 cups of sugar and 2100 cups of flour. Each apple pie requires 1.5 cups of sugar and 3 cups of floor, and each grape pie requires 2 cups of sugar and 3 cups of flour. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make apple pie in six minutes and a grape pie in three minutes. They plan to work no more than 60 hours. Note: Formulation (10 points), Excel solver (10 points). Please submit the excel document to receive full credits

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!