PLEASE ANSWER THIS IN PROPER ORDER, IN PROPER EXCEL FORMULA AND IN EXCEL SHEET, Please $.$ Accounting $311$ Final Project $-$ Budgeting

Shady Shades sells sunglasses for $$50$ each and is estimating sales of $21,000$ units in January and $19,000$ in February. Each lens consists of $2,00mm$ of plastic costing $$2,50$ per mm$,1\mathrm{.}7$ or of dye costing $$2\mathrm{.}80$ per ounce, and $0\mathrm{.}50$ hours direct labor at a labor rate of $$18$ per unit. Desired inventory 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 silicon and solution, b$)$ sales budget c$)($firect 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 tab by the name of the budget. $($Hint: The tabs can be found at the bottom of the excel 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 wel, 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 sigrs can only be seen by clicking an individual cell.

When completing the budgets, make sure that the Excel spreadhheet looks professional. This means be mindful of headings, labels, speling, and fonts. 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 final submission, I may print your work, therefore, be mindthi of awkward cut$-$offs. Resolve this by doing a print preview and adjusting the page.