Dean's Office Official Model Question Paper

Master Budget

A master budget is a comprehensive financial plan summarizing the operating and financial goals of an entire organization for an upcoming accounting period.

Two Primary Components:

1. Operating Budget: (Sales, Production, Materials, Labor, Overhead, and Selling/Admin Budgets).
2. Financial Budget: (Cash Budget, Budgeted Balance Sheet, and Capital Expenditure Budget).

Zero-Base Budgeting (ZBB)

ZBB is a budgeting approach where every single expense must be justified from a “zero base” for each new period, rather than starting with the previous year’s budget and adding an incremental percentage. It eliminates organizational slack by requiring managers to defend every program from scratch.

Standard Costing & Variance Analysis

• Standard Costing: A managerial control technique that establishes predetermined benchmark costs for direct materials, labor, and overhead per unit of output.
• Variance Analysis: The mathematical calculation and evaluation of differences between actual costs incurred and standard/budgeted costs, isolating performance as Favorable (F) or Unfavorable (U).

Flexible Budget

A flexible budget dynamically calculates budgeted revenues and costs for the actual level of output achieved by adjusting variable expenses proportionally, whereas a static budget remains fixed to one planned output level. It provides meaningful variance comparisons by neutralizing volume distortions.

Qualitative Forecasting Methods

1. Delphi Method: A structured, iterative forecasting technique gathering anonymous opinions from an expert panel across multiple rounds of questionnaires.
2. Sales Force Composite: Aggregating bottom-up sales estimates provided by frontline sales representatives and territory managers.

Production Budget and Direct Material Purchase Budget

1. Production Budget (Units)

• Formula: $\text{Required Production} = \text{Budgeted Sales} + \text{Desired Ending Inventory} - \text{Beginning Inventory}$

Calculations:

• Desired Ending Inventory:
  • Month 1: $20\% \times 12,000 = 2,400$ units
  • Month 2: $20\% \times 15,000 = 3,000$ units
  • Month 3: $20\% \times 14,000 = 2,800$ units

Note for Month 4 Production (to compute Month 3 Ending Material Inventory):

• Month 4 Sales = 14,000; assume Month 5 Sales = 14,000 units.
• Month 4 Desired Ending Inventory = $20\% \times 14,000 = 2,800$ units.
• Month 4 Production = $14,000 + 2,800 - 2,800 = 14,000$ units.
• Month 4 Material Requirement = $14,000 \times 2\text{ kg} = 28,000\text{ kg}$.

---

2. Direct Material Purchase Budget

• Material requirement: 2 kg per unit produced.
• Material price: Rs. 50 per kg.
• Desired Ending Raw Material Inventory = 10% of next month’s material requirements.

Calculations:

• Production Needs:
  • Month 1: $10,400 \times 2 = 20,800$ kg
  • Month 2: $12,600 \times 2 = 25,200$ kg
  • Month 3: $14,800 \times 2 = 29,600$ kg
  • Month 4: $14,000 \times 2 = 28,000$ kg
• Desired Ending Raw Material Inventory:
  • Month 1: $10\% \times 25,200 = 2,520$ kg
  • Month 2: $10\% \times 29,600 = 2,960$ kg
  • Month 3: $10\% \times 28,000 = 2,800$ kg

Three-Month Cash Budget (Baisakh, Jestha, Ashadh)

1. Collections from Sales Schedule

• Cash Sales = $20\%$ of total sales.
• Credit Sales = $80\%$ of total sales.
  • Chaitra Credit Sales = $80\% \times 500,000 = 400,000$
  • Baisakh Credit Sales = $80\% \times 600,000 = 480,000$
  • Jestha Credit Sales = $80\% \times 700,000 = 560,000$
  • Ashadh Credit Sales = $80\% \times 800,000 = 640,000$
• Collection terms: 60% in month of sale, 38% in following month.

Monthly Inflows:

• Baisakh:

  • Cash Sales: $20\% \times 600,000 = \text{Rs. } 120,000$
  • Current Credit Collection: $60\% \times 480,000 = \text{Rs. } 288,000$
  • Prior Month (Chaitra) Collection: $38\% \times 400,000 = \text{Rs. } 152,000$
  • Total Baisakh Inflow = Rs. 560,000

• Jestha:

  • Cash Sales: $20\% \times 700,000 = \text{Rs. } 140,000$
  • Current Credit Collection: $60\% \times 560,000 = \text{Rs. } 336,000$
  • Prior Month (Baisakh) Collection: $38\% \times 480,000 = \text{Rs. } 182,400$
  • Total Jestha Inflow = Rs. 658,400

• Ashadh:

  • Cash Sales: $20\% \times 800,000 = \text{Rs. } 160,000$
  • Current Credit Collection: $60\% \times 640,000 = \text{Rs. } 384,000$
  • Prior Month (Jestha) Collection: $38\% \times 560,000 = \text{Rs. } 212,800$
  • Total Ashadh Inflow = Rs. 756,800

---

2. Cash Budget Statement

Conclusion: The cash position is healthy in all three months with no overdraft financing needed.

Activity-Based Budgeting (ABB) vs. Traditional Budgeting

Activity-Based Budgeting (ABB) is a modern budgeting philosophy that focuses on the cost of performing activities required to produce and deliver goods and services, reversing the traditional budgeting sequence.

1. Comparison Matrix

2. The Four Stages of Implementing ABB

Forecast Demand -> Determine Required Activities -> Calculate Resource Needs -> Budget Financial Costs

1. Forecast Demand for Final Products and Services: Determine expected unit volumes, customer orders, and service requests for the budgeting horizon.
2. Determine Required Activities: Map out the operational activities needed (e.g., number of machine setups, customer service inquiries, material dispatches).
3. Identify Cost Drivers and Establish Activity Driver Rates:
   $$\text{Activity Rate} = \frac{\text{Budgeted Cost Pool}}{\text{Practical Capacity of Driver}}$$
4. Calculate Resource Demands and Eliminate Unused Capacity: Match required activity hours against current staffing and machine capacities. Non-value-adding activities (e.g., redundant approvals, excess material handling) are systematically eliminated, and surplus resources are reallocated.

Financial Forecasting: Percentage of Sales Method and AFN

1. The Percentage of Sales Method

The Percentage of Sales Method is a financial forecasting approach based on the premise that balance sheet accounts (cash, inventory, accounts receivable, accounts payable) maintain a stable economic relationship with sales volume under constant operational efficiency.

2. Additional Funds Needed (AFN) Equation

$$\text{AFN} = \left(\frac{A^*}{S_0}\right) \Delta S - \left(\frac{L^*}{S_0}\right) \Delta S - \left(M \times S_1 \times (1 - d)\right)$$

Where:

• $S_0 = \text{Current Sales} = \text{Rs. } 100\text{ million}$
• $g = \text{Growth Rate} = 25\%$
• $\Delta S = \text{Change in Sales} = 100 \times 0.25 = \text{Rs. } 25\text{ million}$
• $S_1 = \text{Projected Next Year Sales} = 100 \times 1.25 = \text{Rs. } 125\text{ million}$
• $A^* = \text{Spontaneous Assets} = \text{Rs. } 80\text{ million}$
• $\frac{A^*}{S_0} = \text{Capital Intensity Ratio} = \frac{80}{100} = 0.80$
• $L^* = \text{Spontaneous Liabilities} = \text{Rs. } 20\text{ million}$ (accounts payable and accruals)
• $\frac{L^*}{S_0} = \frac{20}{100} = 0.20$
• $M = \text{Net Profit Margin} = 8\% = 0.08$
• $d = \text{Dividend Payout Ratio} = 40\% = 0.40$
• $RR = \text{Retention Ratio} = 1 - d = 1 - 0.40 = 0.60$ (60%)

3. Step-by-Step Calculation

1. Required Increase in Assets:
   $$\Delta A = 0.80 \times 25\text{ million} = \text{Rs. } 20.0\text{ million}$$
2. Spontaneous Increase in Liabilities:
   $$\Delta L = 0.20 \times 25\text{ million} = \text{Rs. } 5.0\text{ million}$$
3. Projected Retained Earnings:
   $$\text{Add. to Retained Earnings} = M \times S_1 \times (1 - d) = 0.08 \times 125 \times 0.60 = \text{Rs. } 6.0\text{ million}$$
4. Additional Funds Needed (AFN):
   $$\text{AFN} = 20.0\text{ million} - 5.0\text{ million} - 6.0\text{ million} = \mathbf{\text{Rs. } 9.0\text{ million}}$$

Managerial Interpretation: To support the 25% sales expansion, the firm requires an additional Rs. 9 million in external financing (e.g., new bank borrowings, commercial paper, or fresh equity issue).

Comprehensive Problem Solution: Standard Costing and Variance Analysis

(a) Direct Material Variances (5 Marks)

• Standard Quantity ($SQ$) allowed for actual production of 2,200 units:
  $$SQ = 2,200 \times 4\text{ kg} = 8,800\text{ kg}$$
• Actual Quantity ($AQ$) consumed: $9,200\text{ kg}$
• Standard Price ($SP$): $\text{Rs. } 100\text{ per kg}$
• Actual Price ($AP$): $\text{Rs. } 95\text{ per kg}$

1. Material Price Variance (MPV):
   $$MPV = AQ \times (SP - AP) = 9,200 \times (100 - 95) = \mathbf{Rs.\ 46,000\ (Favorable)}$$
2. Material Usage Variance (MUV):
   $$MUV = SP \times (SQ - AQ) = 100 \times (8,800 - 9,200) = 100 \times (-400) = \mathbf{Rs.\ 40,000\ (Unfavorable)}$$

• Total Material Cost Variance: $MPV + MUV = 46,000(F) - 40,000(U) = \mathbf{Rs.\ 6,000\ (F)}$

---

(b) Direct Labor Variances (5 Marks)

• Standard Hours ($SH$) allowed for actual production of 2,200 units:
  $$SH = 2,200 \times 2\text{ hours} = 4,400\text{ hours}$$
• Actual Hours ($AH$): $4,600\text{ hours}$
• Standard Labor Rate ($SR$): $\text{Rs. } 150\text{ per hour}$
• Actual Labor Rate ($AR$): $\text{Rs. } 160\text{ per hour}$

1. Labor Rate Variance (LRV):
   $$LRV = AH \times (SR - AR) = 4,600 \times (150 - 160) = 4,600 \times (-10) = \mathbf{Rs.\ 46,000\ (Unfavorable)}$$
2. Labor Efficiency Variance (LEV):
   $$LEV = SR \times (SH - AH) = 150 \times (4,400 - 4,600) = 150 \times (-200) = \mathbf{Rs.\ 30,000\ (Unfavorable)}$$

• Total Labor Cost Variance: $LRV + LEV = 46,000(U) + 30,000(U) = \mathbf{Rs.\ 76,000\ (Unfavorable)}$

---

(c) Overhead Variances (5 Marks)

1. Variable Overhead (VOH) Variances:

• Standard VOH Rate ($SVR$) = $\text{Rs. } 50\text{ per hour}$
• Actual Hours ($AH$) = $4,600\text{ hours}$
• Standard Hours ($SH$) = $4,400\text{ hours}$
• Actual VOH = $\text{Rs. } 225,000$
• VOH Spending Variance: $(AH \times SVR) - \text{Actual VOH} = (4,600 \times 50) - 225,000 = 230,000 - 225,000 = \mathbf{Rs.\ 5,000\ (F)}$
• VOH Efficiency Variance: $(SH - AH) \times SVR = (4,400 - 4,600) \times 50 = \mathbf{Rs.\ 10,000\ (U)}$

2. Fixed Overhead (FOH) Variances:

• Budgeted FOH = $\text{Rs. } 200,000$
• Actual FOH = $\text{Rs. } 210,000$
• Standard FOH Rate ($SFR$) = $\text{Rs. } 50\text{ per hour}$ or $\text{Rs. } 100\text{ per unit}$
• Applied FOH = $2,200 \times 100 = \text{Rs. } 220,000$
• FOH Budget (Spending) Variance: $\text{Budgeted FOH} - \text{Actual FOH} = 200,000 - 210,000 = \mathbf{Rs.\ 10,000\ (U)}$
• FOH Volume Variance: $\text{Applied FOH} - \text{Budgeted FOH} = 220,000 - 200,000 = \mathbf{Rs.\ 20,000\ (F)}$

3. Sales Variances:

• Standard Price = Rs. 1,200; Actual Price = Rs. 1,180; Actual Units = 2,200
• Sales Price Variance: $2,200 \times (1,180 - 1,200) = \mathbf{Rs.\ 44,000\ (U)}$
• Sales Volume Profit Variance: $(2,200 - 2,000) \times \text{Standard Profit (Rs. 300)} = \mathbf{Rs.\ 60,000\ (F)}$

---

(d) Profit Reconciliation Statement and Managerial Recommendations (5 Marks)

Actual Profit Calculation:

• Actual Revenue: $2,200 \times 1,180 = \text{Rs. } 2,596,000$
• Actual Costs: Material ($9,200 \times 95 = 874,000$) + Labor ($4,600 \times 160 = 736,000$) + VOH ($225,000$) + FOH ($210,000$) = $\text{Rs. } 2,045,000$
• Actual Profit = Rs. 551,000

Budgeted Profit: $2,000\text{ units} \times \text{Rs. } 300 = \text{Rs. } 600,000$

Managerial Recommendations:

1. Investigate Material Substitution: The favorable price variance (Rs. 46,000 F) was accompanied by an unfavorable usage variance (Rs. 40,000 U), suggesting the procurement department purchased cheaper, lower-quality materials that led to excessive scrap.
2. Control Labor Rates & Overtime: The wage rate was higher than standard (Rs. 160 vs. Rs. 150), and labor was inefficient (4,600 hrs vs. 4,400 hrs), pointing to unscheduled overtime.