Shady Shades sells sunglasses for $40 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consists of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce, and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Beginning inventory Finished goods Direct materials: plastic Direct materials: dye Jan. Feb. Mar. 3,500 3,800 4,500 4,100 4,500 4,600 10,100 11,300 12,200 Instructions 1. Use Microsoft Excel to prepare the following budgets: direct materials budget for silicon and solution, sales budget, direct labor budget, and a production budget. 2. 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) 3. Use formulas in the Excel sheets. Remember that Microsoft Excel is a calculator so therefore, precalculated 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. 4. When completing the budgets, make sure that the Excel spreadsheet looks professional. This means be mindful of headings, labels, spelling, and fonts. Here are some other general tips: o Use 12 fonts and make sure to use spacing between accounts, rows, or columns, when necessary. o Perform a print preview before final submission. I may print your work, therefore, be mindful of awkward cut-offs. Resolve this by doing a print preview and adjusting the page. Extra Credit (Out

Shady Shades sells sunglasses for $40 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.7 oz of dye costing $2.80 per ounce, and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Instructions 1. Use Microsoft Excel to prepare the following budgets; direct materials budget for silicon and solution, sales budget, direct labor budget, and a production budget. 2. 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) 3. Use formulas in the Excel sheets. Remember that Microsoft Excel is a calculator so therefore, precalculated 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. 4. When completing the budgets, make sure that the Excel spreadsheet looks professional. This means be mindful of headings, labels, spelling, 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 mindful of awkward cut-offs. Resolve this by doing a print preview and adjusting the page