Question

In: Accounting

For this question, you need to prepare a flexible budget and offer a critical analysis of...

For this question, you need to prepare a flexible budget and offer a critical analysis of the performance of different items.

The following are the budgeted and actual income statements for Baxter Ltd for the month of July:

Output (production and sales)

Budget

1000 units

Actual

1050 units

Sales Revenue

100,000

104,300

Raw materials

(40 000)

(40 000 meters)

(41,200)

(40,500 meters)

Labour

(20 000)

(2,500 hours)

(21,300)

(2,600 hours)

Fixed overheads

(20 000)

19,400

Operating profit

20 000

22,400

All of this is in pounds.

Solutions

Expert Solution

Original budget Flexed budget Actual
Output 1,000 units 1,050 units 1,050 units
(production and sales)
Sales revenue           100,000         105,000        104,300
Raw materials            (40,000)          (42,000)         (41,200)
Labour            (20,000)          (21,000)         (21,300)
Fixed overheads            (20,000)          (20,000)         (19,400)
Operating profit             20,000           22,000          22,400
Analysis: Comparing the flexible budget with actual revenue is less
but operating profit is more in actual. Due to increased raw material
cost and Fixed overhead cost inflexible budget compare to actual,
operating profit is more in the actual result.
Working
Original budget
1,000 units
Sales revenue per unit                 100
Raw materials                   40
Labour                   20

Related Solutions

How do you prepare a flexible budget?
How do you prepare a flexible budget?
Question 3: [18 marks] You need to prepare the budget for Yellow tree for the quarter...
Question 3: [18 marks] You need to prepare the budget for Yellow tree for the quarter ending June 2018. The budget must be prepared monthly. The quarter consists of 13 weeks. The forecasted sales are as follows: April 4 weeks May 5 weeks June 4 weeks July 4 weeks Sales Units 1,250 1,500 1,750 1,800 The company’s policy changed the inventory policy to keep closing inventory of completed units at 25% of the following month’s sales. Opening inventory on the...
Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible...
Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible budget variances are favorable or unfavorable. Headquarters are contemplating charging each store a 5% marketing expense based on sales. How will that affect the operating profit of the store and the money available for managerial bonuses based on actual results for the past year? Summarize the information in a table. (INFORMATION PROVIDED BELOW) T&P Fashion Shops is a new chain that operates 10 stores...
How to prepare a flexible budget for different levels of activity
How to prepare a flexible budget for different levels of activity
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use...
Peter’s Pretzels is preparing their 2018 budget. They want to prepare a flexible budget for use each month. They estimate sales/production will be between 700,000 and 900,000 boxes of pretzels per month. Monthly budget data                      Selling price of pretzels $5.00    per box Ingredient cost $1.50    per box Packaging cost   $0.50    per box Salary and wages cost    $270,000.00 per month Overtime for production over 800,000 units         $1.00    per box Fringe benefits 50% of wages and overtime...
Question #1: WACC & Capital Budget Analysis – Based on the inputs below prepare a capital...
Question #1: WACC & Capital Budget Analysis – Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. Project Inputs: WACC – Debt is...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Project Inputs: WACC – Debt is 70% and Equity is 30% of this firm’s capital structure. Interest rate on the debt is...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for...
WACC & Capital Budget Analysis Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. Project Inputs: WACC – Debt is 70% and Equity...
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The...
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The budget must be prepared monthly. The quarter consists of 13 weeks. The forecasted sales are as follows: April 4 weeks May 5 weeks June 4 weeks July 4 weeks Sales Units 1,250 1,500 1,750 1,800 The company’s policy changed the inventory policy to keep closing inventory of completed units at 25% of the following month’s sales. Opening inventory on the 1st of April was...
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The...
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The budget must be prepared monthly. The quarter consists of 13 weeks. The forecasted sales are as follows: April 4weeks May 5weeks June 4weeks July 4weeks sales units 1,250 1,500 1,750 1,800 The company’s policy changed the inventory policy to keep closing inventory of completed units at 25% of the following month’s sales. Opening inventory on the 1st of April was 475 units. The labour...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT