Legn Southem N... FuteMAX-Futebol AF-A nge your Prompt Use information from Milestone One and the provided Milestone Two

Post by **answerhappygod** » Mon May 30, 2022 7:36 am

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 1 (37.31 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 2 (55.09 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 3 (58.25 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 4 (29.48 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 5 (45.08 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 6 (48.02 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 7 (52.77 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 8 (28.6 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 9 (24.52 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 10 (27.94 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 11 (26.22 KiB) Viewed 13 times

: Legn Southem N Futemax Futebol Af A Nge Your Prompt Use Information From Milestone One And The Provided Milestone Two 12 (46 KiB) Viewed 13 times

Legn Southem N... FuteMAX-Futebol AF-A nge your Prompt Use information from Milestone One and the provided Milestone Two Market Research Data Appendix Word Document to conduct a cost-volume profit analysis. Complete the "Contribution Margin Analysis" and "Break-Even Analysis" tabs in the Project Workbook Spreadsheet that 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 a sales price for each product. • Calculate the contribution margin for 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 the break-even points for 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 suggested target profits for each product. Show your work using calculations to the side of the table or using appropriate formulas in the table. Guidelines for Submission Submit the Project Workbook with the "Contribution Margin Analysis" and "Break-Even Analysis tabs completed. This file should be completed and submitted using Microsoft Excel. 720 FM KON222 ING
MANNAM FW. Enable Editing Sinu Milestone Two: Market Research Data 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 products you choose to sell: • Collars o I o With pricing at $20 per collar, you can expect to sell 30 collars per day. With pricing at $24 per collar, you can expect to sell 25 collars per day. With pricing at $28 per collar, you can expect to sell 20 collars per day O . Leashes With pricing at $22 per leash, you can expect to sell 28 leashes per day. With pricing at $26 per leash, you can expect to sell 23 leashes per day. With pricing at $30 per leash, you can expect to sell 18 leashes per day. Harnesses O With pricing at $25 per harness, you can expect to sell 25 harnesses per day. O With pricing at $30 per harness, you can expect to sell 22 harnesses per day. With pricing at $35 per harness, you can expect to sell 20 harnesses per day. O 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 o Break-even o $300 target profit each month o $500 target profit each month Leashes O Break-even o $400 target profit each month S600 tornat nenfit each month .
o With pricing at $28 per collar, you can expect to sell 20 collars per day Leashes o With pricing at $22 per leash, you can expect to sell 28 leashes per day. With pricing at $26 per leash, you can expect to sell 23 leashes per day. With pricing at $30 per leash, you can expect to sell 18 leashes per day. o o ● Harnesses I o With pricing at $25 per harness, you can expect to sell 25 harnesses per day. With pricing at $30 per harness, you can expect to sell 22 harnesses per day. With pricing at $35 per harness, you can expect to sell 20 harnesses per day. o o 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 O Break-even o $300 target profit each month o $500 target profit each month Leashes O Break-even $400 target profit each month o $600 target profit each month Harnesses O Break-even o $500 target profit each month o $650 target profit each month Remember that all break-even and target points must be in whole units (we cannot sell a partial unit). Round up when calculating partial units to ensure costs are covered. Excel tip-use ROUNDUP function . o
1 2 Milestone Three-Income Statement 3 4 5 Revenue 6 Collars 7 Leashes 8 Harnesses 9 10 Total Revenue 11 Cost of goods sold 12 Grass profit 33 14 Expenses 15 26 17 38 19 Total Expenses 20 21 Net Income/Loss ===== REAI 22 23 24 26 27 28 29 Other business equipment Reads 70°F Cost Classifich Break-Even Analys COGS 3 Income Statement Variances
% Clipboard Fent Alignment Number E25 6 Putting an X in the appropriate spot, classify the costs as Direct Material, Direct Labor, Overhead, or Period Costs 7 The Fixed and Variable cost classifications have been provided for you. 1 Direct Material Direct Labor Item/Cost Overhead Period Conts Fixed 12 Salary-Collar maker 13 Salary-Leash maker 14 Salary-Harness maker 25 Salary-Receptionist 15 High-tensile strength nylon webbing 17 Polyester/nylon ribbons 18 Buckles made of cast hardware 19 Depreciation on sewing machines 20 Rent 21 Utilities and insurance 22 Scissors, thread, and cording 23 Price tags 24 Office supplies 25 Other business equipment 26 toon payment Variable and Fored Costs Ready all a 9 Cost Classification Accessibility Good to go swange Contribution Margin Analysis xxxx Cell -58 Conditional Format Formatting Table Styles. 2 Styles X Break Even Analysis Variable x * x XXX COGS Income Statement Insert Delete Format Cells Variances ©
4 s Collars 7 Item High-tensile strength nylon webbing 0 Polyester/nylon ribbons 11 Buckles made of cast hardware 2 Price tags 13 Total Variable Costs per Collar 22 23 Leashes -5 Item 27 High-tensile strength nylon webbing 8 Polyester/nylon ribbons 9 Buckles made of cast hardware 0 Price tags 1 Cost Classification 4 5 6 -9 20 -2 43 Ready Accessibility: Good to go B Variable Cost/Item $ 4.00 Variable Cost/Item Variable and Fixed Costs D Item Collar maker's salary (monthly) Depreciation on sewing machines Rent Utilities and insurance Scissors, thread, and cording Loan payment Salary to self Total Fixed Costs Item Leash maker's salary (monthly) Depreciation on sewing machines Rent Utilities and insurance Scissors, thread, and cording Loan payment Salary to self Contribution Margin Analysis $ $ Fixed Costs 2,773.33 183.33 166.67 Fixed Costs Break Even Analysis COGS Income St
E31 A 6 17 19 Total Variable Costs per Collar 20 22 23 Leashes 25 Item 27 High-tensile strength nylon webbing 28 Polyester/nylon ribbons 29 Buckles made of cast hardware 30 Price tags 32 35 36 38 Total Variable Costs per Leash 39 41 42 Harnesses 44 Item. 46 High-tensile strength nylon webbing Cost Classification tto no 33 34 fx B Variable Cost/Item Variable Cost/Item Variable and Fixed Costs Alignment Total Fixed Costs Item: Leash maker's salary (monthly) Depreciation on sewing machines Rent Utilities and insurance. Scissors, thread, and cording Loan payment Salary to self Total Fixed Costs Item Harness maker's salary Contribution Margin Analysis Number Fixed Costs Fixed Costs Break-Even Analysis SO G COGS
34 35 36 38 Total Variable Costs per Leash 39 41 42 Harnesses 44 Item. 46 High-tensile strength nylon webbing 47 Polyester/nylon ribbons 48 Buckles made of cast hardware 49 Price tags 50 51 52 53 54 55 57 Total Variable Costs per Harness 58 60 Variable Cost/Item Total Fixed Costs Item Harness maker's salary. Depreciation on sewing machines Rent Utilities and insurance Scissors, thread, and cording. Loan Salary to self Total Fixed Costs Fixed Costs G
B 3 Milestone Two - Contribution Margin Analysis COLLARS 8 Sales Price per Unit 9 Variable Cost per Unit 11 Contribution Margin 1 555560WN 12 14 15 16 17 D LEASHES HARNESSES G H
? 5 1 5 3 9 0 1 2 3 4 6 7 8 9 0 2 3 4 5 6 8 Milestone Two-Break-Even Analysis Sales Price Fixed Costs Contribution Margin Break-Even Units (round up) Target Profit Break-Even Units (round up) Target Profit Break-Even Units (round up) $ $ S COLLARS 300,00 500.00 $ LEASHES 400.00 600.00 $ $ $ HARNESSES 500.00 650.00 +
C24 11 2 Milestone Three-Statement of Cost of Goods Sold 3 6 Beginning Work in Process Inventory 7 Direct Materials: Materials Beginning Add: Purchases for month of January 11 Materials available for use 12 Deduct Ending materials 14 Materials Used 15 Direct Labor 16 Overhead 18 Total Costs 19 20 Deduct: Ending Work in Process Inventory 21 22 Cost of Goods Sold 24 25 26 77