Question
Westeros INC prepared the following sales budget for its sandbox product. Sales Budget January February March April May Budgeted Unit Sales 70,000 65,000 75,000 80,000
Westeros INC prepared the following sales budget for its sandbox product.
Sales Budget | |||||
January | February | March | April | May | |
Budgeted Unit Sales | 70,000 | 65,000 | 75,000 | 80,000 | 70,000 |
Unit price | $ 2.00 | $ 2.00 | $ 2.00 | $ 2.00 | $2.00 |
Budgeted Sales | $140,000 | $ 130,000 | $ 150,000 | $ 160,000 | $140,000 |
Additional data about the company include the following.
The company requires that 25% of the next month's sales be on hand at the end of each month. The company's policy is to begin each month with an inventory of direct materials equal to 30% of that month's direct material requirements. The price of sand is $0.35 per pound Each unit requires 3 pounds of sand. Each unit requires 0.8 hours of direct labor, and the hourly cost of direct labor is $18. The company does not pay overtime. All sales are on account. The company makes collections on sales according to the following schedule:
30% in month of sale
60% in month following sale
10% in second month following sale
- Required.Prepare thebudget report of cash collectionsfor March.
- Required. Prepare the production budget report for March.
- Required. Prepare thedirect materials budget report for March.
- Required. Prepare thedirect labor budget report for March.
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