Question

Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations (For all requirements, Loss amounts should be indicated by a minus sign.) Complete this question by entering your answers in the tabs below. Required A Required B situs 0 Assume that more than one product is being sold in each of the four fol Case #1 Case #2 Salos S 454,000 $ 205,000 Variable expenses 131,200 Fixed expenses 50,000 Net operating income (loss) 83.220 S Contribution margin ratio (percent) 43 % 90 TL 83 86 2181 Required A

Answer 1

F16 A B C D E F 3 Sales 4 Variable expenses 5 Fixed Expenses 6 Net Operating Income (loss) Contribution Margin Ratio Case#1 Case#2 Case#3 Case#4 $4,54,000 $2,05,000 $6,99,000 $2,94,000 $2,58,780 $1,31,200 $1,25,820 $ 85,260 $1,12,000 $ 50,000 $4,69,000 $2,27,000 $ 83,220 $ 23,800 $1,04,180 $ -18,260 43% 82% 71% 36% 12

3 Sales 4 Variable expenses 5 Fixed Expenses 6 Net Operating Income (loss) 7 Contribution Margin Ratio Case#1 454000 =B3*(1-B7) =B3-B4-B6 83220 0.43 Case#2 205000 131200 50000 =C3-SUM(C4:05) =(C3-C4)/C3 Case#3 =(D5+D6)/D7 =D3*(1-D7) 469000 104180 0.82 Case#4 294000 85260 =E3-E4-E6 -18260 =(E3-E4)/E3 11 12