Based on the Project Information, what would be the variable product cost for large, variable selling cost for cost per small shake and cost per large shake, income statement at breakeven, and income statement at target profit?

Based on the Product Information with the first 4 photos, what would be the Variable selling cost, income statement at breakeven, income statement at target profit?

This is all the information from the Project. Is the funding correct? Also, can I recieve help on the Variable Selling cost for small and large? Then, can I recieve help on the breakeven and target profit? After that, could I get some help on the income statement at breakeven and income statement at target profit?

What's not clear? What information do you need that I can possibly figure out to provide?

E MILK SHAKE SELLING PRICE G $ Small Large $ $ 7.00 10.00 MILK SHAKE SALES MIX 40% Small Small 60% Large OR to MILK SHAKE RECIPE Large Size Whole Milk Cream Sugar Premium Vanilla Ice Cream Flavorings Flavored specialty straws 8 oz cups 12 oz cups Small 8.00 oz 2.00 OZ 2.00 Oz 0.50 cup 6.00 Oz 2.50 tsp Large 12.00 oz 3.00 OZ 3.00 oz 0.75 cup 9.00 oz 4.00 tsp 1 3 9 1 1 1 2 MILK SHAKE MATERIAL COSTS B Whole Milk 4 $ 26.00 per 5 gallon container $ $ 5 Cream $ 20.00 per 1 gallon container 6 7 8 Sugar $ $ 12.00 per 30 cup container (15 pound bag) $ 9 Premium Vanilla Ice Cream $ 25.00 per CUSTOM 600 oz container MILK SHAKE MATERIAL COSTS Whole Milk $ 26.00 per 5 gallon container - . Cream $ 20.00 per 1 gallon container 7 Sugar $ 12.00 per 30 cup container (15 pound bag) 3 Premium Vanilla Ice Cream $ 25.00 per 600 oz container $ $ 19.20 per 2 cup container $ 80.00 per 100 straws $ 200.00 per 500 cups $ 280.00 per 500 cups 1 Flavorings 2 3 Flavored specialty straws 4 -5 8 oz cups 56 37 12 oz cups 38 89 ADDITIONAL COSTS 40 Shack Rental 41 Monthly Rent 42 PLUS Rent based on Sales 43 44 Cleaning and other Supplies 45 46 Industrial Milk Shake Maker $ 5,540.00 10% of gross sales $ 90.00 per month $ 66.00 per machine ADDITIONAL COSTS Shack Rental Monthly Rent PLUS Rent based on Sales $ 5,540.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 147.00 perset 10 Insurance $ 600.00 per year 7 3 Sign $ 100.00 EMPLOYEES 1 Number of Employees 2 Employee Pay 2 $ 800.00 per month 10 years 10 years 5 years 60 EMPLOYEES 61 Number of employees 2 62 Employee Pay $ 800.00 per month 63 64 DEPRECIATION INFORMATION Useful Life Salvage Value 65 Industrial Milk Shake Maker 5 years $0.00 66 Industrial Refrigerator/freezer $0.00 67 Countertops $0.00 68 Tables and benches for customers $0.00 69 Sign 5 years $0.00 70 71 FUNDING INFORMATION NOTE: Do not use EXCEL Time Value of Money Functions in funding calculations. 72 Amount of borrowing To match capital expenditures 73 Interest rate 4.00% annual Repayment terms of borrowing Principle due at the end of two years. 75 76 TARGET PROFIT $ 1,500.00 per month 77 78 KEY 79 YOU entered this information on the INPUT worksheet. 80 YOU gathered this information from the project video and entered it on the INPUT worksheet 81 YOUR INSTRUCTOR entered this information based on your WIN number 82 Labels and clarifying information based on the project description 74 83 B B C D A Variable Product Costs Product Costs Cost per Small Shake Cost per Large Shake Total Product Costs Variable Selling Costs Selling Costs Cost per Small Shake Cost per Large Shake 5 7 Total Selling Costs B Income Statement at Breakeven 3 4 5 Sales 6 Variable Costs 7 Product Costs 8 Selling Costs 9 Total Variable Costs 10 Contribution Margin 11 Fixed Costs 12 13 3 14 15 1 16 17 18 Fixed Costs Breakeven Target Profit Cont Margin Inc Statements Checkfigures BE Selling Costs 2 Total Variable Costs 0 Contribution Margin 11 Fixed Costs 12 13 14 15 16 17 18 19 20 21 22 Total Fixed Costs 23 Net Operating Income 26 Income Statement at Target Profit 27 28 Sales 29 Variable Costs 30 Product Costs 31 Selling Costs 32 Total Variable Costs 33 Contribution Margin 34 Fixed Costs 35 36 37 38 39 40 41 42 43 44 Fixed Costs Breakeven Target Profit Cont Marain In chociano D D Product Costs Selling Costs Total Variable Costs Contribution Margin Fixed Costs 3 2 3 1 2. 3 74 45 Total Fixed Costs 46 Net Operating Income 47 48 NOTE: There are no entries in grayed cells Fixed 1 Capital Expenditures 2 3 Asset 4 Industrial Milk Shake Maker 5 Industrial Refrigerator/freezer 6 Countertops 7 Tables and benches for customers 8 Sign 9 Amount $660.00 $720.00 $1,200.00 $1,470.00 $100.00 10 11 12 $4,150.00 13 Total 14 15 16 17 18 19 20 21 A B 1 Funding 2 3 Amount Borrowed 4 Monthly Payments 5 6 $12,642.20 $1,032.44 D 1 Depreciation 2 3 Asset 4 Industrial Milk Shake Maker 5 Industrial Refrigerator/freezer 6 Countertops 7 Tables and benches for customers 8 Sign 9 10 11 12 13 14 Total 15 Acquisition Cost $660.00 $720.00 $1,200.00 $1,470.00 $100.00 Useful Life $5.00 $10.00 $10.00 $5.00 $5.00 Salvage Value $0.00 $0.00 $0.00 $0.00 $0.00 Annual Depreciation Monthly Depreciation $132.00 $11.00 $72.00 $6.00 $120.00 $10.00 $294.00 $25.00 $20.00 $2.00 1 $4,150.00 $638.00 $54.00 E 3 Conversion of Units Purchased to Units Used 4 5 Number of ounces in a gallon 128 6 Number of teaspoons in a cup 48 7 EXCEPTION: Since these are actual constants, you may enter numbers in C5 and C6. 8 9 Variable Product Costs 0 1 Product Costs 2 Whole Milk 13 Cream 4 Sugar 5 Premium Vanillia Ice Cream 6 Flavorings Flavored specialty straws 8 OZ cups 9 Cost per Small Shake Cost per Large Shake $0.08 $0.12 $0.31 $0.471 S0.01 $0.02 0.25 $0.38 $0.26 $0.42 $0.80 $0.80 $0.40 $0.56 12 oz cups NOWN-000 UN Total Product Costs $2.11 $2.77 Cost per Small Shake Cost per Large Shake -3 Variable Selling Costs Selling Costs Sign Employee pay Total Selling Costs 18 9 Total Variable Costs 0 1 Total Cost per Small Shake Cost per Large Shake 7.00 10.00 A B | Fixed Costs 2 3 4 Shack Rental 5 Cleaning and other Supplies 6 Insurance 7 Employee pay 8 Monthly Costs $5,540.00 $90.00 $50.00 $1,600.00 9 10 11 12 13 14 Total $7,280.00 15 16 17 18 19 20 21 22 Breakeven Put your well-labelled breakeven analysis below. Remember that all of the calculations must be completed in EXCEL formulas and no new data is entered on this worksheet; You may add more rows to this section if needed. . Results Number of Small Shakes Number of Large Shakes 3 Target Profit Put your well-labelled breakeven analysis below. Remember that all of the calculations must be completed in EXCEL formulas and no new information is entered on this worksheet: You may add more rows to this section if needed. 5 5 7 3 Results 1 2 Number of Small Shakes Number of Large Shakes E MILK SHAKE SELLING PRICE G $ Small Large $ $ 7.00 10.00 MILK SHAKE SALES MIX 40% Small Small 60% Large OR to MILK SHAKE RECIPE Large Size Whole Milk Cream Sugar Premium Vanilla Ice Cream Flavorings Flavored specialty straws 8 oz cups 12 oz cups Small 8.00 oz 2.00 OZ 2.00 Oz 0.50 cup 6.00 Oz 2.50 tsp Large 12.00 oz 3.00 OZ 3.00 oz 0.75 cup 9.00 oz 4.00 tsp 1 3 9 1 1 1 2 MILK SHAKE MATERIAL COSTS B Whole Milk 4 $ 26.00 per 5 gallon container $ $ 5 Cream $ 20.00 per 1 gallon container 6 7 8 Sugar $ $ 12.00 per 30 cup container (15 pound bag) $ 9 Premium Vanilla Ice Cream $ 25.00 per CUSTOM 600 oz container MILK SHAKE MATERIAL COSTS Whole Milk $ 26.00 per 5 gallon container - . Cream $ 20.00 per 1 gallon container 7 Sugar $ 12.00 per 30 cup container (15 pound bag) 3 Premium Vanilla Ice Cream $ 25.00 per 600 oz container $ $ 19.20 per 2 cup container $ 80.00 per 100 straws $ 200.00 per 500 cups $ 280.00 per 500 cups 1 Flavorings 2 3 Flavored specialty straws 4 -5 8 oz cups 56 37 12 oz cups 38 89 ADDITIONAL COSTS 40 Shack Rental 41 Monthly Rent 42 PLUS Rent based on Sales 43 44 Cleaning and other Supplies 45 46 Industrial Milk Shake Maker $ 5,540.00 10% of gross sales $ 90.00 per month $ 66.00 per machine ADDITIONAL COSTS Shack Rental Monthly Rent PLUS Rent based on Sales $ 5,540.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 147.00 perset 10 Insurance $ 600.00 per year 7 3 Sign $ 100.00 EMPLOYEES 1 Number of Employees 2 Employee Pay 2 $ 800.00 per month 10 years 10 years 5 years 60 EMPLOYEES 61 Number of employees 2 62 Employee Pay $ 800.00 per month 63 64 DEPRECIATION INFORMATION Useful Life Salvage Value 65 Industrial Milk Shake Maker 5 years $0.00 66 Industrial Refrigerator/freezer $0.00 67 Countertops $0.00 68 Tables and benches for customers $0.00 69 Sign 5 years $0.00 70 71 FUNDING INFORMATION NOTE: Do not use EXCEL Time Value of Money Functions in funding calculations. 72 Amount of borrowing To match capital expenditures 73 Interest rate 4.00% annual Repayment terms of borrowing Principle due at the end of two years. 75 76 TARGET PROFIT $ 1,500.00 per month 77 78 KEY 79 YOU entered this information on the INPUT worksheet. 80 YOU gathered this information from the project video and entered it on the INPUT worksheet 81 YOUR INSTRUCTOR entered this information based on your WIN number 82 Labels and clarifying information based on the project description 74 83 B B C D A Variable Product Costs Product Costs Cost per Small Shake Cost per Large Shake Total Product Costs Variable Selling Costs Selling Costs Cost per Small Shake Cost per Large Shake 5 7 Total Selling Costs B Income Statement at Breakeven 3 4 5 Sales 6 Variable Costs 7 Product Costs 8 Selling Costs 9 Total Variable Costs 10 Contribution Margin 11 Fixed Costs 12 13 3 14 15 1 16 17 18 Fixed Costs Breakeven Target Profit Cont Margin Inc Statements Checkfigures BE Selling Costs 2 Total Variable Costs 0 Contribution Margin 11 Fixed Costs 12 13 14 15 16 17 18 19 20 21 22 Total Fixed Costs 23 Net Operating Income 26 Income Statement at Target Profit 27 28 Sales 29 Variable Costs 30 Product Costs 31 Selling Costs 32 Total Variable Costs 33 Contribution Margin 34 Fixed Costs 35 36 37 38 39 40 41 42 43 44 Fixed Costs Breakeven Target Profit Cont Marain In chociano D D Product Costs Selling Costs Total Variable Costs Contribution Margin Fixed Costs 3 2 3 1 2. 3 74 45 Total Fixed Costs 46 Net Operating Income 47 48 NOTE: There are no entries in grayed cells Fixed 1 Capital Expenditures 2 3 Asset 4 Industrial Milk Shake Maker 5 Industrial Refrigerator/freezer 6 Countertops 7 Tables and benches for customers 8 Sign 9 Amount $660.00 $720.00 $1,200.00 $1,470.00 $100.00 10 11 12 $4,150.00 13 Total 14 15 16 17 18 19 20 21 A B 1 Funding 2 3 Amount Borrowed 4 Monthly Payments 5 6 $12,642.20 $1,032.44 D 1 Depreciation 2 3 Asset 4 Industrial Milk Shake Maker 5 Industrial Refrigerator/freezer 6 Countertops 7 Tables and benches for customers 8 Sign 9 10 11 12 13 14 Total 15 Acquisition Cost $660.00 $720.00 $1,200.00 $1,470.00 $100.00 Useful Life $5.00 $10.00 $10.00 $5.00 $5.00 Salvage Value $0.00 $0.00 $0.00 $0.00 $0.00 Annual Depreciation Monthly Depreciation $132.00 $11.00 $72.00 $6.00 $120.00 $10.00 $294.00 $25.00 $20.00 $2.00 1 $4,150.00 $638.00 $54.00 E 3 Conversion of Units Purchased to Units Used 4 5 Number of ounces in a gallon 128 6 Number of teaspoons in a cup 48 7 EXCEPTION: Since these are actual constants, you may enter numbers in C5 and C6. 8 9 Variable Product Costs 0 1 Product Costs 2 Whole Milk 13 Cream 4 Sugar 5 Premium Vanillia Ice Cream 6 Flavorings Flavored specialty straws 8 OZ cups 9 Cost per Small Shake Cost per Large Shake $0.08 $0.12 $0.31 $0.471 S0.01 $0.02 0.25 $0.38 $0.26 $0.42 $0.80 $0.80 $0.40 $0.56 12 oz cups NOWN-000 UN Total Product Costs $2.11 $2.77 Cost per Small Shake Cost per Large Shake -3 Variable Selling Costs Selling Costs Sign Employee pay Total Selling Costs 18 9 Total Variable Costs 0 1 Total Cost per Small Shake Cost per Large Shake 7.00 10.00 A B | Fixed Costs 2 3 4 Shack Rental 5 Cleaning and other Supplies 6 Insurance 7 Employee pay 8 Monthly Costs $5,540.00 $90.00 $50.00 $1,600.00 9 10 11 12 13 14 Total $7,280.00 15 16 17 18 19 20 21 22 Breakeven Put your well-labelled breakeven analysis below. Remember that all of the calculations must be completed in EXCEL formulas and no new data is entered on this worksheet; You may add more rows to this section if needed. . Results Number of Small Shakes Number of Large Shakes 3 Target Profit Put your well-labelled breakeven analysis below. Remember that all of the calculations must be completed in EXCEL formulas and no new information is entered on this worksheet: You may add more rows to this section if needed. 5 5 7 3 Results 1 2 Number of Small Shakes Number of Large Shakes