Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all the formulas needed and work for all parts of the problem? Problem Little Bee Company provided the following information to prepare budgets

Please show all the formulas needed and work for all parts of the problem?

image text in transcribed
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. o Indirect materials - 1 pound per unit, $6 per pound o 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 o Insurance - $1,000 per month o 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 DJ 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Comprehensive Assurance & Systems Tool

Authors: Laura IngrahamJ Jenkins

2nd Edition

0131377213, 9780131377219

More Books

Students also viewed these Accounting questions