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.
Create A New Tab On Your Spreadsheet And Rename It Week 1 Cost Calculations Then Use The Given Information To Calculat 1 (109.08 KiB) Viewed 46 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!