Homework Help is Here – Start Your Trial Now!
Business
Accounting
re seta of inputa Ater inputing al ofy seree per chec foure Teget prote - Dotar sales neede

re seta of inputa Ater inputing al ofy seree per chec foure Teget prote - Dotar sales neede

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Attached are two pictures. The first picture has the instructions (3 pages) and the second picture is a screenshot of an excel spreadsheet that need the "formulas".

 

20211 ACG2071_Module 5 Excel Spreadsheet Instructions - Word alexandra 困 A File Home Insert Design Layout References Mailings Review View Help O Tell me what you want to do 유 Share % Cut Arial A A := - E - - O Find - 12 Aa v AaBbCcDd AaBbCcDd AaBbC AABBCCC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd Ee Copy dac Replace Paste В I U v abe x, x A - ay I 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 1... |... . .. X1.:L· . 2... |. .. 3... |...4. .. |...5... ...6. . .7... Inputs: Data set #3 Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. Inputs: Fixed 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 data 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 0.50 Miscellaneous general expense Ofice salaries 92,000 Supplies 12,300 Production costs: Miscellaneous general expense 20,000 Total Direct materials $2.30 Direct labor 4.70 Total Factory overhead $225,000 3.00 Additional information: Selling expenses: $18.00 Selling price per unit Expected unit sales Sales salaries & commissions 97,000 Additional information: 150,000 Advertising Miscellaneous selling expense 47,500 Selling price per unit $24.00 Target profit $50,000 16,200 Expected unit sales 150,000 General expenses: Office salaries 92,000 Check figure (Target profit – Dollar sales needed): Target profit $50,000 Supplies Miscellaneous general expense 12.300 0.25 $1,828,800.00 Check figure (Target profit – Dollar sales needed): $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 2 of 3 122 words 50% 8:16 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 O Tell me what you want to do 유 Share % Cut Arial A A := - E - - O Find - 12 Aa v AaBbCcDd AaBbCcDd AaBbC AABBCCC AaB AaBbCcD AaBbCcDd AaBbCcDd AaBbCcDd Ee Copy dac Replace Paste В I U v abe x, x A - ay I 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 1... |... . .. X1.:L· . 2... |. .. 3... |...4. .. |...5... ...6. . .7... Inputs: Data set #3 Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. Inputs: Fixed 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 data 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 0.50 Miscellaneous general expense Ofice salaries 92,000 Supplies 12,300 Production costs: Miscellaneous general expense 20,000 Total Direct materials $2.30 Direct labor 4.70 Total Factory overhead $225,000 3.00 Additional information: Selling expenses: $18.00 Selling price per unit Expected unit sales Sales salaries & commissions 97,000 Additional information: 150,000 Advertising Miscellaneous selling expense 47,500 Selling price per unit $24.00 Target profit $50,000 16,200 Expected unit sales 150,000 General expenses: Office salaries 92,000 Check figure (Target profit – Dollar sales needed): Target profit $50,000 Supplies Miscellaneous general expense 12.300 0.25 $1,828,800.00 Check figure (Target profit – Dollar sales needed): $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 2 of 3 122 words 50% 8:16 PM O Type here to search (99+ 5/25/2021
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 General 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 E12 fx A В D F H K M N P R U 8 9 Data Section: Fixed Variable 10 11 Production costs: $2.30 4.70 12 Direct materials 13 Direct labor 14 Factory overhead $225,000 3.00 15 Selling expenses: Sales salaries & commissions 16 97,000 0.75 Advertising Miscellaneous selling expense General expenses: Office salaries 17 47,500 18 16,200 20 92,000 21 Supplies 12,300 0.25 22 Miscellaneous general expense 15,000 23 24 Total FORMULA1 FORMULA2 25 ======== ====== 26 27 Additional information: $16.00 120,000 $20,000 Selling price per unit Expected unit sales 30 Target profit 33 34 Answer Section: 35 36 Contribution margin per unit FORMULA3 Contribution margin (Total) Contribution margin ratio 37 FORMULA4 38 FORMULAS 39 Break-even point in units FORMULA6 40 Break-even point in sales dollars FORMULA7 41 Target profit (Unit sales needed) FORMULA8 42 Target profit (Dollar sales needed) FORMULA9 43 44 Total revenue at expected unit sales FORMULA10 45 Net income at expected unit sales FORMULA11 46 Margin of safety as a percentage of sales FORMULA12 47 48 40 Sheet1 + 曲 70% 8:16 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 General 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 E12 fx A В D F H K M N P R U 8 9 Data Section: Fixed Variable 10 11 Production costs: $2.30 4.70 12 Direct materials 13 Direct labor 14 Factory overhead $225,000 3.00 15 Selling expenses: Sales salaries & commissions 16 97,000 0.75 Advertising Miscellaneous selling expense General expenses: Office salaries 17 47,500 18 16,200 20 92,000 21 Supplies 12,300 0.25 22 Miscellaneous general expense 15,000 23 24 Total FORMULA1 FORMULA2 25 ======== ====== 26 27 Additional information: $16.00 120,000 $20,000 Selling price per unit Expected unit sales 30 Target profit 33 34 Answer Section: 35 36 Contribution margin per unit FORMULA3 Contribution margin (Total) Contribution margin ratio 37 FORMULA4 38 FORMULAS 39 Break-even point in units FORMULA6 40 Break-even point in sales dollars FORMULA7 41 Target profit (Unit sales needed) FORMULA8 42 Target profit (Dollar sales needed) FORMULA9 43 44 Total revenue at expected unit sales FORMULA10 45 Net income at expected unit sales FORMULA11 46 Margin of safety as a percentage of sales FORMULA12 47 48 40 Sheet1 + 曲 70% 8:16 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
Knowledge Booster
Cash Flows
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS