Lastname Firstname - Excel (Product Activation failed File Data Review View Tell me what you want to do.. 6 X Sign in . Share 47 0 Normal 2 AY AutoSum - Normal 3 Home Insert Page Layout Formulas X Cut Calib - 11 - E Copy - TO- BIU... A *Formal Painter Clipboard fon A Paste Wrap Text General = = = = = Merge Center A - 7. % Alignment Number Comma 2 & Conditional Formal as Normal Formatting Table Bad Goud Insert Delele Fumal Clear Surl & Find & Filter Select Editing Styles H19 L M M N Q R S T A D C D [ G I! J 1 Simitli Cn. produces muffins. These are gourmet muffins that use Ethiopean organic chocolate. There is a shortage of this chacolate and they 2 will be able to important only 1250 KGs of this chocolate during the month of November. 3 They sell 3 types of muffin sets (a set includes 10 muffins): 4 The KING set sells for $30, takes 1 hour to make and requires 0.4 KG of chocolate and $5 of other direct materials 5 The PRESIDENT set sells for $25, takes 1 hour to make and requires 0.3 KG of chocoalte and $4,5 of other direct materials. 6 The MAYOR set sells for $18, takes 45 minutes to make (0.75 hours) and requires 0.15 KG of choclate and $3 of other direct materials. 7 The chocolate costs $10 per KG. 8 Labor is paid $5 per hour. 9 Overheads are $21,000 per month 10 Demand for KING is 1000, for PRESIDENT 2000 and for MAYOR 5000 units. 11 12 Required: 13 a) Advise Simitli Co. how to maximize profit. How many units of each product should they produce? (31 points) 14 b) Calculate the possible forecasted profit. (8 points) 15 c) What other other options does Simitli Co. have to increase production? Give at least three. (18 points) 16 17 Solve here 18 19 20 21 22 23 24 25 26 27 28 29 30 Probler 1 Problem 2 Probler 3 2 Ready O o x) 100% 1231 1C . 'O 40 CNC 11/3/2022