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$[[,,,$an$,,,,m,$any,,$],[,,023,,2022,,2023,,,22,],[$Sales$,$$$,265,000,,189,000,,,,$$$,49,500,],[$Sales discounts,,$2,650,,,,1,100,,,590,],[$Sales returns and allowances,,,,$16,900,,6,400,,,,],[$Net sales,,,,$170,650,,,,,46,500,],[$Cost of goods sold,,$158,100,,,,57,900,,,,],[$Gross profit from sales,,$51,900,,,,49,300,,,22,700,],[$Selling expenses,,$18,820,,19,900,,25,900,,,,],[$Administrative expenses,,$26,500,,,,30,600,,,9,900,],[$Total operating expenses,,,,$47,800,,,,,,],[$Profit $($loss$),,,,15,300,,,,,2,900,],[$Gross profit ratio,,,,,$\%,,\%,,,\%$