Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Matthew Gabon, the sales manager of Office Furniture Solutions, prepared the fol

ID: 2665104 • Letter: M

Question

Matthew Gabon, the sales manager of Office Furniture Solutions, prepared the following budget for 2008:
Sales Department
Budgeted Costs, 2008
(Assuming Sales of $12,000,000)
Salaries (fixed) 500,000
Commissions (variable) 180,000
Advertising (fixed) 100,000
Charge for office space (fixed) 2,400
Total 784,400

After he submitted his budget, the presdient of Office Furniture Solutions reviewed it and recommended that advertising be increased to $120,000. Further, she wanted Matthew to assume a sales level of $13,000,000. This level of sales is to be achieved without adding to the sales force.
Matthew's sales group occupies approximately 250 square feet of office space out of total administrative office space of 20,000 square feet. The $2,000 space charge in Matthew's budget is his share (allocated based on relative square feet) of the company's total cost of rent, utilities, and janitorial costs for the administrative office building.

Prepare a revised budget consistent with the president's recommendation.

Explanation / Answer

President recomended budget fot 2008 is as floows.. Budegeting As per president Actual recomandation 2008 2008 sales 12000000 13000000 variable cost: commission 180000 195000 contribution 11820000 12805000 Fixed cost: salries 500000 500000 charge for office space 2400 240 Advertising 100000 120000 Profit 11217600 12184760 Here space has calicualted : for 20000 square feet -----paid $2000 Relevent space 250 sqf =[250/20000] * 2000 = 240 and variable cost of commission calicualted as follwos.. 12000000 sale......180000 for 13000000 .../ = [13000000 /12000000] * 1800000 = $195000 Budegeting As per president Actual recomandation 2008 2008 sales 12000000 13000000 variable cost: commission 180000 195000 contribution 11820000 12805000 Fixed cost: salries 500000 500000 charge for office space 2400 240 Advertising 100000 120000 Profit 11217600 12184760