How should i insert the data in the excel sheet and please answer the questions. Thank you so much.

Home Insert Draw Page Layout Formulas Data Review View Automate Developer Script Lab DADM_UT @ Tell me Calibri (Body) 12AA C Wrap Text v Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? C11fx What is the sales revenue for the year if no money is spent on marketing? Question 2 What is the profit for the year if no money is spent on marketing? Question 3 What is the profit for the year if $1M is spent on marketing? ActiveWear Inc. is a rapidly growing clothing company that has made significant strides in the fashion industry. Founded in 2010, the company has successfully bridged the gap between functionality and style for athletic clothing. As the brand grows, however, the need for targeted marketing becomes ever more critical to continue driving revenue and expanding market share. The company is planning their budget for the upcoming year and needs to determine how much to spend on marketing. They can allocate up to $4M (million) for marketing efforts with the goal of increasing their market share. The total size of the clothing market is uncertain, as is ActiveWear's potential market share. Investing more marketing dollars will likely further increase ActiveWear's market share, but the amount of increase is also uncertain. The marketing team has put together the following information on the potential market size and ActiveWear's potential market share at different budget levels: - Total Market Size: expected to be $800M with a $25M standard deviation - Market Share without additional spending: anywhere from 12% to 17%, with 15% most likely - Market Share Increase per \$1M Budget: anything from 1\% and 3\% is equally likely For example, suppose ActiveWear spends $2M on marketing, their market share without any spending would be 13%, and each $1M of marketing budget added 2.5% market share. Then their new market share would be 13%+22.5%=18%. However, total sales revenue could not exceed $140M, due to limits on raw materials and production capacity. The sales revenue if there was no capacity limitation, or potential sales revenue is x Hint: use Excel's function to make sure sales revenue isn't greater than $140M. Within this sales limit, ActiveWear can adjust their production level so that they only produce as much clothing as they can sell, so there will be no remaining unsold inventory at the end of the year. The margin per unit sold is 40%. This is how much of each dollar of revenue remains for profit after all expenses for production and distribution. This does not include the marketing spending. You will build a Monte Carlo simulation model in Excel to find the optimal marketing budget and understand the risk at different spending levels. Senior management is also interested in the likelihood of beating last year's record profit of $52M