Question

In: Accounting

Question 13. The following information is from BYE-BYE Industries master budget for the 2016: Number of...

Question 13. The following information is from BYE-BYE Industries master budget for the 2016:

Number of units

   25,000

Sales revenue

$854,000

Direct materials

163,000

Direct labor

105,000

Variable factory overhead

145,000

Fixed factory overhead

84,000

Variable selling and administrative expenses

55,000

Fixed selling and administrative expenses

18,000

a. calculates per unit amount at 25,000 units.

Number of units

   25,000

Per unit amounts

Sales revenue

Direct materials

Direct labor

Variable factory overhead

Variable selling and administrative expenses


24,000 units

25,000 units

28,000 units

Sales revenue

Direct materials

Direct labor

Variable factory overhead

Variable selling and administrative expenses

Contribution margin

Fixed factory overhead

Fixed selling and administrative expenses

Operating income

b. Prepare flexible budgets for the production and sale of 24,000, 25,000 and 28,000 units, respectively in upcoming years.

Solutions

Expert Solution

Requirement a

Number of units

    25,000

Per unit amounts

Sales revenue

$ 34.16

Direct materials

$ 6.52

Direct labor

$ 4.20

Variable factory overhead

$ 5.80

Variable selling and administrative expenses

$ 2.20

Requirement b

Flexible Budget

24,000 units

25,000 units

28,000 units

Sales revenue

$819,840.00

$854,000.00

$956,480.00

Direct materials

$156,480.00

$163,000.00

$182,560.00

Direct labor

$100,800.00

$105,000.00

$117,600.00

Variable factory overhead

$139,200.00

$145,000.00

$162,400.00

Variable selling and administrative expenses

$ 52,800.00

$ 55,000.00

$ 61,600.00

Contribution margin

$370,560.00

$386,000.00

$432,320.00

Fixed factory overhead

$ 84,000.00

$ 84,000.00

$ 84,000.00

Fixed selling and administrative expenses

$ 18,000.00

$ 18,000.00

$ 18,000.00

Operating income

$268,560.00

$284,000.00

$330,320.00

Working

Flexible Budget

24,000 units

25,000 units

28,000 units

Sales revenue

=24000*34.16

=25000*34.16

=28000*34.16

Direct materials

=24000*6.52

=25000*6.52

=28000*6.52

Direct labor

=24000*4.2

=25000*4.2

=28000*4.2

Variable factory overhead

=24000*5.8

=25000*5.8

=28000*5.8

Variable selling and administrative expenses

=24000*2.2

=25000*2.2

=28000*2.2

Fixed factory overhead

84000

84000

84000

Fixed selling and administrative expenses

18000

18000

18000


Related Solutions

. manufactures ONE PRODUCT. The company prepared a master budget for 2016 which included the following...
. manufactures ONE PRODUCT. The company prepared a master budget for 2016 which included the following pro-forma income statement, which is based on an expected production and sales volume of 15,000 units. Mississippi Corporation Budgeted Income Statement For the Year Ending December 31, 2019 Sales $3,000,000 Cost of Goods Sold: Direct Materials $975,000 Direct Labor $225,000 Machinery Repairs (Variable) $60,000 Depreciation - Plant Equipment $300,000 Utilities ($45,000 is variable) $195,000 Plant Management Salaries $200,000 Cost of Goods Sold $1,955,000 Gross...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,300,000 Cost of goods sold Direct materials $ 945,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($60,000 is variable) 195,000 Plant management salaries 210,000 1,935,000 Gross...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget...
Required information [The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 915,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($60,000 is variable) 195,000 Plant management salaries 210,000 1,905,000 Gross...
Leaf Industries is preparing its master budget for 2013. Relevant data pertaining to its sales budget...
Leaf Industries is preparing its master budget for 2013. Relevant data pertaining to its sales budget are as follows: Sales for the year are expected to total 8,000,000 units. Quarterly sales are 25%, 30%, 15%, and 30%, respectively. The sales price is expected to be $2.00 per unit for the first quarter and then be increased to $2.20 per unit in the second quarter. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total for Yr Unit Sales 8,000,000 Unit Selling...
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                           &nb
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                                                         Sales                      Production Cost                                Operating Expenses 2019               1st Quarter          P280,000              P192,000                              P64,000                         2nd Quarter         320,000               200,000                                  68,000                         3rd Quarter          360,000               224,000                                  72,000                         4th Quarter          352,000               200,000                                  76,000 2020               1st Quarter          320,000               224,000                                  72,000 The budgeted Finished Goods Inventories are:         2018       March 31             P56,000                         June 30                 52,000                         September 30      60,000                         December 31     48,000 The company uses...
Please answer this question in details . this lecture is about The master budget is a...
Please answer this question in details . this lecture is about The master budget is a picture of the strategic plan’s projected results in financial terms. you will learn the purpose of the master budget and how it is compiled from functional area budgets within an organization. In different textbooks praise the benefits of participative budgeting. Is it wise to involve multiple parties at multiple levels in the organization in the budget preparation process? Why or why not? Embed course...
Morganton Company makes one product and it provided the following information to help prepare the master budget:
Morganton Company makes one product and it provided the following information to help prepare the master budget: a.The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. b.Forty percent of credit sales are collected in the month of the sale and 60% in the following month. c.The ending finished goods inventory equals 20% of the following month’s unit sales. d.The...
Morganton Company makes one product and it provided the following information to help prepare the master budget:
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,800, 19,000, 21,000, and 22,000 units, respectively. All sales are on credit. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 195,000 Plant management salaries 210,000 1,950,000 Gross profit 1,050,000...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT