Question

(ALL THE INFORMATION HERE IS THE INFORMATION I WAS PROVIDED BY THE PROFESSOR. I DO NOT HAVE ANY MORE INFORMATION BUT WHAT IS HERE)

Kate and Claire, recent college graduates, are unable to find suitable jobs in their field of accounting. However, each has been involved with a small business of their own for the last several years, and have been doing very well. Kate is a talented seamstress, and has designed a line of fashionable blazers that are selling for $500/each. Kate remains shocked at how fast the orders are coming in, and wonders if this could be something big.   Claire also has a small but growing business. She manufactures synthetic leather belts that are selling for $50/each, and is similarly experiencing strong consumer interest. A few large retailers have started to place orders with both girls, and both are struggling to keep up with demand. Kate and Claire are wondering if they should combine their lines and start building the business together, since there is a high amount of overlap among their customers, and they could likely achieve some synergies by combining their marketing and customer service efforts. The belts go very well with the blazers. With a solid knowledge of their accounting basics, both have kept very thorough cost and marketing data. So they decided to pull it all together and analyze it.

Kate’s blazers – manufacturing data

	# of Blazers	Total Manufacturing Costs
2019	400	$140,000
2018	350	130,000
2017	310	122,000
2016	240	108,000
2015	275	115,000
2014	250	106,000

Kate’s blazers – marketing data

	# of Blazers	Total Marketing Costs
2019	400	$60,000
2018	350	55,000
2017	310	51,000
2016	240	44,000
2015	275	47,500
2014	250	45,000

Claire’s belts – manufacturing data

	# of Belts	Total Manufacturing Costs
2019	1,700	$66,500
2018	1,400	56,000
2017	1,100	45,500
2016	1,000	42,000
2015	1,200	49,000
2014	900	38,500

Claire’s belts – marketing data

	# of Belts	Total Marketing Costs
2019	1,700	$11,500
2018	1,400	10,000
2017	1,100	8,500
2016	1,000	8,000
2015	1,200	9,000
2014	900	7,500

DELIVERABLE:

Prepare a comprehensive report with the answers to each of the following questions. Provide all calculations in a well-organized manner, with the final answer for each part clearly stated in a complete sentence.

Total report should be between 2-3 pages.

QUESTIONS:

1. High-low cost estimation method

1. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the blazers.
2. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the belts.

NOTE: The variable and fixed costs for each product line, blazers and belts, contain both a manufacturing and a marketing component. However, the data is recorded separately, which means FOUR separate high-low analyses must be conducted.

2. Cost-Volume-Profit (CVP) analysis, single-product

1. Use CVP analysis to calculate the break-even point in units for the blazers.
2. Use CVP analysis to calculate the break-even point in units for the belts.

3. CVP, multiple-product setting

Merging the data together, it appears the sales mix is approximately 300 blazers and 1,200 belts each year.

For this CVP analysis, assume an additional $30,000 of combined fixed costs, this will be largely customer service costs.

1. Calculate the break-even point for both product lines combined.

4. Cost classification

1. Classify the manufacturing costs, marketing costs, and customer service costs either as production expenses or period expenses.
2. For the period expenses, further classify them into either selling expenses or general and administrative expenses.

5. Sensitivity CVP analysis and production versus period expenses – Multiple-Product Setting

1. If both variable and fixed production expenses (refer to Question #1) associated with the blazer increased by 5% (beyond the estimate from the high-low analysis), how many blazers and belts would need to be sold in order to earn a target income of $96,000? Assume the same sales mix and additional fixed costs in Question #3.

6. Margin of Safety

1. Calculate the margin of safety (both in units and in sales dollars), assuming they sell 700 blazers and 2,500 belts next year. Ignore the suggested change in expenses in Question #5.
2. What does this margin of safety mean?

7. Income statement

1. Prepare a forecasted income statement (to the operating income line) for Kate and Claire, assuming they sell 700 blazers and 2,500 belts, and assuming the 5% cost increase for the blazer (variable and fixed production costs) and the additional $30,000 combined fixed costs.
2. How would you suggest Kate and Claire divide the operating profit?

8. Degree of Operating Leverage

1. Calculate the degree of operating leverage, with the same assumptions as Question #7.
2. What does the DOL tell Kate and Claire? Do you think they should consider promotional events? Why or why not?

Answer 1

For detail solution please see Below

Blazer
Years	units	Total manufacturing cost	Total marketing cost	Total cost
2019	400	140000	60000	200000
2018	350	130000	55000	185000
2017	310	122000	51000	173000
2016	240	108000	44000	152000
2015	275	115000	47500	162500
2014	250	106000	45000	151000
		Highest activity cost	200000
		lowest activity cost	152000
		Highest activity unit	400
		lowest activity unit	240
		Variable cost per unit	=(highest activty cost -lowest activity cost)/(Highest activity unit-lowest activity unit)
	1	Variable cost per unit (blazer)	300	=(200000-152000)/(400-240)
		Fixed cost for highest activity	=Highest activity cost-(Highest activity unit *variable cost per unit)
	1	Fixed cost (blazer)	80000	=200000-(400*300)
		Selling price	500
		Variable cost	300
		contribution	200
	2	CVP blazer	40%	200/500*100
	2	Break even point in units (Blazer)	400	('80000/200)

Belt
Years	units	Total manufacturing cost	Total marketing cost	Total cost
2019	1700	66,500.00	11,500.00	78,000.00
2018	1400	56,000.00	10,000.00	66,000.00
2017	1100	45,500.00	8,500.00	54,000.00
2016	1000	42,000.00	8,000.00	50,000.00
2015	1200	49,000.00	9,000.00	58,000.00
2014	900	38,500.00	7,500.00	46,000.00
		Highest activity cost	78000
		lowest activity cost	46,000.00
		Highest activity unit	1700
		lowest activity unit	900
		Variable cost per unit	=(highest activty cost -lowest activity cost)/(Highest activity unit-lowest activity unit)
	1	Variable cost per unit (Belt)	40	=(78000-46000)/(1700-900)
		Fixed cost for highest activity	=Highest activity cost-(Highest activity unit *variable cost per unit)
	1	Fixed cost (Belt)	10000	=78000-(1700*40)
		Selling price	50
		Variable cost	40
		contribution	10
	2	CVP (belt)	20%	('10/50*100)
	2	Break even point in units (Belt)	1000	('10000/10)