Question
Can someone double-check my work,please? 2. Come up with 5 variable costs of your company and enter them on the Excel tab in lines 3-7.
Can someone double-check my work,please?
2. Come up with 5 variable costs of your company and enter them on the Excel tab in lines 3-7. Enter the name of the variable cost in column A and the amount per unit in column B. 3. In cell B8, use an Excel formula to sum the variable costs. Anywhere you see "FORMULA," you must use an Excel function. 4. Come up with 5 fixed costs of your company and enter them on the Excel tab in lines 11-15. Enter the name of the fixed cost in column A and the total amount in column B. 5. In cell B16, use an Excel formula to sum the fixed costs. 6. Enter the selling price per unit in cell B18. 7. Enter the total projected number of units the company will sell in cell B19. 8. In cell K4, use the appropriate Excel function to solve for Sales Revenue. This should link to other cells in your data set. 9. In cell K5, use the appropriate Excel function to solve for total variable costs by linking to other cells in your data set. 10. Complete K6, K7, and K8 accordingly. Note: At this point, your income statement should function properly so feel free to play around with your price per unit and number of units sold. 11. In cell B21, enter the Excel function to solve for the contribution margin ratio. Be sure to link to the appropriate numbers in your income statement. 12. In cell B22, enter the Excel function to solve for the contribution margin per unit. 13. In cell B23, enter the Excel function to solve for the break-even point in units. 14. In cell B24, enter the Excel function to solve for the break-even point in dollars. 15. In cell B25, enter the Excel function to solve for magnitude of operating leverage. 16. In cell B26, enter the Excel function to solve for Margin of Safety as a % at target profit of $300,000. 17. In cell B27, enter the Excel function to solve for target profit of $300,000. 18. In cell B28, enter the Excel function to solve for target profit of $1,200,000. 19. Summarize your company results under "Summary" below. What type of cost structure does your company use and why? Are you relying more heavily on fixed costs, variable costs, a combination? In your summary, discuss what the magnitude of operating leverage tells you. What happens to profitability with a 10% increase or decrease in sales? Also, discuss margin of safety at target profit of $300,000. What does this number tell you? When submitting your project, leave the sales units at target profit of $300,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started