How do you find the funding from the given information?//

Project Information Choco MNIK Fall 2021 MILK SHAKE SELLING PRICE Small Large $7.00 10.00 $ MILK SHAKE SALES MIX Small 40% Small Large 60% Large OR to MILK SHAKE RECIPE Size Whole Milk Cream Sugar Premium Vanilla loe Cream Flavorings Flavored specialty straws 8 oz cup 12 oz cups Small 8.00 Oz 2.00 Oz 2.00 Oz 0.50 cup 6.00 Oz 250 tsp 1 Large 12.00 Oz 3.00 OZ 3.00 Oz 0.75 cup 9.00 Oz 4.00 tsp 1 1 1 MILK SHAKE MATERIAL COSTS Whole Milk $ 9 20.50 per 5 gallon container Cream $ S 20.00 per 1 gallon container Sugar $ S 12.00 per 30 cup container (15 pound bag) Premium Vanilla Ice Cream $ 25.00 per 600 oz container Flavorings $ 19.20 per 2 cup container Meie Flavored specialty straws $ 80.00 per 100 straws 8 oz cups $ 200.00 per 500 cups 12 oz cups $ 245.00 per 500 cups ADDITIONAL COSTS Shack Rental Monthly Rent PLUS Rent based on Sales $ 620.00 10% of gross sales Cleaning and other Supplies $ $ 90.00 per month $ Industrial Milk Shake Maker Number Needed 66.00 per machine 10 Industrial Refrigerator/freezer $ 720.00 Countertops $ 1,200.00 Tables and benches for customers Number Needed $ 124.00 perset 10 Insurance $600 per year Sign $100 EMPLOYEES Number of Employees Employee Pay 2 $800 per $ month Useful Life 5 years 12 years DEPRECIATION INFORMATION Industrial Milk Shake Maker Industrial Refrigerator/freezer Countertops Tables and benches for customers Sign Salvage Value $0.00 $0.00 $0.00 $0.00 $0.00 12 years 5 years 5 years FUNDING INFORMATION Amount of borrowing Interest rate Repayment terms of borrowing NOTE: Do not use EXCEL Time Valueof Money Functions in funding calculations. To match capital expenditures 4.00% annual Principle due at the end of two years TARGET PROFIT $ 2,000.00 per month KEY YOU entered this information on the INPUT worksheet. YOU gathered this information from the project video and entered it on the INPUT worksheet YOUR INSTRUCTOR entered this information based on your WIN number Labels and clarifying information based on the project description A Funding Amount Borrowed $6,830.00 $295.38 Monthly Payments Project Information Choco MNIK Fall 2021 MILK SHAKE SELLING PRICE Small Large $7.00 10.00 $ MILK SHAKE SALES MIX Small 40% Small Large 60% Large OR to MILK SHAKE RECIPE Size Whole Milk Cream Sugar Premium Vanilla loe Cream Flavorings Flavored specialty straws 8 oz cup 12 oz cups Small 8.00 Oz 2.00 Oz 2.00 Oz 0.50 cup 6.00 Oz 250 tsp 1 Large 12.00 Oz 3.00 OZ 3.00 Oz 0.75 cup 9.00 Oz 4.00 tsp 1 1 1 MILK SHAKE MATERIAL COSTS Whole Milk $ 9 20.50 per 5 gallon container Cream $ S 20.00 per 1 gallon container Sugar $ S 12.00 per 30 cup container (15 pound bag) Premium Vanilla Ice Cream $ 25.00 per 600 oz container Flavorings $ 19.20 per 2 cup container Meie Flavored specialty straws $ 80.00 per 100 straws 8 oz cups $ 200.00 per 500 cups 12 oz cups $ 245.00 per 500 cups ADDITIONAL COSTS Shack Rental Monthly Rent PLUS Rent based on Sales $ 620.00 10% of gross sales Cleaning and other Supplies $ $ 90.00 per month $ Industrial Milk Shake Maker Number Needed 66.00 per machine 10 Industrial Refrigerator/freezer $ 720.00 Countertops $ 1,200.00 Tables and benches for customers Number Needed $ 124.00 perset 10 Insurance $600 per year Sign $100 EMPLOYEES Number of Employees Employee Pay 2 $800 per $ month Useful Life 5 years 12 years DEPRECIATION INFORMATION Industrial Milk Shake Maker Industrial Refrigerator/freezer Countertops Tables and benches for customers Sign Salvage Value $0.00 $0.00 $0.00 $0.00 $0.00 12 years 5 years 5 years FUNDING INFORMATION Amount of borrowing Interest rate Repayment terms of borrowing NOTE: Do not use EXCEL Time Valueof Money Functions in funding calculations. To match capital expenditures 4.00% annual Principle due at the end of two years TARGET PROFIT $ 2,000.00 per month KEY YOU entered this information on the INPUT worksheet. YOU gathered this information from the project video and entered it on the INPUT worksheet YOUR INSTRUCTOR entered this information based on your WIN number Labels and clarifying information based on the project description A Funding Amount Borrowed $6,830.00 $295.38 Monthly Payments