2777 Vettel Man HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW S Cut 111-kA.

Question

2777 Vettel Man HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW S Cut 111-kA. Calibri =E wrap Tent · General Copy ormat Painter B I & Center Form Clipboard Font Alignment Vettel Maunfacturing Inc Selling and Administrative Expenses Budget For the Quarter Ending March 31, 2017 January February March Total Salaries Expense Rent Expense Insurance Expense Depreciation Expense Supplies Expense 1 Total Budgeted Selling and Admin Expense 18 19 20 23 24 25 28 Selling and Admin. Expenses Bud Budgetes . Dil et Labour Cost Budget Factory Overhead Cost Budget O Type here to search ViewSonic

Explanation / Answer

Vettel Manufacturing, Inc Selling & Administrative Expense Budget For The Quarter Ending March 31, 2017 Salaries $8,700.00 $8,700.00 $8,700.00 $26,100.00 Rent $1,800.00 $1,800.00 $1,800.00 $5,400.00 Insurance $250.00 $250.00 $250.00 $750.00 Depreciation $10,050.00 $10,050.00 $10,050.00 $30,150.00 Supplies Expense = Advt. + Freight out + commission $11,249.75 $10,713.39 $12,545.97 $34,509.11 Total Budgeted selling and Admin Exp. $32,049.76 $31,513.39 $33,345.97 $96,909.11 Jan Feb March Total Expected Unit Sales 7450 7090 8320 22860 Expected Sales Dollars (Units x $68.99) $513,975.50 $489,139.10 $573,996.80 $1,577,111.40 Variable Expenses Freight Out = $.80 per unit x unit sales $5,960.00 $5,672.00 $6,656.00 $18,288.00 Sales Commissions = 1% of sales $5,139.76 $4,891.39 $5,739.97 $15,771.11 Total Variable Cost $11,099.75 $10,563.39 $12,395.97 $34,059.11 Fixed Expenses: Salaries $8,700.00 $8,700.00 $8,700.00 $26,100.00 Rent $1,800.00 $1,800.00 $1,800.00 $5,400.00 Advertising $150.00 $150.00 $150.00 $450.00 Insurance $250.00 $250.00 $250.00 $750.00 Depreciation $10,050.00 $10,050.00 $10,050.00 $30,150.00 Total Fixed cost $20,950.00 $20,950.00 $20,950.00 $62,850.00 Total Selling & Administrative Expense (VC + FC) $32,049.76 $31,513.39 $33,345.97 $96,909.11

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.