Question
Bee Company provided the following information to prepare budgets for January, February, and March 2021, including the total for the quarter. Sales were 40,000 units
Bee Company provided the following information to prepare budgets for January, February, and March 2021, including the total for the quarter. Sales were 40,000 units in December 2020. Forecasted sales in units are: January, 50,000; February, 60,000; March, 70,000; April, 80,000. The selling price is $50 per unit. Ending finished goods inventory must equal 20% of the next months expected unit sales. The December 31 finished goods inventory is 5,000 units, which does not comply with this requirement. Ending direct materials inventory must equal 10% of the next months direct materials requirements. The December 31 direct materials inventory was 1,000 units, which does not comply with this policy. The budgeted March 31 direct materials inventory is 15,000 units. Each unit of finished goods inventory requires 2 units of direct materials. Direct materials cost is $22 per unit. Each unit of finished goods inventory requires 15 minutes (1/4 hour) of direct labor at a rate of $25 per hour. Factory overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $3.50 per direct labor hour. Depreciation is $50,000 per month and is considered fixed factory overhead. Sales commissions are 15% of sales and are paid in the month of sale. The sales managers salary is $7,000 each month. Monthly general and administrative expenses include $5,000 of administrative salaries. It also includes $400 of interest payable on a long-term note. Prepare the following budgets for Bee Company:
1) Sales budget 2) Production budget 3) Direct materials budget 4) Direct labor budget 5) Factory overhead budget 6) Selling expense budget 7) General 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