Solver for Excel VBA and please solve with pictures. Project steps are:

$-$ Prepare a userform where the input fields are from a cosmetics product shop

o Product Name $($text$)$

o Product Cost $($ accounting format between $$1\mathrm{.}00-$ $$25\mathrm{.}00)$

o Number of products sold per month $($integer between $5-500)$

o Profit Margin for each product $($as a percentage between $15\%-45\%)$

$-$ In the form there should be Save Data, Close Form buttons. Each record should be added to a new line.

$-$ Prepare a second form $($reachable from the first form$)$ where

o there are summarizing fields where you calculate the min$/$max$/$average sales price $($cost$)$x$(1+$profit margin$)$

o Calculate the total revenue and total profit $($by multiplying # of products sold with selling price$)$

o There should be an area in this second form where you list the top $3$ products in terms of total profit

$-$ Fill with at least $10$ products $($you can randomly give numbers and names...$)$