Question
Lewis Company makes and sells high-quality glare filters for microcomputer monitors. John Crave, controller, is responsible for preparing Lewiss master budget and has assembled the
Lewis Company makes and sells high-quality glare filters for microcomputer monitors. John Crave, controller, is responsible for preparing Lewiss master budget and has assembled the following data for 2019.
| January | February | March | April |
Estimated unit sales | 20,000 | 24,000 | 16,000 | 18,000 |
Sales price per unit | 80 | 80 | 75 | 75 |
Direct labor hours per unit | 4.0 | 4.0 | 3.5 | 3.5 |
Direct labor hourly rate | 15 | 15 | 16 | 16 |
Direct materials cost per unit | 10 | 10 | 10 | 10 |
The direct labor rate includes wages and all employee-related benefits. Labor saving machinery will be fully operational by March. As of March 1, the companys union contract calls for an increase in direct labor wages that is included in the direct labor rate. Lewis expects to have 10,000 glare filters in inventory at the end of the year, and has a policy of carrying 50% of the following months projected sales in inventory. Prepare the following budgets listed below.
Schedule 1: Sales budget
| January | February | March | Total |
Sales in units |
|
|
|
|
Unit price |
|
|
|
|
Total Sales |
|
|
|
|
Schedule 2: Production budget
| January | February | March | Total |
Sales in units |
|
|
|
|
Plus: Ending inventory |
|
|
|
|
Total Needs |
|
|
|
|
Less: Beginning Inventory |
|
|
|
|
Units to be produced |
|
|
|
|
Schedule 3: Direct materials purchases budget
| January | February | March | Total |
Units to be produced |
|
|
|
|
Cost per unit |
|
|
|
|
Total direct materials |
|
|
|
|
Schedule 4: Direct labor budget (hours)
| January | February | March | Total |
Units to be produced |
|
|
|
|
Direct labor hours per unit |
|
|
|
|
Total direct labor hours |
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started