Question

1 Approved Answer

Posted on Jun 29, 2024

Hi this is a managerial accounting assignment. Below ill attach pictures( because i dont know how to upload the excel sheet) of the part one

Hi this is a managerial accounting assignment. Below ill attach pictures( because i dont know how to upload the excel sheet) of the part one of the assignment that i already did and need to get part two done which is the breakeven analysis and contribution margin.

Use information from Milestone One and the providedMilestone Two Market Research Data Appendix Word Documentto conduct a cost-volume profit analysis. Complete the "Contribution Margin Analysis" and "Break-Even Analysis" tabs in theProject Workbook Spreadsheetthat you used for completing the Milestone One assignment.

Specifically, you must address the following rubric criteria:

Contribution Margin.Determine your contribution margin per unit in the "Contribution Margin Analysis" tab.
Choose asales pricefor each product.
Calculate thecontribution marginfor each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
Break-Even Analysis.Use cost-volume-profit (CVP) analysis to determine your break-even points for achieving your target profits in the "Break-Even Analysis" tab.
Determine thebreak-even pointsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
Determine break-even units for the suggestedtarget profitsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

AutoSave On . ACC 202 Project Workboo... - Last Modified: July 11 - Search A bassantessam98@gmail.com B X File Home Insert Page Layout Formulas Data Review View Help Share Comments LO Calibri 10 A ab Wrap Text General AY O Paste Sort & Find & Analyze BIU E = Merge & Center ~ $ ~ % " Conditional Format as Cell Insert Delete Format Formatting * Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis M52 X V B C D E F G H K L M N O Milestone One - Variable and Fixed Costs Collars 7 Item Variable Cost/Item Item Fixed Costs 9 High-tensile strength nylon webbing 4.00 Collar maker's salary (monthly) 2,773.33 10 Polyesterylon ribbons to to to 3.00 Depreciation on sewing machines 55.00 11 Buckles made of cast hardware 2.00 Rent 250.00 12 Price tags Utilities and insurance 200.00 13 S 0.10 Scissors, thread, and cording 400.00 14 Loan payment 183.33 15 Salary to self 166.67 16 17 19 Total Variable Costs per Collar 9.10 Total Fixed Costs $ 4,028.33 20 22 23 Leashes 25 Item Variable Cost/Item Item Fixed Costs 27 High-tensile strength nylon webbing 6.00 Leash maker's salary (monthly) 2,560.00 28 Polyesterylon ribbons 1,50 Depreciation on sewing machines 55.00 in to to to 29 Buckles made of cast hardware 1.50 Rent 250.00 30 Price tags 0.10 Utilities and insurance 200.00 31 Scissors thread and cording 400 00 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + Ready + 100% 10:50 PM Type here to search O 9 ? 7/24/2021B X AutoSave On . ACC 202 Project Workboo... - Last Modified: July 11 - Search A bassantessam98@gmail.com File Home Insert Page Layout Formulas Data Review View Help Share Comments LO Calibri 10 A ab Wrap Text General AY O $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU E Merge & Center Formatting * Table Styles Filter * Select v Data Alignment Number Styles Cells Editing Analysis Clipboard Font M52 X V B C D F G H K L M N O A 25 Item Variable Cost/Item Item Fixed Costs 27 High-tensile strength nylon webbing 5.00 Leash maker's salary (monthly) 2,560.00 28 Polyesterylon ribbons 4.50 Depreciation on sewing machines 55.00 to to to to 29 Buckles made of cast hardware 1.50 Rent 250.00 30 Price tags 0.10 Utilities and insurance 200.00 31 Scissors, thread, and cording 400.00 32 Loan payment 183.33 33 Salary to self 166.67 34 35 36 38 Total Variable Costs per Leash $ 12.10 Total Fixed Costs S 3,815.00 $ 3,815.00 39 41 42 Harnesses 44 Item Variable Cost/Item Item Fixed Costs 46 High-tensile strength nylon webbing 6.00 Harness maker's salary 2,720.00 47 Polyesterylon ribbons 4.50 Depreciation on sewing machines 55.00 to to to to 48 Buckles made of cast hardware 4.00 Rent 250.00 49 Price tags 0.10 Utilities and insurance 200.00 50 Scissors, thread, and cording 400.00 51 Loan 183.33 52 Salary to self 166.67 53 54 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances (+ + 100% Ready 10:50 PM Type here to search O 9 ? 7/24/2021X AutoSave On . ACC 202 Project Workboo... - Last Modified: July 11 - Search A bassantessam98@gmail.com B Share File Home Insert Page Layout Formulas Data Review View Help Comments LO Calibri 10 A ab Wrap Text General AY O Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU E Merge & Center $ ~ % " Formatting * Table Styles v Filter * Select v Data Styles Cells Editing Analysis Clipboard Font Alignment Number F15 X V A B C D E F G H J K L M N P Q Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES 8 Sales Price per Unit 9 Variable Cost per Unit 11 Contribution Margin 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% Ready 10:51 PM Type here to search O 9 ? 7/24/2021ACC 202 Project Workboo... - Last Modified: July 11 + Search A bassantessam98@gmail.com B X AutoSave On . Share Comments File Home Insert Page Layout Formulas Data Review View Help X AY O LO Calibri 12 ~ AA ab Wrap Text General Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU ~ Merge & Center $ ~ % " Formatting " Table Styles Filter * Select v Data Alignment Number Styles Cells Editing Analysis Clipboard Font B2 X V Milestone Two - Break-Even Analysis O P R A A B C D E F G H K L M N Milestone Two - Break-Even Arlalysis COLLARS LEASHES HARNESSES S Sales Price S S Fixed Costs S S S 10 11 Contribution Margin S 12 13 Break-Even Units (round up) 14 16 Target Profit 300.00 S 400.00 S 500.00 17 18 19 Break-Even Units (round up) 20 22 23 Target Profit S 500.00 S 600.00 S 650.00 24 25 Break-Even Units (round up) 26 28 29 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% Ready 10:51 PM Type here to search O 9 ? 7/24/2021