Question

Operating Budget
Create an operating budget for the first quarter of a new business.
Projected Sales are:
Month #1: $65,000
Month #2: $97,500
Month #3: $130,000
Month #4: $100,019
These sales are based on selling one product with a selling price of $6.50
Create a Production Budget based on Units (not dollars).
• Desired Finished Goods Ending Inventory each month is 10% of the next month’s projected sales
Create a Direct Materials Purchase Budget
• Each unit produced requires 10# of direct materials at a cost of $0.08 per pound.
• Desired Ending Direct Materials Inventory is 10% of the next month’s material requirements.
Create a Direct Labor Budget
• Direct Labor Costs are $15/hour
• Each unit requires 5 minutes of labor
Create an Overhead Budget
• Variable Overhead Expenses are:
o Supplies ($.02 per unit)
o Inspection ($.10 per unit)
o Maintenance and Repair ($.03 per unit)
o Utilities ($.01 per unit)
• Fixed Overhead Expenses are $1100 monthly.
Create a Selling and Administrative Budget
• Variable Selling & Administrative Expenses are:
o Sales Commissions ($.03 per unit)
o Delivery ($.01 per unit)
o Office Support ($.02 per unit)
• Fixed Selling & Administrative Expenses are $2500 monthly.

Combine all Budgets to Create a Budgeted Income Statement
Complete a Budgeted Income Statement for months 1 through 3, and a Budgeted Income Statement that reflects the total first quarter.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Operating Budget

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Accounting Questions
Homework Solution
$38.00
Business
Accounting
Fund
Supplies
New Yankee
Tax
Receivable
Nassau
Balance
Accounting Questions
Homework Solution
$20.00
Finance
Business
Accounting
Costs
Economy
Balance
Shares
Insurance
Capital
Straight-Line Method
Amortization
Interest
Bond Liability
Expenses
Cash Flow
Market Conditions
Business Questions
Homework Solution
$70.00
Business
Financial Analyst
MBA
Economy
Accounting
Management
General Motors
Interest
Bonds
Dividends
Stocks
Risk Premiums
Required Returns
US Government
Cash Flow
Pension Fund
Debt
Investments
Portfolio's Beta
Standard Deviation
Financial Analysis of Apple Inc (11 slides)
Homework Solution
$50.00
Finance
Business
Presentation
Administration
Management
Companies
Stakeholders
Horizontal Analysis
Vertical Analysis
Balance Sheet
Income Statements
Liquidity Ratios
Current Ratios
Profit
Assets
Calculations
Preparing A Balance Sheet
Homework Solution
$18.00
Finance
Accounting
Economy
Administration
Balance Sheet
Debt
Goods
Sales Revenue
Taxes
Expenses
Cash
Equipment
Stock
Prepaid Expenses
Doubtful Accounts
Allowance
Get help from a qualified tutor
Live Chats