Please assist with the attached questions. Include formulas in the excel sheet, not just the final answer. This will help gain a better understanding of the questions.

Profitability Analysis Assume a local Cost Cutters provides cuts, perms, and hairstyling services. Annual fixed costs are $135,000, and v (a) Determine its break-even point in sales dollars. $ (b) Determine last year's margin of safety in sales dollars. $ (c) Determine the sales volume required for an annual profit of $50,000. $ osts are $135,000, and variable costs are 50 percent of sales revenue. Last year's revenues totaled $310,000. Multiple Product Planning with Taxes In the year 2008, Wiggins Processing Company had the following contribution income statement: HINT: Round the contribution margin ratio to two decimal places for your calculations belo (a) Determine the annual break-even point in sales dollars. (b) Determine the annual margin of safety in sales dollars. (c) What is the break-even point in sales dollars if management makes a decision that increases fi (d) With the current cost structure, including fixed costs of $270,000, what dollar sales volume is Do not round until your final answer. Round your answer to the nearest dollar. (e) Prepare an abbreviated contribution income statement to verify that the solution to part (d) w Round your answers to the nearest dollar. Use rounded answers for subsequent calculations. Do CALCULATIONS: Sales Variable Costs (64% Contribution Margi Fixed Costs Net Income before Income taxes (39%) Net Income after ta ur calculations below. ision that increases fixed costs by $36,000? ollar sales volume is required to provide an after-tax net income of $150,000? solution to part (d) will provide the desired after-tax income. ent calculations. Do not use negative signs with any of your answers. CALCULATIONS: Variable Costs (64%) Contribution Margin Fixed Costs Net Income before taxes Income taxes (39%) Net Income after taxes Contribution Income Statement and Operating Leverage Florida Berry Basket harvests early-season strawberries for shipment throughout the eastern United States in Ma containing 100 individually packaged one-quart containers. Affixed to each one-quart container is the distinctive $271,000 per year. In the year 2008, Florida Berry Basket sold 45,000 crates. (a) Prepare a contribution income statement for the year ended December 31, 2008. HINT: Use a negative sign w (Include calculations) SALES VARIABLE COSTS CONTRIBUTION MARGIN FIXED COSTS NET INCOME (b) Determine the company's 2008 operating leverage. (Round your answer to two decimal places.) (c) Calculate the percentage change in profits if sales decrease by 10 percent. (Round your answer to one decima % decrease (d) Management is considering the purchase of several berry-picking machines. This will increase annual fixed co Calculate the effect of this acquisition on operating leverage and explain any change. (Round your answer to two The acquisition of the berry-picking machines will decrease variable costs, thereby increasing the contribution m The acquisition of the berry-picking machines will increase variable costs, thereby increasing the contribution ma The acquisition of the berry-picking machines will reduce variable costs, thereby increasing the contribution mar The acquisition of the berry-picking machines will increase variable costs, thereby increasing the contribution ma 00 0 Cost-Volume-Profit Relations: Missing Data Following are data from 4 separate companies. Supply the missing data in each independent case Case A Unit Sales Sales Revenue Variable Cost Per Unit 1,000.00 Net Income Case C 10.00 Case D 800.00 20,000.00 Contribution Margin Fixed Costs Case B 60,000.00 2.00 10.00 800.00 8,100.00 60,000.00 600.00 Unit Contribution Margin 13.00 Break-even point (units) 4,000.00 2,000.00 Margin of Safety (units) 100.00 1,000.00 CVP Analysis and Special Decisions Sweet Grove Citrus Company buys a variety of citrus fruit from growers and then processes the f One staff member has proposed that Sweet Grove purchase more automated processing equipm Another staff member has suggested that Sweet Grove rely more on outsourcing for fruit proces Round your answers to the nearest whole number. (a) What is the current break-even point in sales dollars? (b) Assuming an income tax rate of 38 percent, what dollar sales volume is currently required t (c) In the absence of income taxes, at what sales volume will both alternatives (automation an (d) Briefly describe one strength and one weakness of both the automation and the outsourcin Automation has higher profits if sales increase. Outsourcing has less risk and a lower break-even Automation has higher profits if sales increase and a lower break-even point. Outsourcing has le Automation has less risk and a lower break-even point. Outsourcing has higher profits if sales inc Automation has less risk. Outsourcing has higher profits if sales increase and a lower break-even then processes the fruit into a product line of fresh fruit, juices, and fruit flavorings. The most recent year' d processing equipment. This strategy would increase fixed costs by $300,000 but decrease variable costs rcing for fruit processing. This would reduce fixed costs by $300,000 but increase variable costs to 65 perce currently required to obtain an after-tax p(b) Assuming an income tax rate of 38 percent, what dollar sa ves (automation and outsourcing) provide the same profit? n and the outsourcing alternatives. a lower break-even point. . Outsourcing has less risk. her profits if sales increase. a lower break-even point.rofit of $300,000? he most recent year's sales revenue was $4,200,000. Variable costs were 60 percent of sales and fixed cost rease variable costs to 54 percent of sales. ble costs to 65 percent of sales. cent, what dollar sales volume is currently required to obtain an after-tax profit of $300,000? f sales and fixed costs totaled $1,400,000. Sweet Grove is evaluating two alternatives designed to enhance 300,000? designed to enhance profitability