ACCT301 Week 6 Homework – Problem # 14-16 on page 528 – Perfect Solution – Instant Delivery

Lab Price = \$9
Please feel free to send us your queries at: support@iqrajavaid.com
Payment methods

Problem Statement
Problem # 14-16 on page 528 using Excel. Formulas are required.

Problem 14-16 Behavioral impact of budgeting Butler Corporation has three divisions, each operating as a responsibility center. To provide an incentive for divisional executive officers,the company gives divisional management a bonus equal to 15 percent ofthe excess ofactual net income over budgeted net income. The following is French Division’s current year’s performance

Current Year
Sales revenue \$2,000,000
Cost of goods sold 1,250,000
Gross profit 750,000
Selling & admin. expenses 450,000
Net income \$ 300,000

The president has just received next year’s budget proposal from the vice pesident in charge of French Division. The proposal budgets a 5 percent increase in sales revenue with an extensive explanation about stiff market competition. The president is puzzled. French has enjoyed reve-nue growth of around 10 percent for each ofthe past fiveyears. The president had consistently approved the division’sbudget proposls based on 5 percent growth in the past. This time, the president wants to show that he is not a fool. “I will impose a 15 percent revenue increase to teach them a lesson!” the president says to himself smugly.

Assume that cost of goods sold and selling and administrative expenses remain stable in proportion to sales.

Required
a. Prepare the budgeted income statementbased on French Division’sproposal of a 5 percent increase.
b. If growth is actually 10 percent as usual, how much bonus would French Division’sexecutive officers receive if the president had approved the division’s proposal?
c. Prepare the budgeted income statement based on the 15 percent increase the president imposed.
d. Ifthe actual results turn out to be a 10 percent increase as usual, how much bonus would French Division’s executive officers receive since the president imposed a 15 percent increase?
e. Propose a better budgeting procedure for Butler Corporation.

CHECK FIGURES
a.Nl:\$315,000
c. Nl: \$345,000

Relevant Material
Screenshots
Instructions
* If you want to purchase multiple products then click on “Buy Now” button which will give you ADD TO CART option.Please note that the payment is done through PayPal.
* You can also use 2CO option if you want to purchase through Credit Cards/Paypal but make sure you put the correct billing information otherwise you wont be able to receive any download link.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received, download link of the solution will automatically be sent to the address used in selected payment method.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please wait for atleast 8 hours for a response from our side. Afterall, we are humans.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.
* MOST IMPORTANT Please use the tutorials as a guide and they need NOT to be used for any submission. Just take help from the material.
******************************************** Good Luck ***************************************************