In: Accounting
The Ward Company produces and sells a product. The cost accountants at Ward have gathered the following budgeting information for the year 2018: Budgeted number of boxes of product produced and sold 6,000,000 Unit Selling Price- $3.00 Rent for factory 65,000 Plant Manager Salary 85,000 Direct Labor 4,800,000 Depreciation on factory building 15,000 Cost of wood 1,800,000 Cost of graphite 3,000,000 Boxes to store product for sale 600,000 Advertising 100,000 Directions: - Prepare a Flexible Budget between 5,000,000 and 7,000,000 boxes of pencils in increments of 1,000,000
Ward Company |
|||||
Flexible Budget |
|||||
Flexible budget |
Flexible budget at |
||||
variable Amount per Unit |
Total Fixed cost |
5000000 Units |
6000000 Units |
7000000 Units |
|
Sales |
$ 3.00 |
$ 15,000,000.00 |
$ 18,000,000.00 |
$ 21,000,000.00 |
|
Variable costs |
|||||
Cost of Graphite |
$ 0.30 |
$ 1,500,000.00 |
$ 1,800,000.00 |
$ 2,100,000.00 |
|
Direct Labor |
$ 0.80 |
$ 4,000,000.00 |
$ 4,800,000.00 |
$ 5,600,000.00 |
|
Cost of Wood |
$ 0.50 |
$ 2,500,000.00 |
$ 3,000,000.00 |
$ 3,500,000.00 |
|
Packing cost (Boxes to store products) |
$ 0.10 |
$ 500,000.00 |
$ 600,000.00 |
$ 700,000.00 |
|
Total Variable Costs |
$ 1.70 |
$ 8,500,000.00 |
$ 10,200,000.00 |
$ 11,900,000.00 |
|
Contribution margin |
$ 1.30 |
$ 6,500,000.00 |
$ 7,800,000.00 |
$ 9,100,000.00 |
|
Plant manager's salary |
$ 85,000.00 |
$ 85,000.00 |
$ 85,000.00 |
$ 85,000.00 |
|
Rent of Factory |
$ 65,000.00 |
$ 65,000.00 |
$ 65,000.00 |
$ 65,000.00 |
|
Depreciation-Factory Building |
$ 15,000.00 |
$ 15,000.00 |
$ 15,000.00 |
$ 15,000.00 |
|
Advertising |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
|
Total Fixed Costs |
$ 265,000.00 |
$ 265,000.00 |
$ 265,000.00 |
$ 265,000.00 |
|
Income From operations |
$ 6,235,000.00 |
$ 7,535,000.00 |
$ 8,835,000.00 |