Trident ACC310 module 4 case and slp

| October 22, 2018

Module 4 – CaseANALYSIS OF PROFITABILITY AND CAPITAL BUDGETINGCase AssignmentThis case has two separate parts.Part IBeautifully Fabulous Beauty Salon (BFBS) manufacturer has two stores. The most recent monthly Income Statement for BFBS.TotalStore IStore IISales$2,000,000$1,200,000$800,000Less variable expenses1,200,000840,000360,000Contribution margin800,000360,000440,000Less traceable fixed expenses400,000220,000180,000Segment margin400,000140,000260,000Less common fixed expenses300,000180,000120,000Net operating income$ 100,000$( 40,000)$140,000BFBS is considering closing Store I. If Store I is closed, one-fourth of its traceable fixed expenses would continue unchanged. Also, the closing of Store I would result in a 20% decrease in sales in Store II. BFBS allocates common fixed expenses on the basis of sales dollars.The following items will be assessed in particular:1. Prepare a new monthly income statement for the company if Store I is closed.2. Evaluate and discuss the impact of the decision of closing Store I.3. Include in your discussion the relevance of traceable and common fixed expenses.Part IIBeautifully Fabulous Beauty Salon manufactures two products, Beauty Gloss and Cocooning Spray. Beauty Gloss is of fairly recent origin, having been developed as an attempt to enter a market closely related to that of Cocooning Spray. Beauty Gloss is produced on an automated production line. Due to the forecast of economic growth, the BFBS is considering purchasing a new machine costing $40,000. The machine will have 10 years of useful life and a salvage value of $6,000. Using the straight-line depreciation method, the original machine cost will be depreciated over 10 years not considering the salvage value in the calculation of the depreciation. The new machine will generate $15,000 in annual net cash flows throughout its useful life (ordinary annuity). To maintain the machine it will require additional working capital of $3,000, which would be released at the end of the useful life. The company’s tax rate is 40% and its discount rate is 10%. Present value tables can be accessed at the following link: .mcgraw-hill.com/sites/0072994029/student_view0/present_and_future_value_tables.html”>http://highered.mcgraw-hill.com/sites/0072994029/student_view0/present_and_future_value_tables.htmlThe following items will be assessed in particular:1. Prepare a NPV table based on the information given and using the table .trident.edu/content/enforced/45240-ACC310-WIN2015-1/Modules/Module5/102757ACC310%20MOD5%20Spreadsheet.xls?_&d2lSessionVal=4asrjJ7huVONc1Bv1XQkE4cau&ou=45240&_&d2lSessionVal=ejogQI6n7oFJtqDt2ilgM2d3L&ou=60964″>BFBS Cost Analysis format. The student may use Periasamy, P. (2010). Textbook of Financial Cost and Management Accounting, Global Media 2010 (read chaps 27-29) as a review source.2. Analyze the data in the NPV table.3. Discuss the decision that should be made concerning the investment in the new machine.As an example, review the spreadsheet below:CashTax EffectAfter-Tax11%PV ofDescriptionYear(s)Flow30%Cash flowsFactorCash FlowNew machine costNow($500,000)-500,0001.0000($500,000)Controls and softwareNow-80,000-80,0001.0000-80,000Salvage of old machineNow12,0000.708,4001.00008,400New annual cost savings1 to 1278,5000.7054,9506.4924356,755Depreciation tax shield1 to 12-45,0000.30-13,5006.4924-87647.4Salvage value of machine1220,0000.7014,0000.28584,002Net present value($298,490.4)When your discussion paper and spreadsheet analysis are done, upload them.Assignment ExpectationsIt is important to answer the questions above. The discussion should be four to six pages and written in a clear and concise manner. Support your discussion with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved.When your paper is done, send it in.Module 4 – SLPANALYSIS OF PROFITABILITY AND CAPITAL BUDGETINGThis SLP has two separate parts.Part IThe objective of Part I is for the student to become familiar with the cost-volume-profit analysis as a tool used for decision making.Review the “Consolidated Statements of Income” In Hershey’s 2007 annual report (ignore all figures below net income, such as, per share information). Using the spreadsheet below fill in requirements 1 through 4 in the spreadsheet using the following data:1. Units Solda. 2005 – 100,000,000 unitsb. 2006 – 100,400,000 unitsc. 2007 – 200,000,000 units2. Variable Manufacturing Costs Percentage – 45% of Cost of Sales3. Variable Marketing Costs Percentage – 15% of Cost of Sales4. Fixed Costs Percentage – 40% of Cost of SalesLENGTH: spreadsheetThe following items will be assessed in particular:I. Instructionsa. Double Click on .trident.edu/content/enforced/45240-ACC310-WIN2015-1/Modules/Module4/102756ACC310%20MOD4%20Worksheet.xls?_&d2lSessionVal=4asrjJ7huVONc1Bv1XQkE4cau&ou=45240&_&d2lSessionVal=ejogQI6n7oFJtqDt2ilgM2d3L&ou=60964″>“Requirement 1”on the spreadsheetb. Scroll down through the spreadsheet; you should see four (4) requirementsc. Fill in the spreadsheet with your analysis answersd. Cut and Paste or save your completed spreadsheet into an excel filee. Upload the excel file.Part IIThe objective of Part II is for the student to become familiar with the budget concepts as a tool used for decision making. There are primarily two types of Budgets; strategic and operational. Strategic budgets are more long term planning; operational budgets are short term. Either budget follows a process of compilation and revision. Revision is caused by feedback from those who are responsible for implementing the budget. The budget compilation process begins with developing a Master Budget. The Master Budget includes the operational and financial plans of the organization. Budgets are used to coordinate, communicate, and motivate managers and employees. Since this course is focused on managerial analysis, we will couch our discussion in the operational budget process.The following items will be assessed in particular:1. Review the analysis of the “Consolidated Statements of Income” in Hershey’s 2007 annual report completed in the Part I. In a 2 to 3 page written report, using the data requirements in 2 and 3 of Part I, create a hypothetical operational budget for 2008.2. Evaluate and discuss the assumptions you made to compile the hypothetical operation budget. The changes made should take into consideration the “What if?” in the requirement 4 section.SLP Assignment ExpectationsIt is important to answer the questions above. The discussion should be four to six pages and written in a clear and concise manner. Support your discussion with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved.When your paper is done, send it in.

Order your essay today and save 30% with the discount code: ESSAYHELP
Order your essay today and save 30% with the discount code: ESSAYHELPOrder Now