computer homework needed asap
alaa.k
week_11_make_it_right_lab_work.xlsxProfit Analysis Report
| Dion Designwear | |||||||
| Profit Anaylsis | |||||||
| Product | Desciption | Cost | Profit | Units Sold | Total Sales | Total Profit | % Profit |
| 4835 | Coat | $247.63 | $144.83 | 95,159 | $37,346,101.14 | $13,781,877.97 | 36.903% |
| 7563 | Custom | 210.08 | 142.18 | 75,762 | 26,687,922.12 | 10,771,841.16 | 40.362% |
| 8191 | Dress | 186.53 | 99.48 | 69,297 | 19,819,634.97 | 6,893,665.56 | 34.782% |
| 8409 | Hat | 146.82 | 59.97 | 39,164 | 8,098,723.56 | 2,348,665.08 | 29.000% |
| 5677 | Jacket | 140.68 | 85.63 | 38,261 | 8,658,846.91 | 3,276,289.43 | 37.837% |
| 8985 | Shirt | 68.38 | 8.15 | 42,420 | 3,246,402.60 | 345,723.00 | 10.649% |
| 5871 | Slacks | 144.54 | 30.44 | 68,536 | 11,992,429.28 | 2,086,235.84 | 17.396% |
| 7796 | Sleepwear | 93.74 | 11.80 | 77,413 | 8,170,168.02 | 913,473.40 | 11.181% |
| 7777 | Suit | 305.91 | 126.00 | 19,999 | 8,637,768.09 | 2,519,874.00 | 29.173% |
| 8178 | Sweater | 112.21 | 9.24 | 61,257 | 7,439,662.65 | 566,014.68 | 7.608% |
| Totals | 587,268 | $140,097,659.34 | $43,503,660.12 | 31.052% | |||
| Lowest | $68.38 | $8.15 | 19,999 | $3,246,402.60 | $345,723.00 | 7.608% | |
| Highest | $305.91 | $144.83 | 95,159 | $37,346,101.14 | $13,781,877.97 | 40.362% | |
| Average | $156.54 | $71.77 | 54,679 | $14,009,765.93 | $3,302,420.24 | 25.489% |
Jeff Quansey Make It Right 2-1
