$1.)$ List each group members name $($first and last$)$ and one sentence or comment on where forecast Budgeting and planning may impact or be part of their future professional job in the Business Community: $(\mathrm{.}15$ points$)1.\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_2.\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_3.\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_2.)$ Writing Assignment and Case Study: You are doing some consulting for a new Candles and Essential Oil manufacturer in Boise Idaho. The company has been in operation for two years and never had a forecasted budget. They have historical knowledge on some sales and costs and some estimates for the future.They have $64$ employees and three departments list below:Manufacturing DepartmentAdministration DepartmentSales$/$Revenue Marketing DepartmentInstructions: Write a formal professional email or letter to the CEO Shelia Mark about how they should design their first $1$ year budget: $(1\mathrm{.}25$ point for clarity, spelling and professionalism$)$ Note: they have two years of historical information to rely on but have never created a budget as they are still a start$-$up company. Questions to consider: what do they do first? who do the involve?write a minimum of two paragraphs on what steps they should do to create the first $1$ year budget? do they do the budget for the whole company or by department? what would you recommend? $3.)$ Think of a simple company that makes $3$ products, example but cant use this is Clothing Company $($Sells T$-$Shirts, Sweaters and Sweatshirts$)$ what are your three products? $($not allowed to do FOOD items$)(\mathrm{.}10))$ Building and Creating Budgets:Now it is time to build out Budgets for your Manufacturing Company that you created inInstructions, Sales Budget and Cash Collections Budget $($you might need separate paper$)$Step $1$: List the Name and Sales price $ of each of the $3(\mathrm{.}25$ point$)$ Step $2$: List the Estimated Forecasted Monthly Sales volume using graph below: $(\mathrm{.}75$ point$)$ Create an excel sheetJanuaryFebruary MarchApril MayJuneJulyAugustSeptember OctoberNovember DecemberProduct $11$Product $2$Product $3$Step $3$: What do you estimate to be the cash collections to be each month from sales? April May June $(\mathrm{.}5)$ FebruaryMarchAprilMayJuneProduct $1$ in Sales Dollars $ Product $2$ in Sales Dollars $ Product $3$ in Sales Dollars $ Total $($for example, $???\%$ cash collect in month of sale and $??\%$ in the second month, $??$X third month make$-$up your own split, and option to allocate $2\%$ or $5\%$ to uncollectible Cash Collection Budget based on total Sales $$ $(\mathrm{.}75$ point$)$ AprilMayJuneTotalFebruary Sales $$ March Sales $$ April Sales $$ May Sales $$ June Sales $$ Total Cash Collections $5.)$ Build out Product Budget $1$ points Step $1$: Use the numbers already created in your Sales Budget for Production BudgetStep $2$: Second, decide how much ending inventory does your Manufacturing Company desire to have on hand at the end of the period? what $\%$ percentage of inventory available at the end of the month based off next months sales should be available for sale? Build the production needed for each product $1,2$ and $3,$ what is your desired ending inventory for each product should be differentProduct $1$AprilMayJuneQuarterBudget unit sales Add: Desired Units ending finished goods Total Needed Less Units of beginning finished goods Required Production in units Product $2$ Production BudgetProduct $2$AprilMayJuneQuarterBudget unit sales Add: Desired Units ending finished goods Total Needed Less Units of beginning finished goods Required Production in units Product $3$ Production BudgetProduct $1$AprilMayJuneQuarterBudget unit sales Add: Desired Units ending finished goods Total Needed Less Units of beginning finished goods Required Production in units $6.)$ Why is depreciation expense considered a non$-$cash impact or referred to as a non$-$cash expense? $(\mathrm{.}25$ point$)$