Exercise $5-11$ Calculating income statement components LO$1,5$

Calculate the missing amounts. $($Loss amounts should be indicated with a minus sign and input all other amounts as positive values. Do not round intermediate calculations. Round "Gross profit ratio" to $2$ decimal places.$)$

$\backslash$table$[[$Sales$,$Company A$,$Company B$],[2023,2022,,5,2023,2022],[$$$,254,000,$$$,178,000,,,,$$$,44,000,],[$Sales discounts,,$2,540,,144,200,,,1,100,,,480,],[$Sales returns and allowances,,,,$15,800,,,5,300,,,,],[$Net sales,,,,$160,600,,,$ele,,,$41,000,],[$Cost of goods sold,,$152,600,,1,,,56,800,?,,,],[$Gross profit from sales,,$50,800,,,,,48,200,,,19,400,],[$Selling expenses,,$17,720,,18,800,,,24,800,,,,],[$Administrative expenses,,$25,400,,1,,,29,500,,,8,800,],[$Total operating expenses,,,,$45,600,,,,$r$,,,],[$Profit $($loss$),,,,14,200,,,,,,1,800,],[$Gross profit ratio,,,,,$\%,,,\%,,,\%$