6 Preview File Edit View Go Tools Window Help . O . View (305' dataappendix.pdf Zoom Share Highlight Rotate Markup Search... 1page ACC 202 Milestone One: Operational Costs Data Appendix Screen Shot Macintosh HD 2023-0. 3.02 AM You plan to open a small business for manulacturing pet collars, leashes, and harnesses. You have found a workshop space you can use for sewing your products, After some research and planning, you have , , 7 estimates for the various operating costs for your business Docx ' The total square footage for the sewing rooms is 1.50) square feet broken into three areas (500 square ECO 20' \"\"9\" feet each). You have taken out a loan for start-up costs, and the monthly payment is 5550; it goes into append pdf Template eecl Immediately and should be accounted for in your costs You will also collect a modest salary for the rst year of $500 per month; remember to divide evenly among the servlces. Salary and lllrlna Dan 1 r) v . - - One collar maker, who wil be paid $16.00 per hour and work 40 hours per week ,2 ' 3 )1). J EEMW One leash maker. who will be pm sumo per hour and work 40 hours per week 9.)? 1, 3 3 ,L One harness maker, who will be paid $17!!) per hour and work '0 hours per week}r, q (p w y j , One receptionist, who will be paid $15.00 per hour and work 30 hours per week ' '1' 5L' m CM! ' 32:22:\"?! ' -. Discussion Post 1 - Rent: $750 per month; allocate based on square lootage - High-tensile strength nylon webbing$12 peryard of webbing ; 137/}, goon-\" L o 3 collars per yard of webbing o 2 leashes per yard of webbing o 2 harnesses per yard of webbing Relaied "ems Potyesterylm ribbons$9 per yard of ribbon a Cl /3, u 3 collars per yard of ribbon o 2 leashes per yard of ribbon o Zharnessesperyardofribbon A. 3:)\"112 Ct Buckles made of cast hardware$0.50 per buckle M 0 Human Resources 0 4 buckles used per collar Assistant..ern Bank 0 3 buckles used per leash max 0 8 buckles used per harness - 3 industrial sewing machines at $3,300 each for a total of $9.900: depreciation is $165 per month (5 , , , .-__....... year life, zero salvage value) ' 0' 5' \\' I"? - Utilities" andi r 15600 month' I ate ba n ,. Screen Shot mu ance w ' a '0' sed o ' 2023-om52.54 AM Preview File Edit View Go Tools Window Help - G X 42 Q 8 Tue Jun 27 10:18 AM View cost data appendix.pdf Zoom Share Highlight Rotate Markup Search... 1 page UTE LUHOT TICKET, WITU WIN VE palu 210.90 per nour and work 40 hours per week X 17 ). One leash maker, who will be paid $16.00 per hour and work 40 hours per week 2}73.3 3 Screen Shot Macintosh HD . One harness maker, who will be paid $17.00 per hour and work 40 hours per week qu 4 4 2023-0...53.02 AM One receptionist, who will be paid $15.00 per hour and work 30 hours per week 1, 950 Other Costs DOCX PDF Rent: $750 per month; allocate based on square footage High-tensile strength nylon webbing-$12 per yard of webbing = 12/ 3 example cost data ECO 201 Project appendix.pdf Template 3 collars per yard of webbing o 2 leashes per yard of webbing o 2 harnesses per yard of webbing Polyesterylon ribbons-$9 per yard of ribbon $73 9 /3 3 collars per yard of ribbon Screen Shot Module One ACC 2 leashes per yard of ribbon 2023-0...18.40 AM 202 Proj...ook.xIsx o 2 harnesses per yard of ribbon Buckles made of cast hardware-$0.50 per buckle .35X4 .90-4=200 o 4 buckles used per collar DOCX 3 buckles used per leash 202 June Discussion Post o 8 buckles used per harness 2023 3 industrial sewing machines at $3,300 each for a total of $9,900; depreciation is $165 per month (5- year life, zero salvage value) = 0 Sawange = 8900 Utilities and insurance: $600 per month; allocate based on square footage Scissors, thread, cording: $1,200 Price tags: $250 for 2,500 ($0.10 each) Relocated Items Office supplies: $2,400 or $200 per month Other business equipment: $2,000 Loan payment of $550 per month Salary drawn of $500 per month Docx Human Resources Assistan...ern Bank Screen Shot 2023-0...52.54 AM JUN 1 "tv A 27 W XExcel File Edit View Insert Format Tools Data Window Help G Q 8 Tue Jun 27 9:52 AM AutoSave OFF - G... Module One ACC 202 Project Workbook Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri v 10 AA = ab Wrap Text v General Ex AP- O. Paste BIU E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data M17 fx B C D E F G H I J K L M N P Q R S T U V w X Y Milestone One - Variable and Fixed Costs W N Collars 7 Item Variable Cost/Item Item Fixed Costs High-tensile strength nylon webbing 4.00 Collar maker's salary (monthly) $ 2, 773.33 10 Polyesterylon ribbons 3.00 Depreciation on sewing machines 11 Buckles made of cast hardware 2.00 Rent 12 Price tags 0.10 Utilities and insurance 13 Scissors, thread, and cording 14 Loan payment 183.33 15 Salary to self 166.67 16 17 19 Total Variable Costs per Collar S 9.10 Total Fixed Costs 20 22 23 Leashes 25 Item Variable Cost/Item Item Fixed Costs 27 High-tensile strength nylon webbing Leash maker's salary (monthly) $ 2,773.33 28 Polyesterylon ribbons Depreciation on sewing machines 29 Buckles made of cast hardware Rent 30 Price tag Utilities and insurance 31 Scissors, thread, and cording 32 Loan payment 33 Salary to self 34 36 38 Total Variable Costs per Leash Total Fixed Costs 39 41 42 Harnesses 44 Item Variable Cost/Item Item Fixed Costs 46 High-tens th nylon webbing ker's salary 2,946.66 D Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances Ready Accessibility: Good to go + 100% C JUN S atv A 27 W G XExcel File Edit View Insert Format Tools Data Window Help G Q 8 Tue Jun 27 9:53 AM AutoSave OFF - G... Module One ACC 202 Project Workbook Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri v 10 AA ab Wrap Text v General Ex AP- O. Paste E E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze BIUVE Formatting as Table Styles Filter Select Data M17 fx A B C D E F G H 1 J K L M N P Q R S T U V w X Y 23 Leashes 25 Item Variable Cost/Item Item Fixed Costs 27 High-tensile strength nylon webbing Leash maker's salary (monthly) $ 2 , 773.33 28 Polyesterylon ribbons Depreciation on sewing machines 29 Buckles made of cast hardware Rent 30 Utilities and insurance 31 Scissors, thread, and cording 32 Loan paymen 33 Salary to self 34 35 36 38 Total Variable Costs per Leash Total Fixed Costs 39 41 42 Harnesses 44 Iten Variable Cost/Item Item Fixed Costs 46 High-tensile strength nylon webbing Harness maker's salary $ 2,946.66 47 Polyesterylon ribbons Depreciation on sewing machines 48 Buckles made of cast hardware Rent 49 Price tags Utilities and insurance 50 Scissors, thread, and cording 51 Loan 52 Salary to self 53 54 55 57 Total Variable Costs per Harness Total Fixed Costs 58 60 61 62 Cost Classification Variable and Fixed Costs Contribution Margin Analysis Break-Even Analysis COGS Income Statement Variances + 100% Ready Accessibility: Good to go JUN S atv A 27 W G X