Answer:
Storm Tools
STORM TOOLS
1. Sales Budget
For the Three Months January to March
January February March
Expected Cash Collections
From Sales $1,400,000 $2,275,000 $2,500,000
STORM TOOLS
2. Production Budget
For the Three Months January to March
January February March
Production Schedule 25,000 27,500 30,000
Cost of direct materials $1,000,000 $1,100,000 $1,200,000
STORM TOOLS
4. Direct Materials Budget
For the Three Months January to March
January February March
Expected Cash Payments
for Materials Purchases $1,025,000 $1,125,000
STORM TOOLS
5. Direct Labor Budget
For the Three Months January to March
January February March
Direct labor costs $200,000 $220,000 $240,000
STORM TOOLS
6. Factory Overhead Budget
For the Three Months January to March
January February March
Variable overhead $75,000 $82,500 $90,000 $97,500
Fixed overhead 25,000 25,000 25,000 25,000
Total overhead $100,000 $107,500 $115,000 $122,500
Depreciation cost 15,000 15,000 15,000 15,000
Cash payment for o/h $85,000 $92,500 $100,000 $107,500
STORM TOOLS
7. Ending Finished Goods Inventory
31-Mar
Units Per Unit Cost Per Unit Total
January 5,000 $51.91 $259,550
February 7,500 $51.91 $389,325
March 12,500 $51.91 $648,875
STORM TOOLS
Selling, General, and Administrative Budget
For the Three Months January to March
January February March
Fixed overhead:
Salaries $100,000 $100,000 $100,000
Office expenses 40,000 40,000 40,000
Advertising 75,000 75,000 75,000
Fixed overhead $215,000 $215,000 $215,00
Variable overhead 210,000 341,250 375,000
Selling, General, and Admin. $425,000 $556,250 $590,000
STORM TOOLS
Cash Budget
For the Three Months January to March
January February March
Beginning cash balance $500,000 $1,135,000 $1,461,500
Plus: Customer receipts 1,400,000 2,275,000 2,500,000
Available cash $1,900,000 $3,410,000 $3,961,500
Less disbursements:
Direct materials $0 $1,025,000 $1,125,000
Direct labor 200,000 220,000 240,000
Factory overhead 85,000 92,500 100,000
SG&A 425,000 556,250 590,000
Total disbursements $710,000 $1,893,750 $2,055,000
Cash surplus/(deficit) $1,190,000 $1,516,250 $1,906,500
Financing:
Planned repayment $50,000 $50,000 $50,000
Interest on note
(1/2% of unpaid balance) 5,000 4,750 4,500
Ending cash balance $1,135,000 $1,461,500 $1,852,000
Explanation:
a) Data and Calculations:
Initial Balance Sheet on January 1:
Cash $500,000
Plant and equipment $2,500,000
Total assets $3,000,000
Notes payable $1,000,000
Residual equity $2,000,000
Total liabilities and equity $3,000,000
Repayment of note:
Note payment $50,000 per month
Accrued interest 250
Total repayment $50,250 per month
January February March April
Production Schedule 25,000 27,500 30,000 32,500
Cost of direct materials $1,000,000 $1,100,000 $1,200,000 $1,300,000
Ending raw materials 6,875 7,500 8,125
Production Schedule 25,000 27,500 30,000 32,500
Beginning raw materials 6,250 6,875 7,500 8,125
Purchase of materials 25,625 28,125 30,625
Cost price = $40 per drill
Payment for materials $1,025,000 $1,125,000 $1,225,000
Beginning Finished goods 5,000 7,500 12,500
Production 25,000 27,500 30,000 32,500
Ending Finished goods 5,000 7,500 12,500 15,000
Sales 20,000 25,000 25,000 30,000
Selling price = $100 per drill
Credit sales: $1,000,000 $1,250,000 $1,250,000 $1,500,000
40% month of sale 400,000 625,000 625,000 750,000
60% following month 400,000 625,000 625,000
Cash sales 1,000,000 1,250,000 1,250,000 1,500,000
Total sales collection $1,400,000 $2,275,000 $2,500,000 $2,875,000
Direct labor per drill = 20 minutes
Labor rates = $24 per hour
Variable overhead = $9 per direct labor hour
Production Schedule 25,000 27,500 30,000 32,500
Total labor hours 8,333 9,167 10,000 10,833
Direct labor costs $200,000 $220,000 $240,000 $260,000
Variable overhead $75,000 $82,500 $90,000 $97,500
Fixed overhead 25,000 25,000 25,000 25,000
Total overhead $100,000 $107,500 $115,000 $122,500
Depreciation cost 15,000 15,000 15,000 15,000
Cash payment for o/h $85,000 $92,500 $100,000 $107,500
Selling, general, and administrative costs:
Fixed overhead $215,000 $215,000 $215,000 $215,000
Variable overhead 210,000 341,250 375,000 431,250
Total selling, etc $425,000 $556,250 $590,000 $628,250
Cost of production:
Cost of direct materials $1,000,000 $1,100,000 $1,200,000 $1,300,000
Direct labor costs $200,000 $220,000 $240,000 $260,000
Overhead applied 97,746 107,529 117,300 127,071
Total costs of prodn. $1,297,746 $1,427,529 $1,557,300 $1,687,071
Production Schedule 25,000 27,500 30,000 32,500
Cost per unit $51.91 $51.91 $51.91 $51.91