please help solve asap
Sign in X AutoSave O Off) ACC 202 Project Workbook Cassidy White - Excel Search Share Comments File Home Insert Page Layout Formulas Data Review View Help X Ex AY O LO Calibri 10 ~ A A ab Wrap Text General $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU ~ GEE Merge & Center Formatting * Table Styles v Filter * Select Alignment Number Styles Cells Editing Ideas Clipboard Font D57 X V Total Fixed Costs K L M N O A B C D E F G H 41 42 Harnesses 44 Item Variable Cost/Item Item Fixed Costs 46 High-tensile strength nylon webbing 5.00 Harness maker's salary 2,946.67 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 600.00 51 Loan 183.33 52 Salary to self 166.67 53 54 55 57 Total Variable Costs per Harness $ 14.60 Total Fixed Costs 4,201.67 60 61 62 63 64 65 66 68 69 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% 2:44 PM X N O W P 3/28/2021Sign in AutoSave O Off) ACC 202 Project Workbook Cassidy White - Excel Search X File Home Insert Page Layout Formulas View Help Share Comments Data Review X Ex AY O LO Calibri 10 ~ A A ab Wrap Text Accounting $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU- E GEE Merge & Center Formatting * Table Styles Filter * Select Cells Editing Ideas Clipboard Font Alignment Number Styles F9 X V 21.6 A B C D E F G H K L M N O P Q Milestone Two - Contribution Margin Analysis COLLARS LEASHES HARNESSES 8 Sales Price per Unit S 13.60 S 21.60 21.60 9. Variable Cost per Unit 13.60 21.60 21.60 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% 2:45 PM X N e O W PX VA TO . ill 3/28/2021Sign in X AutoSave O Off) ACC 202 Project Workbook Cassidy White - Excel Search Share Comments File Home Insert Page Layout Formulas Data Review View Help X General Ex AY O LO Calibri 10 ~ A A ab Wrap Text $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU - EE GEE Merge & Center Formatting ~ Table Styles Filter * Select Number Styles Cells Editing Ideas Clipboard Font Alignment K20 X V P Q R 4 C D E F G H K M N O A COLLARS LEASHES HARNESSES Sales Price Fixed Costs S S S 10 C 11 Contribution Margin S 12 13 Break-Even Units (round up) 14 16 17 Target Profit S 300.00 S 400.00 S 500.00 18 19 Break-Even Units (round up) 20 22 500.00 600.00 S 650.00 23 Target Profit S S 24 25 Break-Even Units (round up) 26 28 29 30 31 32 COGS Variances Cost Classification Contribution Margin Analysis Break-Even Analysis + Variable and Fixed Costs Income Statement + 100% 2:45 PM X PX VA TO . ill N e O O W 3/28/2021arch Data App File Home Insert Design Layout References Mailings Review View Help i Share Fl Comments Am .. .. .2 4 A ,Ormd .. l'1 LEE Calibri \"l1?- ~ A A A8" I50 :7 " AaBchDt AaBchDc AaBchD AaBchm Aal AaB AoBchDi \"b R ' 0P? : ep ace Paste v l v I .. A v E *2 .. 'll Normal 1i NOS c... Heaoin 'l Headln 2 'llTitle \"Subtitle Subtle Em... v m......:...... I I H ab *2 x A I ._ \"a ' 9 s sec..- Clipboard IE Font ii Paragraph Ii Styles Ii Editing A You have conducted some market research for style and size of products you want to use to launch your business. The market research has indicated the following sales price ranges will be optimal for your area depending on style of producls you choose to sell: I Collars a With pricing at $20 per collar, you can expect to sell 30 collars per day. 0 With pricing at $24 per collar, you can expect to sell 25 collars per day. a With pricing at $28 per collar, you an expect to sell 20 collars per day I Leashes :3 With pricing at $22 per leash, you can expect to sell 28 leashes per day. a With pricing at $26 per leash, you can expect to sell 23 leashes per day. :3 With pricing at $30 per leash, you can expect to sell 18 leashes per day. I Harnesses a With pricing at $25 per harness, you can expect to sell 25 harnesses per day. 0 With pricing at $30 per harness, you can expect to sell 22 harnesses per day. :3 With pricing at $35 per harness, you can expect to sell 20 harnesses per day. Additionally, you will need to compare your hrea keven points for the following target prots for each area of your business to determine your prices: I Collars o Break-even a 3300 target prot each month 0 5500 target prot each month 7 Page1of1 ZYZwords [D IliFMHS E 'I+ 100% 3:32 P M 3/ 23.2021 A 'fm ..|I| AutoSave O Off) ACC 202 Milestone Two Market Research Data Appendix - Saved to this PC Search Sign in X File Home Insert Design Layout References Mailings Review View Help Share Comments X Cut Find Calibri 12 ~ A" A Aa* A AaBbCcDc AaBbCcDc|AaBbCcD AaBbCcDc Aal AaB AaBbCCD [ Copy Gc Replace Paste BIU ab X X A LA 1 Normal 1 No Spac.. Heading 1 Heading 2 1 Title 1 Subtitle Subtle Em... = Format Painter Select ~ Clipboard Font Paragraph Styles Editing with pricing at 353 per namess, you can expect to sell zonamesses per day. Additionally, you will need to compare your break-even points for the following target profits for each area of your business to determine your prices: . Collars Break-even $300 target profit each month O $500 target profit each month . Leashes Break-even $400 target profit each month $600 target profit each month Harnesses Break-even $500 target profit each month o $650 target profit each month Page 1 of 1 272 words Focus + 100% 3:33 PM X N e W w 3/28/2021AutoSave O Off) ACC 202 Project Workbook Cassidy White - Excel Search Sign in X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 10 ~ A A ab Wrap Text General Ex AY O Paste $ ~ % " Cell BIU - GEE Merge & Center Conditional Format as Insert Delete Format Sort & Find & Ideas Formatting ~ Table Styles v Filter * Select Clipboard Font Alignment Number Styles Cells Editing Ideas D57 X V Total Fixed Costs A B C D E F G H K L M N O 1 Milestone One - Variable and Fixed Costs INLAWN Collars 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 3.00 Depreciation on sewing machines 55.00 in to to to 11 Buckles made of cast hardware 2.00 Rent 250.00 12 Price tags 0.10 Utilities and insurance 200.00 13 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,773.33 28 Polyesterylon ribbons 4.00 Depreciation on sewing machines 55.00 29 Buckles made of cast hardware 1.50 Rent 250.00 30 Price tags 0 10 Utilities and insurance 200 00 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% 2:44 PM X N e W 3/28/2021AutoSave O Off) ACC 202 Project Workbook Cassidy White - Excel Search Sign in X File Home Insert Page Layout Formulas Data Review View Help Share Comments X LO 10 ~ A A General Ex AY O Calibri ab Wrap Text $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU ~ GEE Merge & Center Formatting * Table Styles v Filter * Select Cells Editing Ideas Clipboard Font Alignment Number Styles D57 X V Total Fixed Costs A B C D E F G H K L M N O 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,773.33 28 Polyesterylon ribbons 4.00 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 600.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 $ 4,028.33 $ 4,228.33 39 41 42 Harnesses 44 Item Variable Cost/Item Item Fixed Costs 46 High-tensile strength nylon webbing 5.00 Harness maker's salary 2,946.67 47 Polyesterylon ribbons 4.50 Depreciation on sewing machines 55.00 in 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 600.00 51 Loan 183.33 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + + 100% 2:44 PM X N e W P 3/28/2021
