to value her inventory items and would like to know how much money she is making...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
to value her inventory items and would like to know how much money she is making on each product. Your task is to compute the standard inventory cost and gross profit margin for four of her top selling items; Bath-Bombs, Mini-Bombs, Bomb-in-a-Bag and Bubbling Bath Salts. 1) In excel, begin with the recipe of direct materials for each item. Create a conversion chart for how bulk weights purchased are converted to direct materials used for each inventory item. Assign direct materials cost to each item. Next, assign direct labor costs based on labor cost per hour and time required to make each item. Don't forget to also add the cost of packaging. Combine the direct materials, direct labor and packaging costs for each item to arrive at a total cost per unit. Finally, using current selling price and cost per unit, calculate gross margin for each of the four inventory items. What is the gross profit when the business owner might run a "buy 4 get 1 free" promotional offer? Which item is most profitable? Which item is the least profitable, and why? Calculate the break-even unit and sales if the manufacturing overhead cost is 40% from the conversion cost and the fixed operating cost is 20% from the total product cost. 2) Write a memo to the business owner that describes how you used cost accounting concepts to arrive at your inventory values and gross profit margin amounts. Include your calculations when there is a "buy 4 get 1 free" sale. What recommendations do you have for the business owner? 3) Work together in small groups to decide on a final inventory cost and gross profit amount for Bath- Bombs, Mini-Bombs, Bomb-in-a-Bag and Bubbling Bath Salts. Create one final excel costing spreadsheet for the business owner that can be updated if the cost of bulk purchases or sales prices change. How the changes affect the breakeven unit and sales. 4) Finally, create a power point presentation that you will use when you deliver your presentation of calculations and recommendations on inventory costing to the business owner. The recipes, costs of direct materials, packaging costs, direct labor time and costs, and sales prices are listed below. A B C D E F Recipe for Bath Bombs, Bomb in a Bag, & Mini Bomb 600 cups baking soda cric acid 300 cups 0.75 cups com arch 0.50 cups 2:00 p psom sat tagrance of 3.00 tbsp mica 1.00 tbsp polysorbate 1 batch=10 (Basic) Bath Bombs 10 batch=5 Bomb-in-a-Bage 11 batch=10 bags of Min Bomba 6 7 13 Recipe for Bubbling Bath Salts 14 15 cups baking soda * 2 cups cnc acid 15 M 16 17 0.75 cups com starch 4 cups tbsp 3 tbsp 2 epsom sat tagrance of mica polysortate 1 tbsp 21 "f batch = 6 bags of Bubbing Bath Salts 18 19 GH Cost of Direct Materials J 50 pounds 50 pounds baking soda ctric acid com starch pom 50 pounds 50 pounds 1 pounds fragrance of 1 pounds mica polysorbate 1 gallon Cost of Direct Labor K 522 01 $7402 Cost of Packaging For each Buch Bomb For each Bomb-in-a-bag. Mini bomb Bath sas Minimum Wage per hour Social security Medicare FUTA K $69.00 $23.00 $95.00 $33.35 L 50.10 50 23 $13.50 062 x wage base 01401x wage base 06 x wage base M N 0 Sales price per unit Bath Bombs Bomb-in--Bag Min Bomb Bubbing Bath Salts P Bomb-in-a-bag MirBomba Bubbing Bath Salts $6.97 $10.00 $10.00 $10.00 Batch processing time in minutes Buth Bombs 30 Isu: 1 Semakan: to value her inventory items and would like to know how much money she is making on each product. Your task is to compute the standard inventory cost and gross profit margin for four of her top selling items; Bath-Bombs, Mini-Bombs, Bomb-in-a-Bag and Bubbling Bath Salts. 1) In excel, begin with the recipe of direct materials for each item. Create a conversion chart for how bulk weights purchased are converted to direct materials used for each inventory item. Assign direct materials cost to each item. Next, assign direct labor costs based on labor cost per hour and time required to make each item. Don't forget to also add the cost of packaging. Combine the direct materials, direct labor and packaging costs for each item to arrive at a total cost per unit. Finally, using current selling price and cost per unit, calculate gross margin for each of the four inventory items. What is the gross profit when the business owner might run a "buy 4 get 1 free" promotional offer? Which item is most profitable? Which item is the least profitable, and why? Calculate the break-even unit and sales if the manufacturing overhead cost is 40% from the conversion cost and the fixed operating cost is 20% from the total product cost. 2) Write a memo to the business owner that describes how you used cost accounting concepts to arrive at your inventory values and gross profit margin amounts. Include your calculations when there is a "buy 4 get 1 free" sale. What recommendations do you have for the business owner? 3) Work together in small groups to decide on a final inventory cost and gross profit amount for Bath- Bombs, Mini-Bombs, Bomb-in-a-Bag and Bubbling Bath Salts. Create one final excel costing spreadsheet for the business owner that can be updated if the cost of bulk purchases or sales prices change. How the changes affect the breakeven unit and sales. 4) Finally, create a power point presentation that you will use when you deliver your presentation of calculations and recommendations on inventory costing to the business owner. The recipes, costs of direct materials, packaging costs, direct labor time and costs, and sales prices are listed below. A B C D E F Recipe for Bath Bombs, Bomb in a Bag, & Mini Bomb 600 cups baking soda cric acid 300 cups 0.75 cups com arch 0.50 cups 2:00 p psom sat tagrance of 3.00 tbsp mica 1.00 tbsp polysorbate 1 batch=10 (Basic) Bath Bombs 10 batch=5 Bomb-in-a-Bage 11 batch=10 bags of Min Bomba 6 7 13 Recipe for Bubbling Bath Salts 14 15 cups baking soda * 2 cups cnc acid 15 M 16 17 0.75 cups com starch 4 cups tbsp 3 tbsp 2 epsom sat tagrance of mica polysortate 1 tbsp 21 "f batch = 6 bags of Bubbing Bath Salts 18 19 GH Cost of Direct Materials J 50 pounds 50 pounds baking soda ctric acid com starch pom 50 pounds 50 pounds 1 pounds fragrance of 1 pounds mica polysorbate 1 gallon Cost of Direct Labor K 522 01 $7402 Cost of Packaging For each Buch Bomb For each Bomb-in-a-bag. Mini bomb Bath sas Minimum Wage per hour Social security Medicare FUTA K $69.00 $23.00 $95.00 $33.35 L 50.10 50 23 $13.50 062 x wage base 01401x wage base 06 x wage base M N 0 Sales price per unit Bath Bombs Bomb-in--Bag Min Bomb Bubbing Bath Salts P Bomb-in-a-bag MirBomba Bubbing Bath Salts $6.97 $10.00 $10.00 $10.00 Batch processing time in minutes Buth Bombs 30 Isu: 1 Semakan:
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Natureview Farm It was a crisp Vermont morning in February 2000. Christine Walker, vice president of marketing for Natureview Farm, Inc., a small yogurt manufacturer, paused to collect her thoughts...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Solve the Given Requirements by using this Equation: Tangent Lines and Derivatives. x + cos y = 1 a) Find dy b) Evaluate at dx c) Draw the tangent line at 35 1 y = 0 -1 -2 05 1.5 d) Write the...
-
Refer to the information in Problem 6-12B. Assume that the company uses a perpetual inventory system. Also assume that monthly purchases of inventory occur on the first day of each month. In Problem...
-
A chemical manufacturer uses chemicals 1 and 2 to produce two drugs. Drug 1 must be at least 80% chemical 1, and drug 2 must be at least 50% chemical 2. Up to 70,000 ounces of drug 1 can be sold at...
-
After the positrons were annihilated, the energy density of the universe was dominated by the photons and the neutrinos. Show that the energy density in that era was given by \(u_{\text {total...
-
Pottery Ranch Inc. has been manufacturing its own finials for its curtain rods. The company is currently operating at 100% of capacity, and variable manufacturing overhead is charged to production at...
-
3. You have been provided with the information listed below for the City of XYZ. 2024 2025 market value of taxable property $1.3 billion increases by 2.0% from 2024 exemptions $26 million increases...
-
You have been presented with the following set of financial statements for National Property Trust, a REIT that is about to make an initial stock offering to the public. This REIT specializes in the...
-
) Create a script file that will read the x and y vectors (having different lenghts) from an excel file and will use them as inputs for the function explained as follows: MATLAB Function file should...
-
what are the two types of misstatements that are relevant to auditors' consideration of fraud? Explain.
-
We have not filed anything additional with the Internal Revenue Service (IRS). How do you think we'll be taxed?
-
Brian is an unmarried dependent child who works part time at a local restaurant. During the year, Brian earns $4,800 and receives $150 in interest income from his savings. How much is Brian's...
-
What percentage of companies worldwide have experienced fraud in a recent 12-month period?
-
2. (10 points) For each part, describe a relation using the different representations asked for. (a) Let A {1, 2, 3, 4, 5, 6}. (i) Write out the relation R on A that expresses x | y (divides), that...
-
Prepare an argument for presentation in class in which you develop one closely reasoned argument. You may wish to present one of the evidenced arguments. Find an argumentative editorial published in...
-
Troy is a qualified radiologist who operates a successful radiology practice from purpose- built rooms attached to his house. Troy works in the practice three days a week, and the other two days he...
-
Portofino Company made purchases on account from three foreign suppliers on December 15, 2012, with payment made on January 15, 2013. Information related to these purchases is as follows: Portofino...
-
Zorba Company, a U.S.-based importer of specialty olive oil, placed an order with a foreign supplier for 500 cases of olive oil at a price of 100 crowns per case. The total purchase price is 50,000...
-
What accounting issues arise for a company as a result of engaging in international trade (imports and exports)?
-
Figure P19.4 shows two hot streams and two cold streams for heat integration (subject to \(\Delta T_{\min }=20^{\circ} \mathrm{C}\) ). (i) What are the energy targets? (ii) Show a network design...
-
Figure P19.5 shows an existing design of a process plant, containing two exothermic processes. These require streams of reactants as shown in the diagram, and produce products at the temperatures...
-
Recalculate the problem in P19.5 using a \(\Delta T_{\min }=10{ }^{\circ} \mathrm{C}\). Comment on the effect of reducing the minimum temperature difference. [ (a) \(T_{\mathrm{C}_{\text {pinch...
Study smarter with the SolutionInn App