Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem Little Bee Company provided the following information to prepare budgets for April, May and June 2023. - Forecasted sales in units are: April, 44,000;
Problem Little Bee Company provided the following information to prepare budgets for April, May and June 2023. - Forecasted sales in units are: April, 44,000; May, 48,000; June, 52,000; July, 49,000. The selling price is $254 per unit. - The company would like ending finished goods inventory to be 5,000 units each month. The beginning inventory for April is expected to be 4,000 units. - The company would like ending direct materials inventory to be 7,000 pounds each month. The beginning inventory for April is expected to be 6,500 pounds. Each unit of finished goods inventory requires 3 pounds of direct materials. Direct materials cost is $23 per pound. - Each unit of finished goods inventory requires 45 minutes (3/4 hour) of direct labor at a rate of $28 per hour. - Manufacturing overhead includes the following. Variable costs are based on the number of units produced. Indirect materials 1/2 pound per unit, $6 per pound Indirect labor -2 hours per unit, $18 per hour Variable maintenance - $3 per unit Variable utilities - $1 per unit Supervisor salaries $4,000 per month Insurance $1,000 per month Depreciation - $2,700 per month - Sales commissions are $12 per unit sold and are paid in the month of sale. The sales manager's salary is $10,000 each month. - Monthly general and administrative expenses include $9,500 of administrative salaries. It also includes $1,200 of depreciation expense. Prepare the following budgets for Little Bee Company for April, May, and June 2023: 1) Sales budget 2) Production budget 3) Direct materials budget 4) Direct labor budget 5) Manufacturing overhead budget 6) Sales and administrative expense budget
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