Problems
PA 1
PA 3
PA 7
PA 8
Students must create an Excel file to answer these problems – use the textbook as a guide. Show your work for 60% credit and 40% credit for the correct answer.
Use the correct heading and format for the problem assigned. Create one workbook with a worksheet for each problem. SAVE as a XLS entitled the File jbradley_Ch3PA.
CVP _
https://youtu.be/R8gjp6BCrRI?si=S6Is5fYqMXu1sQIo Links to an external site.
or
https://youtu.be/4U60Ya5ysMU?si=ENwttXFhhx34bcM7 Links to an external site.
or
https://youtu.be/IOE9QB6RYJU?si=q-EBLJ6PYvm4Y8AoLinks to an external site.
PA 1.
LO 3.1 A company sells small motors as a component part to automobiles. The Model 101 motor sells for $850 and has per-unit variable costs of $400 associated with its production. The company has fixed expenses of $90,000 per month. In August, the company sold 425 of the Model 101 motors.
A. Calculate the contribution margin per unit for the Model 101.
B. Calculate the contribution margin ratio of the Model 101.
C. Prepare a contribution margin income statement for the month of August.
PA 3.
LO 3.2 Fill in the missing amounts for the four companies. Each case is independent of the others. Assume that only one product is being sold by each company.
PA 7.
LO 3.4 Manatoah Manufacturing produces 3 models of window air conditioners: model 101, model 201, and model 301. The sales price and variable costs for these three models are as follows:
The current product mix is 4:3:2. The three models share total fixed costs of $430,000.
A. Calculate the sales price per composite unit.
B. What is the contribution margin per composite unit?
C. Calculate Manatoah’s break-even point in both dollars and units.
D. Using an income statement format, prove that this is the break-even point.
PA 8.
LO 3.5 Jakarta Company is a service firm with current service revenue of $400,000 and a 40% contribution margin. Its fixed costs are $80,000. Maldives Company has current sales of $6,610,000 and a 45% contribution margin. Its fixed costs are $1,800,000.
A. What is the margin of safety for Jakarta and Maldives?
B. Compare the margin of safety in dollars between the two companies. Which is stronger?
C. Compare the margin of safety in percentage between the two companies. Now, which one is stronger?
D. Compute the degree of operating leverage for both companies. Which company will benefit most from a 15% increase in sales? Explain why. Illustrate your findings in an Income Statement that is increased by 15%.