I apologize. I am requesting help with # 6-9

Budget #1 Computer Accessories Sales Budget For the year ending December 31, 2019 Annual Total Units Sales price Sales Budget First Quarter 3,200 $110 $352,000 Second Quarter 2.600 $110 $286,000 Fourth Third Quarter Quarter 2900 $110 $110 $319,000 $440,000 $1,397,000 Budget #2 Computer Accessories Production Budget For the year ending December 31, 2019 Second Fourth First Quarter Quarter Third Quarter Quarter 3,200 2,600 2,900 4,000 390 435 600 270 3,590 3,035 3,500 4,270 480 390 435 600 3,110 2,645 3,065 3,670 Unit sales Desired Ending Inventory Total Requirements Less Beginning Inventory Budgeted Production in units Annual Total 12,700 270 14,395 480 12,490 Beginning-of-year balances Cash Accounts receivables (previous quarter's sales) Raw materials Finished Goods Accounts payable 20000 61200 653 Kits 510 Units 33255 Budget #3 Computer Accessories Purchases Budget For the year ending December 31, 2019 Desired end-of-year inventory balances Raw materials 500 kits Finished goods 270 units Budgeted production in units Desired ending inventory of kits Total Requirements Less Beginning Inventory Kits Purchase requirements in kits Cost per kit Total purchases of kits in dollars Second First Quarter Quarter 3,110 2,645 529 613 3,639 3,258 622 529 3,017 2,636 50.00 $ 50.00 $ 150,850 $ 131,800 Fourth Third Quarter Quarter Annual Total 3,065 3,670 12,490 734 500 500 3,799 4,170 12,990 613 734 622 3,177 3,548 12,378 $ 50.00 $ 50.00 $ 50.00 $ 158,850 $ 177,400 $ 618,900 Desired end-of-quarter balances Raw materials as a portions of the following quarter's prod Finished goods as a portion of the following quarter's sales 20% 15% Manufacturing costs other than raw materials are paid in month incurred unless it is an noncash expense Variable Standard Unit of input Unit price per inp Total cost per unit Raw materials 1 kit $ 50.00 $ 50.00 Direct labor hours 0.8 hour S 25.00 $ 20.00 Variable overhead 0.8 hour $ 10.00 $ 8.00 Total Variable Standard cost per unit $ 78.00 Budget #4 Computer Accessories Manufacturing Cost Budget For the year ending December 31, 2019 Second Fourth Third Quarter Quarter First Quarter Annual Total Fixed overhead cost per quarter used cash Manufacturing Depreciation per quarter 40000 5000 Direct Materials: Budgeted production in units Cost per kit Direct material cost S $ 3,110 50.00 155,500 $ $ 2,645 50.00 132,250 $ $ 3,065 50.00 153,250 $ $ 3,670 50.00 183,500 $ $ 12,490 50.00 624,500 Selling and administrative costs are paid in month incurred unless it is an noncash expense Variable cost per unit Fixed selling and administrative cost per quarter used cas! 25000 Selling and administrative depreciation per quarter 5000 Additional information: All cash payments except purchases are made quarterly as incurred. Direct labor Budgeted production in units Direct labor cost per unit Direct labor cost 3,110 20.00 62,200 $ $ 2,645 20.00 52,900 $ $ 3,065 20.00 61,300 $ $ 3,670 20.00 73,400 $ $ 12,490 20.00 249,800 S Portion of sales collected Collected in the quarter of sale Subsequent quarter Bad debts 70% 28% 2% Variable Manufacturing Overhead: Budgeted production in units Variable Overhead cost per unit Variable Manufacturing Overhead 3,110 8.00 24,880 $ $ 2,645 8.00 21,160 3,065 8.00 24,520 $ $ 3,670 8.00 29,360 $ $ $ 12,490 8.00 99,920 $ $ Portion of purchases paid Paid in the quarter of purchases Subsequent quarter Fixed Manufacturing Overhead: $45,000 65% 35% $45,000 $45,000 $45,000 $45,000 Total Manufacturing Costs $ 287,580 $ 251,310 $ 284,070 $ 331,260 $ 1,019,220 Unit selling price $ 110.00 Sales forecast Budget #5 First Second Third Quarter Unit sales Fourth 2900 3200 2600 4000 Computer Accessories Selling and Administrative Expenses Budget For the year ending December 31, 2019 Second Fourth Quarter Third Quarter Quarter 2,600 2,900 4,000 $286,000 $319,000 $440,000 Annual Total Budgets Sales Units from Budget #1 Budgets Sales Dollars from Budget #1 First Quarter 3,200 $352,000 Variable selling and admin. expenses: 73 Budget #6 Computer Accessories Cash Budget For the year ending December 31, 2019 Second Fourth Quarter Third Quarter Quarter Annual Total First Quarter $45,000 Cash Balance, Beginning Collection on sales: Collected in current quarter Collected in subsequent quarter Total collection on sales Cash available for operations Cash Disbursements: Purchases: Paid in Current quarter Paid in subsequent quarter Direct labor Variable Manufacturing Overhead Fixed Manufacturing Overhead Variable selling and administrative expenses Fixed selling and administrative expenses Total Disbursements Cash Balance, Ending 95 97 98 Budget #7 99 100 101 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. Computer Accessories Pro Forma Contribution Margin For the year ending December 31, 2019 Second Fourth First Quarter Quarter Third Quarter Quarter Annual Total Sales Revenue Less Variable Costs: Cost of Goods sold Selling and Administrative expenses Total Variable costs 104 105 106 107 108 109 110 Contribution margin 111 112 113 Less Fixed Costs: Manufacturing Overhead Selling and Administrative Expenses Total Fixed Costs Net Income 114 115 116 117 #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 118 margin ratio Breakeven in 119 Dollars Margin of Safety in Sales 120 Dollars Comment on 121 your results. 122 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? 124 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 125 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. 126 127 The following budgets would change: 128 New annual net income: 129 130 131 132 133