We read your photo as:

A. Prepare a flexible budget at the activity levels of 800, 1,200 and 1,500 units respectfully. B. From above information, calculate the quantity the company should produced in 2026 to breakeven. Calculate the value at that quantity.

Accounting

ScanSolve AI Answer

Step-by-step solution

4 steps

Okay, Able, let's prepare that flexible budget and analyze the break-even point.

Part a· 2 steps

Prepare a flexible budget at the activity levels of 800, 1200, and 1500 units.

First, let's recall the per-unit and fixed cost components for 2026 from our previous calculations:

  • Budgeted Selling Price per unit: ₦572
  • Budgeted Variable Cost per unit: ₦605
  • Fixed Costs (Depreciation + Maintenance + Insurance): ₦60,000 + ₦100,000 + ₦40,000 = ₦200,000
  • Supervisors Fee: ₦120,000 for Q≤1000Q \le 1000 units, and ₦132,000 for Q>1000Q > 1000 units.
  1. Calculate Total Fixed Costs for each activity level.

    • For 800 units (since 800≤1000800 \le 1000): Total Fixed Costs=₦200,000+₦120,000=₦320,000\text{Total Fixed Costs} = \text{₦}200,000 + \text{₦}120,000 = \text{₦}320,000
    • For 1200 units (since 1200>10001200 > 1000): Total Fixed Costs=₦200,000+₦132,000=₦332,000\text{Total Fixed Costs} = \text{₦}200,000 + \text{₦}132,000 = \text{₦}332,000
    • For 1500 units (since 1500>10001500 > 1000): Total Fixed Costs=₦200,000+₦132,000=₦332,000\text{Total Fixed Costs} = \text{₦}200,000 + \text{₦}132,000 = \text{₦}332,000
  2. Prepare the Flexible Budget.

    Item800 Units (₦)1200 Units (₦)1500 Units (₦)
    Sales Revenue (₦572/unit)457,600686,400858,000
    Less: Variable Costs (₦605/unit)484,000726,000907,500
    Contribution Margin(26,400)(39,600)(49,500)
    Less: Fixed Costs
    Depreciation60,00060,00060,000
    Maintenance100,000100,000100,000
    Insurance40,00040,00040,000
    Supervisors Fee120,000132,000132,000
    Total Fixed Costs320,000332,000332,000
    Net Income (Loss)(346,400)(371,600)(381,500)

Part b· 2 steps

Calculate the Quantity the company should produce in 2026 to break even. Calculate the target profit at that quantity.

  1. Calculate the Contribution Margin per unit.

    Contribution Margin per unit=Selling Price per unit−Variable Cost per unit\text{Contribution Margin per unit} = \text{Selling Price per unit} - \text{Variable Cost per unit} Contribution Margin per unit=₦572−₦605=-₦33\text{Contribution Margin per unit} = \text{₦}572 - \text{₦}605 = \text{-₦}33
  2. Determine the Break-even Quantity.

    The contribution margin per unit is negative (₦-33). This means that for every unit sold, the company loses ₦33 even before covering any fixed costs.
    Since the company incurs a loss on each unit sold, it is impossible to break even under the current cost and pricing structure, as long as fixed costs are positive. Selling more units would only increase the total loss.

    Therefore, the break-even quantity is not achievable. The target profit at this non-existent break-even quantity would also be impossible to calculate, as the company will always operate at a loss.

Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp