management accounting question i need answer according to excel. i'm stuck in that

Subject: ACACT202A-Management Accounting Case Study 1 Maria makes tortillas and sells them from her house. She is concerned about purchasing too many ingredients and having to throw away unsold tortillas at the end of the day. It costs her $5.00 to make 100 tortillas and she sells them for $20.00 per 100. She has kept track of sales and discovered that she can sell 1,500 tortillas about 25% of the time, 1,000 tortillas about 50% of the time and only 500 tortillas the rest of the time. What is the minimum number of tortillas she should make daily to maximize profit? Round to the nearest 100 tortillas. AutoSave 8- ACACT202A Management Accounting Assignment Ser2 2020 Template (2) - Anchal Aacha Home nsert Draw Page Layout Formulas Data Review View Help X Us Calibri General 47 BIU- -11-AA Wrap Test A Merge Center Font Alignment $ - %982 Sana Conditional Format Cell Formatting Table Styles Styles Chboard 15 Number 19 Ceili P14 D F 6 H M N P 1 Revenue 2 Variable Cost 3 $ $ c C 20.00 per 100 5.00 per 100 Hint: She cannot sell more than she makes, so if she makes 500 she has a 100% probability of selling them all, if she makes 600, she is likely to sell S75 (500 x 25% + 600 X 50%+600x25%) Calculate the profit at each level and you can work out how many she should make 4 5 500 600 800 900 1000 1100 1200 1300 1400 ISDO 1600) 1700 6 Quantity Produced 7 Estimated total sales Quantity & Sales 9 Total Variable costs 10 Profit 12 13 =0.5 markeath formula only awarded as per formula i calculations are done on calculator or formule don't tot Total marks in the above formulas = 764 murid for the lasation of the custo below = 30 marks in total 15 16 17 18 19 Conclusion / Explanation of calculations above: (50-100 words) I 20 22 Case study A Type here to search O a 3