asap with cell referencing please

8- using your information from number seven compute the annual contribution margin, the breakeven in dollars for the year, and the margin of safety in dollars for the year. Make sure you are using cell referencing comment on your results, including a discussion of cost behavior.

Contribution margin ratio:

Break even in dollars:

margin of safety in sales dollars:

Comment on your results:

9- What is the Company is able to lower the fixed manufacturing overhead costs that uses cash per quarter from $18,000-$14,000. Which budget will change and what will be the new annual income? You should only have change the fixed manufacturing overhead costs that uses cash on this worksheet and all the appropriate budget will change on the solution worksheet if you have set up your cell referencing correctly. Please make sure you return the fixed manufacturing overhead cost that uses cashback to the original number before you submit your solution.

The following budget would change:

annual net income:

Part 1 relates to Module 22 make sure you take time to Review 224, which also has a video in MBC that walks you through the review. I haw budgot support materal in the Module 22 folder in the course Computer Accessones assembies a computer networkang device from kits of imported components. You have been asked to dewilop a quarterfy and annual operating budget and a pro-forma income stalements for the year ending December 31,20x You haw oblainod the following infornation I have a ternplate set up on the PartiBudgetSolution workshoet that you showh ure to complete the roquired budgots You need to use cell references in the development of your budgets. You must use this worksheet to reference the data that is being inputted onto the budgets on the budget worksheet. If you type in any numbers in the solution, I will take off 5 pts for each cell that has a number typed in the cell. You should use this worksheet as your data ficld and only une ced refercnces and formulas in your budgets The beauty behind excel is that managers can perform what-if analysers jest by changing the data, so you do not noed to retype the budgots if you have used cell references and formulas throughout elling and administrative costs are paid in quarter incurred uniess it is an noncash exnence