Question

Case Study #1 Each question refers to the same initial data. Treat each Part individually. Ignore income taxes. Assume no beginning or ending inventories. Calculations and backup should be completed and submitted in Excel. Use proper Contribution Income Statement formatting – example below. Analysis can either be typed into cells in Excel (formatted to be easily legible) or typed into a text box in Excel. Contribution Margin Format Example:

Data for all questions: Panalon produces cast iron dutch ovens (a deep pot with a lid that can be used on a stovetop or in the oven). Their pots are sold at many local department stores. The cost of manufacturing and marketing their pots, at their normal factory volume of 15,000 pots per month, is shown in the table below. These pots sell for $60 each. Panalon is making a small profit, but would prefer to increase profitability. Hint: Fixed costs are shown on a per-unit basis in the table based on normal volume. However, fixed costs as a total do not change when volume changes, so you will need to determine total fixed costs first. Data for all Questions:

Questions: Part 1: (12 points) A) Prepare a Contribution Margin Income Statement for the company using the given financial data at their normal factory volume. Include line items for each type of cost as well as subtotals for the variable and fixed costs. B) What is the break-even point in units? (Show your calculations.) C) What is the break-even point in sales dollars? (Show your calculations.) D) Using a Contribution Margin Income Statement, verify that your calculated break-even volume results in Operating Income of Zero. (Prepare the entire Contribution Margin statement at the break-even level.)

Part 2: (10 points) A kitchen-goods chain has offered to purchase 13,000 pots (one time in one month) if the sales price was lowered to $50 per pot. Panalon’s maximum capacity is 25,000 units. A) Based on the cost data provided, what would be the impact of the price decrease on sales, costs, and operating income if Panalon accepted this sale? Prepare a contribution margin income statement to show your results. B) Do you think Panalon should accept this sale? Support your decision with evidence and analysis. Hint: Compare your contribution margin income statement including the special sale to the company’s normal contribution margin income statement.

Part 3: (12 points) Panalon is thinking of increasing sales by offering pots with a colored enamel coating. The investment needed to enamel their pots would increase fixed overhead costs by $80,000 per month. The variable materials cost (only variable material costs – not all variable costs) would increase by $8 per pot. Maximum production for the pots would remain 25,000 units because the same production lines would be used. Market research estimates that the colored pots would sell for $75 each, and volume would increase 25%. A) Prepare a revised Contribution Margin Income Statement to include the costs and benefits of the colored pots. B) What is the new break-even point in units for the colored pots? C) What is the new break-even point in sales dollars for the colored pots? D) If volume did not increase when making the colored pots, is Panalon better off producing colored pots or their basic black cast iron pots? Support your answer with data.

Part 4: (16 points) Panalon is thinking of cutting costs by using a different raw material supplier. Their variable material costs would decrease by 25%. The quality of the metal is lower, so Panalon estimates that their additional fixed scrap costs related to the metal quality would be $20,000 per month. They would not change the pricing of their pots. Note: Use the initial data provided for all questions. Ignore the colored pots and special sale data from other questions. A) Prepare a revised Contribution Margin Income Statement to include the costs and benefits of the different raw material supplier. B) If the sales decrease because of the change in quality, how much of a reduction in sales (dollars and units) could Panalon handle and still keep their net operating income the same as before the supplier change? Show your data in a Contribution Margin Income Statement. C) Write a memo to the CFO that presents the pros and cons of the potential supplier change. Include the potential impacts on revenue costs and net operating income, as well as any other factors or consequences of this decision. Be sure to include quantitative evidence and backup as well as any qualitative analysis

. Hint: The analysis is expected to be thorough. Expect to present approximately 400 words, and support your analysis with data (either given or calculated). Remember that this is a letter to the CFO, so proper grammar is expected. unit manufacturing cost Per unit per unit Variable Material $12.00 variable Labor $ 14.00 Variable Overhead $7.00 Fixed Overhead $9.00 total unit manufacturing costs $42.00 Unit Marketing Costs: Variable Marketing Costs $3.00 Fixed Marketing Cost $10.00 Total Unit Marketing Costs $13.00

Answer 1

Answer to Part-1

A)  Contribution Margin Income Statement

	Particulars		Per Unit	Per 15000 Unit
	Selling Price		60	900000	(15000*60)
Less: Variabable Cost
	Material Cost	-12
	Variable Cost	-14
	Varible OH	-7
	Variable Markerting Cost	-3
	Total Variable Cost		-36	-540000
	Constribution		24	360000	(15000*36)
Less: Fixed Cost
	Fixed Cost	-9
	Fixed Markerting Cost	-10
	Total Fixed Cost		-19	-285000	(15000*19)
	Net Profit		5	75000

B) break-even point in units

Break Even Point in units= Total Fixed cost for 15000 units / Contribution per unit

285000 / 24

Therefor Break even points in units =11875

C) Break Even point in Sales Dollars = 11875 Units * 60 $ per Unit

712500

D)

	Particulars		Per Unit	Per 11875 Unit
	Selling Price		60	712500	(11875*60)
Less: Variabable Cost
	Material Cost	-12
	Variable Cost	-14
	Varible OH	-7
	Variable Markerting Cost	-3
	Total Variable Cost		-36	-427500
	Constribution		24	285000	(11875*36)
Less: Fixed Cost
	Fixed Cost	-9
	Fixed Markerting Cost	-10
	Total Fixed Cost		-19	-285000	(15000*19)
	Net Profit		5	0
Note: Since Fixed Cost does not changes with change in production Volume , Fixed Cost is Constant

Part-2

	Particulars		Per Unit	Per Unit	Per 15000 Unit	Per 13000 Unit
	Selling Price		60	50	900000	712500
Less: Variabable Cost
	Material Cost	-12
	Variable Cost	-14
	Varible OH	-7
	Variable Markerting Cost	-3
	Total Variable Cost		-36	-36	-540000	-468000
	Constribution		24	14	360000	244500
Less: Fixed Cost
	Fixed Cost	-9
	Fixed Markerting Cost	-10
	Total Fixed Cost		-19	19	-285000	-285000
	Net Profit		5	-5	75000	-40500

As Seen Above if selling Price decreases from 60 to 50 The Profit of 75000/- will result in loss of 40500

Part-3)

A)

	Particulars		Per Unit	Per 15000 Unit
	Selling Price		75	1406250	(15000*1.25*75)
Less: Variabable Cost
	Material Cost	-20			Increased by 8$
	Variable Cost	-14
	Varible OH	-7
	Variable Markerting Cost	-3
	Total Variable Cost		-44	825000
	Constribution		31	581250	(11875*36)
Less: Fixed Cost
	Total Fixed Cost			-365000	(15000*19+80000)
	Net Profit		31	946250

B) break-even point in units

Break Even Point in units= Total Fixed cost for 18750 units / Contribution per unit

365000 / 31

Therefor Break even points in units =11774.2

C) Break Even point in Sales Dollars = 11774.2 Units * 75 $ per Unit

883064.5

D) Net Profit per unit in pot is 5

Net Profit per unit in colored pot is 31

therefore it is benefical in production of Colored