Please check my answers in the Total Column for the tasks 5, 6, and 7, i am confused. Thank you!

.

61 Budget #5 Computer Accessories Selling and Administrative Expenses Budget For the year ending December 31, 2019 Budgets Sales Units from Budget #1 Budgets Sales Dollars from Budget #1 First Quarter $3,200 $352,000 Second Quarter $2,600 $286,000 Third Quarter Fourth Quarter Annual Total $2,900 $4,000 $12,700 $319,000 $440,000 $1,397,000 Variable selling and admin. expenses: Bad Debts Variable selling and admin. expenses Total variable selling and admin. Expenses Fixed Selling and administrative Expenses Total selling and administrative expenses $7,040 $19,200 $26,240 $25,000 $51,240 $5,720 $15,600 $21,320 $25,000 $46,320 $6,380 $17,400 $23,780 $25,000 $48,780 $8,800 $24,000 $32,800 $25,000 $57,800 $27,940 $76,200 $104,140 $25,000 $129,140 Budget #6 Computer Accessories Cash Budget For the year ending December 31, 2019 Second First Quarter Quarter $20,000 Third Quarter Fourth Quarter Annual Total Cash Balance, Beginning Collection on sales: Collected in current quarter absequent quarter Total collection on sales $246,400 $61,200 $307,600 $200,200 $68,992 $269,192 $223,300 $56,056 $279,356 $308,000 $62,524 $370,524 $977,900 $86,240 $1,064,140 Cash available for operations $327,600 $269,192 $279,356 $370,524 $1,064,140 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 $154,483 $33,255 $80,000 $19,200 $40,000 $26,240 $25,000 $378,178 ($50,578) $137,367 $54,069 $65,000 $15,600 $40,000 $21,320 $25,000 $358,356 ($89,164) $143,607 $48,078 $72,500 $17,400 $40,000 $23,780 $25,000 $370,365 ($91,009) $204,048 $50,262 $100,000 $24,000 $40,000 $32,800 $25,000 $476,110 ($105,586) $655,978 $71,417 $317,500 $76,200 $40,000 $104,140 $25,000 $1,290,235 ($226,095) 102 Budget #7 103 Hint: You will need to compute Variable Cost of Goods Sold for each quarter, which is unit sold times total Variable Standard c Computer Accessories Pro Forma Contribution Margin For the year ending December 31, 2019 First Quarter $352,000 Second Quarter $286,000 Third Quarter Fourth Quarter Annual Total $319,000 $440,000 $1,397,000 Sales Revenue Less Variable Costs: Cost of Goods sold Selling and Administrative expenses Total Variable costs $249,600 $19,200 $268,800 $202,800 $15,600 $218,400 $226,200 $17,400 $243,600 $312,000 $24,000 $336,000 $990,600 $76,200 $1,066,800 Contribution margin $83,200 $67,600 $75,400 $104,000 $330,200 Less Fixed Costs: Manufacturing Overhead Selling and Administrative Expenses Total Fixed Costs Net Income $40,000 $25,000 $40,000 $25,000 $65,000 $18,200 $40,000 $25,000 $65,000 $2,600 $40,000 $25,000 $65,000 $10,400 $40,000 $25,000 $65,000 $265,200 $39,000 61 Budget #5 Computer Accessories Selling and Administrative Expenses Budget For the year ending December 31, 2019 Budgets Sales Units from Budget #1 Budgets Sales Dollars from Budget #1 First Quarter $3,200 $352,000 Second Quarter $2,600 $286,000 Third Quarter Fourth Quarter Annual Total $2,900 $4,000 $12,700 $319,000 $440,000 $1,397,000 Variable selling and admin. expenses: Bad Debts Variable selling and admin. expenses Total variable selling and admin. Expenses Fixed Selling and administrative Expenses Total selling and administrative expenses $7,040 $19,200 $26,240 $25,000 $51,240 $5,720 $15,600 $21,320 $25,000 $46,320 $6,380 $17,400 $23,780 $25,000 $48,780 $8,800 $24,000 $32,800 $25,000 $57,800 $27,940 $76,200 $104,140 $25,000 $129,140 Budget #6 Computer Accessories Cash Budget For the year ending December 31, 2019 Second First Quarter Quarter $20,000 Third Quarter Fourth Quarter Annual Total Cash Balance, Beginning Collection on sales: Collected in current quarter absequent quarter Total collection on sales $246,400 $61,200 $307,600 $200,200 $68,992 $269,192 $223,300 $56,056 $279,356 $308,000 $62,524 $370,524 $977,900 $86,240 $1,064,140 Cash available for operations $327,600 $269,192 $279,356 $370,524 $1,064,140 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 $154,483 $33,255 $80,000 $19,200 $40,000 $26,240 $25,000 $378,178 ($50,578) $137,367 $54,069 $65,000 $15,600 $40,000 $21,320 $25,000 $358,356 ($89,164) $143,607 $48,078 $72,500 $17,400 $40,000 $23,780 $25,000 $370,365 ($91,009) $204,048 $50,262 $100,000 $24,000 $40,000 $32,800 $25,000 $476,110 ($105,586) $655,978 $71,417 $317,500 $76,200 $40,000 $104,140 $25,000 $1,290,235 ($226,095) 102 Budget #7 103 Hint: You will need to compute Variable Cost of Goods Sold for each quarter, which is unit sold times total Variable Standard c Computer Accessories Pro Forma Contribution Margin For the year ending December 31, 2019 First Quarter $352,000 Second Quarter $286,000 Third Quarter Fourth Quarter Annual Total $319,000 $440,000 $1,397,000 Sales Revenue Less Variable Costs: Cost of Goods sold Selling and Administrative expenses Total Variable costs $249,600 $19,200 $268,800 $202,800 $15,600 $218,400 $226,200 $17,400 $243,600 $312,000 $24,000 $336,000 $990,600 $76,200 $1,066,800 Contribution margin $83,200 $67,600 $75,400 $104,000 $330,200 Less Fixed Costs: Manufacturing Overhead Selling and Administrative Expenses Total Fixed Costs Net Income $40,000 $25,000 $40,000 $25,000 $65,000 $18,200 $40,000 $25,000 $65,000 $2,600 $40,000 $25,000 $65,000 $10,400 $40,000 $25,000 $65,000 $265,200 $39,000