BUDGETING
Master Budget Overview (Q1: Jan–Mar)
Sales Budget:
January: 1,500 units × $3.00 = $4,500
February: 1,800 units × $3.00 = $5,400
March: 2,000 units × $3.00 = $6,000
Total Sales: $15,900
Production & Cost Budgets
Production Budget
Matches Sales: 5,300 units
Direct Materials Budget:
Coffee Beans = $0.60/unit
5,300 × $0.60 = $3,180
Direct Labor Budget:
0.1 hr/unit × $5/hr × 5,300 = $2,650
Overhead Budget:
$2,000/month × 3 months = $6,000
Cash Budget Summary
Opening Cash: $1,000
Total Inflows: $15,900
Outflows:
Direct Materials: $3,180
Direct Labor: $2,650
Overhead: $6,000
Other: $1,500
Total Outflows: $13,330
Ending Cash: $3,570
Budgeted Income Statement
Sales Revenue: $15,900
COGS: $9,830
Gross Profit: $6,070
Operating Expenses: $3,000
Net Profit: $3,070