Question
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 1 7. Quiz Company developed the following sales forecasts for the first five months of the year. Unit
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 1 7.
Quiz Company developed the following sales forecasts for the first five months of the year.
| Unit sales |
January | 40,000 |
February | 50,000 |
March | 60,000 |
April | 60,000 |
May | 62,000 |
Each unit is expected to sell for a price of $205.
Finished goods inventory on January 1 is projected to be 32,000 units. Quiz Company plans production to have ending inventory equal to 80% of the next months sales.
Each unit requires two materials: Material 1 and Material 2. Information on the materials is as follows.
Direct materials | Per-unit usage | DM cost per lb. |
Material 1 | 10 lbs. | $8 |
Material 2 | 6 | 5 |
Quiz Companys materials inventory policy is to have ending materials on hand to meet 50% of the following months production needs. Inventory on January 1 is expected to satisfy this policy.
Each unit requires 3 hours of direct labor. Direct labor cost is $14.25 per hour.
Prepare a sales budget, production budget, direct materials purchases budget, and direct labor budget for the first quarter.
1. Determine total sales revenue for the first quarter.
Note: Give your answer using dollar signs and commas but no decimal points (cents).
2. Determine the number of units to be produced in February.
Note: Give your answer using commas, but do not include the word units.
Example: 12,345
3. Determine the ending finished goods inventory for the quarter.
Note: Give your answer using commas, but do not include the word units.
Example: 12,345
4.Determine the beginning raw materials inventory for Material 1 for the quarter (in lbs.).
Note: Give your answer using commas, but do not include the word lbs.
Example: 12,345
5. Determine total direct materials cost for March.
Note: Give your answer using dollar signs and commas but no decimal points (cents).
Example: $12,345
6. Determine total direct labor cost for January.
Note: Give your answer using dollar signs and commas but no decimal points (cents).
Example: $12,345
7. Determine total direct labor cost for the quarter.
Note: Give your answer using dollar signs and commas but no decimal points (cents).
Example: $12,345
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