Question

Find Solution for Yellow Boxes with formulas.B5 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 3 Budgeted information for Quarter 1 of Year 3: 4Sales in units 5 |Sales price per unit 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of Goods Sold (per unit) 9 Sales Commissions (per dollar of sales) 10 11 Administrative Salaries (per quarter) 45,000.00 12 Rent Expense (per quarter) 13 Depreciation Expense (per quarter) 14 15 16 1. Prepare a contribution margin income statement for Quarter 1 of Year 3 17 18 19 20 21 29.00 9.50% $27,000.00 $36,000.00 Jay Corporation Budgeted Income Statement For Year 3, Quarter 1Jay Corporation Budgeted Income Statement For Year 3, Quarter 1 18 19 20 21 22 Sales 23 Variable expenses: 24 Cost of goods sold 25Sales commissions 26 Total variable expenses 27 Contribution margin 28 Fixed expenses: 29Adminstrative salaries 30 Rent expense 31Depreciation expense 32 Total fixed expenses 33 Net operating income 34 25

0 0
Add a comment Improve this question Transcribed image text
Answer #1

CONTRIBUTION MARGIN INCOME STATEMENT FOR QUARTER 1 OF YEAR 3

PARTICULARS DETAIL AMT($) AMT($)
A. SALES (17000 x 48)

816000 .

LESS: VARIABLE COST
COST OF GOOD SOLD (17000 x 29) 493000
SALES COMMISSION (816000 x 9.5%) 77520
B. TOTAL VARIABLE EXPENSES (570520)
C. CONTRIBUTION (A - B) 245480
LESS: FIXED COST
ADMINISTRATION SALARIES 45000
RENT EXPENSES 27000
DEPRECIATION EXPENSES 36000
D. TOTAL FIXED COST (108000)
E. NET OPERATING PROFIT (C - D) 137480
Add a comment
Know the answer?
Add Answer to:
Find Solution for Yellow Boxes with formulas. B5 1 Jay Corporation has decided to prepare contribution...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Enter the answers as a formula. 1 Jay Corporation has decided to prepare contribution income statements...

    Enter the answers as a formula. 1 Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of Year 3: Sales in units Sales price per unit $ 17,000 48.00 5 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of Goods Sold (per unit) $ 29.00 9 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) $...

  • Jay Corporation has decided to prepare contribution income statements for A B C D E F...

    Jay Corporation has decided to prepare contribution income statements for A B C D E F G 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 2 3 Budgeted information for Quarter 1 of Year 3: 4 Sales in units 5 Sales price per unit 48.00 17.000 tterns 7 After analyzing expenses, the company has determined the follo 8 Cost of Goods Sold (per unit) $ 29.00 9 Sales Commissions (per dollar of sales) 9.50% 11...

  • А B D E F G 2 A1 fix Jay Corporation has decided to prepare contribution...

    А B D E F G 2 A1 fix Jay Corporation has decided to prepare contribution income statements for C 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 3 Budgeted information for Quarter 1 of Year 3: Sales in units 17,000 Sales price per unit 48.00 7 After analyzing expenses, the company has determined the following cost patterns, 8 Cost of Goods Sold (per unit) S 29.00 9 Sales Commissions (per dollar of sales) 9.50%...

  • All answers must be entered as a formula. Click OK to begin. OK Jay Corporation has...

    All answers must be entered as a formula. Click OK to begin. OK Jay Corporation has decided to prepare contribution income statements for internal planning Budgeted information for Quarter 1 of Year 3: 17,000 48.00 iSales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales) 29.00 9.50% 0 Administrative Salaries (per quarter) 45,000.00 Rent Expense (per quarter) $ 27,000.00 2...

  • Fill in the yellow cells with the correct cell references/formulas A || IU diu la por...

    Fill in the yellow cells with the correct cell references/formulas A || IU diu la por Jay Cu p- А D BC 1 To aid in planning, Jay Corporation is preparing a contribution format income statement. 3 Budgeted information for Quarter 1 of Year 3: 4 Sales in units 5 Sales price per unit 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of goods sold 29.00 per unit Sales commissions 9.50% per...

  • fill in the yellow shaded area with the formulas only. All answers must be entered as...

    fill in the yellow shaded area with the formulas only. All answers must be entered as a formula. Click OK to begin. OK ? - х High-Low Method Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign in Calibri 11 % Paste BIU Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styres Cpboard Font Al v Jay Corporation has decided to prepare contribution income statements for A B с D...

  • Answers need for highlighted boxes. Answers have to a formula not just numbers DEF 1 Jay...

    Answers need for highlighted boxes. Answers have to a formula not just numbers DEF 1 Jay Corporation has decided to prepare contribution income statements for internal planning. 3 Budgeted information for Quarter 1 of Year 3: Sales in units 5 Sales price per unit 17,000 48.00 7 After analyzing expenses, the company has determined the following cost patterns 8 Variable Cost of Goods Sold (per unit) 29.00 9 Sales Commissions (per dollar of sales) 9.50% 11 12 Fixed Manufacturing Overhead...

  • Jay Corporation has provided data from a two-year period to aid in planning. The Controller has...

    Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. · Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B4” was entered, the formula would output the result from cell B4,...

  • FILE HOME INSERT P AGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AÁ -...

    FILE HOME INSERT P AGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AÁ - A Paste B I U , Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font X A1 for To aid in planning, Jay Corporation is preparing a contribution format income o aid in planning, Jay Corporation is preparing a contribution format income statement. udgeted information for Quarter 1 of Year 3: Sales in units Sales price per unit 17,000...

  • Variable cost per unit 1. Analyze a mixed cost using a scattergraph plot and the high-low...

    Variable cost per unit 1. Analyze a mixed cost using a scattergraph plot and the high-low method. 2. Prepare income statements for a merchandising company using the traditional and contribution formats. XI FILE . HOME High Low Method Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW Compute the fixed cost portion using the high level of activity. Total cost at high level of activity Less: Variable cost element Total fixed cost INSERT B IU. A !....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT