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.)

Answer 1

solution:

Excel 8.xlsx - Microsoft Excel Formulas Data Review View - 2 x 11 A A = E Autosum General X 90 = File Home Insert Page Layout % Cut Calibri Ea Copy Paste Format Painter B I U H Clipboard Font 111 fic В B = E Wrap Text Merge & Center Fill A $ % , 8. Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear ZI TU Sort & Find & Filter Select Editing Alignment E Number Cells C D E F G H I J K L M N O P Q R S Particulars Unit sold Sales Variable expenses Fixed expenses Net operating income (Loss) Contribution margin per unit | Case 1 Case 2 Case 3 Case 4 8200 7650 20700 4100 $237,800.00 $299,200.00 $393,300.00 $110,700.00 $106,600.00 $176,800.00 $248,400.00 $82,000.00 $99,000.00 $168,000.00 $32,900.00 $86,000.00 $32,200.00 -$45,600.00 $112,000.00 - $57,300.00 $16.00 $16.00 $7.00 $7.00 Particulars Sales Variable expenses Fixed expenses Net operating income (Loss) Contribution margin ratio Case 1 Case 2 Case 3 Case 4 $443,000.00 $200,000.00 $706,000.00 $291,000.00 $274,660.00 $122,000.00 $176,500.00 $78,570.00 $112,000.00 $51,000.00 $472,000.00 $222,000.00 $56,340.00 $27,000.00 $57,500.00 $9,570.00 38.0% 39.0% 75.0% 73.0% K Sheet474 (4) Sheet396 (2) Sheet666 Sheet667 Sheet669 Sheet670 Sheet672 Sheet6730 Sheet663 Circular References Ready BO 100% + @ o e o o o Panta i Ches.com -6Xy Microsotec - Wy) answer.deas. Image Opng -- 0 7:14 AM 2/10/2020

Excel 8.xlsx - Microsoft Excel X 90 = File Home Insert Page Layout Formulas Data Review View - 2 x fr EO ? A o @ Calculate Now Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math More - Used Time Reference & Trig Functions Function Library A a Define Name f Use in Formula Name Manager Create from Selection Defined Names Trace Precedents 5 Show Formulas Trace Dependents Error Checking Remove Arrows Evaluate Formula Formula Auditing Watch Window Calculation Calculate Sheet Options Calculation в C D E F Particulars Case 1 Unit sold 8200 Sales 237800 Variable expenses 106600 Fixed expenses 99000 Net operating income (Loss) =C4-C5-C6 Contribution margin per unit =(C4-C5)/C3 Case 2 =(D4-D5)/D8 299200 =D4-06-07 168000 -45600 1 6 Case 3 20700 =(E3*E8) +E5 248400 =E4-E5-E7 112000 Case 4 4100 110700 =F4-F6-F7 86000 -57300 =(F4-F5)/F3 Particulars Case 1 Case 2 Case 3 Case 4 Sales 443000 200000 =(E13+E14)/E15 (291000 Variable expenses =C11-C11*c15) 122000 =E11-(E11*E15) 78570 Fixed expenses =C11-C12-C14 51000 472000 =F11-F12-F14 Net operating income (Loss) 56340 =D11-D12-D13 57500 -9570 Contribution margin ratio 0.38 =(D11-D12)/D11 0.75 =(F11-F12)/F11 25 K Sheet474 (4) Sheet396 (2) Sheet666 Sheet667 Sheet669 Sheet670 Sheet672 Sheet6730 M Ready Sheet663 Circular References 20J100% 0 @ o e o o o Panta i Ches.com -6- X Microtect. Wy) answer.deas. Image Opng -- 7:14 AM 2/10/2020