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 $p$ values. Do not round intermediate calculations. Round "Gross profit ratio" to $2$ decimal places.$)$

$\backslash$table$[[,$Company A$,$Company B$],[,2023,2022,,2023,2022,],[$Sales$,$$$,248,000,,$$$,172,000,,,41,000,],[$Sales discounts,,$2,480,,,1,900,,1,100,,420,],[$Sales returns and allowances,,$45,720,,,15,200,,4,700,,,],[$Net sales,,$199,800,,,154,900,,103,800,,38,000,],[$Cost of goods sold,,$149,600,,,96,900,,56,200,,,],[$Gross profit from sales,,$50,200,,,58,000,,47,600,,17,600,],[$Selling expenses,,$17,120,,,18,200,,24,200,,+,],[$Administrative expenses,,$24,800,,,26,200,,28,900,,8,200,],[$Total operating expenses,,$41,920,,,44,400,,53,100,,,],[$Profit $($loss$),,8,280,,,13,600,,(5,500),,1,200,],[$Gross profit ratio,,$25\mathrm{.}12,\%,,37\mathrm{.}44,\%,,\%,,\%$