Please I want a correct and clear solution, I ask you to focus on the solution until you give me a correct answer, the solution must be electronically written (handwriting is rejected). Item name model.

slove from 1 Day to 20 Day

0.2 Complete the following simulation table for purchase of 70 bmw from sales loss profit from exces demandalags from sale of scrap and daily pro Costdata 033 Unitost Unitrice 050 Unit lost Un refund 005 Purchase 70 Random Digita Random for Type Digits) of Type of for Newsday Newsday Demand Demand 0.23 001 40 from Es Salape for Sale Day 1 Daily Pro 2 0.78 Fair 0.31 0 3 0.62 Fair 0.64 4 0.75 Fair 0.78 70 $ 0.74 Fair 0.12 50 6 0.09 0.45 7 0.16 Good 0.36 20 8 35 Fair 0.62 20 9 0.00 Pro 0.25 40 10 0.40 Fair 0.57 11 02 Poor Ox3 70 12 D.NO Pace 0.62 SO 13 0.72 Fair 0.70 70 14 0.3% Fair 0.X2 70 15 057 Fair 0:57 60 16 0.99 Poor 0.91 70 17 0.61 Fair 0.74 70 18 0.25 Good 0.05 50 19 0.35 Good OX 90 0.5$ Fair 0.55 Tel Avehti Sb Mini Max Pit Q.2 Complete the following simulation table for purchase of 70 newspaper by computing revenue from sales loss profit from excess demand salvage from sale of scrap and daily profit Cost data Unit cost 0.33 Unit price Unit lost Unit refund Purchase 0.50 0.17 0.05 70 Random Digits Random for Type Digits of Type of for Newsday Newsday Demand Demand 0.23 Good 0.01 40 Lost Profit Revenue from from Excess Sales Demand Salvage from Sale of Scrap Day 1 Daily Profit 2 0.78 Fair 0.51 60 3 0.62 Fair 0.64 60 4 0.75 Fair 0.78 70 5 0.74 Fair 0.12 50 6 0.09 Good 0.45 80 7 0.16 Good 0.36 70 8 0.35 Fair 0.82 70 9 0.90 Poor 0.28 40 10 0.40 Fair 0.57 60 11 0.82 Poor 0.83 70 12 0.80 Poor 0.62 50 0,72 Fair 0,70 70 14 0.38 Fair 0.82 70 15 0.57 Fair 0.57 60 16 0.99 Poor 0.91 70 17 0.61 Fair 0.74 70 18 0.25 Good 0.05 50 19 0.25 Good 0.88 90 20 0.55 Fair 0.55 60 Total AvgProfit StDev Profit MinProfit Max Profit