Questions
Operating Budget Create an operating budget for the first quarter of a new business. Projected Sales...

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: $110,500

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. (Use the Finished Goods Ending Inventory amount for the previous year for the Beginning Finished Goods Inventory to start this year).

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:

Supplies ($.02 per unit)

Inspection ($.10 per unit)

Maintenance and Repair ($.03 per unit)

Utilities ($.01 per unit)

Fixed Overhead Expenses are $1100 monthly.

Create a Selling and Administrative Budget

Variable Selling & Administrative Expenses are:

Sales Commissions ($.03 per unit)

Delivery ($.01 per unit)

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.

**********TEMPLATE FOR ASSIGNMENT IS BELOW, COPIED FROM EXCEL***********************

DMATERIALS
Month #1 Month #2 Month #3 Month #4
Sales
Projected Quantity
Beginning FG Inventory
Desired FG Inventory
Items Produced
Material Quantity Needed
Material Cost
DLABOR
Month #1 Month #2 Month #3 Month #4
Sales
Projected Quantity
Beginning FG Inventory
Desired FG Inventory
Items Produced
Direct Labor
OVERHEAD
Month #1 Month #2 Month #3 Month #4
Sales
Projected Quantity
Beginning FG Inventory
Desired FG Inventory
Items Produced
Variable Manufacturing Overhead
    Supplies
   Inspection
   Maintenance & Repair
   Utilities
Fixed Overhead
S&A
Month #1 Month #2 Month #3 Month #4
Sales
Projected Quantity
Beginning FG Inventory
Desired FG Inventory
Items Produced
Variable S&A
   Commission
    Delivery
   Office Supplies
Fixed S&A
BUDGETED INCOME STATEMENT
Month #1 Month #2 Month #3 Month #4 First Quarter
Sales
Projected Quantity
Beginning FG Inventory
Desired FG Inventory
Items Produced
Material Cost
Direct Labor Cost
Gross Margin
Manufacturing Overhead
    Supplies
   Inspection
   Maintenance & Repair
   Utilities
   Fixed Overhead
S&A
   Commission
    Delivery
   Office Supplies
   Fixed S&A
   
Net Income

In: Accounting

How many electrons in an atom could have these sets of quantum numbers? n=3

How many electrons in an atom could have these sets of quantum numbers?

(a) n=3

(b) n=4, l=2

(c) n=7, l=3, ml=-1

 

In: Chemistry

Without using google or encyclopedia, in your own words write a definition for each: 1. Finance...

Without using google or encyclopedia, in your own words write a definition for each:

1. Finance

2. Bonds

3. Financial Assets

4. Financial Instruments

5. Securitized assets

In: Finance

What is the present value and future value of the following cash flow stream at a...

What is the present value and future value of the following cash flow stream at a rate of 8.00%? Years: 0 1 2 3 4 CFs: $0 $75 $225 $0 $500

In: Finance

As a source of financing, once retained earnings have been exhausted, the weighted average cost of...

As a source of financing, once retained earnings have been exhausted, the weighted average cost of capital will

1.

decrease.

2.

change in an undetermined direction.

3.

increase.

4.

remain the same.

In: Finance

provide one examle for the following (Foundation of Risk Management and Insurance) 1)Large Deductible Plan 2)Captive...

provide one examle for the following (Foundation of Risk Management and Insurance)

1)Large Deductible Plan

2)Captive Insurers

3)Retrospective Rating Plan

4)Securitization

5)Hedging

In: Operations Management

Which of the following is NOT a task? 1) Calculate settlement amount 2) Determine if customer...

Which of the following is NOT a task?

1) Calculate settlement amount

2) Determine if customer is liable for damage

3) Insurance policy does not cover the damage

4) Check insurance policy details

In: Operations Management

The stem direction of a note starts to point downward when the note is on the...

The stem direction of a note starts to point downward when the note is on the _____ line of the staff? (Hint: the bottommost line is the first line)

1.

second

2.

third

3.

fourth

4.

fifth

In: Advanced Math

ADP is adenosine diphosphate. How many high-energy linkages (or bonds) does ADP contain? How do you...

ADP is adenosine diphosphate. How many high-energy linkages (or bonds) does ADP contain? How do you know?

A. 1    

B. 2     

C. 3     

D. 4

In: Chemistry

Write the definition for each terms at length. 1. The Distribution of a Variable 2. Frequency Tables

Write the definition for each terms at length.
 
1. The Distribution of a Variable
2. Frequency Tables
3. Differences Between Groups or Conditions
4. Correlations Between Quantitative Variables
5. Scatterplots

In: Statistics and Probability