Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lens Junction sells lenses for $47 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2

image text in transcribed
Lens Junction sells lenses for $47 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.40 per pound, 3 oz of solution costing $2 per ounce, and 30 minutes of direct labor at a labor rate of $19 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory \begin{tabular}{|l|r|r|r|} \hline Finished goods & 4,000 & 4,800 & 5,100 \\ \hline Direct materials: silicon & 8,000 & 9,000 & 9,100 \\ \hline Direct materials: solution & 11,000 & 11,900 & 12,900 \\ \hline \end{tabular} Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget for the months of January and February. Show any calculations using Excel formulas (there are point deductions for not using Excel functions, and if you use Excel functions the assignment is much easier because budgets generally have programmatic elements that reflect mathemetical assumptions). Hint: the order of the listed budgets is intentional, budgets logically build off one another

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions