Homework Help is Here – Start Your Trial Now!
Business
Accounting
Data Section: Fixed Variable Production costs: Direct materials $2.30 Direct labor 4.70 $225,000 Factory overhead Selling expenses: Sales salaries & commissions 3.00 97,000 0.75 Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense 47,500 16,200 92,000 12,300 0.25 15,000 Total $505,000.00 $11.00 Additional information: Selling price per unit Expected unit sales Target profit $16.00 120,000 $20,000 Answer Section: Contribution margin per unit Contribution margin (Total) Contribution margin ratio Break-even point in units Break-even point in sales dollars Target profit (Unit sales needed) Target profit (Dollar sales needed) $5.00 $600,000.00 31.25% FORMULAG FORMULAT FORMULAB FORMULAS Total revenue at expected unit sales FORMULA10 Net income at expected unit sales FORMULA11 Margin of safety as a percentage of sales FORMULA12 Sheet1

Data Section: Fixed Variable Production costs: Direct materials $2.30 Direct labor 4.70 $225,000 Factory overhead Selling expenses: Sales salaries & commissions 3.00 97,000 0.75 Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense 47,500 16,200 92,000 12,300 0.25 15,000 Total $505,000.00 $11.00 Additional information: Selling price per unit Expected unit sales Target profit $16.00 120,000 $20,000 Answer Section: Contribution margin per unit Contribution margin (Total) Contribution margin ratio Break-even point in units Break-even point in sales dollars Target profit (Unit sales needed) Target profit (Dollar sales needed) $5.00 $600,000.00 31.25% FORMULAG FORMULAT FORMULAB FORMULAS Total revenue at expected unit sales FORMULA10 Net income at expected unit sales FORMULA11 Margin of safety as a percentage of sales FORMULA12 Sheet1

Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 3.4C
See similar textbooks
icon
Related questions
icon
Concept explainers
Question

Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers). 

20211_ACG2071_Module 5 CVP NEW (1) - Excel alexandra 困 A File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share X Cut E AutoSum Arial Rounded MT - 10 A A ab Wrap Text Number e Copy V Fill Paste B IU - $ • % Conditional Format as Cell Insert Delete Format Sort & Find & 00 E Merge & Center 00 V Format Painter Formatting Table Styles O Clear Filter - Select - Clipboard Font Alignment Number Styles Cells Editing D39 fx FORMULA6 A. В E F G K L. M N Q R 8 9 Data Section: Fixed Variable 10 11 Production costs: 12 Direct materials $2.30 13 Direct labor 4.70 14 Factory overhead $225,000 3.00 15 Selling expenses: 16 Sales salaries & commissions 97,000 0.75 17 Advertising Miscellaneous selling expense 47,500 18 16,200 19 General expenses: 20 Office salaries 92,000 21 Supplies Miscellaneous general expense 12,300 0.25 22 15,000 23 24 Total $505,000.00 $11.00 25 =====%3D 26 27 Additional information: Selling price per unit Expected unit sales Target profit 28 $16.00 29 120,000 30 $20,000 31 32 33 34 Answer Section: 35 Contribution margin per unit $5.00 $600,000.00 36 Contribution margin (Total) Contribution margin ratio 37 38 31.25% 39 Break-even point in units Break-even point in sales dollars FORMULA6 FORMULA7 40 41 Target profit (Unit sales needed) Target profit (Dollar sales needed) FORMULA8 42 FORMULA9 43 44 Total revenue at expected unit sales FORMULA10 45 Net income at expected unit sales Margin of safety as a percentage of sales FORMULA11 46 FORMULA12 Sheet1 75% 8:51 PM O Type here to search 99+ 5/25/2021
Transcribed Image Text:20211_ACG2071_Module 5 CVP NEW (1) - Excel alexandra 困 A File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share X Cut E AutoSum Arial Rounded MT - 10 A A ab Wrap Text Number e Copy V Fill Paste B IU - $ • % Conditional Format as Cell Insert Delete Format Sort & Find & 00 E Merge & Center 00 V Format Painter Formatting Table Styles O Clear Filter - Select - Clipboard Font Alignment Number Styles Cells Editing D39 fx FORMULA6 A. В E F G K L. M N Q R 8 9 Data Section: Fixed Variable 10 11 Production costs: 12 Direct materials $2.30 13 Direct labor 4.70 14 Factory overhead $225,000 3.00 15 Selling expenses: 16 Sales salaries & commissions 97,000 0.75 17 Advertising Miscellaneous selling expense 47,500 18 16,200 19 General expenses: 20 Office salaries 92,000 21 Supplies Miscellaneous general expense 12,300 0.25 22 15,000 23 24 Total $505,000.00 $11.00 25 =====%3D 26 27 Additional information: Selling price per unit Expected unit sales Target profit 28 $16.00 29 120,000 30 $20,000 31 32 33 34 Answer Section: 35 Contribution margin per unit $5.00 $600,000.00 36 Contribution margin (Total) Contribution margin ratio 37 38 31.25% 39 Break-even point in units Break-even point in sales dollars FORMULA6 FORMULA7 40 41 Target profit (Unit sales needed) Target profit (Dollar sales needed) FORMULA8 42 FORMULA9 43 44 Total revenue at expected unit sales FORMULA10 45 Net income at expected unit sales Margin of safety as a percentage of sales FORMULA11 46 FORMULA12 Sheet1 75% 8:51 PM O Type here to search 99+ 5/25/2021
20211 ACG2071_Module 5 Excel Spreadsheet Instructions - Word alexandra 困 A File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do 유 Share % Cut Arial A A :E - E - O Find - - 12 Aa v AaBbCcDd AaBbCcDd AaBbC AABBCCD AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd E Copy dac Replace Paste В I U v abe x, X aby v 1 Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. Emphasis Intense E. V Format Painter A Select - Clipboard Font Paragraph Styles Editing Inputs: Data set #3 Below you will see three sets of inputs. After inputting all of your formulas, you should Data Section: Variable Inputs: Fixed be able to use any of these sets of data and have the answers automatically update. Data Section: Fixed Variable Production costs: Please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different dats set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Direct materials $2.30 Production costs: Direct labor 4.70 Direct materials $2.30 $300,000 Factory overhead Selling expenses: Direct labor Factory overhead $300,000 5.50 Sales salaries & commissions 97,000 Advertising Miscellaneous selling expense Selling expenses: Sales salaries & commissions Data set #1 16,200 97,000 Advertising Miscellaneous selling expense 47,500 General expenses: Inputs: 16,200 Office salaries 92,000 General expenses: Data Section: Fixed Variable Supplies 12,300 0.50 Miscellaneous general expense Ofice salaries 92,000 12,300 Supplies Miscellaneous general expense Production costs: 20,000 Total Direct materials $2.30 Direct labor 4.70 Total Factory overhead $225,000 3.00 E=== Additional information: Selling expenses: $18.00 Selling price per unit Expected unit sales Sales salaries & commissions 97,000 Additional information: 150,000 Advertising 47,500 Selling price per unit $24.00 Miscellaneous selling expense Target profit $50,000 16,200 Expected unit sales 150,000 General expenses: Office salaries Check figure (Target profit – Dollar sales needed): Target profit $50,000 92,000 Supplies 12.300 0.25 $1,828,800.00 Check figure (Target profit – Dollar sales needed): Miscellaneous general expense $1,612,698.41 Total ===== Additional information: Selling price per unit $16.00 Expected unit sales 120,000 Target profit $20,000 Check figure (Target profit - Dollar sales needed): $1,680,000.00 Data set #2 Page 1 of 3 122 words 50% 8:52 PM O Type here to search (99+ 5/25/2021
Transcribed Image Text:20211 ACG2071_Module 5 Excel Spreadsheet Instructions - Word alexandra 困 A File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do 유 Share % Cut Arial A A :E - E - O Find - - 12 Aa v AaBbCcDd AaBbCcDd AaBbC AABBCCD AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd E Copy dac Replace Paste В I U v abe x, X aby v 1 Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. Emphasis Intense E. V Format Painter A Select - Clipboard Font Paragraph Styles Editing Inputs: Data set #3 Below you will see three sets of inputs. After inputting all of your formulas, you should Data Section: Variable Inputs: Fixed be able to use any of these sets of data and have the answers automatically update. Data Section: Fixed Variable Production costs: Please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different dats set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Direct materials $2.30 Production costs: Direct labor 4.70 Direct materials $2.30 $300,000 Factory overhead Selling expenses: Direct labor Factory overhead $300,000 5.50 Sales salaries & commissions 97,000 Advertising Miscellaneous selling expense Selling expenses: Sales salaries & commissions Data set #1 16,200 97,000 Advertising Miscellaneous selling expense 47,500 General expenses: Inputs: 16,200 Office salaries 92,000 General expenses: Data Section: Fixed Variable Supplies 12,300 0.50 Miscellaneous general expense Ofice salaries 92,000 12,300 Supplies Miscellaneous general expense Production costs: 20,000 Total Direct materials $2.30 Direct labor 4.70 Total Factory overhead $225,000 3.00 E=== Additional information: Selling expenses: $18.00 Selling price per unit Expected unit sales Sales salaries & commissions 97,000 Additional information: 150,000 Advertising 47,500 Selling price per unit $24.00 Miscellaneous selling expense Target profit $50,000 16,200 Expected unit sales 150,000 General expenses: Office salaries Check figure (Target profit – Dollar sales needed): Target profit $50,000 92,000 Supplies 12.300 0.25 $1,828,800.00 Check figure (Target profit – Dollar sales needed): Miscellaneous general expense $1,612,698.41 Total ===== Additional information: Selling price per unit $16.00 Expected unit sales 120,000 Target profit $20,000 Check figure (Target profit - Dollar sales needed): $1,680,000.00 Data set #2 Page 1 of 3 122 words 50% 8:52 PM O Type here to search (99+ 5/25/2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

what is margin of safety as a percentage of sales

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
SEE MORE TEXTBOOKS