Green Company sells CBD and Hemp products to the general public through a physical storefront and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Green Company sells CBD and Hemp products to the general public through a physical storefront and through online sales. The business has six (6) products, and the sales for all products are split with 40% being online and 60% being in-store. The company has 5 departments: Mixing, Lab, Sales/Marketing, Administration, and IT. Lab hours cost $20 each, Mixing hours cost $14 each, Sales/Marketing hours cost $11 each, Administration hours cost $12 each, and IT hours cost $18 each. These labor hour costs could change after service department costs are allocated. Products 1, 2, and 3 have to be further handled and processed by the company to make them ready for sale. This time is split between the Mixing Department (40%), the Lab Department (45%), and the Sales/Marketing Department (15%). Any material used for these products is added at the beginning of the process. Products 4, 5, and 6 are purchased pre-packaged and then minimal effort is needed to resell them to customers. However, some of these items do go through the Lab Department for randomized testing. This averages out to be approximately 10% of the labor hours for these products with the rest of their time going through Sales/Marketing (90%). The company has certain fixed cost items that are shared between the Online Store and the physical Storefront: Insurance and Warehouse Costs. The Server Space and Website costs are for the Online Store, and the remaining fixed cost items are for the physical Storefront. All costs are fixed costs. Overhead costs are allocated based on labor hours. The company is wrapping up year-end and they are planning for the upcoming year's sales and budgets. They have the following Sales mix: Online-40% in-store-60% Droducts: mixing: lab: Fixed COS+S: online store - 2 40% 40%% 45% 45% Sales/marketing: 15% 15% administration: - IT: - departments: mixing lab Sales/ marketing administration Server space website costs insurance . . IT time in each department: rent (warehouse) utilities (warehouse) . - Costs per hour: 14 20 11 12 18 3 40% 45% 15% - 4 physical store front insurance rent (store) rent (warehouse) 10% 90% utilities (Store) - - utilities (warehouse) 5 10% 90% 10% 90% Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 1 Department Mixing Lab Sales/Marketing Administration IT Fixed Overhead Rent - Store Rent-Warehouse. $ $ Insurance Utilities - Store Utilities - Warehouse Server Space and Website Total Overhead $ $ $ $ Estimated Manufacturing Overhead - Allocated on Direct Labor Hours of Mixing, Lab, and Sales/Marketing $ $ Ś Wholesale Costs (Direct Material) $ $ Units in Beginning WIP (80% complete) $ $ 1 2.00 4.00 3.00 6.00 5 10.00 12.00 Number of Employees 2 2 1 The company wants an annual net profit of $250,000 1,200 Direct Labor Hours 60,000 30,000 24,000 21,600 6,000 14,400 156,000 0.50 0.75 1.00 0.50 0.50 0.25 Units Started and Completed 2,000 Type of Department Operational Operational Operational Service Service Estimated Manufacturing Overhead Rate Units in Ending WIP (40% Complete) 450 Total Hours Worked per Employee 2080 2080 1040 2080 2080 $ Margin % 20.00% 20.00% 15.00 % 12.00% 12.00% 10.00% 55,100 Labor Cost in Beg WIP $ 600 475 0 3,400 $ Server Hours Used 120 350 Sales Mix % 25.00% 20.00% 12.00% 15.00% 18.00% 10.00% Current Period Labor Costs 4,500 Labor Hours Used 4160 2080 5200 4160 2080 Total Cost per Employee (Hours x Rate) $ $ $ $ $ 29,120 41,600 11,440 24,960 37,440 questions: • Product 1 is made the most. Calculate the ending WIP balance in units and dollars using the weighted average method. All other products were finished at year-end. All materials are added at the beginning of the process. • Allocate the service departments' costs to the operating departments using the reciprocal method. The allocation of IT Department costs is based on server hours and the Administration Department costs are allocated based on labor hours. • Calculate the total cost of each product. • Calculate the Break-Even in Units Sold for the given sales mix of products. • Calculate the Units Sold needed for the given sales mix of products for the company to make $250,000 in profit. Calculate the Overhead for In-Store operations and Online operations. • Use the above overhead to see which sales method is the most profitable, Online or In-Store. If you had $100,000 to invest in the business, which product would you invest in, and would you push it Online or In- Store? Green Company sells CBD and Hemp products to the general public through a physical storefront and through online sales. The business has six (6) products, and the sales for all products are split with 40% being online and 60% being in-store. The company has 5 departments: Mixing, Lab, Sales/Marketing, Administration, and IT. Lab hours cost $20 each, Mixing hours cost $14 each, Sales/Marketing hours cost $11 each, Administration hours cost $12 each, and IT hours cost $18 each. These labor hour costs could change after service department costs are allocated. Products 1, 2, and 3 have to be further handled and processed by the company to make them ready for sale. This time is split between the Mixing Department (40%), the Lab Department (45%), and the Sales/Marketing Department (15%). Any material used for these products is added at the beginning of the process. Products 4, 5, and 6 are purchased pre-packaged and then minimal effort is needed to resell them to customers. However, some of these items do go through the Lab Department for randomized testing. This averages out to be approximately 10% of the labor hours for these products with the rest of their time going through Sales/Marketing (90%). The company has certain fixed cost items that are shared between the Online Store and the physical Storefront: Insurance and Warehouse Costs. The Server Space and Website costs are for the Online Store, and the remaining fixed cost items are for the physical Storefront. All costs are fixed costs. Overhead costs are allocated based on labor hours. The company is wrapping up year-end and they are planning for the upcoming year's sales and budgets. They have the following Sales mix: Online-40% in-store-60% Droducts: mixing: lab: Fixed COS+S: online store - 2 40% 40%% 45% 45% Sales/marketing: 15% 15% administration: - IT: - departments: mixing lab Sales/ marketing administration Server space website costs insurance . . IT time in each department: rent (warehouse) utilities (warehouse) . - Costs per hour: 14 20 11 12 18 3 40% 45% 15% - 4 physical store front insurance rent (store) rent (warehouse) 10% 90% utilities (Store) - - utilities (warehouse) 5 10% 90% 10% 90% Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 1 Department Mixing Lab Sales/Marketing Administration IT Fixed Overhead Rent - Store Rent-Warehouse. $ $ Insurance Utilities - Store Utilities - Warehouse Server Space and Website Total Overhead $ $ $ $ Estimated Manufacturing Overhead - Allocated on Direct Labor Hours of Mixing, Lab, and Sales/Marketing $ $ Ś Wholesale Costs (Direct Material) $ $ Units in Beginning WIP (80% complete) $ $ 1 2.00 4.00 3.00 6.00 5 10.00 12.00 Number of Employees 2 2 1 The company wants an annual net profit of $250,000 1,200 Direct Labor Hours 60,000 30,000 24,000 21,600 6,000 14,400 156,000 0.50 0.75 1.00 0.50 0.50 0.25 Units Started and Completed 2,000 Type of Department Operational Operational Operational Service Service Estimated Manufacturing Overhead Rate Units in Ending WIP (40% Complete) 450 Total Hours Worked per Employee 2080 2080 1040 2080 2080 $ Margin % 20.00% 20.00% 15.00 % 12.00% 12.00% 10.00% 55,100 Labor Cost in Beg WIP $ 600 475 0 3,400 $ Server Hours Used 120 350 Sales Mix % 25.00% 20.00% 12.00% 15.00% 18.00% 10.00% Current Period Labor Costs 4,500 Labor Hours Used 4160 2080 5200 4160 2080 Total Cost per Employee (Hours x Rate) $ $ $ $ $ 29,120 41,600 11,440 24,960 37,440 questions: • Product 1 is made the most. Calculate the ending WIP balance in units and dollars using the weighted average method. All other products were finished at year-end. All materials are added at the beginning of the process. • Allocate the service departments' costs to the operating departments using the reciprocal method. The allocation of IT Department costs is based on server hours and the Administration Department costs are allocated based on labor hours. • Calculate the total cost of each product. • Calculate the Break-Even in Units Sold for the given sales mix of products. • Calculate the Units Sold needed for the given sales mix of products for the company to make $250,000 in profit. Calculate the Overhead for In-Store operations and Online operations. • Use the above overhead to see which sales method is the most profitable, Online or In-Store. If you had $100,000 to invest in the business, which product would you invest in, and would you push it Online or In- Store?
Expert Answer:
Related Book For
Fundamentals of Investment Management
ISBN: 978-0078034626
10th edition
Authors: Geoffrey Hirt, Stanley Block
Posted Date:
Students also viewed these accounting questions
-
Situation 1 Espino Company has the following stock outstanding: Common Stock Preferred Stock 100,000 shares 9,000 shares s0.50 par value s20 par, $2 dividend The amount available for dividends this...
-
John saved $4000 and he invested part of it in his saving account that paid 4% per year and the rest of his saving in stocks that paid 8% per year. The total interest after 1 year became $400 with...
-
A corporation buys $100 par value preferred stock of another corporation. The dividend payment is 7.8 percent of par. The corporation is in a 35 percent tax bracket. a. What will be the after-tax...
-
What are the main advantages and disadvantages of using 360 degree appraisal?
-
Why is interfunctional cooperation important for new-product design? What are the symptoms of a possible lack of interfunctional cooperation?
-
Fifty (50) households were surveyed to determine the number of TVs in each of the households. The number of TVs in each household is shown in the chart below. What is the average number of TVs per...
-
The one-dimensional heat equation is solved on a grid consisting of \(N\) spatial grid points and \(M\) time layers. The boundary conditions are of Dirichlet type. Calculate, in terms of \(N\) and...
-
Bjerg Company specializes in manufacturing a unique model of bicycle helmet. The model is well accepted by consumers, and the company has enough orders to keep the factory production at 10,000...
-
Review applicable AICPA Accounting and Review Services standards. 2) A current audit client (Acme Manufacturing, Corp.) is aware there are other types of assurance services. The CFO, Joan Brown, a...
-
Presented below are the financial statements of Rocastle Company. Additional data:1. Dividends of $23,000 were declared and paid.2. During the year equipment was sold for $10,000 cash. This equipment...
-
Not all logarithmic and exponential equations can be solved algebraically. Use technology to solve the equation 3 2x-3 = log 2 (2) to 4 decimal places. Include a sketch or screenshot in your solution.
-
5. (5 marks) An island has two types of inhabitants: Knights who always tell the truth and knaves who always lie. On the island, you encounter A, B, and C who are inhabitants of the island. A says...
-
Suncity Pty Ltd operates a hotel in the New South Wales ski fields, providing accommodation, bar and restaurant facilities for tourists. Casual and part-time wages are a major expense item,...
-
What are the human behaviors economists should observe when creating economic models? Example: people tend to find solutions that are good enough, but not the best solutions. 2) two examples pf how...
-
What is your prescription ( refractive power ) if you measure your lenses to have a focal length of - 1 4 . 2 cm ?
-
Two objects with equal amounts and types of charge are separated by a distance of 34.2 cm. They repel each other with an electric force of 5.36 N. Determine the amount of charge on one of the objects.
-
I'm confused by this?. 2 The Singer Division of Patio Enterprises currently earns $4.25 million and has divisional assets of $25 million. The division manager is considering the acquisition of a new...
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
In problem 6, if the Treasury bill had only three months to maturity, a. How much interest would the investor receive? b. What would be the price of the Treasury bill? c. What would be the effective...
-
Why are stock index futures and options sometimes referred to as derivative products? Why do some investors believe derivative products make the markets more volatile?
-
Compute the duration for the data in problem 1. Use an approach similar to that in Table 182 on page 469. A discount rate of 13 percent should be applied.
-
Enter the following items in the necessary debtors accounts only; do not write up other accounts. Then balance down each personal account at the end of the month. 19X6 May 1 33 " " " 9 4 10 18 20 24...
-
Enter the following in three-column cash book. Balance off the cash Pook at the end of the month and show the discount accounts in the general ledger. 19X8 June 1 Balances brought forward: Cash 97;...
-
. Enter the following in the personal accounts only. Do not write up the other accounts. Then balance down each personal account at the end of the month. 19X8 June 1 Purchases on credit from J Young...
Study smarter with the SolutionInn App