Question

In: Accounting

The Ward Company produces and sells a product. The cost accountants at Ward have gathered the...

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

Solutions

Expert Solution

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


Related Solutions

Grainger Company produces only one product and sells that product for $110 per unit. Cost information...
Grainger Company produces only one product and sells that product for $110 per unit. Cost information for the product is as follows: Direct Material $16 per Unit Direct Labor $26 per Unit Variable Overhead $5 per Unit Fixed Overhead $33,500 Selling expenses are $4 per unit and are all variable. Administrative expenses of $20,000 are all fixed. Grainger produced 5,000 units; sold 4,000; and had no beginning inventory. A. Compute net income under i. Absorption Costing $ ii. Variable Costing...
Grainger Company produces only one product and sells that product for $110 per unit. Cost information...
Grainger Company produces only one product and sells that product for $110 per unit. Cost information for the product is as follows: Direct Material $14 per Unit Direct Labor $25 per Unit Variable Overhead $4 per Unit Fixed Overhead $27,200 Selling expenses are $4 per unit and are all variable. Administrative expenses of $16,000 are all fixed. Grainger produced 4,000 units; sold 3,200; and had no beginning inventory. A. Compute net income under i. Absorption Costing $.  ?? ii. Variable Costing...
1. Grainger Company produces only one product and sells that product for $90 per unit. Cost...
1. Grainger Company produces only one product and sells that product for $90 per unit. Cost information for the product is as follows: Direct Material $16 per Unit Direct Labor $25 per Unit Variable Overhead $5 per Unit Fixed Overhead $40,800 Selling expenses are $5 per unit and are all variable. Administrative expenses of $30,000 are all fixed. Grainger produced 6,000 units; sold 4,800; and had no beginning inventory. A. Compute net income under i. Absorption Costing $ ii. Variable...
Grainger Company produces only one product and sells that product for $110 per unit. Cost information...
Grainger Company produces only one product and sells that product for $110 per unit. Cost information for the product is as follows: Direct Material $16 per Unit Direct Labor $24 per Unit Variable Overhead $6 per Unit Fixed Overhead $26,800 Selling expenses are $3 per unit and are all variable. Administrative expenses of $12,000 are all fixed. Grainger produced 4,000 units; sold 3,200; and had no beginning inventory. A. Compute net income under i. Absorption Costing $ ii. Variable Costing...
Grainger Company produces only one product and sells that product for $100 per unit. Cost information...
Grainger Company produces only one product and sells that product for $100 per unit. Cost information for the product is as follows: Direct Material $14 per Unit Direct Labor $24 per Unit Variable Overhead $4 per Unit Fixed Overhead $34,000 Selling expenses are $3 per unit and are all variable. Administrative expenses of $15,000 are all fixed. Grainger produced 5,000 units; sold 4,000; and had no beginning inventory. A. Compute net income under i. Absorption Costing ii. Variable Costing   ...
A company produces and sells one product only, Peperoni, the standard cost for one unit being...
A company produces and sells one product only, Peperoni, the standard cost for one unit being as Follows. $ Direct material A – 10 kilograms at $20 per kg                                                                                    200 Direct material B – 5 litres at $6 per litre                                                                                               30 Direct wages – 5 hours at $6 per hour                                                                                                     30 Fixed production overhead                                                                                                                         50 Total standard cost                                                                                                                                          310 The fixed overhead included in the standard cost is based on an expected monthly output of...
The Timbrick Company produces and sells a single product. The production of this product requires 15...
The Timbrick Company produces and sells a single product. The production of this product requires 15 liters of direct material for each unit produced. Timbrick has an inventory policy which sets a target ending inventory of finished goods equal to 15% of next months expected unit sales. The target ending inventory for direct materials is 30% of the materials needed for production for next month. The budgeted cost of direct materials is $0.40 per liter. Normally, Timbrick pays the suppliers...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Monthly Income Statements March April May June Sales in units 6,800 6,300 7,050 7,300 Sales revenue $ 829,600 $ 768,600 $ 860,100 $ 890,600 Less: Cost of goods sold 418,500 393,000 426,250 444,000 Gross margin 411,100 375,600 433,850 446,600 Less: Operating expenses Shipping expense 76,000 71,000 79,250 80,000...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April May June   Sales in units 5,800 5,300 6,450 7,600   Sales revenue $ 742,400 $ 678,400 $ 825,600 $ 972,800 Less: Cost of goods sold 392,200 366,336 429,312 496,128 Gross margin $ 350,200 $ 312,064 $ 396,288 $ 476,672 Less: Operating Expenses            Shipping expense...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The...
The Central Valley Company is a manufacturing firm that produces and sells a single product. The company’s revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April May June Sales in units 6,900 6,400 8,100 9,800 Sales revenue $ 793,500 $ 736,000 $ 931,500 $ 1,127,000 Less: Cost of goods sold 421,350 397,440 484,380 574,770 Gross margin $ 372,150 $ 338,560 $ 447,120 $ 552,230 Less: Operating Expenses Shipping expense $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT