Instructions
a.	Prepare a CVP income statement for 2022 based on management estimates. Include columns for per unit and percent of sales information.
b.	Compute the break-even point in (1) sales units and (2) sales dollars.
c.	Compute the contribution margin ratio and the margin of safety ratio. (Round to the nearest full percent.)
d.	Determine the sales dollars required to earn net income of $180,000.
NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), into the yellow shaded input cells.

Autoguardado ng 2. .... Inicio Insertar Dibujar Disposicin de pgina Frmulas Datos Vista Qu deseas? f Liberation Sans Ajustar textov General V [A V 12 & A Pegar NK Sv B +3 Cembinar y centrar $ % 9 D Formato Dar formato Estilos condicional como tabla de celde A1 A X fx P5.3 Prepare a CVP income statement, and compute break-even point, contribution margin ratio, margin of safety ratio and sales for target net income. 8 C D E H I J K L M N 0 P D F S T U W X 1 P5.3 Prepare a CVP Income statement and compute break-even point, contribution margin. 2 catio, margin of safety ratio and sales for target net income. 3 4 Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents 5 per 16-ounce bottle to rotaliers. For the year 2022, management estimates the following 6 revenues and costs. 7 8 Sales $ 1,800,000 9 Direct materials 430,000 10 Direct labor 380,000 11 Manufacturing overhead-variable 390,000 12 Manufacturing overhead-tied 290,000 13 Selling expenses-variable 70,000 14 Selling expenses-fixed 85,000 15 Administrative expenses-variable 20,000 16 Administrative expenses-tied 50,000 17 13 Instructions 19 a. Prepare a CVP income statement for 2022 based on management estimates. Include 30 columns for per unit and percent of sales information. 21 b. Compute the break-even point in (1) sales units and (2) sales dollars. 0 Compute the contribution margin ratio and the margin of safety ratio. (Round to the nearest full pomont.) 33 24 d. Determine the sales dollars required to eam net income of $180,000. 25 30 NOTE: Enter a formula, a cell reference, or a value if you are unable to reference a cell), 27 Into the yellow shaded input cells. 28 191 10 31 8. JORGE COMPANY 32 CVP Income Statement (Estimated) For the Year Encing December 31, 2022 11 24 Percent of Sales 15 Dollar Amounts Per Unit 57 10 39 40 41 42 43 44 45 46 47 E5.9 E5.9 Add Ques + 48 49 50 Sales Variable expenses Cost of goods sold Seling expense8 Administrative expenses Total variable expenses Curtrbulion margin Fixed expenses Listo Cost of goods sold Seling expenses Administrative expenses Totalted expenses Net income P5.3 P5.3 Add Ques Revisar EXAMEN.xlsx - Solo lectura Y Y Insertar Eliminar Formato 2 3 Compartir * AD Y Ordenar filtrar V Buscar y y filtrar seleccionar AB AD - Comentarios Fra M Analizar datos AF + B0% Autoguardado GABD. Cn Inicio Insertar Dibujar Disposicin de pgina Frmulas Datos Vista Qu deseas? & 12 A A Ajustar texto v General Z V L [A Liberation Sans NKS Pegar B. & A +3 Cembinar y centrar $ Y % 9 D V Formato Dar formato Estilos condicional como tabla de celde X fx P5.3 Prepare a CVP income statement, and compute break-even point, contribution margin ratio, margin of safety ratio and sales for target net income. C D E F F I J M N 0 p Y u H 5 T U W! 50 51 Breakeven acint in unta 52 Unit selling price 53 Unit variable costs Unit contribution margin 55 56 Fixed costs 57 Unit contribution margin sa Broak even point in units 59 bu GL 62 Brakewn point in colars Break-even point in units Unit selling price 63 64 Break-even point in collars G 66 67 c. Compute the contribution margin ratio and the margin of safety ratio. (Round to the nearest b full percent. Contribution margin ralio Urit contribution margin Unit selling price Contribution margin ratio Marcin of safety ratio Total sales dollars Break-even sales (dollars) Margin of safety (colars) Total sales Margin of salely ralio 63 d. Determine the sales dollars required to eam net income of $180,000. 14 15 Sales dollars required to sem target income 86 Fixed costs Target income 68 Total fixed cust+target income 69 Contribution margin ratio 90 Sales dollars required 91 92 93 When you have completed P5.3, respond to the additional question, on the P5.3 Sol to Add 54 Question worksheet. 25 96 97 20 P5.3 P5.3 Add Ques E5.9 E5.9 Add Ques + A1 TA 70 31 AAAARFRES=22: A 3 b. (1) F Listo (2) A V Revisar EXAMEN.xlsx - Solo lectura Insertar Eliminar Formato 2 AA Compartir Ordenar Buscar y y filtrar seleccionar filtrar AL AL Prem * AD Y V AB AS Comentarios Fra M Analizar datos + AG 80% T