Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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.7oz 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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen, Suresh Kalagnanam, Ganesh Vaidyanathan

2nd Canadian Edition

0070964777, 9780070964778

More Books

Students also viewed these Accounting questions

Question

Evaluate the following integrals. cot 4 x dx

Answered: 1 week ago

Question

Know how to prepare for an interview prior to an applicants arrival

Answered: 1 week ago