PLEASE ANSWER THESE ALL IN PROPER EXCEL SHEET PLEASE AND WITH FORMULA AND PROPER WAY ORDER. Shady Shades sells sunglasses for $$50$ each and is estimating sales of $21,000$ units in lanuary and $19,000$ in February. Each lens consists of $2,00mm$ of plastic costing $$2,50$ per mm$.1\mathrm{.}7$ oz of dre costing $$2\mathrm{.}80$ per ounce, and $0\mathrm{.}50$ hours direct labor at a labor rate of $$18$ per unit. Desired imentory levels are:

$\backslash$table$[[,$Jan.,Feb.,Mar.$],[$Beginning inventory,,,$],[$Finished goods,$3,500,3,800,4,500],[$Direct materials: plastic,$4,100,4,500,4,600],[$Direct materials: dye,$10,100,11,300,12,200]]$

Instructions

Use Microsoft Excel to prepare the following budgets: a$)$ direct materials budget for slicon and solution, b$.)$ sales budget, c$)$ direct labor budget, and d$.)$ a production budget.

You must complete the budgets in the proper order. The order of completion will be determined by the labeling in Microsoft Excel. To be specific, use a worksheet and label each tal by the name of the budget. $($Hint: The tabs can be found at the bottom of the extel spreadsheet$)$

Use formulas in the Excel sheets. Remember that Microsoft Excel is a calculator so therefore, precaloulated answers which are then copied over to excel are not acceptable. As well, this is your way of showing me your work by inputting formulas into the cells. Hint: When you put formulas in the cell, the mathematical signs can only be seen by clicking an individual cell,

When completing the budgets, make sure that the Excel spreadsheet looks professional. This means be mindhul of headings, labels, speling, and forts. Here are some other general tips:

Use $12$ fonts and make sure to use spacing between accounts, rows, or columns, when necessary.

Perform a print preview before froll submission. I may print your work, therefore, be mindlul of awkward cut$-$offs. Resolve this by doing a print preview and adjusting the page.