Note that you will package and sell these cookies in packages of 9. This has several consequences to your math. First, o
Posted: Wed Apr 27, 2022 10:37 am
Note that you will package and sell these cookies in
packages of 9. This has several consequences to your
math. First, one unit of cookies is a nine. Second, your recipe may
make 18, 24 or some other amount of cookies – this is your batch
amount. Some costs are per batch and others are per unit.
-Must have at least five
ingredients
You must consult your recipe to determine the amount of
ingredients required for one batch of cookies. You
also must consult Exhibits 1 and 2 for information regarding the
costs of ingredients, manufacturing overhead, and operating
expenses. If your cookies have minor ingredients (< 2TBS) that
are not included in Exhibit 2, these ingredients are considered
part of indirect materials in overhead and you DO NOT need to
account for the costs separately. More substantial ingredients will
require you to research the cost.
a. Total variable costs per unit of cookies
i. This includes
1. DM
2. DL
3. VOpEx
4. VMOH
i. See Exhibit 1 for calculation information
i. in dollars and
ii. in units
units, use the information from
Exhibit 4.
Exhibit 1: Sales price, overhead, and operating expenses Sales Price: Mark-up on total variable cost per unit: 300% Direct Labor Costs: Hourly wage for labor (includes taxes and benefits) Hours of labor per batch $15.25 0.20 Manufacturing Overhead: Variable costs (per batch): $0.05 $0.15 Fixed Costs (per month): Utilities Other indirect materials and labor Maintenance Depreciation Supervision Totals $100 $800 $1,600 $2,500 $0.20 Operating Expenses: Fixed Costs (per month): Variable costs (per unit): $0.12 $0.13 Sales Commission Shipping Costs Salaries Depreciation Other Totals $2,000 $250 $1,750 $4,000 $0.25
Exhibit 2: Cost of ingredients Below is a listing of bulk ingredients available from the local warehouse club. The Unit Size and Cost per Bulk Unit columns are the packages that are sold at the warehouse club. I have translated these into cost per cup or individual cost, as appropriate. You will need to make further adjustments to match your recipe. Ingredient Cost per cup Cost per each $ 0.62 $ $ 1.46 0.11 Almonds, whole Baking powder Baking soda Butter (16 sticks) Chocolate chips, dark Chocolate chips, semi-sweet Cocoa powder Coconut, shredded Cream cheese Eggs Flour, standard all purpose Milk Oatmeal, instant Oil, coconut Oil, vegetable Raisins Sugar, confectioners Sugar, dark brown Sugar, light brown Sugar, white Vanilla, imitation Vanilla, pure extract Walnuts, chopped Unit Unit Size 3 Ibs 60 OZ 15 Ibs 4 Ibs 60 OZ 72 OZ 23 Oz 2 lbs 48 oz 180 each 25 lbs 1 gal 10 lbs 30 oz 1.5 gal 12 oz 7 lbs 7 lbs 7 Ibs 25 Ibs 32 oz 8 oz 3 lbs Cost per Bulk Unit $ 12.98 $ 5.78 $ 7.48 $ 9.99 $ 15.98 $ 9.98 $ 7.18 $ 19.49 $ 8.76 $ 19.36 $ 7.48 $ 2.79 $ 7.98 $ 14.98 $ 7.98 $ 5.11 $ 4.29 $ 4.29 $ 4.29 $ 11.59 $ 4.97 $ 20.98 $ 14.98 $ 0.95 $ 0.78 $ 0.57 $ 1.24 $ 1.64 $ 0.86 $ 1.38 $ 2.15 $ 0.77 N/A $ 0.08 $ 0.17 $ 0.14 $ 3.95 $ 0.33 $ 2.25 $ 0.17 $ 0.32 $ 0.29 $ 0.20 $ 1.14 $ 19.24 $ 1.38 768 192 4 Cups Exhibit 3: Imperial Conversions Measure Fluid Oz TBSP TSP 1 Gallon 4 Quarts 256 1 Quart 64 2 Cups 1 Pint 32 1 Cup 8 ounces 16 1/2 Cup 4 ounces 8 1/8 Cup 1 ounce 2 1/16 Cup .5 ounce 1 96 Milliliters 3,800 950 470 237 118 30 15 48 24 6 3
Exhibit 4: Sales Projections, Collections, Purchases and Payments Monthly sales projections (in units of cookies): January First four digits of your Spartan ID February Last four digits of your Spartan ID March Last four digits of your drivers license April Last four digits of your phone number May Last four of your zip code. UT (33602) or home. You have stopped production of cookies at year end to facilitate the expansion of the business. Therefore, you expect to have no uncollected accounts receivables, unpaid accounts payable, or raw material inventories at January 1, the beginning of your budget period. Collections on Sales: Cash sales are collected in the month of sale. Credit sales collected in the next month after sale Credit sales collected in the second month after sale Percentage 60% 25% 15% Production: The company produces complete batched of the cookies daily. No work-in-process is maintained. Raw materials: The company plans to maintain an ending inventory of raw materials at the end of each month calculated as a percentage of raw materials production needs for the next month. Desired ending raw materials inventory percentage: 16% Payment for Raw Materials: Percentage Paid in the month of purchase Paid in the month following purchase Paid in the second month following purchase 40% 40% 20% Finished goods: The company plans to maintain an ending inventory of finished goods at the end of each month calculated as a percentage of sales needs for the next month. Desired ending finished goods percentage: 26% See Exhibit 1 for information regarding raw material costs, manufacturing overhead, and operating expense.
A в C D D E F G H I J к K L M N 0 P P Q R 9 Total CVP Analysis 1 Direct Materials 2 3 Total Variable Costs Per unit 4 5 6 7 Sales Price Per unit Variable costs Markup Sale price 8 9 10 11 12 13 14 15 16 Contribution Margin Per unit Selling price less: Total variable costs Total cost of direct materials, per batch Number cookies per batch Cost of direct materials per cookie Times cookies in sales unit Total cost of direct materials, per unit Total Total cost of direct labor, per batch Number cookies per batch Cost of direct labor per cookie Times cookies in sales unit Total cost of direct labor, per unit , 17 18 Direct Labor 19 20 21 22 23 24 24 BE 25 26 27 Variable Manufacturing Overhead 28 29 30 31 32 33 34 35 36 Total Total cost of variable MOH, per batch Number cookies per batch Cost of VMOH per cookie Times cookies in sales unit Total cost of VMOH, per unit Inputs Operating Budgets Financial Budgets +
Old Fashioned Peanut Butter Cookies Servings: 60 Save Yield: 4-5 dozen P Pin Ingredients 3 cups all-purpose flour 1 teaspoon baking powder 1 teaspoon salt 1 cup unsalted butter, softened 1 cup packed brown sugar 1 cup white sugar 2 eggs 2 cups peanut butter chips 1 cup peanut butter 2 teaspoons vanilla extract © Copyright 2022 Allrecipes. All rights reserved. Printed from https://www.allrecipes.com 04/22/2022 Local
packages of 9. This has several consequences to your
math. First, one unit of cookies is a nine. Second, your recipe may
make 18, 24 or some other amount of cookies – this is your batch
amount. Some costs are per batch and others are per unit.
-Must have at least five
ingredients
You must consult your recipe to determine the amount of
ingredients required for one batch of cookies. You
also must consult Exhibits 1 and 2 for information regarding the
costs of ingredients, manufacturing overhead, and operating
expenses. If your cookies have minor ingredients (< 2TBS) that
are not included in Exhibit 2, these ingredients are considered
part of indirect materials in overhead and you DO NOT need to
account for the costs separately. More substantial ingredients will
require you to research the cost.
a. Total variable costs per unit of cookies
i. This includes
1. DM
2. DL
3. VOpEx
4. VMOH
i. See Exhibit 1 for calculation information
i. in dollars and
ii. in units
units, use the information from
Exhibit 4.
- Note That You Will Package And Sell These Cookies In Packages Of 9 This Has Several Consequences To Your Math First O 1 (86.6 KiB) Viewed 37 times
Exhibit 2: Cost of ingredients Below is a listing of bulk ingredients available from the local warehouse club. The Unit Size and Cost per Bulk Unit columns are the packages that are sold at the warehouse club. I have translated these into cost per cup or individual cost, as appropriate. You will need to make further adjustments to match your recipe. Ingredient Cost per cup Cost per each $ 0.62 $ $ 1.46 0.11 Almonds, whole Baking powder Baking soda Butter (16 sticks) Chocolate chips, dark Chocolate chips, semi-sweet Cocoa powder Coconut, shredded Cream cheese Eggs Flour, standard all purpose Milk Oatmeal, instant Oil, coconut Oil, vegetable Raisins Sugar, confectioners Sugar, dark brown Sugar, light brown Sugar, white Vanilla, imitation Vanilla, pure extract Walnuts, chopped Unit Unit Size 3 Ibs 60 OZ 15 Ibs 4 Ibs 60 OZ 72 OZ 23 Oz 2 lbs 48 oz 180 each 25 lbs 1 gal 10 lbs 30 oz 1.5 gal 12 oz 7 lbs 7 lbs 7 Ibs 25 Ibs 32 oz 8 oz 3 lbs Cost per Bulk Unit $ 12.98 $ 5.78 $ 7.48 $ 9.99 $ 15.98 $ 9.98 $ 7.18 $ 19.49 $ 8.76 $ 19.36 $ 7.48 $ 2.79 $ 7.98 $ 14.98 $ 7.98 $ 5.11 $ 4.29 $ 4.29 $ 4.29 $ 11.59 $ 4.97 $ 20.98 $ 14.98 $ 0.95 $ 0.78 $ 0.57 $ 1.24 $ 1.64 $ 0.86 $ 1.38 $ 2.15 $ 0.77 N/A $ 0.08 $ 0.17 $ 0.14 $ 3.95 $ 0.33 $ 2.25 $ 0.17 $ 0.32 $ 0.29 $ 0.20 $ 1.14 $ 19.24 $ 1.38 768 192 4 Cups Exhibit 3: Imperial Conversions Measure Fluid Oz TBSP TSP 1 Gallon 4 Quarts 256 1 Quart 64 2 Cups 1 Pint 32 1 Cup 8 ounces 16 1/2 Cup 4 ounces 8 1/8 Cup 1 ounce 2 1/16 Cup .5 ounce 1 96 Milliliters 3,800 950 470 237 118 30 15 48 24 6 3
Exhibit 4: Sales Projections, Collections, Purchases and Payments Monthly sales projections (in units of cookies): January First four digits of your Spartan ID February Last four digits of your Spartan ID March Last four digits of your drivers license April Last four digits of your phone number May Last four of your zip code. UT (33602) or home. You have stopped production of cookies at year end to facilitate the expansion of the business. Therefore, you expect to have no uncollected accounts receivables, unpaid accounts payable, or raw material inventories at January 1, the beginning of your budget period. Collections on Sales: Cash sales are collected in the month of sale. Credit sales collected in the next month after sale Credit sales collected in the second month after sale Percentage 60% 25% 15% Production: The company produces complete batched of the cookies daily. No work-in-process is maintained. Raw materials: The company plans to maintain an ending inventory of raw materials at the end of each month calculated as a percentage of raw materials production needs for the next month. Desired ending raw materials inventory percentage: 16% Payment for Raw Materials: Percentage Paid in the month of purchase Paid in the month following purchase Paid in the second month following purchase 40% 40% 20% Finished goods: The company plans to maintain an ending inventory of finished goods at the end of each month calculated as a percentage of sales needs for the next month. Desired ending finished goods percentage: 26% See Exhibit 1 for information regarding raw material costs, manufacturing overhead, and operating expense.
A в C D D E F G H I J к K L M N 0 P P Q R 9 Total CVP Analysis 1 Direct Materials 2 3 Total Variable Costs Per unit 4 5 6 7 Sales Price Per unit Variable costs Markup Sale price 8 9 10 11 12 13 14 15 16 Contribution Margin Per unit Selling price less: Total variable costs Total cost of direct materials, per batch Number cookies per batch Cost of direct materials per cookie Times cookies in sales unit Total cost of direct materials, per unit Total Total cost of direct labor, per batch Number cookies per batch Cost of direct labor per cookie Times cookies in sales unit Total cost of direct labor, per unit , 17 18 Direct Labor 19 20 21 22 23 24 24 BE 25 26 27 Variable Manufacturing Overhead 28 29 30 31 32 33 34 35 36 Total Total cost of variable MOH, per batch Number cookies per batch Cost of VMOH per cookie Times cookies in sales unit Total cost of VMOH, per unit Inputs Operating Budgets Financial Budgets +
Old Fashioned Peanut Butter Cookies Servings: 60 Save Yield: 4-5 dozen P Pin Ingredients 3 cups all-purpose flour 1 teaspoon baking powder 1 teaspoon salt 1 cup unsalted butter, softened 1 cup packed brown sugar 1 cup white sugar 2 eggs 2 cups peanut butter chips 1 cup peanut butter 2 teaspoons vanilla extract © Copyright 2022 Allrecipes. All rights reserved. Printed from https://www.allrecipes.com 04/22/2022 Local