B C D E F G H K L M N P Q R S T U V 96 Cash Balance, Ending ($60,978) ($81,364) ($82,309) ($93,586) ($187,995) 98 Budget #7 Hint: You will need to compute Variable Cost of Goods Sold for each quarter, which is unit sold times total Variable Standard cost per unit. 99 Computer Accessories 00 Pro Forma Contribution Margin 01 For the year ending December 31, 2019 Second Third Fourth 02 First Quarter Quarter Quarter Quarter Annual Total 103 Sales Revenue $352,000 $286,000 $319,000 $440,000 $1,397,000 Less Variable Costs: Cost of Goods sold 249,600 202,800 226,200 312,000 990,600 Selling and Administrative expenses $19,200 $15,600 $17,400 $24,000 $76,200 Total Variable costs 268,800 218,400 243,600 336,000 1,066,800 Contribution margin Less Fixed Costs: Manufacturing Overhead $40,000 $40,000 $40,000 $40,000 $40,000 Selling and Administrative Expenses $25,000 $25,000 $25,000 $25,000 $25,000 Total Fixed Costs $65,000 $65,000 $65,000 $65,000 $65,000 Net Income $18,200 $2,600 $10,400 $39,000 $265,200 16 17 #8. Using your information from #7, 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 references. Comment on your results. Contribution 18 margin ratio Breakeven 19 in Dollars Margin of Safety in Sales 20 Dollars Comment on 21 your results. 22 123 #9. What if the company is able to lower the fixed Manufacturing overhead costs that uses cash per quarter from $40,000 to $35,000. Which budgets will change and what will be the new annual income? 24 You should only have to change the fixed manufacturing overhead costs that uses cash on this worksheet and all the appropriate budgets will change on the solution worksheet if you have 25 set up your cell references correctly. Please make sure you return the Fixed manufacturing overhead costs that uses cash back to the original number before you submit your solution. OverviewFinalProject Part 1 Part1 BudgetSolution Part 2 Part 3 Part 4 +