Luxor Cosmetics Executive Summary Essay

Question 1 2008Variable manufacturing cost as a percentage of selling price Product(Variable manufacturing cost/WSP Production)Mark up Lipstick16.8/2180%(21/16.8)-125% Nail polish10.5/1570%(15/10.5)-143% Creams2.8/5.650%(5.6/2.8)-1100% 2010 Product Lipstick15.3/1885%(18/15.3)-118% Nail polish9.3/11.680%(11.6/9.3)-125% Creams3.3/6.650%(6.6/3.3)+1100% *Note that these calculations are done for goods produced in the year in question Question 2 (cost of goods manufactured in 2008/ sales value for units produced in 2008) * ending inventory 2008 (16.8/21) * 11.5 9.748million Question 3 Luxor uses a FIFO inventory system, so the inventory that is sold first actually may come from prior years. Because of this, goods that are sold in each year need to be separated into goods produced in that year and goods produced in prior years. This is necessary to do because the percentage of the COGS that is variable is slightly different from year to year. 2009 Cost of Goods Sold: 6.3M from inventory on hand at beginning of year (produced in 2008 under FIFO) 2.3M from inventory produced in 2009  2010 Cost of Goods Sold:  8.2M from inventory on hand at beginning of year (produced in 2009 under FIFO) 0.3M from inventory produced in 2010  We now must determine the percentage of COGS that is variable for goods produced in 2008, 2009 and 2010: 2008 10.5M/(10.5M+0.7M) =93.75% 2009 9.8M/(9.8M+0.7M) = 93.333333% 2010 9.3M/(9.3M+0.6M) =93.939393% We now apply these percentages to the COGS for 2009 and 2010 to determine the total variable cost for each year. 2009 Variable COGS = (6.3M * .9375) + (2.3M * .93333333) = $8.0529M 2010 Variable COGS = (8.2M * .93333333) + (0.3M * .9393939393) = $7.9352M Assuming the variable manufacturing cost per unit was the same in 2009 and 2010, a higher variable cost of goods sold means that more units were sold. Since the variable COGS in 2009 is higher in 2009 than it is in 2010, we can conclude that the sales volume of nail polish decreased in 2010. Question 4 Let x = Break Even SalesF = Marketing & Promotion + General Administration + Interest + Fixed Manufacturing Costs Let F = Total Fixed CostsF = 3.4 + 1.3 + 1.8 + 1 Let V = Variable Costs Per Dollar of Sales7.5 V is easily estimated by (COGS-Fixed Costs) /Sales There is a small amount of fixed costs in COGS which means that it is not strictly variable, but for our purposes that makes a very small, immaterial difference and the question only requires an approximation. V = (27.7-1)/33.5 0.7970 x = F + Vx x = 7.5 + 0.7970x 0.2030x = 7.5 x = 36.95 Break even sales are approximately $36.95 Million Question 5 Let x = Break Even SalesF = Marketing & Promotion + General Administration + Interest Let F = Total Fixed CostsF = 3.3 + 1.3 + 1.1 + 1 Let V = COGS Per Dollar of Sales6.7 Again, V is easily estimated by COGS/Sales There is a small amount of fixed costs in COGS which means that it is not strictly variable, but for our purposes that makes a very small, immaterial difference and the question only requires an approximation. V = (27.7-1)/33.5 0.7970 x = 33.00 x = F + Vx x = 6.7 + 0.7970x 0.2030x = 6.7 The new breakeven sales for 2012 would be approximately 33.00, given that 2012 is approximately similar to 2011. The firm is more likely to breakeven than the previous year if they can keep their sales constant and do not produce more than they can sell. Although with current trends of sales over the past few years, it could be estimated that breakeven is not likely. With the current trends sales could be estimated somewhere around 32 million, in which case the firm would not breakeven in 2012. Question 6 Inventory Schedule – 2011 Budget InventoryLipstickNail PolishCreams Inventory (12/31 2010 Actual)15.011.41.2 Planned Production * 19.013.08.0 Goods Available for Sale34.024.49.2 Budgeted Sales19.013.08.0 Ending Inventory (12/31/2011 Budget)15.011.41.2 * Planned production is to produce the same amount as the planned sales, as per sales manager Budgeted Cost of Goods Manufactured and Sold – 2011 Budget Variable Manufacturing Cost (Budget)0.90.90.6 17.911.74.4 Fixed Manufacturing Cost (Budget)0.80.60.6 Cost of Goods Manufactured18.712.35.0 Inventory (12/31/2010 Actual) 13.69.60.7 Goods Available for Sale32.321.95.7 Inventory (12/31/2011 Budget)0.90.90.6 14.110.40.7 Budgeted Cost of Goods Sold 18.211.45.1 MARGINS1.01.11.6 0.00.10.6 Variable Manufacturing Cost – First, find the factor of Variable Manufacturing cost to planned production, less fixed manufacturing cost i.e. – 6.8/(8.0-.0.8) = 0.9 (From Exhibit 2) Inventory – Find the factor of budgeted ending inventory cost to budget inventory value i.e. – 6.6/7.0 = 0.9 (from Exhibit 2) Margins – (Budgeted Sales/Budgeted Cost of Goods Sold) – 1 i.e. – (19.0/18.2) – 1 = 1.0 (rounded) Income Statement – 2011 BudgetCash Flow – 2011 Budget Sales40.0Cash Receipts From Customers40.0 Cost of Goods Sold34.7 Gross Margin5.3Cash disbursements Marketing & Promotion3.6Variable Manufacturing34.1 General Administration1.3Fixed Manufacturing1.0 Interest1.8Marketing and Promotion3.6 Pretax Income-1.4General Administration1.3 Interest1.8 Pro-Forma Year-End Balance Sheet – 2011 BudgetTotal Disbursements41.8 Assets Cash0.0Beginning Cash5.5 Miscellaneous Current Assets3.0+ Receipts40.0 Inventory0.0- Disbursements41.8 Property & Equipment11.2- Loan Repayment10.0 Goodwill9.3Ending Cash (Budgeted)-6.3 Total Assets23.5 Equities Bank Loan16.3 Miscellaneous Current Liabilities4.0 Common Stock12.5 Retained Earnings *9.7 Total Equities42.5 * The Retained Earnings are 9.7 in this budget, which is adjusted from the previous budget to account for an additional $0.7 M loss i.e. – 10.4 – 0.7 = 9.7 Question 7 Through the implementation of the suggested changes in allocation, more of the fixed costs will be allocated to the cream products because this product line has the highest margin (as shown in the budgeted Cost of Goods Manufactured above), even though creams have the lowest total sales value. This will lead to more of the fixed costs being incorporated into the Cost of Goods sold, and not into the ending inventory numbers, therefore decreasing pre-tax income even further. Allocating the fixed costs in this manner would not affect the Cash Flow Statement in any way, as the fixed costs would still lead to a cash disbursement of an equal value regardless of which product line they are allocated to. Question 8 Luxor Cosmetics is a company that is stuck in a dying market because most of their customers that buy the lipstick and nail polish are women aged 45 to 75 who are in the lower income group. As that group gets older and older they have less need for cosmetics so they buy less and less. The sales will continue to drop and we will get less and less profitable. A way to combat this is to reposition ourselves in the market. We need to find a way to get ourselves into a better market that is more eager to buy cosmetics. One way of doing this would be to start targeting a new demographic of women who will buy our products. We could also avoid the non-wholesale market because that way we would get bigger orders and be able to budget better. However if we do this we will have to consider the possibility that we will have to lower our prices and we will have less profits in the end but we will have more sales. We should reinvest in the company that we purchased in the 1990s. We had a product t hat we were going to aim at teenagers but we abandoned the company due to the dotcom crash; we should look at getting that company running. We should reinvest in the company that we abandoned because the market has recovered now. We would get a brand new customer base and we could have increased sales. Plus we already own the company and it does no benefit to us just sitting on the books not generating any profits. It is an environmentally friendly product and environmentally friendly products are becoming more and more popular today. We could make the company seem very socially responsible and that would build us a better reputation and may make our sales in our existing company increase substantially. The goodwill that is on the books today was acquired when we bought the environmentally friendly company in the 1990’s and yet we have not revalued it since then. The asset impairment test should be done on goodwill to see how much of the goodwill exists anymore. It is possible that the asset of goodwill should not exist on the books for Luxor at all anymore. And it is just making our financial statements misleading for investors. If we adjust this properly we will have a more realistic picture of our company as it stands now. This way we will not have misleading financial statements anymore. There are a few ethical issues in the case. The first is that there is pressure for the numbers to be fudged, but as a  professional accountant that cannot be done. We do not want to make the statements misleading so that the bank is coaxed into giving us a loan that we cannot afford. We cannot fudge the statements to meet our needs because someone would figure it out and we would not get away with it and overall it is highly unethical. The other is following the policy that is set in place for how to account for certain things. If our inventory is not usable anymore we should not be keeping it on the books hoping it will make us look better. This is not appropriate and should be written off and adjusted for the fact that it is now obsolete.