234k views
2 votes
Coyle Manufacturing reports the following information for year 1:

Sales revenue (69,000 units) $ 5,265,000
Manufacturing costs
Materials $ 311,000
Variable cash costs 256,000
Fixed cash costs 599,000
Depreciation (fixed) 1,809,000
Marketing and administrative costs
Marketing (variable, cash) 850,000
Marketing depreciation 278,000
Administrative (fixed, cash) 925,000
Administrative depreciation 143,000
Total costs $ 5,171,000
Operating profits (losses) $ 94,000

All depreciation charges are fixed. Manufacturing depreciation is expected to increase by 10 percent in year 2. Marketing and administrative depreciation are expected to remain the same for year 2. Sales volume is expected to increase by 5 percent, but prices are expected to fall by 10 percent. Materials costs per unit are expected to decrease by 8 percent. Unit variable cash manufacturing costs are expected to increase by 15 percent. Fixed cash costs are expected to increase by 6 percent.
Variable marketing costs will change with unit volume. Administrative cash costs are expected to decrease by 10 percent. Inventories are kept at zero. Coyle Manufacturing operates on a cash basis.

Required:
Prepare a budgeted income statement for year 2 for Coyle Manufacturing.
Note: Do not round intermediate calculations. Round your final answers to the nearest who

User Foxidrive
by
7.9k points

1 Answer

1 vote

The explanation should emphasize the importance of considering both quantitative and qualitative factors in budgeting. Coyle Manufacturing needs to carefully analyze cost drivers, production changes, and market conditions to create a realistic budget that aligns with its strategic goals and economic environment. The cash basis of operations is also crucial in understanding the actual cash flows within the business.

To prepare a budgeted income statement for year 2 for Coyle Manufacturing, we need to take into account the expected changes in various components based on the provided information. Let's calculate each line item:

Sales Revenue:

  • Expected unit volume increase by 5%, but prices are expected to fall by 10%. Therefore, the expected increase in sales revenue is calculated as (1 + 5%) * (1 - 10%) * Sales revenue year 1.

Manufacturing Costs:

  • Materials costs per unit are expected to decrease by 8%.
  • Unit variable cash manufacturing costs are expected to increase by 15%.
  • Fixed cash manufacturing costs (depreciation) are expected to increase by 10%.

Marketing and Administrative Costs:

  • Variable marketing costs will change with unit volume (5% increase in unit volume).
  • Administrative cash costs are expected to decrease by 10%.
  • Depreciation:
  • Manufacturing depreciation is expected to increase by 10%.
  • Marketing and administrative depreciation will remain the same.

Total Costs:

  • Sum of the calculated manufacturing costs, marketing costs, and administrative costs.

Operating Profits (Losses):

Sales Revenue - Total Costs.

User Quyen Anh Nguyen
by
7.6k points