Arial CaCel File Edit View Insert Format Tools Data Window Help 5 Bus 2410 Project 5 Home Insert Page Layout Formulas Data Review View X out 10 A- A Wrap Text General Coop Pasta B 1 A. Format Marge & Cantar - FIS Xfx D H K M N o loo's Ice Cream Company Moe's Ice Cream Completo now what the Main Sales would be in a day with the following contra $ 3.10 Tel Sale 1. They we were comes they serve Rocky Road and 1 Calle Doughn Wale Canet Once Where there are Nel the dy 2. They only carry whole Dough achter 2.133 cod 1 when the one they coul are the next day, 11 5.321 only serve customers per day 2.183 herche antwoor 3. 11 C the solutions to the De Server We Format 100ls Data Window Help Bus 2410 Project 5 Page Layout Formulas Data Review View Arial 10 AA- Home Insert Xon Copy Parts Format FIR . * Wrap Text General B U Marge & Center $ 96 2 Conditional Format Formatting as Table A D E F G H K Moo's Ice Cream Company M 1 2 N P ane Dihts Cone 6.20 Total Sales Revue 5 Moe's Ice Cream Comany weddike to know what the Minimum Sales Ever would in any day with the following constraints: 1. They how i Weter they see Rocky and Daugh w Ware. Once With Carepare there are the next day Roy Reads 6.35 I 2. They only vyhode Dough och dyerve cand where they can get the rest day Cock Doch Con The score 500 per day Geot De Bawapa . 2,183 Wand Decores and have to Teal Baby Type of cane these in the Soutoutinhas the 20 M 10 AAA EWra Pasto do Cut Arial Copy: B Format xfx I U Mer F18 A B D E F 1 Moo's Ice Cream Company ON 6.20 Total Sales Revenue Island Delights Regular Cone Subototal: $ $ 6.25 Rocky Road $ Waffle Cone Subototal: $ . 6.75 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Cookie Dough $ Waffle Cone Subototal: $ Constraints Waffle Cone Cookie Dough Server Capacity 5,321 2,183 5,500 Total Sales by Type of Cone Regular Cone Waffle Cone Total Served 21 22 23 24 25 26 27 28 29 30 31 32 33 35 Cover Sheet Part Data Table Loan Payments Part 2 Break Even Analysis Part 3 Solve El Wrap Text General Merge & Center $ %) 0 00 00 . Conditional Format Formatting as Tablo Call Styles Insert F G H 1 J K L M N Moo's Ice Cream Company would like to know what the Maxmimum Sales Revenue would be in any given day with the following constraints: 1. They have 5,321 Waffle cones available, they serve Rocky Road a dand Cookie Dough in Waffle Cones. Once the Waffle Cones are gone there are no more until the next day. 5,321 2,183 5,500 2. They only carry enough Cookie Dough each day to serve 2,183 cones and when it is all gone they can not get anymore until the next day. 3. The servers can only serve 5500 customers per day. They serve Island Delight in regular cones and have an unlimited supply of these. Using the Solver function put in these contraints to calculate the maximum revenue. Use the information in Tech Plugin T4 to help with this worksheet. Part 3 Solver + ty w px] 3G