Question

Problem 3.52 Elina Siljander owns Elina's Stained Glass in Helsinki, Finland. The business produces and sells three different types of stained glass windows: small, medium, and large. Elina has two full-time employees who work regular schedules to cut glass and assemble the windows. She borrowed money from the bank to start the business and pay living expenses. She is concerned that her cash flovs might not be high enough either to pay herself or to repay the bank loan. She would like to generate approximately €10,000 in pretax earnings each month to cover her living expenses and repay the loan. The following revenue and cost information covers the past four months: August September €16,116 July €9,050 C10,531 €12,946 June Revenues Raw materials and supplies Labour 1,745 3,880 2,000 2,433 4,041 2,000 701 €900 €1,356 3,074 4,246 2,000 4,029 4,282 2,200 Rent Miscellaneous 525 747 793 €4,812 Profit €2,879 X Your answer is incorrect. Try again. Develop a cost function for Elina's Stained Glass. (Round answers to 0 decimal places, e.g. 15 or 15%.) 68|| J0% of revenues 2000 Cost function: Total Cost LINK TO TEXT LINK TO TEXT LINK TO TEXT LINK TO TEXT LINK TO TEXT X Your answer is incorrect. Try again. Determine the level of revenue Elina's Stained Glass must generate to achieve the targeted profit of €10,000 per month. (Round answer to 0 decimal places, e.g. 125.) Level of revenue for targeted profit 37500 LINK TO TEXT LINK TO TEXT LINK TO TEXT LINK TO TEXT LINK TO TEXT
What are the correct answers?

Answer 1

ANSWER

Part 1

Cost function: total cost = €6771 + 28% of total revenue

Raw materials are variable = 4029/16116 = 25%

Labor and rent are fixed

Miscellaneous using regression analysis comes to 289 fixed and 3% variable

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.873015
R Square	0.762156
Adjusted R Square	0.643234
Standard Error	69.9928
Observations	4
ANOVA
	df	SS	MS	F	Significance F
Regression	1	31397.01	31397.01	6.408871	0.126985
Residual	2	9797.985	4898.993
Total	3	41,195
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	288.5315	162.9787	1.770363	0.218684	-412.709	989.7724	-412.709	989.7724
X Variable 1	0.033137	0.013089	2.531575	0.126985	-0.02318	0.089456	-0.02318	0.089456

Part 2

Revenue = fixed expense + profit / contribution margin ratio = (6771+10000)/(1-0.28) = $23,293

Part 3

Degree of operating leverage = contribution margin / profit = (16116*(1-0.28))/4812 = 2.41

__________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU*************