Question

6 Cycle-1 is a fast-growing start-up firm that manufactures bicycles. The following income statement is available for October Sales revenue (540 units $640 per unit) $345,600 2.5 Less points Manufacturing costs Variable costs 25,000 Skipped Depreciation (fixed) Marketing and administrative costs Fixed costs (cash) 27,000 66,900 23,800 $142,700 Depreciation (fixed) Total costs eBook $202,900 Operating profits Print Sales volume is expected to increase by 20 percent in November, but the sales price is expected to fall 5 percent. Variable manufacturing costs are expected to increase by 4 percent per unit in November. In addition to these cost changes, variable manufacturing costs also will change with sales volume. Marketing and administrative cash costs are expected to increase by 10 percent. References Cycle-1 operates on a cash basis and maintains no inventories. Depreciation is fixed and should remain unchanged over the next three years. Required: Prepare a budgeted income statement for November. (Do not round intermediate calculations.) CYCLE-1 Budgeted Income Statement For the month of November Less Manufacturing costs: Total manufacturing costs $ $ Less Marketing and Administrative Total marketing and administrative costs $ $ 0

Answer 1

Correct Answer:

Cycle-1
Budgeted income statement
For the month of November
Sales Revenue	$ 393,984.00
Less:
Manufacturing cost
Variable cost	$    31,200.00
Depreciation (Fixed)	$    27,000.00
Total Manufacturing cost	$    58,200.00
Sales Revenue - Total manufacturing cost	$ 335,784.00
Less:
Marketing and Administrative costs
Fixed Costs (cash)	$    73,590.00
Depreciation (Fixed)	$    23,800.00
Total marketing and administrative cost	$    97,390.00
Operating profit	$ 238,394.00

Working:

20% increase in sales volume

Initial sales volume = 540 unit

November’s sales volume = 540 + 540*(20/100) = 648 units

5% fall in sales price:

Initial sales price per unit = $ 640

November’s sales price = 640 – 640*(5/100) = $ 608.00

Variable manufacturing cost per unit = 25000/540 units = $ 46.296

4% increase in Variable manufacturing cost per unit = 46.296 + 46.296*(4/100) = $ 48.148

Total Variable manufacturing cost = 648 units * 48.148 = $ 31,200.00

Marketing and administrative cash cost increase by 10%

Initial cash cost =$ 66,900.00

November’s cash cost = $66,900+ 66900*(10/100) = $    73,590.00

End of answer.

Please give a thumbs-up, it will be highly appreciated.

Thanks. J