Create a new tab on your spreadsheet and rename it Week 1 Cost Calculations. Then, use the given information to calculate the inventory cost and gross profit margin. Your spreadsheet should be functional and developed so Jessie can have real-time information about costs and make changes as needed.

Converted Supply Bulk Name Cost Conversion Measurment Converted Cost Per Measurement baking soda 1001 cup per cup citric acid 1501 cup per cup $ 22.01 $ 74.02 $ 29.00 $ $ 0.22 $ 0.49 $ 0.15 $ 0.69 corn starch 1891 cup per cup epsom salt 1001 cup per cup per fragrance oil 32.41 tbsp 69.00 $ 23.00 $ 85.00 tablespoon $ 0.71 $ 2.55 $ per mica 33.31 tbsp tablespoon per $ polysorbate 33.35 2561 tbsp 0.13 tablespoon INSTRUCTIONS 1. Download the excel spreadsheet 2. Create a new tab on your spreadsheet and rename it Week 1 Cost Calculations. Then, use the given information to calculate the inventory cost and gross profit margin. Your spreadsheet should be functional and developed so Jessie can have real-time information about costs and make changes as needed. Answer for Bath Bomb One (Basic) Bath Bomb $ 1.25 $ 0.10 Ingredients Paper Bag Total Direct Materials $ 1.35 Direct Labor $ 0.64 $ 1.99 Total Cost Selling Price $ 6.97 $ Total Cost (from above) 1.99 $ Profit Margin 4.98 Profit Margin % 71.5% Obeyoutiful-bath-bombs-students.xlsx27 April 2022, 12:03 PM Recipe for Bath Bombs, Bomb-in-a- Bag, Mini Bombs 6 cups baking soda citric acid 3 cups 0.75 cups corn starch 0.5 cups epsom salt fragrance oil 2 tbsp 3 tbsp mica polysorbate 1 tbsp 1 batch= 10 (Basic) Bath Bombs 5 Bomb-in-a-Bag 10 bags of Mini Bombs Recipe for Bubbling Bath Salts 1.5 cups 2 cups 0.75 cups 4 cups 2 tbsp baking soda citric acid corn starch epsom salt fragrance oil mica polysorbate 3 tbsp 1 tbsp 1 batch= 6 bags of Bubbling Bath Salts Cost of Direct Materials 50 pounds 50 pounds 50 pounds 50 pounds 1 pound 1 pound 1 gallon baking soda citric acid corn starch epsom salt fragrance oil mica polysorbate Cost of Packaging For each Bath Bomb For each Bomb-in-a-Bag, Mini Bombs, Bubbling Bath Salts $ 22.01 $ 74.02 $ 29.00 $69.00 $ 23.00 $85.00 $ 33.35 $ 0.10 $ 0.23 Cost of Direct Labor Minimum Wage per hour $13.50 Social Security 0.062 x wage base Medicare 0.01481 x wage base FUTA tax 0.06 x wage base Sales Price per Unit $ $ Bath Bombs Bomb-in-a-Bag Mini Bombs Bubbling Bath Salts 6.97 10.00 10.00 10.00 $ $ Batch Processing Time (in Minutes) Bath Bombs Bomb-in-a-Bag Mini Bombs Bubbling Bath Salts 25 10 30 30 Converted Supply Bulk Name Cost Conversion Measurment Converted Cost Per Measurement baking soda 1001 cup per cup citric acid 1501 cup per cup $ 22.01 $ 74.02 $ 29.00 $ $ 0.22 $ 0.49 $ 0.15 $ 0.69 corn starch 1891 cup per cup epsom salt 1001 cup per cup per fragrance oil 32.41 tbsp 69.00 $ 23.00 $ 85.00 tablespoon $ 0.71 $ 2.55 $ per mica 33.31 tbsp tablespoon per $ polysorbate 33.35 2561 tbsp 0.13 tablespoon INSTRUCTIONS 1. Download the excel spreadsheet 2. Create a new tab on your spreadsheet and rename it Week 1 Cost Calculations. Then, use the given information to calculate the inventory cost and gross profit margin. Your spreadsheet should be functional and developed so Jessie can have real-time information about costs and make changes as needed. Answer for Bath Bomb One (Basic) Bath Bomb $ 1.25 $ 0.10 Ingredients Paper Bag Total Direct Materials $ 1.35 Direct Labor $ 0.64 $ 1.99 Total Cost Selling Price $ 6.97 $ Total Cost (from above) 1.99 $ Profit Margin 4.98 Profit Margin % 71.5% Obeyoutiful-bath-bombs-students.xlsx27 April 2022, 12:03 PM Recipe for Bath Bombs, Bomb-in-a- Bag, Mini Bombs 6 cups baking soda citric acid 3 cups 0.75 cups corn starch 0.5 cups epsom salt fragrance oil 2 tbsp 3 tbsp mica polysorbate 1 tbsp 1 batch= 10 (Basic) Bath Bombs 5 Bomb-in-a-Bag 10 bags of Mini Bombs Recipe for Bubbling Bath Salts 1.5 cups 2 cups 0.75 cups 4 cups 2 tbsp baking soda citric acid corn starch epsom salt fragrance oil mica polysorbate 3 tbsp 1 tbsp 1 batch= 6 bags of Bubbling Bath Salts Cost of Direct Materials 50 pounds 50 pounds 50 pounds 50 pounds 1 pound 1 pound 1 gallon baking soda citric acid corn starch epsom salt fragrance oil mica polysorbate Cost of Packaging For each Bath Bomb For each Bomb-in-a-Bag, Mini Bombs, Bubbling Bath Salts $ 22.01 $ 74.02 $ 29.00 $69.00 $ 23.00 $85.00 $ 33.35 $ 0.10 $ 0.23 Cost of Direct Labor Minimum Wage per hour $13.50 Social Security 0.062 x wage base Medicare 0.01481 x wage base FUTA tax 0.06 x wage base Sales Price per Unit $ $ Bath Bombs Bomb-in-a-Bag Mini Bombs Bubbling Bath Salts 6.97 10.00 10.00 10.00 $ $ Batch Processing Time (in Minutes) Bath Bombs Bomb-in-a-Bag Mini Bombs Bubbling Bath Salts 25 10 30 30