INPUT SECTION–BUDGET ASSUMPTIONS
Quarter
First
Second
Third
Fourth
Income Assumptions:
Forecasted housing begins
(native space)
6,000
24,000
7,000
2,000
Common variety of sinks per
home
three.zero
2.9
three.zero
three.1
Market share
35%
35%
35%
35%
Common promoting worth per
unit
$85.00
$85.00
$85.00
$85.00
Manufacturing Price Assumptions:
Variable Manufacturing Prices:
Direct material-Kilos per unit
40
40
40
40
Direct material-Price per pound
$zero.50
$zero.50
$zero.50
$zero.50
Direct labor-Hours per unit
three
three
three
three
Direct labor-Price per hour
$12.00
$12.00
$12.00
$12.00
Desired ending sink stock
as % of subsequent quarter’s gross sales
10%
10%
10%
10%
Desired ending DM stock as
% of subsequent quarter’s DM requirement
10%
10%
10%
10%
Variable
Manufacturing Prices Per Direct Labor Hour:
Oblique labor
$zero.3000
$zero.3000
$zero.3000
$zero.3000
Provides
$zero.2667
$zero.2667
$zero.2667
$zero.2667
Different
$zero.1000
$zero.1000
$zero.1000
$zero.1000
Fastened
Manufacturing Price:
Depreciation
$9,000
$9,000
$9,000
$9,000
Fastened
overhead allocation base: Direct labor
hours
Promoting
and Administration Price Assumptions:
Variable
Prices:
Fee as % of income
10%
10%
10%
10%
Dangerous money owed as % of income
2%
2%
2%
2%
Fastened
Prices:
Salaries
$40,000
$40,000
$40,000
$40,000
Depreciation
$2,400
$2,400
$2,400
$2,400
Different
$eight,300
$7,400
$9,200
$7,300
Money
Stream Assumptions:
Income
Collections:
Throughout quarter offered
66%
66%
66%
66%
Throughout subsequent quarter
32%
32%
32%
32%
Direct
Materials Funds:
Throughout quarter bought
66.6667%
66.6667%
66.6667%
66.6667%
Throughout subsequent quarter
33.3333%
33.3333%
33.3333%
33.3333%
Present 12 months Earnings
Tax–Estimated Funds
$zero
$80,000
$40,000
$40,000
All different prices paid as
incurred
Dividends Declared & Paid
$zero
$zero
$zero
$50,000
Quick-Time period
Financing Assumptions:
Minimal Money Steadiness
$30,000
$30,000
$30,000
$300,000
Annual Curiosity Price for
Borrowing
eight%
eight%
eight%
eight%
Assume
no curiosity earned on money balances
Earnings
Assertion Assumption:
Earnings Tax Price
30%
30%
30%
30%
Prior
12 months Balances Carried Over to Present 12 months:
Belongings:
Money
$45,820
Uncooked supplies stock (price)
$10,000
20,000
Kilos
Completed items stock (Price)
$30,250
600
Sinks
Accounts receivable
$118,000
Allowance for dangerous money owed
$(7,378)
Land, constructing and gear
$912,000
Gathered depreciation
$(114,000)
Liabilities and Fairness:
Accounts payable (purchases)
$72,370
Earnings taxes payable
$7,000
Credit score Line Mortgage Payable
$-
Frequent inventory
$750,000
Retained Earnings
$165,322
Starting
Steadiness Sheet Math Test:
Complete Belongings
$994,692
Complete Liab & Fairness
$994,692